Software Developer Customer Service

Andy C. Tan

Apex, NC 781-***-**** *******@*****.***

SUMMARY

A senior professional software developer with over 20 years of experience in application design and development with an innovative concept to the next evolutionary phase. Proficient at coalescing data from various sources into useful reporting tools. Able to quickly diagnose and correct complex systems. Professional interpersonal and inter- discipline communication skills.

SKILLS

• ASP.NET (C#), Windows Service, Web API, Microsoft SQL server, Stored Procedure, JavaScript, SSRS, SSIS, ETL, Office 365 and Batch script.

EXPERIENCE

Calamp Wireless Network, Irvine, CA

Sr. Software Developer (Mar 2016 – Jun 2020)

• Developed ASP.NET Web application and Web API in C# for international licenses request product information.

• Developed stored procedures for analytical and Oracle integration.

• Developed and supports reporting solutions with SSRS for various business units.

• Developed and supports data extract with SSIS packages for external customer use.

• Implemented the ETL process to migrate legacy data to SQL database.

• Interact with the project team members responsible for developing reports, interfaces and data conversion to Oracle Cloud.

• Developed Windows Service in C# to separate emails and text messages, it send SMS messages and make phone call through Twilio API to users.

• Developed ASP.NET Web application in C# to configure paging alerts for law enforcement based on the region of the country and times of the day to receive alerts.

• Developed ASP.NET Web application in C# to check and report tower status to field engineering allowing for quick notification of trouble in the network to resources who can repair it. LoJack Corporation, Canton, MA

Sr. Programmer Analyst (Jun 1998 – Mar 2016)

• Developed server application running 24/7 on Windows Server using VB6, Active-X control components, ADO data access to SQL Server, and Microsoft Outlook client to receive formatted emails and text messages though allowed remote users to control vehicles, get vehicle status, and report various system information.

• Developed Early Warning application server running 24/7 on Windows Server, using VB6, Active-X control components, ADO data access to SQL Server 2000 to create alert phone calls, emails, and SMS messages to Early Warning™ customers to notify them that an event has occurred. Server used Dialogic cards to send phone calls and SMTP for email. Additionally, server answered calls from Radio Frequency towers reporting alert information, sent and received data from IP connected towers by FTP and Winsock. This server makes the Early Warning™ product from LoJack functional.

• Developed client application for Early Warning™ customer support in VB6 running Active-X control components, ADO data access to SQL Server stored procedures on Citrix MetaFrame providing a rich user interface to customer service personnel. This application is used to create new and mondify customer registrations and information as well as creating incident escalation reports with Crystal Reports.

• Developed client application for managing client registrations of new vehicles and replacement installations using VB6, Active-X control components, ADO data access to SQL Server making it possible to correct errors in installation data and provide validated data to the recovery servers.

• Proficient as using SQL Server Data Transformation Service (DTS) to import and manipulate data to and from SQL Server databases which is useful in creating and correcting failed server installations.

• Supported remote systems 24/7 via VPN, using VNC and PCAnywhere. Master Software Technology, Stoneham, MA

Software Consultant (Sept 1997 – May 1998)

• Developed client server application for Medical Laboratory Application, using VB5, Active-X control components, Microsoft Word, ODBC data access to MS Access database.

• Developed automation scripts using SQA Robot, defined test plans, created and relayed the test scripts, reported results and maintained scripting environment.

• Used DemoShield software to create pre-sales demo that were published it on the internet to show customers what the final product would look like.

• Demonstrated the application to clients and wrote documentation for SQA test scripts allowing for continued maintenance and product improvement.

New England State Police Information Network, Needham, MA Computer Programmer (Nov 1996 – Aug 1997)

• Developed and implemented NESPIN Web Page by using Microsoft FrontPage 97 and Netscape Suitespot program hosted at NESPIN in a web server.

• Used Microsoft Access 7.0 database program to develop applications for internal use and linked to the Web. Converted existing programs from Access 2.0 to Access 7.0

• Network Troubleshooting on LAN/WAN support for Novell 3.1, Windows NT 4.0 and provided service pack or maintenance upgrades to servers and administrative backup.

• Network Application Troubleshooting by bug fixes, general user assistance for application problems, printing, and training.

• Network Maintenance, setting up TCP/IP address and internal/internet mail accounts on Microsoft Exchange server.

• PC Software Maintenance, MS Windows NT Workstation 4.0, Windows 95 and MS Office Professional 95 client upgrades, internal application and driver installations. University of Massachusetts at Boston, Boston, MA

Data Analyst (Feb 1993 – Oct 1996)

• Used SAS Program to analysis Health Service patients data, generated monthly and annual reports.

• Used Microsoft Access database program to generate reports for Physicians, Nurses and Health Insurance company use.

EDUCATION

B.S. Management Information Systems University of Massachusetts, Boston, MA