Chanan is available for hire
Hire ChananChanan Sittisomsap
Verified Expert in Engineering
Microsoft SQL Server Developer
Bangkok, Thailand
Toptal member since March 8, 2017
Bio
Chanan has over 15 years of experience in software development with a primary focus on the Salesforce Commerce Cloud, Microsoft .NET technology encompassing analysis, design, development, and execution of business applications with six years of experience in eCommerce platforms.
Portfolio
Tervis Tumbler Company
Git, Microsoft SQL Server, jQuery, JavaScript, BizTalk, C#, ASP.NET...
AT&T (Contractor through Aditi Consulting Co.,Ltd.)
Microsoft Kinect, Three.js, JavaScript, CSS, HTML5
Tervis Tumbler Company
Microsoft Dynamics NAV, Microsoft Commerce Server, Microsoft SQL Server, jQuery...
Experience
- ASP.NET - 15 years
- Microsoft SQL Server - 15 years
- JavaScript - 15 years
- jQuery - 6 years
- Agile Software Development - 6 years
- BizTalk - 6 years
- Demandware API - 3 years
- Demandware - 3 years
Preferred Environment
TFS, Git, Salesforce Commerce Cloud (SFCC)
The most amazing...
...thing I've coded is a custom catalog manager that was built from scratch and integrated with an ERP system and an eCommerce platform with multiple technologies.
Work Experience
Sr. Web Developer
2012 - PRESENT
Tervis Tumbler Company
- Developed websites (Tervis.com and TervisB2B.com) using Salesforce Commerce Cloud technology. I was responsible for the front-end, back-end, and the integration.
- Implemented the import/export for data integration between Salesforce Commerce Cloud and other systems using BizTalk and SOA.
- Used HTML5 and a Three.js framework to migrate a customizer application from .NET platform to a Salesforce Commerce Cloud template.
- Engaged with the UX designer to create templates and content slots.
- Led the offshore development team to assign tasks, code review, and advice in a Tervis.com enhancement project.
- Modernized an existing catalog management system using ASP.NET and integrated it with a MS Commerce Server (Before changing the platform from Tervis.com to Salesforce Commerce Cloud).
- Involved in requirement gathering phase with integrator for Tervis.com re-platform project.
Technologies: Git, Microsoft SQL Server, jQuery, JavaScript, BizTalk, C#, ASP.NET, Salesforce Commerce Cloud
Software Application Developer/Analyst
2012 - 2012
AT&T (Contractor through Aditi Consulting Co.,Ltd.)
- Developed a proof of concept 3D network diagram visualization web application using HTML5 and Three.js to display cell sites and network elements. It controlled the movement of a diagram using body gesture via Microsoft Kinect device.
Technologies: Microsoft Kinect, Three.js, JavaScript, CSS, HTML5
Web Programmer II
2010 - 2012
Tervis Tumbler Company
- Handled and was responsible in enhancing and maintaining an eCommerce Tervis.com website using ASP.NET and Commerce Server 2009. Worked extensively on the front-end and back-end.
- Developed data integrations between Commerce Server 2009 and MS Dynamics NAV using BizTalk Server 2009.
- Developed an e-packing web application to help packers track items that will be packed in the box using ASP.NET and Entity Framework.
- Developed an e-decorating web application to visualize where to put an emblem and personalize stickers on the tumblers using ASP.NET, Entity Framework, and Silverlight.
- Developed reports for Tervis.com daily transactions in SSRS.
- Created custom commerce server pipelines to handle special promotions based on business requirements.
Technologies: Microsoft Dynamics NAV, Microsoft Commerce Server, Microsoft SQL Server, jQuery, JavaScript, Entity Framework, Sitefinity, C#, ASP.NET
IT Consultant
2008 - 2010
Freelance Work
- Developed POS software from scratch for Thai restaurants in Orlando area using Visual Basic and Crystal Report.
Technologies: Crystal, Visual Basic
Business Analyst
2007 - 2008
Total Access Communication Co., Ltd.
- Gathered requirements from the business user and converted them to Project Initial Brief (PIB) for IT the department.
- Negotiated requirements, technology, and timeline with the vendor and other partners to meet the user requirements.
- Worked closely with a process development team to decide on the right kind of technology and how to utilize it with the given business process.
- Designed a new IVR (Interactive Voice Response) and USSD (Unstructured Supplementary Service Data) diagram for new DTAC SIM product to support new DTAC SIM card’s registration system.
- Added a new diagram on top of the existing system such as new package and new additional package.
- Designed and developed an interim system for the Postpaid Distribution Enhancement System with ASP.NET, C#, and SQL Server 2005.
- Researched and implemented new technologies to work with the existing project in IT.
- Coordinated and implemented the use GPS, a personal digital assistant (PDA), and e-document management.
- Integrated data from GPS or PDA and a sales-tracking system to analyze sales performance in any area of the country, and improve performance of area supervisor and retailer.
Technologies: Microsoft SQL Server, C#, ASP.NET
Database Analyst
2006 - 2007
Total Access Communication Co., Ltd.
- Created a web portal application for the department to access the intranet web application in one window and integrated LDAP authentication for a login to system with ASP.NET, SQL Server 2000.
- Created an interim voucher tracking system to record voucher distribution via web application using ASP.NET, C#, and integrated information as a text file to the United Distribution Company with SQL Server 2005 Integration Services.
- Worked with a business analyst and vendors to design a database structure for voucher tracking and report analysis with SQL Server 2005.
Technologies: Microsoft SQL Server, ASP.NET
System Analyst
2005 - 2006
Advance Systems Consulting Co.,Ltd.
- Designed and developed a KPI and commission module of a Salesforce system for the DTAC company using VB.NET console application and SQL Server 2000.
- Utilized a complex formula to calculate KPI and commissions from sale and activation data, to display results on the Salesforce system web application.
- Designed a web application and web services for KPI and commission module of a Sales force system using VB.NET and SQL Server 2000.
- Designed and developed a Windows application for direct sales to track sales performance on a daily basis and synchronized the data from laptop to back-end system via the Internet with VB.Net, C# and Microsoft Access 2000.
- Developed the web application and batch process for the commission calculation module in the sales tracking system using ASP.NET and C# console application.
Technologies: Microsoft SQL Server, C#, VB.NET, ASP.NET
Programmer Analyst
2003 - 2004
Advance System Consulting Co., Ltd.
- Designed and developed MML Libraries with MSMQ and network communication Ttechnology using VB.NET.
- Developed and designed a console application for sending MML commands via network element to NOC server using VB.NET.
- Developed a web application for Phatra Insurance company using ASP.NET, C# and Crystal Report to print out checking slips via the intranet.
Technologies: C#, VB.NET, ASP.NET
Programmer
2002 - 2003
Summit Computer Company
- Developed an electronic document system for the Thai National Intelligent Agency Department using ASP.NET and SQL Server 2000.
- Developed an electronic document system for the Thai Boundary Department using ASP.NET and Oracle Database.
Technologies: Microsoft SQL Server, ASP.NET
Experience
Sitedown Alert
I developed a proof of concept iOS application to alert us when the Tervis.com site is down. The application was written with Xcode and iOS 3. The application sends a request to the website on the specific minimal content page every minute. it plays a sound when the server response is 404 or has no response.
Thai POS System
I built a POS system from scratch for Thai restaurants in the Orlando, FL area. The application is built with VB6 and uses MS Access as a database. It has all the main feature for a normal POS system such as clock-in, clock-out, table plan, ordering, payment, splitting check, and daily summary.
Education
2016 - 2017
Demandware Certified Developer in Demandware Customization, Integration, and Performance
Demandware - Burlington, MA, USA
2015 - 2017
Developing in Demandware Certification in Developing in Demandware
Demandware - Burlington, MA, USA
1996 - 2000
Bachelor's Degree in Business Computer
Siam University - Bangkok, Thailand
Certifications
FEBRUARY 2018 - PRESENT
Salesforce Certified Commerce Cloud Digital Developer
Salesforce
Skills
Libraries/APIs
jQuery, Demandware API, LINQ, Three.js, Entity Framework
Tools
Git, TFS, Visual Studio, Sitefinity, Microsoft Dynamics NAV, Salesforce Commerce Cloud (SFCC)
Languages
XML, SQL, XSLT, JavaScript, C#, HTML5, CSS, Visual Basic, Crystal, VB.NET
Frameworks
ASP.NET, Entity, Microsoft Kinect
Paradigms
Agile Software Development
Platforms
Demandware, Eclipse
Storage
Microsoft SQL Server, Salesforce Commerce Cloud
Other
BizTalk, Microsoft Commerce Server
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring