SUMMARY

• Results - oriented software developer with over 17 years developing and maintaining a wide variety of systems for corporations across different industries.
• Well-versed in working with business experts, designing technical solutions to meet requirements, implementing development processes, and leading teams to deliver software.
• Experienced OO developer with expertise in web applications using .NET technology.

TECHNICAL SKILLS

Programming Languages: C#, VB.NET, ASP.NET, JavaScript, HTML, XML, PL SQL, JAVA, UNIX Shell Scripts, ASP, VBA, Visual Basic 6, T-SQL, C, APL, COBOL, Easytrieve, JCL

Databases: Oracle, MS SQL Server, MS Access, Sybase SQL Anywhere, DB2

Operating Systems: MS Windows, Linux, MS DOS, HP UX, IBM OS 390

PROFESSIONAL EXPERIENCE

Confidential

SYSTEM ANALYST

Responsibilities:

• Worked with a team to create an ASP.NET web application using C# for actuaries. Implemented the MVP design pattern on the code behind. Moq library for .NET used extensively on all unit test cases.
• Wrote enhancements using VB.NET for an existing ASP.NET web application to allow users to request tests and investigation reports. Assigned work duties and code design standards to other developers. Acted as go-to person for other functional groups (DBA/Server/Security) to identify and resolve issues for numerous areas within the project.
• Worked with a team to convert the CRM system based on Epoint to an ASP.NET web application using VB.NET. Responsible for creating back end objects including Account and User Management related ones, coding ASMX web services/interface components that are used by many in house web applications.
• Worked with a team to design and code an ASP.NET web application used in the rate making process. Converted VBA from 18 Excel files to VB.NET by implementing Visual Studio Tool for Office (VSTO) to load data, compute statistical data, and save results to Oracle database through WCF web service.
• Designed and coded ASP.NET web pages in VB.NET including Add, Summary, Search, History, File Attachment, and Matrix Reports to give the data providers a centralized point of access to view and address issues.
• Analyzed, designed, and coded a trip reporting application in VB.NET for corporate representatives. The application eliminates the usage of Word documents and provides an efficient method for data collection, searching, and reports generating.
• Converted existing online data downloading tools by implementing XML/XSLT on the front end ASP page, re-factoring the class relationship on the back end using VB6, and moving all database calls into T-SQL. The new system provided faster response and saved the download time up to 40%.
• Production support and coded enhancements for the CRM system. Used the Epoint language to add functionality for inbound call guide and create order processing for outbound call guide.
• Worked with a team of seven developers to create an ASP.NET web application, which displays several key insurance information based on the different states. Responsible for the back end data processing design, database design and coded stored procedures in Oracle, coded VB6 COM components interact with MS Project component, third party graphic component from ComponentOne and Adobe Acrobat SDK.
• Acted as code reviewer and build administrator for web applications.

Confidential

SYSTEM CONSULTANT

Responsibilities:

• Converted and enhanced a VB/PowerBuilder based application used by the sales and marketing department to Hyperion Essbase based application. Identified dependent systems, documented and supported with data flow diagrams at system and module levels.
• Wrote online tool in ASP.NET to assist data management.
• Acted as a mentor for client’s IT supports for troubleshooting Outlook form, VBA in MS Excel and Access applications.
• Installed, tested, and documented setup procedures for WebLogic Server. Worked with BEA support personnel to set up and test the WebLogic Business Connector for secure file transferring.
• Developed JAVA components that utilized Java Message Service for address verification. Wrote JSP pages to automate the web forms creation. Worked along with five other team members and wrote the Voice IP subscription online application used by the customer services.

Confidential

Responsibilities:

• Analyzed, designed, and coded a system for implementing the Consumer Price Checker in the retail stores. Configured, set up, and tested four different price checkers from three vendors. Acted as the technical representative for the client when interacting with vendors. Designed and developed in C and VB6. The key components include retrieving scanned bar code data, extracting product information from database, formatting and sending the search results to the price checker’s LCD screen, and generating reports for the scanned items.
• Implemented the Kiosk in retail stores. Analyzed and configured the security setup for the NT workstation. Developed in VB6 a customized browser application running in the Kiosk to strengthen security access. Worked with web site vendor utilizing a COM component to enable the OPOS printing from the web site. The project contributed to the profit margin of the store.
• Created scripts in WinBatch to automate the software installation, update virus definition files, and purge database for all 198 retail stores. Developed in VB6 a utility tool to remote change the NT server password. Configured and created the bootable CD with images for new PC.
• Designed and developed a VB6 application that detects duplicate credit card transactions. Wrote enhancements in VB6 to produce the customer’s signature in the transaction report.

Confidential

Responsibilities:

• Rewrote the data extracting procedures for a financial reporting system to read the data directly from DB2 instead of the legacy file. Developed EasyTrieve programs, modified JCL and COBOL programs, led the testing effort, and coordinated loading procedures for the move to production. This project eliminated 80% of manual procedures and provided the system availability two hours earlier.
• Enhanced a financial planning system by implementing the dial-up function with different access level to the system. Developed APL programs to extract actuals data from mainframe and load into the planning system. Rolled over the financial planning system for the new accounting year.
• Automated the data processing to load the On-Board-Computer (OBC) data into the financial actuals system. Performed functional analysis for database structure to include the OBC data. Met with managers to design several ad hoc reports. Developed JCL and EasyTrieve to prepare the OBC data. Developed APL program to load OBC data into the actuals system and to create new financial reports. This project halped the company manage the drivers effectively.
• Tested several financial actuals and planning systems at unit, system, and integration levels. Ensured that the programs were Year 2000 compliant. Production support for financial actuals and planning systems.
• Supported and wrote enhancements for an APL system that automates legal schedules creation. Developed data extracting procedures and used Dynamic Data Exchange (DDE) to populate data by MS-Word mail merge function.