SUMMARY

• Application Developer and Support Analyst with over20years of experience.
• Experienceincludes:Application Development,Enhancements,Tier IIIProductionSupport,Trouble Shooting,System Migrations, and Reverse Engineering
• Requirements Gathering, Technical Design, Construction, Unit Testing, Internal Walk Throughs, and Implementations
• Industries include: Pharmaceutical, Banking,Manufacturing,andGovernment.
• ExcellentClient Relations skills andTechnical capabilities.

TECHNICAL SKILLS

• Visual Studio2010through 2017,.NET 2.0 through 4.5.
• Team Foundation Server - TFS, ASP.net, C#,VB.net, Java Script,andXML.
• Eclipse, Java,SOAP,JSON
• Excel,Word,and VBA for programming MS Office applications
• MS Access,VBAand VB6
• Oracle, SQL Server,SQL Developer,TOAD
• Stored Procedures Unix,C,andVI

PROFESSIONAL EXPERIENCE

Confidential,Chicago, IL

Application Development, Data Analysis, Reverse Engineering

Responsibilities:

• System Migrations (Worked to convert client software from Legacy Payment Net System to Payment Net 4 System)
• Participated in the creation of the Process to guide the RE team to success
• This project entailed Reverse Engineering legacy (VB6 projects with SQL Stored ProceduresandCrystal Reports) into specifications for similar programs in the new Payment Net 4 system. There were several Business / Technical documents used for this process as follows:
• RE - Reverse Engineer (Business Document)
• Legacy to Payment Net 4 DB Structure Conversion (used to Automate the RE document)
• CM - Capabilities Matrix (Business Document)
• Payment Net 4 DB table and field names to View field names used in Mapforce (used to Automate Capabilities Matrix document). This document served as the Specification document for creating the Payment Net 4 programs.
• The system was converted from a SQL Server platform having separate databases for each client to an Oracle platform with a new database design containing all client data in a single database.
• The programs converted were specialized client output files from the Payment net system which were used by the client for various purposes. (loading other system, reports etc.)
• These programs known as Mappers were based in VB6/VBA and SQL Server on the Legacy side and converted to XSLT and Oracle on the New Payment Net 4 system side.
• The project management was tracked though customized SharePoint applications created and modified by our team. Each individual member also had the capability to customize SharePoint pages output to his or her liking to enhance that individuals understanding. Management leaned heavily on this system to determine the progress for each leg of the migration. Each Migration Leg was a two month process moving several bank clients for each leg.
• Another part of the process was the development of Mapforce programs which are compiled to create the XSLT files to produce the Mappers which matched or closely matched the output from the Legacy system.
• Next we are worked on a 2ndproject to convert Access, Excel and SAS reports to the new Payment Net system. We are using a similar process to perform this operation.

Confidential, Kalamazoo, MI

Application Developer

Responsibilities:

• Created Website / Database.
• Setup system with MS Visual Studio 2008, ASP.net, VB.net, Java Script and SQL Server.
• Quantum Group is a Parts Sorting company for Tier II parts suppliers to the automotive industry.
• The Website / Database is to Keep track of Customers, Employees, Contracts, Hours, and Part sorting statistics. The Sorting statistics are available on-line to each customer for their review via their own access name and password.
• Gathered system requirements, created the overall design for the project.
• Setup the database in SQL 2005 and the several pages of the website using Visual Studio and VB.net 2008.

Confidential,Kalamazoo, MI

ApplicationDeveloperand Support Analyst

Responsibilities:

• Tier IIISupport, Software Changes, Testing, Configuration, Installation, Database Maintenance, and Disaster Recovery Planning.
• Worked withVisual Studio, Team Foundation Server, APS.net, VB.net, Java Script, VB Script,MS Access, MS Excel, SharePoint, VBA, VB6,Oracle and SQL Server.
• Responsible for support and maintenance to 6 different internal websites used for automated user request and information system.
• These websites were written inHTML,Classic ASP, ASP.net, Java Script, and VBscript.
• The websites provided guidance, automatically created Service Desk tickets, and sent emails to the appropriate parties.
• Supported systems including Chromatography, LIMS, Electronic Change Control, Environmental Monitoring, Complaint Investigation, Incidents Management and User Request Web sites for user application support.
• Worked with Oracle tools to provide data extracts and Oracle version upgrade testing.
• Developed VBA code changes and enhancements in MS Access and MS Excel.
• Provided VB6 and VB.net changes and enhancements.
• Quality Information Control System (QuICS), in-house, MS-Access, VBA, SQL Server 2005
• LabCalcs, in-house, GMP certified Lab Calculation MS-Excel 2000-2007 worksheets for Production including extensive VBA for Excel and accessed through SharePoint.
• Deviation Reporting System (DRS), in-house, Citrix based, VBA, VB6, Access & Oracle 11.
• Culture Catalog (CCAT2), in-house, Client based, VB6, and Oracle 11.
• Core-LIMS, CLV2, In-house, Web based, Oracle 11.
• GalaxieChromatography, Vendor, Citrix based with six Windows 2003 servers.

Confidential, Romulus, MI

System Developer (Consultant)

Responsibilities:

• Gather requirements from business and write program specifications
• Create functional and technical specifications
• Software Design, Creation, Testing, Implementation, and Maintenance
• Create and execute test plans for all new changes
• Create file extracts, data conversions, and database table load modules
• Create Reports and provide Production support
• Design and implementation of a Contract based, transaction keeping invoicing system which reduced data entry and improved production.
• Contracts of the prior system were in Word document and therefore completely unusable in data entry.
• System was written in Microsoft Access 2003, VBA and VB6.
• The database was designed and created in Microsoft SQL Server 2000.
• Created and maintained a system used for data collection and statistical analysis of manufacturing production lines for a new Goodyear contract which tied directly into the Goodyear SAP system.
• System was designed to create reports and invoices as well as feed the existing company accounts receivable system using SQL 2000, VB6, Excel 2003, and VBA.
• Developed Assembly line and Production data collection tools used for quality control, costing analysis, shipping and billing purposes. This was accomplished with VB6, Access, VBA, and Excel.

Confidential, Benton Harbor, MI

Production Support Specialist/ Application Developer

Responsibilities:

• Primary responsibilities included maintenance and production support of the DRP (Demand Requirements Planning) system.
• The DRP system supplied vital information to the ERP system for Whirlpool. Whirlpool used SAP to help create JIT (Just in Time) resource model for production which kept inventory at a minimum and scheduled Inventory deliveries. It also produced many reports for production and managements analysis to help improve product production efficiency.
• The DRP system resides on a MVS/TSO-ISPF platform with JCL, COBOL, COBOL II, SAS, Sync Sort,Changeman, MQ-Series and FTP.
• Perform code fixes and overrides for production job streams.
• Make system modifications and enhancements as needed for business requirements.
• Create and execute test plans for all new changes.
• Testing of new interfaces and system changes for compatibility with other systems
• Create and update on-line programs using COBOL II and SAS.
• Production support.
• Secondary responsibilities were to develop new application data interfaces for the APS (Advanced Planning System). The APS systems are a mix of applications by I2 Technologies and interface/modules developed by Whirlpool.
• Write new data extracts for APS using MVS/JCL, FTP, PL/SQL, COBOL II, andChangeman.
• Create and execute test plans for all new changes.