SUMMARY:

• Confidential has over 20 years of experience as a System Analyst, Programmer Analyst, System Programmer and Team Lead using COBOL with CICS, DB2, and ORACLE databases. He has worked with varying levels of management, users, System/DBA staff and team members developing user requirements, completing system designs and writing specifications while using verity methodologies. He has lead teams of 3 to 6 programmers and performed task scheduling, team code walkthrough and assisting team member in resolving programming problems.

TECHNICAL SKILLS:

Operating Systems: IBM OS/390, MVS/ESA/XA, TSO/ISPF

Languages: ORACLE 8i/9i, PL/SQL, SQL*PLUS, COBOL 370, COBOL 390, M/F COBOL, CICS, DB2, CICS TS, IMS, SQL, IMS, EDI, MQ SERIES, CL, JCL, VSAM, COBOL II, NATURAL, .NET.

Products/Tool: ORACLE 8i/9i/11i, COGNOS, DATASTAGE, CICS Socket, EDI, MQ SERIES, IDCAMS, QMF, CHANGEMAN, ENDEAVOR, SUPFI, PLATINUM, FILE - AIDE, MAINVEIW, RUMBA, CA-7, CA-11, IMPACS, TCP/IP, LIBRARIAN, SNA, PANVALET, INTERTEST, XPEDITER, PLATINUM, MS Office, MS Project, Via Soft, Method I, INFO-MAN, IBM Utilities, RACF, ZEKE, Systemware, System View, NDM, BMC, HTML, FTP, Lotus Notes, Systematic, IMPACS, CNSI, IPCP/PLUS, Connect:Direct FTP.

Business Domain: Banking, Railway, Credit Card, Health Care, MMIS, HIPAA, Accounting, Insurance, Government, Distribution, Inventory, MITA, Data Warehouse

PROFESSIONAL EXPERIENCE:

Confidential - Raleigh, NC

Programmer Analyst

Responsibilities:

• Provided analysis, coding, testing, and implementation of IAT POINT system using AS400, COBOL, CL and SQL. Worked with the BA group on identifying issues with the daily, weekly, and monthly cycle of their Edit Reporting System. Also supported the Regulation Compliance department with their monthly, quarterly, and yearly reporting cycles for different municipality.

Confidential - Raleigh, NC

System Programmer

Responsibilities:

• Interfaced with the ( Confidential Security programming staff on creating and maintaining ZEKE events for the production cycle. Maintaining and monitoring RACF groups and profiles for Confidential . Acting as Endevor Administrator. My role is to coordinate the movement of source packages to the different test and production environments. Creating and modifying Xerox forms for the Confidential Security. Assisted the Tax team and the UI team with creating reports and forms. I also assisted with developing and maintaining the existing payment system, utilizing COBOL II, CICS, MVS/JCL, MQ SERIES, IPCP/PLUS, TSO/ISPF, and MVS/XA. Maintained and monitored test and production CICS regions for Confidential .

Confidential - Raleigh, NC

Programmer Analyst

Responsibilities:

• Provided analysis, coding, documenting, testing, and implementation of Financial Claim System for the Confidential . Assisted with the development of CSR for the Confidential . Created Unit and String test cases documents for the Financial Reporting System being presented to the Confidential . Interfaced with team leads of different system to identify outstanding issues, that impacted SAS routines. Also interfaced with users on testing and data issues for system sign-off. Created decision table which was used for mapping data to build of new DB2 table for the NC Medicare project. I was assigned task from creating program spec to mapping data for DB2 table. We were doing a total re-write of the existing NC Medicare system. Presently working as a team lead with the P.E. team which focus is to enhance performance of the existing beta version of the NC-MMIS project, also functioned as the contact point with the IT staff with setting up test runs, creating test files, and creating JCL job streams utilizing COBOL II, CICS, DB2, MVS/JCL, TSO/ISPF, and MVS/XA.

Confidential Moines, IA

System Analyst

Responsibilities:

• Provided analysis, coding, and testing of ICD-10 conversion for their in-house production system using COBOL II, COBOL 390, DB2, MVS/JCL, TSO/ISPF, MVS/XA and CICS. Identify elements and programs that will be affected with a field’s expansion in several of their Production VSAM file and their DB2 tables.

Confidential - Pierre, SD

Programmer Analyst

Responsibilities:

• Programmed in ORACLE 11i, COGNOS, DATASTAGE, COBOL 390, CICS, TSO/ISPF, MVS/JCL, SYSD, FILE-AIDE, MVS/ESA, TOAD Worked with the Department of Social Service on installing CNSI MMIS system. My role was to interface with the State Medical Management on identifying/mapping edits, and business rules logic from an existing mainframe system to CNSI MMIS system. Assist a team of programmer in the development of a VSAM/CICS Medicaid Claims System. I also coded, tested, and implemented Cobol/CICS programs. Assisted with a VSAM to ORACLE conversion that involved data mapping and analyzing impact to programs, coding and testing programs. Mapped and coordinate ORACLE tables against existing VSAM file for the Confidential . I also interfaced with CNSI staff with the status of the ORACLE tables.

Confidential - Phoenix, AZ

Programmer Analyst

Responsibilities:

• Provided analysis of design, coding, testing, and implementation of program fixes and major/minor enhancement for a new service call M-Power projectwritten in COBOL, CICS, DB2, CL/400, SQL/400, MVS/JCL, MVS/XA, andTSO/ISPF. This project is enhancing an existing utility company system, enabling them to allow customers to transfer from the standard monthly billing cycle to pay as you need the service. I also mapped data and build test cases for the purpose of testing common modules for M-Power.

Confidential - Eagan, MN

Programmer Analyst

Responsibilities:

• I enhanced an existing Enrollment Fee/Allotments Maintenance system to accept TRS transactions along with their PRIME transactions. The current environment is using COBOL II, CICS, DB2, VSAM, MVS/JCL, MVS/XA and TSO/ISPF. My role was to assist with writing spec and test plans for a number of CICS programs for the Confidential internal procedure. Also coding and testing of the Enrollment Fee/Allotment Maintenance system.

Confidential - Phoenix, AZ

Programmer Analyst

Responsibilities:

• Provided extensive hands-on analysis in the field and file expansive in an environment using COBOL II, CICS, DB2, SQL, VSAM, MVS/JCL, MVS/XA and TSO/ISPF. In this project my role was to identify elements and programs that will be effected with a fields expansion in several of their Production VSAM file. I also assisted with setting up the test environment allowing us to test and run a parallel test with the production daily, and monthly cycle. I was the contact point with the IT staff with setting up test runs, creating test files, and creating JCL job streams that was model after the existing production job stream

Confidential

Responsibilities:

• Provided analysis, design, coding, testing, documentation, and implementation of NCPDP v5.1 Prior Authorization Transaction Segment for CALPOS using COBOL II, COBOL 390, ORACLE, MVS/JCL, VSAM, TSO/ISPF, MVS/XA, MQ Series and CICS. I participated in creating the (SFD) System Functional
• Design document and the (TSD) Technical System Design document for the State of California Health Department, and Confidential ’s staff. The NCPDP v5.1 Prior Authorization Transaction System was based on the existing Pharmacy Claims System. Prior Authorization segments were passed from the IBM mainframe using CICS Socket to the ORACLE SURGE Database. Also was involved with the Product Delivery team making several fixes to support the real time Pharmacy Claim System. This project involved a working knowledge of NCPDP v5.1 data requirements, which outlined required and optional data for a Prior Authorization transaction segment type. Data was mapped according to the SURGE Database which processed TARs coming from the IBM mainframe.

Confidential

Responsibilities:

• Provided analysis, coding, testing, and implementation of major/minor program enhancements using COBOL II, COBOL 390, DB2, MVS/JCL, VSAM, TSO/ISPF, MVS/XA and CICS. Also made enhancement to an in-house Medicaid healthcare system and assisted with supporting the HIPAA for the Confidential . Main focus was working with Claims-837, Claim Payments and RemittanceAdvice-835.

Confidential

Responsibilities:

• Programmed in COBOL 390, DB2, SQL, CICS, TSO/ISPF, MVS/JCL, CHANGEMAN, SPUFI, QMF, MAINVEIW, FILE-AIDE, MVS/ESA, PLATINUM Lead a team of programmer in the development of a CICS/DB2 Medicaid Reporting System. I performed task scheduling. Conducted team walkthroughs. I wrote program specs. coded, tested, implemented DB2 Stored Procedures, CICS and DB2 COBOL II programs. Assisted with several different conversion projects, the IMS to DB2 conversion that involved data mapping and analyzing impact to programs, coding and testing programs. Also assisted with VSAM to DB2 conversion.

Confidential - Phoenix, AZ

Programmer Analyst

Responsibilities:

• Programmed in COBOL II, M/F COBOL, CICS, TELON, VSAM, TSO/ISPF, MVS/JCL, MVS/XA, MMIS. Functioned as the primary point of contact supporting requirement analysis, development of issue resolution schedule, and planning for the Client Claims System, Confidential t’s Accounting, and the Third Party

Confidential

Responsibilities:

• As a Production Control team member, utilized COBOL II, CICS, IMS, DB2, TELON, SQL, QMF, SPUFI, JCL, PLATINUM, VSAM, MVS/JCL, MVS/XA AND TSO/ISPF to provided 24/7 application support for PCS Health System daily production cycles. This involved identifying the problem, researching issues, providing the solution or contacting other team members that created the system and getting their assistance to resolve the issue. Also functioned as a team contact and/or coordinator.

Confidential

Responsibilities:

• Provided analysis, design, coding, testing, documentation, and implementation of program fixes and major/minor enhancements using COBOL II, CICS, MVS/JCL, VSAM, TSO/ISPF, MVS/XA and CICS. Also made enhancement to an in- house claims healthcare system and assisted with supporting the MMIS for the Confidential of Georgia at GTE Healthcare. Assisted the System Programmer in creating test regions for the Confidential Blue Cross team.

Confidential - Tempe, AZ

Programmer Analyst

Responsibilities:

• Provided analysis of design, coding, testing, and implementation of program fixes and major/minor enhancement for Consumer and Mortgage Loan applications written in COBOL II, CICS, DB2, SQL, VSAM, MVS/JCL, MVS/XA and TSO/ISPF. Enhanced part of the Alliance Project written in COBOL II and CICS, which customized and Standardized CMS for all affiliates, which operated differently (Interstate Banking).

Confidential - Phoenix, AZ

Programmer Analyst

Responsibilities:

• Programmed COBOL II, CICS, VSAM, MVS/JCL, MVS/XA and TSO/ISPF to provide enhancement to an existing Financial System handling VISA Collections. Also utilized COBOL II and CICS to expand the healthcare legal requirement by creating a system that allowed the Production Activity file to be downloaded to a PC on request by auditor. Interfaced with the users and management on the VISA Collections Enhancement.

Confidential - Long Beach, CA

Programmer Analyst

Responsibilities:

• Utilized COBOL II, CICS, DB2, SQL, VSAM, TSO/ISPF, MVS/XA and MVS/JCL to provide enhancements, testing, implementation, and support for a TDS Confidential t Tracking System. Trained the medical staff on usage of the online screens for the Confidential t Tracking System. Assisted with converting the company from Tandem to IBM.