SUMMARY:

• 25 plus years as an IT Consultant in a variety of mainframe environments.
• 8+ years of MEDICARE/MEDICAID systems development.
• 8+ years of Health Insurance including FEP Systems
• 2 1/2 years in State Dept of Social Services, and Childcare Management systems.
• 2+ years in Catalog Sales, Order Entry, Credit Card Billing & securityMultiple Database conversion (IMS to DB2) at various client sites
• Experienced with SDLC, Requirements planning, systems analysis, information gathering, Application
• & Database Design, QA, Unit, & Regression testing procedures.
• Excellent problem determination and resolution skills.
• Successfully performed in Team lead, and Technical Resource and Project Lead positions.

TECHNICAL SKILLS:

Operating Systems: Z/OS, OS390, MVS (XA & ESA), VSE

Software: COBOL 390, Cobol II, DB2, QMF, SPUFI, SQL, EXPLAIN, Oracle (mainframe), IMS DB/DC, CICS & CICS utilities, BMS, BMS/GT, EASYTRIEVE, TSO/ISPF, MQ, Stored Procedures, ENDEVOR, CHANGEMAN, Panvalet, TELON, FILEAID, XPEDITER, SMARTTEST, DEBUGGER, INTERTEST, SyncSort, CaSort. Microsoft OFFICE Suite, Microsoft VISIO, Microsoft PROJECT, LOTUS NOTES.

RESUME OF PROFESSIONAL EXPERIENCE:

Senior Analyst

Confidential, New Hampshire

Responsibilities:

• Apply required changes to COBOL/CICS programs and BMS Maps
• Troubleshoot and fix several CICS programs with various abend problems.
• Assist in the Reverse Engineering of the client Company's Life Insurance Enrollment System.
• Update the stored procedure cross reference matrix for all called procedures.
• Update the data dictionary when needed.
• Flowchart the process of Stored Procedures using MS VISIO.
• Provide narratives for nontechnical staff.

Skills Used: COBOL CICS, BMS, VISIO, PANVELET, EXCEL, DB2

Senior Analyst/Developer

Confidential

Responsibilities:

• Research change requests for the Claims System batch & CICS.
• Write detailed Specifications for problem resolution.
• Help resolve issues and abends.
• Often made code changes required by the Specifications I wrot.

Skills used. Cobol - 390, DB2,QMF, SPUFI, CICS, IMS DB/DC, JCL, SyncSort, Endevor, Trace Master.

Senior Analyst/Developer

Confidential, Springfield, IL

Responsibilities:

• Analyze existing IMS Programs and produce DB2 code needed to get the same results as the old IMS programs for State Child Care Management Systems.
• Test DB2 Queries using QMF and SPUFI to validate data accuracy.
• Requested additional indices to help improve seek times and prevent table scans where needed.
• Helped move several programs out of TELON and convert to COBOL modular code.

Skills used: Cobol-390, CICS, EASYTREIVE, DB2 SPUFI/QMF, IMS, EXPEDITER, SyncSort, TSO, Panvalet, TELON, MS Office Suite

Senior Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Wrote programs to convert and prepare IMS Data to be uploaded to DB2 databases.
• Performed maintenance on existing programs in the old employee Benefits & Retirement System.
• Researched Period of Service and Payment Method for Retired Employee’s.
• Wrote programs to convert Period of Service and Payment method data for load to Oracle Database.
• Create turnover packages for Peer Review, Customer Acceptance, QA review and Production install.

Skills used: IMS, DB2, QMF, SPUFI, COBOL-390, ENDEVOR, EXPEDITER, TSO, DUMPMASTER, SyncSort, JCL, Shareware, Office Communicator, MS OFFICE, VISIO, MS Project, DELTEK time Reporting.

Senior Analyst/Developer

Confidential, Pennsylvania

Responsibilities:

• Wrote programs to convert and prepare IMS Data to be uploaded to DB2 database.
• Performed Maintenance on reporting programs for Membership Services.
• Researched and documented Membership DIRECT PAY criteria.
• Worked various shifts to get the data loaded to the databases.

Skills used: IMS, DB2 COBOL-390, ENDEVOR, EXPEDITER, TSO, DUMPMASTER, MQ Series, JCL, Shareware, Office Communicator, MS OFFICE 2003, VISIO, MS Project, DELTEK time Reporting.

Senior Analyst/Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Wrote several programs to convert and prepare Data to be uploaded to the DB2 database.
• Wrote several query modules to validate and merge data to be uploaded.
• Wrote detailed specs for assembler program to relax the name edits for the database load files.
• Documented FTP procedures for TSO and DOS Command prompts to transfer data from an EXCEL spread sheet to a flat file for upload to the database.
• Worked various shifts to get the data loaded to the databases.
• Wrote Excel schedules for the MOCK 1 & Mock 2 load efforts.

Skills used: COBOL 390, ENDEVOR, EXPEDITER, TSO, MQ, FTP, CA7, JCL, FILEAIDSyncSort, MS Windows XP PRO, MS OFFICE 2010, LOTUS NOTES.

Senior Analyst/Developer

Confidential, South Carolina

Responsibilities:

• Performed analysis functions for problem identification and resolution for multi-state Medicare/Medicaid clients.
• Wrote specifications to correct/enhance IMS & DB2 Batch programs.
• Test, validate, document, and implement solution to production.
• Modify JCL when needed.

Skills used: COBOL/390, APS, IMS, DB2, QMF/SPUFI, MQ, EASYTRIEVE, ENDEVOR, EXPEDITER, TSO, Windows XP PRO, MS OFFICE, LOTUS NOTES

Lead Senior Analyst

Confidential

Responsibilities:

• Responsible for the maintenance and enhancements of the CICS based Order Entry and Warehousing systems, including returns, distribution, and credit card processing.
• When I came on board the CICS based Order Entry system was experiencing several hundred abends per day.
• I did the research, identified the problems which were all commarea related.
• I Redesigned the commarea.
• Wrote detailed specifications for 60 plus Programs to be changed.
• Applied the changes and tested them. After Extensive testing by the QA group The new system went into production.
• From that day forward the online systems abend rate dropped from several hundred per day to less than 20.
• Worked closely with end users to identify problems correctly.
• Set up test cases for problem resolution by extracting production data from the DB2 Log files.
• Coordinated QA testing procedures with customer support to validate the solutions.
• Gather requirements from client meetings, determine which resources should be used and translate the requirements into program specifications
• Implemented universal DB2 abend routines, which were inplemented in 2006.
• The routines identified the SQL code & state codes, values of the host variables used for the call, and the SQL commarea, the information was written to the DB2.LOG table and used as an aid in the problem determination process.
• Added kits and components processing logic to the On-Line & Batch systems.
• Participant on the ‘Credit Card Fraud Prevention’ project.
• Identified inefficiencies in DB2 Calls so more INDICES could be used to prevent table scans.

Skills Used: COBOL, CICS, DB2, QMF/SPUFI, EXPLAIN, BMS, EXPEDITER,MQ, EASYTRIEVE, FILEAID (VSAM & DB2), ENDEVOR, TSO, JCL, FTP, CA7, SyncSort, MS Windows XP PRO, MS Office 2000, LOTUS NOTES.

Senior Analyst/Developer

Confidential

Responsibilities:

• Developed On-Line application to create and maintain the Process-Rules File for each state in the FEP system. This allowed identification of Specific lines of business and supplied processing rules for each line of business.
• Included the Process Rules file logic into the FEP On-line and batch systems.
• Expanded claim # field to 14 characters.
• Applied required HIPAA changes to the on-line system.
• Helped set up QA testing rules and procedures for the upgrades.
• Responsible for testing against existing production data in a parallel region, Using Fileaid to compare test output files to Production data
• Modified CLIST to change symbolic characters in JCL job streams.

Skills Used: COBOL II, IMS/DB, DB2, QMF/SPUFI, CICS, BMS, TSO/ISPF, JCL, CLIST, ENDEVOR, EXPEDITER, EASYTRIEVE, FILEAID, SyncSort,, Microsoft Office 2000.

Project Lead

Confidential, Richmond, VA

Responsibilities:

• Wrote technical design documents and specifications for the upgrades to deposits and transaction routing systems of the ONE BANK project.
• Developed work load schedules using MS PROJECT, and assigned tasks as staff became available.

Skills Used: COBOL II, TSO/ISPF, CICS, JCL, VSAM, DB2, QMF, SPUFI, CASorty, Wdows XP, Microsoft OFFICE, MS PROJECT

Senior Systems Analyst/Team Leader

Confidential, Richmond, VA

Responsibilities:

• Collected information and wrote specifications for several of the upgrades to the CICS systems for the Virginia Medicaid.
• Gather requirements from client meetings, determine which resources should be used and translate the requirements into program specifications.
• Enhanced CICS based systems for Claims Processing, Diagnosis Codes maintenance, Participant Eligibility update and Query systems.
• Corrected problems with existing CICS screens.

Skills Used: COBOL II, DB2, QMF/SPUFI, CICS, TSO/ISPF, JCL, CA7, FILEAID, ENDEVOR, SyncSort, Windows, Microsoft Office, LOTUS NOTES

Senior Analyst/Develpoer

Confidential

Responsibilities:

• Wrote several DB2 programs for the Product Profitability group to build claims history data for 3rd party Vendors and upload it to the DB2 database.
• Coded several programs to extract additional data from other DB2 databases to complete the claims history data
• Wrote procedures for FTP data transfers from PC to mainframe.
• Wrote several programs to convert data from multiple vendors in several file formats to VSAM sequential files.

Skills Used: COBOL II, DB2, QMF/SPUFI.CICS, TSO/ISPF, JCL, FTP, FILEAID, EXPEDITER, ENDEVOR, SyncSort, MS Windows Microsoft Office.

Senior Analyst/Developer

Confidential

Responsibilities:

• Assisted in the conversion of CICS Screens for the CACS (Computer Assisted Collections System).
• Converted CACS programs to accept new data feeds.
• Wrote custom code for optional CACS features.
• Put the Confidential Logo in screen headings.

Skills Used: CICS, DB2, QMF/ SPUFI, TSO/ISPF, JCL, VSAM, CHANGEMAN, FILEAIDE, CASortMS Windows, MS Office.