Cobol Rpg

** ********** ****** *****: 973-***-****

Pequannock, New Jersey 07440 Email: **********@*******.***

James Avitable

Profile Highly skilled in analyzing, designing, specifications, programming, testing, documenting, instructing,

implementing and maintaining CICS/DB2/MQ/VSAM on-line and Cobol II batch systems with complete

life-cycle processing experience.

Years Years Years

Programming CICS 20+ BAL / Assembler 18 IDMS 2

COBOL 20+ MQ 8 RPG II 2

VSAM 20+ Stored Procedures 2 Channels/Containers 1

DB2/SQL 15 REXX 2 CWS 1

Skills Z/OS OS/390 MVS Data Studio Excel Powerpoint Word Easytrieve

TSO/ISPF OS/JCL DOS/JCL Endevor Changeman HTML/XML Xpediter Intertest Agile BMC AppWatch MQmenu File-Aid SPB Syncsort

History

>Compassionate Leave

01/20-01/23

Care of terminally ill relative.

> United Health Group Basking Ridge, N.J.

05/19 –01/20 Position: Consultant

Part of team converting multiple divisions to one national division to serve as a common source of truth for provider demographics and contracts. Created CICS, COBOL, DB2 programs to reflect pre-change business requirements and also for the creation of the new national division, using source data from the old geographically local divisions.

>Fidelity Investments Jersey City, N.J.

05/18 – 02/19 Position: Consultant

*Changed Trading Activity Fee (TAF) reporting to allow for the inclusion of cancelled trades into all reports’ calculations as negative amounts. Skills entailed CICS/COBOL II/DB2/JCL. Learned JAVA/Eclipse in preparation of anticipated future system conversions. Used Data Studio as tool for developing SQL/PL stored procedures.

> Bank of America Jersey City, N.J.

10/16 – 09/17 Position: Consultant

*Part of team writing a COBOL II, DB2 batch process to swing physical certificates from participant Merrill Lynch to become a new retail participant as part of Bank of America’s separation of retail and institutional broker dealer activities. The processing consisted of new batch COBOL II/DB2 jobs, creating their JCL, and identifying and capturing the pertinent physical certificate records from a DB2 table, translating old boxes to new boxes, and placing them on an AIMCDI-formatted file for transmittal to DTCC for swing consummation. Multiple excel reports documented the audit trail, both pre-DTCC and post-DTCC. I also, enhanced, tested and debugged multiple CICS/DB2 programs to accommodate the ongoing company enhancements.

> United Health Group Basking Ridge, N.J.

04/13 – 05/16 Position: Consultant

* Logging of ACA-mandated ERAs and EFTs : Created programs for logging of electronic remittance

advice (ERA) and electronic funds transfers (EFT) events, as part of the monitoring needed to meet

government-mandated requirements of the Affordable Care Act (ACA). These were CICS/MQ and

COBOL II/MQ batch called programs, complemented by an MQ ‘listener’ program utilizing MQ,

DB2 and VSAM processing. Logging is initiated from both distributed and mainframe which results in the calling of my programs, to edit and put the events to MQ, where a ‘listener’ (written by myself) gets the messages and populates a DB2 repository table used for government reporting.

* Parsing of XML DB2 logs to a variable file of multiple-formatted records using COBOL XML parse.

Created Fileaid access to the file, using XREF functionality, as an aid for users data readability.

> United Health Group Basking Ridge, N.J.

07/09 – 10/12 Position: Consultant

* Claims capturing for retesting : Conceived, designed, wrote specifications and coded a claims

capturing system for in-flight MQ claims flowing from distributed users into the mainframe. The

system allowed multiple expeditor testing sessions and infinite retesting of claims.

* Real-Time-Processing of claims : Real-time pricing for both batch and online claims using CICS,

DB2, MQ, Channels and Containers.

* TRICARE Military health program : Interfacing U.S.TRICARE military southern region medical

contract into a current UHG claims processing system using 4th-generation language XGEN

interfacing with CICS and COBOL II.

> Galaxe Solutions Somerset, N.J.

08/08 – 03/09 Position: Consultant

* HIPAA implementation for prescription eligibility :Implementation of HIPAA conformity throughout

a major medical company’s (MEDCO) prescription-processing eligibility system. Analysis of

changes needed for both Batch and CICS with changes incorporating source, JCL, PROCS, control

cards, CICS commareas and file structures.

> UBS Weehawken, N.J.

02/04 – 07/08 Position: Sr. Associate

* Financial Services – Wealth Management : Coded the original application of online intra-day

trades and transactions for their timely dynamic presentation to clients via a client/server

configuration. This was the first time that intra-day techniques came into existence, at UBS. This included all types of wealth management holdings information. Also, developed and maintained batch, CICS, DB2 and Stored Procedures software in support of client enrollment and client inquiry systems for use by field agents.

> Merck-Medco Montvale, N.J.

12/00 - 06/03 Position: Consultant

* Formulary eligibility for third-party claims : Implemented CICS drug copay functionality into a

formulary system.

* Integrated Drug CWS System : Part of a 3-person team which designed and created a CICS-to-

Web Support pilot system (CWS), supplying data communication abilities between users on the

internet and the CICS mainframe which used DB2 tables. The internet medium was in the form of

HTML web pages communicating with mainframe CICS. This included inquiry, browse and update

functionality and was the first CWS processing developed within the Integrated Drug group.

> Prudential Insurance Roseland, N.J.

08/97 - 12/00 Position: Consultant

* Court-mandated remediation of misrepresented insurance policies : Analyzed, designed,

programmed, tested, debugged and documented CICS/DB2/VSAM maintenance programs to

allow for policyholder-selected compensation packages. Enhanced COBOL II/DB2 batch

programs to generate maintenance transactions to be used to update the Prudential main

master file along with programs to monitor the policyholder selection’s status.

> Commercial Data Processing ( CDP ) Fairfield, N.J.

03/96 - 08/97 Position: Senior P/A

* Responsible for a major rewrite of a unique municipal courts ticket and criminal CICS/DB2

system to enable interfacing of CDP’s system with the State of New Jersey's Administration of the Court's System in compliance with state regulations. Interviewed state personnel and analyzed state court system. Determined how to transmit the privately-entered data to the state system so as to maintain compatible parallel systems with enforced data integrity. This system was the only private system in New Jersey that was allowed to process tickets outside the state system. I documented the private system and trained users. I worked independently as the CICS/DB2/VSAM programmer analyst on this project only occasionally enlisting a consultant to help meet deadlines.

Education Many IBM, software vendor, in-house courses. CICS COBOL - Verhoef Information Packages.

CICS Internals - On-line Software International. Liberal Arts - Rutgers Evening Extension.

Contact this candidate