JEFFREY ARCHIBALD

P.O. Box ****

Raleigh, NC ****3

562-***-****

ac2mpc@r.postjobfree.com

Summary

Mr. Jeffrey Archibald 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 9 programmers and performed task scheduling, team code walkthrough and assisting team member in resolving programming problems.

Technical Summary:

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

Education:

Saint Stephens Bible College, Los Angeles, California

Bachelor of Administration Business Administration

Certification:

OCPDBA - CERTIFIED ORACLE 8i

Comp TIA Network+

Experience:

IAT - Raleigh, NC

Programmer Analyst - 02/15 to Present

- Programmed in AS400, COBOL, CL, and SQL.

- Provided analysis, coding, documenting, testing, and implementation of IAT POINT system.

State of North Carolina (DES) - Raleigh, NC

System Programmer - 11/12 to 12/14

- Interfaced with the (DES) Department of Economic Security programming staff on creating and maintaining ZEKE events for the production cycle. Maintaining and monitoring RACF groups and profiles for DES.

- 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 Department of Economic 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 DES.

- Mapped data from existing COBOL programs to JAVA and .NET. Presently receiving training with .NET.

JEFFREY ARCHIBALD Page 2

CSC - Raleigh, NC

Programmer Analyst - 08/11 to 08/12

- Provided analysis, coding, documenting, testing, and implementation of Financial Claim System for the State of North Carolina. Assisted with the development of CSR for the State of North Carolina.

- Created Unit and String test cases documents for the Financial Reporting System being presented to the State of North Carolina. Interfaced with team leads of different system to identify outstanding issues, that impacted SAS and JAVA 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.

Blue Cross Blue Shield of Michigan – Detroit, MI

System Analyst - 01/11 to 08/11

- Provided analysis, coding, and testing of ICD-10 conversion for their NASCO database, and OSCAR BI Claims 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.

STATE of SOUTH DAKOTA – Pierre, SD

Programmer Analyst - 05/07 to 01/11

- Programmed in ORACLE 11i, COGNOS, DATASTAGE, COBOL 390, WEB 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 State of South Dakota. I also interfaced with CNSI staff with the status of the ORACLE tables.

SRP – Tucson, AZ

Programmer Analyst - 02/06 to 03/07

Provided analysis of design, coding, testing, and implementation of program fixes and major/minor enhancement for a new service call M-Power project written in COBOL 390, CICS, DB2, MQ series, MVS/JCL, MVS/XA, and TSO/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.

ACS – Eagan, MN

Programmer Analyst - 03/05 to 01/06

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, MQ SERIES, 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 State of North Carolina internal procedure. Also coding and testing of the Enrollment Fee/Allotment Maintenance system.

JEFFREY ARCHIBALD

Page 3

Diamond Technology – Phoenix, AZ

Programmer Analyst, 01/99 to 02/05

State of Florida

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

EDS – Electronic Data System

- 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 EDS’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.

Blue Cross Blue Shield of Michigan

- 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 Blue Cross Blue Shield of Michigan. Main focus was working with Claims-837, Claim Payments and RemittanceAdvice-835.

State of Arizona

- Programmed in ORACLE 8i, PL/SQL, RMAN, COBOL 390, DB2, SQL, CICS, TSO/ISPF, MVS/JCL, CHANGEMAN, SPUFI, QMF, MAINVEIW, FILE-AIDE, MVS/ESA, MQ Series, 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.

BNSF - Burlington Northern Santa Fe Railway

- Programmed in COBOL 370, M/F COBOL, DB2, SQL, CICS, TSO/ISPF, IMS, MVS/JCL, CHANGEMAN, SPUFI, MAINVEIW, FILE-AIDE, QMF, BMC, MVS/ESA, PLATINUM.

- Researched the Personnel Activity Tracking System for impact from resizing DB2 tables. This project cuts across many

existing systems and business areas and required a complex coordinated testing effort. Demanded the ability to create and

maintain DB2 tables. Also assisted with the IMS to DB2 conversion for the PAT System as an Analyst/Coordinator.

Created new standards for Burlington Northern Santa Fe Railway’s menu driven CICS programs.

NDC HEALTH SYSTEM

-Programmed in COBOL 370, DB2, CICS, SQL, PL/SQL, UNIX, TSO/ISPF, MVS/JCL, QMF, SPUFI, IMS, VSAM,

CHANGEMAN, MVS/ESA, PLATINUM, GROUP/1. Utilized COBOL/CICS/DB2 to develop the Drug Override system. This involved designing, coding, testing, implementing, and documenting in a DB2 database environment. Supported the Medicaid, and claims production issues dealing with existing legacy systems written in COBOL/CICS/DB2. Assisted DBA and the system programmer with creating and loading DB2 tables for several different CICS test regions. Also was involved with impact analysis and coding for HIPAA. Provided 24/7 on-call production support with the MMIS area.

JEFFREY ARCHIBALD

Page 4

CSI - Computer Services International – Phoenix, AZ

Programmer Analyst, 03/97 to 11/98

Unisys/State of Kentucky

- 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, Patient’s Accounting, and the Third Party Liability System for the State of Kentucky Medicare division/Unisys.

PCS Health System

- 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.

GTE Healthcare System/Blue Cross Blue Shield of Georgia

- 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 Blue Shield of Georgia at GTE Healthcare. Assisted the System Programmer in creating test regions for the Blue Shield Blue Cross team.

1st Interstate Bank - Tempe, AZ

Programmer Analyst, 09/94 to 02/97

- 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). The client was 1st Interstate Bank.

CSI - Computer Services International – Phoenix, AZ

Programmer Analyst, 01/94 to 09/94

ABC Collections

- 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.

Long Beach Memorial Medical Center Long Beach, CA

Lead Programmer Analyst, 03/90 to 11/93

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

Contact this candidate