Confidential is a Senior Consultant mainframe programmer/analyst with extensive experience in business applications development, testing and deployment.
Confidential ’s strengths include an in - depth knowledge of enterprise legacy systems development, trouble-shooting and support. He is a seasoned professional developer who prides himself on expert technical expertise coupled with the ability to communicate with all levels of an organization.TECHNICAL SUMMARY
HARDWARE: IBM & compatible mainframes, Tandem, PCs, AS/400 (System/38)
LANGUAGES: COBOL (LE, IDMS DB/DC-DML), JCL, C, REXX, CLIST, Assembler, RPGIII, SQL
DEVELOPMENT TOOLS: TSO/ISPF, Xpediter/TSO, ABEND-AID, ENDEVOR, ADS/A, ADS/O, Culprit, OLQ, DME, IDD, CA Easytrieve, CA Panvalet, Librarian, Roscoe, QMF, SPUFI, Compuware File-AID, CICS, Control-M.
OPERATING SYSTEMS: z/OS (MVS, OS/390), VM/CMS, DOS/VSE, TPF, Unix, Windows
DATABASE SYSTEMS: IDMS, IDMS/R, IDMS-LRF, DB2, IMS, Total, Access
METHODOLOGIES: Agile, Waterfall
INDUSTRIES: State government, Federal government, travel,insurance, brokerage accounting
APPLICATIONS: Payroll, General Ledger, Inventory, Purchasing, Insurance, Manufacturing, Banking, Brokerage, Reservations, Medicaid, Medicare
Confidential, Des Moines, IA
Continuing to provide technical support, enhancements and maintenance for all on-line and most batch mainframe systems used by the Medical Systems and Data Warehousing, Division of Data Management. Supported systems are: A Medicare system which tracks dual-eligible Medicaid recipients. It sends and receives data from CMS (Centers for Medicare & Medicaid Services) using Connect:Direct (NDM); Title 19 Medicaid eligibility; Presumptive Medicaid Eligibility (PRSM). An additional system, Medicaid for Employed Persons with Disabilities (MEPD) is an integrated billing system which receives payments and applies them and also prints statements.
Recent project involved developing interfaces to and from the Accenture Benefits Management System which was and is being customized to replace Iowa’s aging Automated Benefits Calculation system. Much of the work has to do with having both the new and old systems feeding the mainframe Medicaid systems. Much of the work was required to be compliant with the Affordable Care Act implemented 1/1/2014.
Initial assignment was to code and test a new version of the HIPP (Health Insurance Premium Payment) system. Originally a CICS VSAM system, it was completely re-written for the IDMS database. The on-line part of the system consisted of 60 new ADS/O dialogs. The batch part of the system consisted of 30+ batch jobs and 60+ COBOL programs most of which needed to be completely re-written.
Subsequent assignment was to design and implement a new IDMS Medicare Database used by “Iowa Medicaid Enterprise” to track Medicare benefits for Medicaid recipients. Designed and implemented on-line screens to access and view Medicare data. Designed and implemented batch programs to maintain the information with data received from CMS (Centers for Medicare & Medicaid Services.)
Environment: MVS (z/OS), IDMS-DB/DC, IDMS/R - SQL, ADS/O, ADS/A, MAPC, IDD, OLQ, COBOL, VSAM, JCL, FTP
Confidential, Greenwood Village, CO
Senior Technical Analyst
Responsible for production support and enhancements to Confidential ’s car and hotel back-end mainframe reservations systems.
- Confidential ’s back-end (where the actual availability resides) reservations systems are IDMS based and written in a combination of ADS/O, COBOL II DB/DC and Easytrieve. COBOL II programs were used to do the actual data look-up for terminal and GUI based travel agents and web sites, such as CheapTickets.com.
- Assisted in the design of enhancements to the systems.
- Most development assignments were for extensive enhancements to the ADS/O on-line screens, COBOL II/DC programs, C and Easytrieve report programs.
- Day-to-day production support involved: Fielding questions from clients, both internal and external (car and hotel companies); trouble-shooting system problems and managing file transmissions via FTP or other transmission protocols; analyzing and debugging on-line COBOL programs; using SDSF to analyze console operations.
- Designed and wrote Extra scripts to update 1000’s of hotel properties that saved over 100 man-hours during EURO cutover.
- Implemented an encryption technology for secure open internet FTP transmissions.
- Wrote and modified C and assembler programs for TPF, which is the message-switching layer which format messages between the back-end systems and the various presentation layers.
Environment: MVS, z/OS, IDMS COBOL-DB/DC, ADS/O, ADS/G, MAPC, IDD, DME, IDMS Release 14 and 15, COBOL II, ALC, ENDEVOR, Easytrieve, TPF.
Confidential - Denver, CO/Dallas, TX
- Made modifications to both ADS/O and COBOL II existing production systems to automate special agreements between ING and other reinsurance companies.
Environment: MVS, IDMS-DB/DC, ADS/O (Release 14), COBOL II, ENDEVOR
Confidential - Gaithersburg, MD
- Y2K modifications - Involved analyzing and modifying complicated CLIST and REXX programs which used file tailoring to dynamically create JCL for execution of billing systems cycles. Created duplicate baseline test environments for 4 production billing systems for regression testing.
Environment: MVS, JCL, REXX, CLIST, ENDEVOR, MVS utilities
Confidential - Boston, MA
Confidential Systems acts as a back office for brokerage firms, such as Dean-Witter, etc. Each brokerage client conversion in or out of Confidential was a custom job - mapping the data, etc. Assigned the task of creating PROCs so only one set of JCL and one set of programs were always used. This realized a 30% savings of man-hours.
Maintenance, enhancements and on-call support for a nightly batch DB2 update system driven by ACH bank files which uploaded the updated DB2 tables to a Sybase UNIX system. At the end of the business day, the Sybase tables were downloaded to the mainframe DB2 tables in preparation for the nightly batch cycle.
Modified and supported Confidential ’s use of RECON-Plus (by Checkfree) to balance fund redemptions and purchases with correspondent banks. As many as 40 different files from banks, brokerages, and internal feeds were processed nightly. Many files were in different formats and had to be parsed and applied to the database before the start of business. Assisted analysts daily to resolve reconciliation issues.
Using RECON-Plus as a base-line, modified CICS screens, VSAM file formats and COBOL II batch programs to replace a time-consuming manual process which reconciled all of Confidential ’s mutual funds between transfer agent activity and the internal fund accounting system.Environment: MVS, JCL, DB2, QMF, SPUFI, CICS, VSAM, COBOL II, ENDEVOR, UNIX
Confidential - Lakewood, CO
- Development and maintenance of the Royalty Management Program for the Minerals Management Service, Department of the Interior.
- A 3 year design and development project which included: writing detailed program design documents, coding, testing and implementation.
- A 4 year assignment of post-implementation production support and enhancements.
Environment: MVS, IDMS-DB/DC, LRF, ADS/O, ADS/G, MAPC (Release 14), COBOL II, ENDEVOR, VAX