Programmer Analyst North Carolina

NAME: Jeffrey Archibald

POSITION: Programmer Analyst

EDUCATION: B.A., Business Administration, Saint Stephens Bible College

CERTIFICATIONS: OCPDBA – Certified Oracle 8

SOFTWARE/ ORACLE 8i/9i, SQL*PLUS, COBOL 370, COBOL 390, M/F COBOL, CICS,

LANGUAGES: DB2, CICS TS, IMS, SQL, EDI, MQ SERIES, CL, JCL, VSAM, COBOL II, NATURAL, ORACLE 8i/9i/11i, CICS Socket, MQ SERIES, IDCAMS, QMF, CHANGEMAN, ENDEAVOR, SUPFI, PLATINUM, FILE-AIDE, MAINVEIW, CA-7, CA-11, IMPACS, TCP/IP, LIBRARIAN, PANVALET, INTERTEST, XPEDITER, MS Office, MS Project, Via Soft, Method I, INFO-MAN, IBM Utilities, RACF, ZEKE, Systemware, System View, NDM, BMC, HTML, FTP, Systematic, IMPACS, CNSI, IPCP/PLUS, Connect:Direct FTP.

OPERATING

SYSTEMS: IBM OS/390, MVS/ESA/XA, TSO/ISPF

ASSIGNMENTS:

LabCorp 2/18 – Current

Programmer Analyst

Provided analysis, coding, testing, and implementation of Lab Support system using the UNISYS Platform, COBOL, ECL and QLP/SQL.

Collaborated with the End User on identifying issues with the daily tracking of Specimens to different labs.

Updated common logic models using Cobol and QLP.

IAT Group 2/15 – 10/17

Programmer Analyst

Provided analysis, coding, testing, and implementation of IAT POINT system using AS400, COBOL, CL and SQL.

Collaborated with the BA group on identifying issues with the daily, weekly, and monthly cycle of the Edit Reporting System.

Supported the Regulation Compliance department with their monthly, quarterly, and yearly reporting cycles for different municipality.

Updated common logic models using Cobol and SQL.

Developed Audit reports using Cobol, CL and SQL.

State of North Carolina (DES) 11/12 -12/14

System Programmer

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.

Coordinated the movement of source packages to the different test and production environments using Endeavor.

Assisted the Tax team and the UI team with creating reports and forms.

State of North Carolina (DES) 11/12 -12/14

System Programmer

Developed and maintained the existing payment system, utilizing COBOL II, CICS, MVS/JCL, MQ SERIES, IPCP/PLUS, TSO/ISPF, and MVS/XA.

Created Queues using MQ Series for application team.

Maintained and monitored test and production CICS regions for DES.

State of North Carolina 8/11 – 10/12

Programmer Analyst

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 used for mapping data to build of new DB2 table for the NC Medicare project.

Created program spec for mapping data for DB2 table. We were doing a total re-write of the existing NC Medicare system.

As a team lead with the P.E. team, enhanced performance of the existing beta version of the NC- MMIS project,

Set up test runs, created test files, and created JCL job streams utilizing COBOL II, CICS, DB2, MVS/JCL, TSO/ISPF, and MVS/XA.

Blue Cross Blue Shield of Michigan 1/11 – 8/11

System Analyst

Performed analysis, coding, and testing of ICD-10 conversion for NASCO database, and OSCAR BI Claims system using COBOL II, COBOL 390, DB2, MVS/JCL, CL/400, SQL/400, TSO/ISPF, MVS/XA and CICS.

Identified elements and programs that were affected with a field’s expansion in several of the Production VSAM file and their DB2 tables.

State of South Dakota 5/07 – 1/11

Programmer Analyst

Programmed in ORACLE 11i, COGNOS, DATASTAGE, COBOL 390, WEB CICS, TSO/ISPF, MVS/JCL, SYSD, FILE-AIDE, MVS/ESA, TOAD

Interacted with the Department of Social Service in effort to install the CNSI MMIS system.

Collaborated with the State Medical Management on identifying/mapping edits, and business rules logic from an existing mainframe system to CNSI MMIS system.

Developed a VSAM/CICS Medicaid Claims System. Coded, tested, and implemented Cobol/CICS programs.

Performed 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. Interfaced with CNSI staff with the status of the ORACLE tables.

Contact this candidate