Sam Tantasook

Lexington, KY *****

Cell: 859-***-****

E-mail: ac5tzd@r.postjobfree.com

Technical Proficiencies

• Multi-tier and service architecture

• Relational Database

• SQL Server 7-2014

• T-SQL

• VS.NET 2003-2015

• VB6

• VBA

• VB.NET

• C#

• ASP.NET and classic ASP

• Entity Framework

• DevExpress

• IIS 7-8

• SSRS

• Team Foundation Server

• Testing (Unit, Alpha, and Beta)

• .NET Compact Framework for Windows Mobile

• Excel

• Integration of applications

• Data Migration

• Data Warehouse and Data Mart design

Professional Experience

VASCOR, Ltd.

Georgetown, KY

2010-Present

Inbound Logistics Software Architect

Continue in the Inbound Logistics Software Architect role in VASCOR Inbound Logistics business line. Mentor new developers, guide architecture, coding practices, and establish development platforms. Gather requirements from customers and internal business units. Collaborate, design, code, test, deploy, and support applications that enable smooth business operations. Interface with internal and external managers.

Key Achievements

• Work with Toyota Engineering and Manufacturing of North America (TEMA) to overhaul, migrate, and enhance their cross dock application. o Work directly with the customer to understand operational problems, brainstorm solutions, and gather requirements to make improvements. o Write up use cases and quotes.

o Develop, test, deploy, and support TEMA's cross dock application.

o Migrated legacy VB6 code to VB.NET.

• Dissected the application's VB6 code in order to thoroughly understand the functionalities of every tier of the legacy application.

• Reverse engineered the user-interface into a VB.NET WinForm application. VB.NET was chosen in order to stay as close as possible to the original code, which really facilitated testing and debugging to ensure that the new application remain functionally faithful to the legacy application.

• Reverse engineered the business objects' VB6 code to VB.NET.

• Used Entity Framework to access data.

• Migrated the legacy Crystal Reports into an ASP.NET web application in order to allow TEMA to access them via the Internet. The report parameter pages were ASP.NET pages with C# code behind, JavaScript client-side scripts, and HTML markup. DevExpress grid controls were employed as needed. The report themselves were migrated to SSRS. Starting to migrate this web application into ASP.NET Core MVC.

• Reverse engineered the order processing component's VB6 code to VB.NET.

• Wrote unit tests in C# in order to test the business objects.

• Used SQL 2014 database.

o Languages used: VB6, VB.NET, C#, T-SQL, HTML, JavaScript. o Third-party tools used: DevExpress.

• Code, test, deploy, and support various VASCOR Inbound Logistics applications. The various applications require me to work with the following:

o VB6

o VB.NET

o C#

o SQL Server

o SSRS

o ASP.NET

VASCOR has a number of legacy applications that were written in VB6. While they are being migrated into a newer platform, the legacy applications still need to be enhanced in order to meet the more immediate needs. This requires me to code in both legacy VB6 and .NET.

• Implement VASCOR inbound applications for a VASCOR sister company based in Chongqing, China.

o This project required VASCOR to train the Chinese team on the following:

• Installation of the servers and applications

• Setting up customers

• Using the applications

• Setting up the development environment to allow

enhancements to be made.

• Compiling of the source code

• Deployment.

o Lead the project and communicated periodically with the Chinese team to provide status updates and resolve problems. The Chinese team included the Vice-President of Operations, Manager of Operations, Logistics Operations Team, IT Developers, and IT Infrastructure team. o Served as lead developer.

o Established implementation plan.

o Completely emptied the databases, and rebuilt them to ensure that they can be populated from scratch with Chinese data. o Prepared step-by-step installation and implementation guide for setting up the servers and applications. This included instructions for setting up the Windows Server, SQL Servers, IIS, and all application components.

o Prepared step-by-step guide for setting up development environment. o Developed components to help setup their customers onto VASCOR applications. The components were written in C#, and T-SQL. o Prepared training schedules and materials for the trip. o Traveled to China and led the training of the Chinese team to install the servers and applications, setup the customers, run the application in their operational context, and resolve whatever issue that came up. Also trained the developers in setting up the development environment, compile code, and deployment.

• Established solid relationships with managers and employees of various business units in VASCOR, and recognized for being approachable, technically competent, business savvy, and has a very positive attitude.

• Mentored 3 new developers and trained them to full autonomy.

• Migrated 20 development, beta, and production SQL Servers from 2000 to 2008, and from 2008 to 2012 in both virtual and physical environment.

• Restructured legacy web applications to a cleaner structure, and migrated from 32-bit IIS6 to 64-bit IIS7.

• Worked with consultants and internal resources to implement SharePoint 2010. Installed SharePoint content database server, configured the Business Intelligence features of SharePoint 2010, and worked with end users to publish Excel Services/PowerPivot dashboards. Prototyped Performance Point dashboards for proof of concepts.

• Worked with end user and BI Architect on Business Intelligence initiatives to analyze, design, code, test, and deploy data warehouse and dashboards. Crate & Barrel

Northbrook, IL

2008-2010

Senior Software Developer

A senior developer in the Store Technology Group in a nationwide furniture and houseware retail company. Enhanced and maintained the Point-of-Sale (POS) application, Kiosks, and POS application server. Gathered requirements from internal functional architects, code, test, deploy, and support. Collaborated with members in other teams to resolve production and development issues. Ran beta testing sessions with the QA team when called upon. Key Achievements

• Assigned as Lead Developer to work with the infrastructure team in

“virtualizing” the Point-of-Sale application

o Developed using the following:

VS2005 and VS2008

Test Driven Development

.NET 2.0 and 3.5

C#

Web Services

MVC

SQL Server 2000 and 2005

NUnit and RhinoMocks for unit testing

o Enhanced the Point-of-Sale to work in a hosted environment as opposed to a stand-alone environment.

o Modified the XML data access objects to be callable by multiple clients via remoting and hosted in a Windows service. This allows many instances of POS to run in a hosted environment with minimal memory footprint.

o Diligently resolved deployment problems that occurred when application was put onto Windows 2008 terminal server by working with the networking group and Microsoft engineers. o Wrote Windows service to automatically download application updates. o Wrote Windows service to automatically download XML data files. o Saves Crate & Barrel significant hardware cost, and allows the POS to be used on a regular PC without having to purchase specialized POS terminals.

• Complimented by supervisor and his supervisor as being technically competent, able to take ownership of projects and see them to 100% completion, having very good communication, and excellent people skills, and having great potential to go into other higher-level facets of IT within the company.

VASCOR, Ltd.

Georgetown, KY

2001-2008

Lead Enterprise Architect

Promoted to Lead Enterprise Architect to lead projects, set and enforce coding standards, SDLC procedures, architectural directions, and strategic development goals. Lead a multi-national team of 6 senior-level developers consisting of team members from the U.S., India, Mexico, and Philippines. Gather requirements from customers and internal business units; lead, collaborate, design, code, test, deploy, and support applications that enable smooth operations of $50-$80 million business- lines. Interface with internal and external managers. Work with the Vice President of IT to prepare budgets. Interview and hire developers. Mentor, motivate, guide, and reward team members.

Key Achievements

• Established solid relationships with managers and employees of various business units in VASCOR, and recognized for being approachable, technically competent, business savvy, and has a very positive attitude.

• Built a team that has been complimented by APL, VASCOR’s mother company, as being very capable, flexible, and responsive despite its size. APL has leveraged VASCOR applications and included them in its marketing efforts in Asia.

• Ensure team productivity by implementing agile software development methodology.

• Led the implementation of reusable software foundation components.

• Implemented SDLC procedures, coding standard, architecture standard, testing procedure and platform, and deployment standard.

• Project led, designed, coded, tested, and deployed an enterprise multi-tier application that enables the success of an $80 million business-line that supports the customers finished vehicle delivery supply chain. Highlights are: o Processes approximately 100,000 transactions per day. o Consists of a Pocket PC application, a web application, and numerous EDI import and export components.

• The Pocket PC application portion used VB.NET (Framework 1.1), SOAP Web Services, .NET Compact Framework 1.1, SQL Server 2000. I coded this entire application.

• The web application used VB.NET (Framework 1.1 and 3.5), ASP.NET, COM+, System Transactions, Crystal Reports, and SQL Server. I wrote some of the ASP.NET pages, about 35% of the business objects, and modeled the database.

• EDI importer and exporter components used VB.NET

(Framework 1.1 and 3.5), Component Services, and SQL Server. I wrote about 35% of the exporters.

o The application was used at more than 20 locations in the U.S. and Mexico. The Pocket PC application was deployed on over 150 handheld scanners.

• Project led, designed, coded, tested, and deployed an enterprise multi-tier application that enables the success of a $50 million business-line that supports VASCOR milk-run business to pick up and deliver parts to the customers’ plants. Highlights are: o The application consisted of a VB6 Windows application, ASP web application and Crystal Reports for reporting, and EDI importer for GPS updates.

• I wrote the Windows application and its Component Services business objects in VB6.

• Component Services was used to host the business objects. The VB6 Windows application communicated with the business objects via Remote Data Service.

• The database was in SQL Server.

• I wrote the Web application using ASP and, later, ASP.NET. The reports were written in Crystal Report.

• EDI importer for GPS updates used VB.NET (Framework 3.5), System.Transactions, and SQL Server. I wrote this entire importer.

o The application tracks all routes that pick up and deliver parts for major automotive manufacturers.

o GPS-enabled by interfacing with QualComm and other satellite- tracking services. This feature saves cost and allows VASCOR dispatching operation to run using a smaller team. o Relied upon by VASCOR customers to provide timely information that affects daily operational decisions.

o Relied upon by VASCOR customers to provide key performance indicators that are used to continually pinpoint opportunities for improvement in their operations.

VASCOR, Ltd.

Georgetown, KY

1997-2001

Senior Developer

Hired to perform full life-cycle development. Wrote numerous applications that supported various new and existing business-lines. Gathered requirements, designed, developed, tested, migrated, deployed, maintained, and supported client/server and multi-tier applications for internal and external clients. Key Achievements

• Gained respect from management and peers, and recognized as an employee who is competent, hardworking, diligent, and has a “can do” attitude.

• Designed, coded, tested, deployed, and supported numerous applications that supported VASCOR’s growth. Developed all tiers. Used VB5-6, VB.NET, Access, Office 2000, Crystal Report 8, COM+, IIS, and SQL Server 6.5- 2000.

• Applications were recognized by APL, VASCOR’s mother company, and some were used in starting their new operations in Asia.

• Won Employee of the Quarter award in 1999 for helping to streamline EDI processing that saved cost, greatly improved customer service, satisfaction, and responsiveness.

Computrex Logistics

Nicholasville, KY

1996-1997

Software Engineer.

Developed a company-wide, client/server, object-oriented freight payment application using SQL Server 6.5, Visual FoxPro 5.0, and VB 4.0. The application processed approximately $10 million worth freight bills weekly for Fortune 100 customers, and used object-oriented business objects to allow flexibility in handling customer-specific business rules, while easing reusability and maintainability. VASCOR, Ltd.

1995-1996

Part-time Programmer

Wrote various Visual FoxPro programs to automate and distribute purchase orders. Wrote applications that reduced routine paperwork. Performed application support and helpdesk.

Key Achievements

Applications helped reduce the time to generate and distribute purchase orders to VASCOR suppliers from 7 days to 2 days, which translated to more lead time for the suppliers, increasing suppliers’ ability to meet part demands, and ultimately resulted in better customer service.

DICOM, Inc.

Nicholasville, KY

1993-1996

Part-time Programmer and Technical Support Representative. Helped develop, debug, and maintain a Windows-based, voice-enabled database application installed at various Fortune 500 organizations including John F. Kennedy Airport, World Trade Center, and Kodak using Borland C++, and VB3. Assembled and diagnosed industrial-grade, IBM-compatible systems. Performed remote system support on clients' systems using remote session software. Education

Bachelor of Arts Degree in Decision Science and Information Systems, University of Kentucky, Lexington, KY

Henry Clay High School, Lexington, KY

Certifications

Microsoft Certified Professional, Visual Basic 6.0 Desktop Development Microsoft Certified Professional, Visual Basic 6.0 Distributed Development Microsoft Certified Professional, Analyzing Requirements and Defining Solution Architectures

Microsoft Certified Professional, Designing and Implementing Databases with SQL Server 7.0

Passed the above 4 exams and acquired the Microsoft Certified Solution Developer certification.

Technical Events/Courses Attended

2015 Microsoft Ignite, Chicago, IL

2011 Microsoft TechEd, Atlanta, GA

2007 Microsoft TechEd, Orlando, FL

2006 Managing Technical Professionals and Organizations, MIT Sloan School of Management, Cambridge, MA

2006 Development using VS.NET 2005 and SQL Server 2005 training, Falls Church, VA

2003 Data warehousing using SQL 2000, Atlanta, GA

2000 Visual Studio DevCon, Scottsdale, AZ

1998 TCP/IP technical course in Lexington, KY

1997 Office 97/VBA DEVCON in Nashville, TN

1996 Visual FoxPro DEVCON in Scottsdale, AZ

1996 Visual FoxPro Advance Programming Course in Upper Darby, PA Foreign Language

Fluent in Thai

Professional References

Sujay Gummadi

Logistics Operations Manager

Toyota North America

859-***-****

George Humphries

DBA

Creative Lodging Solutions

859-***-****

Ashley Gieringer

QA Analyst

Creative Lodging Solutions

859-***-****

Contact this candidate