SKILLS PROFILE:

• Areas of Expertise VSAM to DB2 Conversions,IDMS to DB2 Conversions, Data Migration. Database Development. Business Systems Analysis. Data architecture. Database analysis. Analysis, design programming, and QA testing. Consulting, multiple PeopleSoft Conversions, SAP Conversion, Production Support 24/7 , Oracle, DB2, MQ, Web Interface.
• Applications Financials, Accounting, Health Care Delivery, Medicare, Claims, Insurance, Retail, Financial Institutions, State of Ohio, Marketing, Nuclear Energy Company, Greeting Card Company, Manufacturing, World Famous Clinic, Oil Company, Telephony, Procurement, Billing, Order Processing, Invoicing, Commission Rate, Purchasing, GL, DB Support, HR, Payroll, CAS, Mortgage Foreclosures, Mortgage Insurance.
• Hardware, Operating Systems - Windows, IBM mainframes, z/OS, XA, OS/MVS, OS/390, Client/Servers
• Software DB2,VSAM, SQL, SQR, IMS, IDMS vers 10 to 17 , ADSO, ADSA, ADS/BATCH , DMLO, OLQ, COBOL, CICS, VISIO, QMF, SPUFI, TSO, ROSCOE, CMS, LIBRARIAN, ENDEVOR, CHANGEMAN, Panvalet, Xpediter, Intertest, EDS, WORD, EXCEL, MS Project, MERCURY TEST DIRECTOR, HP QUALITY CENTER, REMEDY, DB2 CONNECT, CA7, NDM, Oracle, MQ CICS Web Interface.
• Languages - COBOL, JCL, SQR, DYL280, CULPRIT, Easytrieve, Focus

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

• Designed and created new DB2 Batch programs to perform maintenance on DB2 tables. Coded and tested changes to DB2 Stored Procedures and Programs to
• Populate a new column on the DB2 tables. These changes were successfully installed in Production.
• Design and Analysis for combining notifications for FTP Data transmissions into one email.
• Added Member Alerts to DB2 Stored Procedures and Batch Programs.
• Tested these changes and successfully implemented them into Production..
• Performed scans of Panvalet and Copylibs to identify programs that needed to be remediated for the ICD10 Code Conversion project.
• Completed the Design, Coding, Testing of the ICD10 Code Conversion for several
• CICS DB2 programs and CICS Maps. Coded and tested DB2 Batch programs for the
• . ICD10 Code Conversion project including Landmark and Express Scripts.
• Fixed several Production support issues.
• Coded Medicare Advantage changes.
• Coded and Tested Disease Management Rules in DB2 Stored Procedures and DB2 Programs

Confidential

Software Engineer

• Completed the Design, Coding, Testing and Implementation of the Zero Monthly Redesign for a Mortgage Insurance project which generated an additional 5 Million in Revenue for the Client. Utilized Cobol, DB2, QMF, SPUFI, Test Scripts, Stored Procedures, Oracle, CICS, MQ, NDM, Endevor, vsam, JCL, CA7 Scheduler, Eztrieve to complete this project.
• Saved the Client 4 Million Dollars by designing, coding, testing, and implementing the TERMS78 Project Utilizing Cobol, DB2, IDMS, Oracle, CICS, MQ, NDM, Endevor, vsam, JCL, CA7 Scheduler, Eztrieve.
• Designed and created new DB2, Oracle, IDMS, VSAM, CICS Financial programs.
• Provided Production Support for Nightly Financial Batch Processing .
• Mentor to new Hires.
• Provided suggestions to enhance performance.

Confidential

Software Engineer

• Developed new Programs using COBOL.
• Analyzed PNC data and Flagstar data to facilitate data conversion
• Converted Flagstar Banks to PNC Banks
• Performed QA function verification of conversion data
• Developed Program code, performed unit test, system test, QA test, Mock Conversion, Early Push, and Loaded into Production IMS Database
• Perform these responsibilities using COBOL, IBM Utilities, JCL, VSAM, TSO, VSAM, DB2, VSAM, Oracle, WORD, EXCEL, FILEAID, IMS, CICS, and ENDEVOR.
• Assisted in the Conversion of Royal Bank of Canada RBCB Banks by performing unit test, system test, QA test, Mock Conversion, Early Push, and Loaded into Production IMS Database

Confidential

Application Programmer/Analyst

• Created a new ADSA Clearinghouse Structure
• Developed new IDMS Batch Programs using COBOL.
• Created 10 new ADS/O Dialogs to interface with SAP Accounts Payable and General Ledger and Financial Systems
• Perform these responsibilities using COBOL, CICS, z/OS, IDMS, IBM Utilities, TSO, ADS/O, MAPC, ADSC, IDDM, DMLO, OLQM, IDMS, VSAM, DB2, WORD, EXCEL, and ENDEVOR.

Confidential

Application Production Support

• Completed a z/OS upgrade to the JCL and the Procs for 500 batch jobs.
• Suggested runtime performance improvements which cut the batch runtime by 3 hours.
• Developed new IDMS Batch Programs using COBOL.
• Created several new ADS/O Dialogs and a CICS/VSAM Online Program.
• Ensure the 24x7x365 availability and functionality of a High Availability Credit Loss Management Financial Reporting System, including Mortgage Forclosures.
• Monitored production processes, pro-actively deter application and data issues, react quickly and efficiently to production problems.
• Provide timely and clear communication of production issues.
• Review/analyze/modify programs and job schedules to reduce runtimes and increase throughput.
• Investigate and Resolve Production Data Issues.
• Train/mentor junior staff.
• Perform these responsibilities using COBOL, CICS, z/OS, IDMS, IBM Utilities, TSO, ADS/O, MAPC, ADSC, IDDM, DMLO, OLQM, IDMS, VSAM, DB2, REMEDY, EXCEL, and ENDEVOR.

Confidential

Technical Consultant for solving production performance issues on batch jobs, and deadlock issues with online screens for the University of Mississippi utilizing IDMS rel. 17 and ADSO.

Confidential

PeopleSoft Financials Conversion Programmer Analyst. Cost Accounting and Financials Programmer

• Analyst for Progressive Insurance. Implemented the largest project in Progressive's history for the Financial area.
• Provided Production Support and Enhancements for DB2 Cost Accounting and Expense Mainframe systems. Converted several programs from VSAM to DB2.
• Performed Enhancements and Production Support for IDMS Claims System.
• Changeman Manager for Corporate Financial area. QA Tester, Solved Production Performance issues.

Confidential

• Defect Manager for Epic HealthCare Conversion project. Lead Systems Analyst for large IDMS to DB2 Conversion including Membership, Medicare, Claims system.
• Converted ADSO Dialogs to DB2/CICS.
• Maintained 3 CICS/DB2 Environments for Membership, Medicare, and Claims systems. Maintained the DB2 database, package binds and plans. Year 2000 lead for the batch testing of all financial and clinical applications for Healthcare and Insurance. Applied technical solutions and provided Production support 24/7 for DB2 CICS IDMS Healthcare and Insurance systems.

Confidential

• Successfully Completed the Year 2000 Remediation for National City Bank's Checking Account DDA and Savings Account systems DES . Skills used: CICS/VSAM/DB2/UFAM/Expediter/Cobol II. Part of the role was solving system test problems, researching problems with testcases, rewriting JCL and Procs, changing and recompiling programs as well as running integrated and system test.
• Responsible for aging the input data files. When coworker left the project, assumed his responsibilities as well..

Confidential

Successfully Completed all phases of the Fax and EDI transmission of Purchase Orders project for Joann Fabrics utilizing DB2/CICS, batch DB2, IDMS, Expediter, QMF, Spufi, Cobol II, Word, Excel, etc.

Confidential

• Developed the State of Ohio Careworks Workmans Comp Claims system for Blue Cross Blue Shield.
• Developed and modified the Cobol II. VSAM, CICS programs, batch Cobol II programs, JCL, Procs, copybooks, and setup CICS tables including FCT and PPT entries.
• Installed and coordinated scheduling of 140 batch jobs, pinpointed online problems and solutions, created production support documentation and provided production support 24/7.

Confidential

Linked 3 mainframes together using CICS DPL Links and Windows NT for Key Bank. Applied solutions using Cobol II, DB2, and CICS. I coded, tested, and implemented new DB2, CICS, Cobol II programs which interfaced to and from the Client Server Infrastructure.

Confidential

• Successfully completed multiple projects including a Peoplesoft Conversion project. Completed all phases of a Payroll/HR Peoplesoft Conversion project using SQR, Cobol II, DB2, Client Server.
• Converted data from CICS and IMS to DB2. Created all of the SQL reports for Payroll and Human Resources as well as the paycheck, direct deposit advice programs, W2 year end processing, and the year end tax programs.
• Developed a Client Server solution for the Successful Marketing and Retention Tool SMART Project, using Xceed's Sysbase Marketing package.
• Completed the analysis of Centerior's business needs, Data mapping, program specs, coded DB2 and IMS interface and conversion programs. Converted VSAM system to DB2.
• Tested and implemented this system into Production.

Confidential

Successfully Completed an IDMS batch Shipping System for American Greetings which interfaced with a client server purchase order system. Developed and tested IDMS/ADSO dialogs for the Order Processing system.

Confidential

Created the Commission Rate Online System application using ADSA, IDMS/ADSO, ADSG, OLM, and IDD.

Confidential

• Successfully developed new IDMS batch, and IDMS ADSO programs for the Cleveland Clinic.
• These new Programs were enhancements to CAS 1.3 System and included A/R, A/P, and Inventory.

Confidential

• Developed an IDMS ADSO and IDMS batch Payroll and HR system for Alltel Telephone Company.
• Created the Online Security System for the Payroll and HR systems, was a developer as well as a lead.

Confidential

• Created an inventory backload system which extracted information from an IDMS database and uploaded An IMS database.
• Developed IDMS batch and ADSO online dialogs which were enhancements to the CAS 1.3 system at Sherwin Williams.

Confidential

Installed, and Enhanced the Genesys Payroll Payroll package for BP America using Cobol and VSAM.

Confidential

Developed the Financial Equity Risk Management System for General Electric using IDMS batch, IDMS ADSO, ADSA, OLM, and IDD.

Confidential

Successfully completed a Table Access Management System using COBOL, VSAM, IDCAMS, TSO, and Panvalet for Ameritech Telephone Corp. Wrote 80,000 lines of structured Cobol in 6 weeks to develop this system.

Confidential

Created the Perry Nuclear Power Plant Time Entry system for Centerior Energy using IMS and CICS.

Confidential

Developed a Purchase Order Package using IMS/DB IMS/DC for Arabian American Oil, while employed at Anacomp.