PROFESSIONAL SUMMARY:

• Senior - level IT professional with over 20 years of experience on IBM AS400 iSeries (IBM i) midrange systems specializing in Application Design and Development, Database Analysis and Development, and complete SDLC. Industries served include Manufacturing, Engineering, Real Estate Management, Health Care,,, and Retail Supply Chain. Highly skilled at entering new situations and getting up to speed quickly, analyzing and troubleshooting existing systems, and developing new systems.
• Excellent database analysis skills. Programming language expertise includes all versions of RPG, AS400 Control Language (CL), COBOL, SQL, embedded SQL, IFS, and ILE programming concepts, as well as display files, subfiles, and production support.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Responsibilities:

• Working remotely as an AS400 consultant for Clearbridge Technology Group, performed as a COBOL programmer/analyst developing new programs, modifying existing programs, and occasionally troubleshooting.
• Used embedded SQL in COBOL ILE programs and worked with very large CL programs. Also worked as their main developer of very large SQL tables for use by their Informatica programmers. Much of the programming was to either import data into their systems or to send data out of their systems to their clients and business partners via IFS.

Confidential, Port Washington, WI

Responsibilities:

• As an AS400 consultant for Confidential Inc., performed programming, analysis, and testing related to merging of the Allen Edmonds Shoe Company into the Confidential company. Languages used: CL and RPG ILE.

Confidential, Roseville, CA

Responsibilities:

• Worked remotely as a Senior Consultant providing programming support for their AS400 MedSeries 4 (MS4) Payroll and H/R systems using RPG ILE and CL. Programming often involved using Integrated File
• Structure (IFS) technology and secure FTP for distributing sensitive healthcare and payroll information to different hospital locations and computer platforms. Also provided operational support by running essential jobs in the live production environment and troubleshooting any problems that arose in their scheduled production jobs.

Confidential, Washington, DC

Responsibilities:

• As a consultant, participated in a 9 ½ month project to convert all Confidential files on the AS400 iSeries system to a nationally centralized PeopleSoft system that consolidated all Ascension Health hospitals. This involved a long cycle of analysis, conversion programming, testing, data validation, and data corrections in coordination with the national conversion team of Ascension Health and Providence
• Hospital over the life of the project. Main responsibility was the successful conversion of the Sieman’s MedSeries4 (MS4) Human Resources files, along with assisting with the MS4 Payroll files conversion. System resources utilized were RPG ILE, CL (IBM Control Language), SQL, embedded SQL, Query/400, and Excel spreadsheets.

Confidential, Monroeville, PA

Responsibilities:

• Working as an AS400 consultant, performed programming and analysis using RPG ILE, CL, and SQL for their package Delivery Tracking System enhancements. Also ran existing programs to effect package delivery scheduling adjustments in real time as part of my production support duties.

Confidential, Reston, VA

Responsibilities:

• Working remotely as an AS400 consultant, participated in several large development projects associated with their health insurance claim processing business based on the MHS software system. Some projects involved producing 837 files and EDI programming.
• Others involved writing or changing screen entry programs that interfaced with stored procedures communicating with the web. Programmed with COBOL ILE, CL, and embedded SQL. Wrote new batch programs to edit and process insurance data uploads and downloads to and from clients, performed troubleshooting and debugging as needed, and other large projects associated with HIPAA 5010, claims,, and billing.

Confidential, Richmond, VA

Responsibilities:

• As an AS400 consultant, produced many ad-hoc custom reports for upper management at City Hall, debugged and maintained key programs that produced student transcripts, developed programs that transferred data to and from PCs/Servers, and helped design and develop the “School Dashboard” system that tracks and displays school data and statistics from the iSeries over the web using Java Server Pages at the backend. Used RPG-FREE, CL, and Query/400.

Confidential, Alexandria, VA

Responsibilities:

• As an AS400 consultant, performed programmer/analyst and database analyst services developing ways to improve the accuracy of the data contained in their large insurance database. Much of this involved using SQL and Query/400 to find inactive, invalid, incomplete, or duplicate records across many files so that the data could be corrected by the client and accurate numbers could be retrieved for reporting. Also wrote new CL and COBOL ILE programs that improved their search and data retrieval capabilities when searching their database, resulting in much more efficient customer service and overall workflow.

Confidential, Richmond, VA

Responsibilities:

• As an AS400 consultant, worked as part of a team of developers working together to expand their International Purchase Order System for the Supply Chain department. Created detailed design documents prior to programming and created user documentation before project implementation. Developed RPG file maintenance screen programs for new files, wrote data conversion programs to correctly map and populate new data fields and data files, and modified existing programs to use the new files and purchasing processes.

Confidential, Washington, DC

Responsibilities:

• Lead Developer/Consultant on a variety of AS400 projects, including an automated file reorganization system to automatically remove delete-flagged records from their files when numeric thresholds were reached, an archiving system to remove linked engineering job records from numerous active files and archive them, file transfers that moved data to and from file servers using FTP, foreign currency enabling of financial systems, specialized financial reporting for upper management, and more. Used RPG, CL, and embedded SQL. Worked remotely much of the time.