SUMMARY:

Senior Contract COBOL Programmer Analyst with over 25 years of COBOL, JCL, ISPF and VSAM, as well as over 15 years of DB2 and IMS DB experience. He has a MBA and PhD education and expertise in designing, developing, supporting and migrating applications in a variety of industries. Accustomed to tight deadlines and short term project life cycles.

SKILLS:

• Confidential COBOL II JCL MVS Confidential VSAM IMS
• DB2 TSO/ISPF FILEAID EXPEDITOR PANVALET QMF
• EZTRIEVE RACF FTP SYNCSORT Agile Devl SPUFI
• SQL Forms/Menu ENDEAVOR PL/I Changeman File Manager UNIX
• MQSeries EXCEL INTERTEST Fault Analyzer Confidential REXX
• Microfocus Workbench Clear Quest Requisite Pro

EXPERIENCE:

Confidential, Atlanta, GA

Programmer Analyst

Responsibilities:

• Assigned to work on Modernization of Confidential programs utilizing COBOL, JCL, Confidential, VSAM, IMS DB/DC, ENDEVOR, Agile development
• Analyzed various programs related to Customer Designed Health Plans.
• Started modifying Cobol Batch programs that call I/O Cobol modules that access Corporate IMS databases
• Used Confidential to test a program’s execution.
• Explored programs to discover fields from the NY BC/BS system that corresponded to fields on the Confidential system for Coordination of Benefits Mainframe Moderation project

Environment: COBOL, JCL, IMS DB/DC, DB2, SQL, MVS, TSO/ISPF, VSAM, File - Aid, ENDEVOR, ABEND-AID, Debug, Agile development

Confidential, Madison, WI

Programmer Analyst

Responsibilities:

• Modified Confidential and batch programs used to insert, delete, update and query data in DB2 tables and VSAM files
• Create/modify the PROCS and JCL to execute these programs

Environment: COBOL, COBOL II, JCL, DB2, SQL, MVS, TSO/ISPF, VSAM, File-Aid, Changeman, ABEND-AID, Confidential Debug

Confidential, Pittsburgh, PA

Programmer Analyst

Responsibilities:

• Modified Confidential background Confidential programs used to insert, delete, update and query data in DB2 tables using Agile Development technology in Healthcare industry
• Worked on several projects with Membership application:
• Creation of a County Code table to be used to determine rates for Medical insurance
• Modified software to update client Termination Date when information received from CMS or PSAR
• Modified programs to include Assignment Date for QHP Brokers
• Create/modify the JCL to execute these programs, inserting data in MQ Series queues that then call the new/ modified programs.
• Cobol programs utilized Object Oriented technology, utilizing components with single functions called from other modules based upon parameters passed from modules higher in the architecture.
• Prepared documentation that described all programs in the system and prepared a Visio presentation listing the program hierarchy and parameters used to navigate thru the hierarchy.

Environment: COBOL, COBOL II, JCL, DB2, SQL, MVS, TSO/ISPF, VSAM, MQSeries, ABEND-AID, FTP, Endeavor and TraceMaster for testing

Confidential, St. Louis, MO

Programmer Analyst

Responsibilities:

• Modified batch programs used to create various letters sent to Clients and the JCL to execute these programs.
• Researched other programs sent to Financial Advisors for rejected Zero-dollar ACH transfers used to verify client accounts for retirement account payments.
• Worked on the Real Time Cash project in which programs that involved updating a client’s investment additions made the funds available the same or next day, involving hundreds of programs.

Environment: COBOL, COBOL II, JCL, DB2, SQL, SYNCSORT, MVS, TSO/ISPF, VSAM, FTP, ABEND-AID,, INTERTEST

Confidential, Oklahoma City, OK

Programmer Analyst

Responsibilities:

• Developed new Confidential /COBOL/VSAM screens needed for migration of Dwelling insurance from mid-range computers to the Confidential Mainframe.
• Modified and created batch programs related to the new Dwelling policy system being created and the JCL to execute these programs.
• Thoroughly tested new and changed programs.
• New screens were to be used to create new Dwelling policies, display the details related to Dwelling policies, changing the coverage and renewing the policies.

Environment: COBOL, COBOL II, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, FTP, ABEND-AID, EXCEL

Confidential, Olympia, WA

Programmer Analyst

Responsibilities:

• Maintain COBOL/ Confidential /IMS Online and Batch programs that determine client eligibility for Food Stamp, Medicaid and Cash (TANF, General Aid, LTC and Disaster Aid) benefits.
• Modified or created numerous JCL jobs for the batch programs for the Confidential project
• Thoroughly tested changed programs.
• Very complex batch and online COBOL/IMS program were modified to meet new requirements from the Washington DSHS and the modifications tested both on a Unit and System basis.
• Program changes included changes to IMS Database inquiries, updates, inserts and deletes.
• Update the tracking of Change Request, Problem Reports and Defects using Clear Quest.
• Created and maintained Analysis and Design Documents for the Confidential project using Share Point/RequisitePro.
• Helping with implementation of the Health Benefits Exchange.
• Worked with Release Management group to ensure programs modified were properly migrated to next level.

Environment: COBOL II, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, FILEAID for VSAM, FTP, EXCEL, Visio, WORD, ABEND-AID, Changeman

Confidential, Sacramento, CA

Programmer Analyst

Responsibilities:

• Created and maintained Design Documents for the California Medicaid Management Information System

Environment: COBOL II, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, WORD Visio Confidential /Unisys Systems, El Monte, CA, 11/2009 - 09/2011

Contract Programmer Analyst

Confidential

Responsibilities:

• Created and maintained COBOL database (SQL)) programs for the LA Department of Social Services Welfare (CalWORKS), Food Stamps and MediCal programs Eligibility Determination and Benefits Calculation group.
• The programs utilized COBOL and SQL (to access a relational database like “DB2).
• Thoroughly tested new and changed programs.
• Programs were executed in batch mode and utilized Unisys computer using ECL.
• Worked with Release Management software to ensure programs modified were properly migrated to next level.

Environment: COBOL, UNISYS Mainframe, DB2-like Relational database, SQL, WORD, ECL (like JCL), HP Powerbuilder for program development)

Confidential, Ft. Collins, CO

Contract Programmer Analyst

Responsibilities:

• Created and maintained COBOL VSAM S2000 (SAS database) programs for the Automated Timber Sales Accounting (ATSA) system and Batch programs for the ATSA department and the Forest Service that track the funds from companies and persons who do business with the Forest Service
• Modified JCL used to execute the batch programs I created or modified.
• Thoroughly tested changed programs.
• Reports are modified or created the auditors use to account for the funds paid to the Forest Service using a System 2000 database used to store the contract data, a hierarchical database developed by SAS
• Created and maintained REXX programs to edit files and create JCL to execute batch jobs
• Reports sent to UNIX system via FTP.

Environment: COBOL II, S2000, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, REXX, FTP, ENDEAVOR, UNIX, RACF, ABEND-AID, FILEAID for VSAM and S2000, EXCEL

Confidential, Denver, CO

Contract Programmer Analyst

Responsibilities:

• Created and maintained COBOL, VSAM and DB2 programs for Confidential Permanente including batch programs for the IT Department that transferred data from the software that edited the incoming claims data to the VSAM files that stored the claims data ( Confidential ) were modified in Healthcare industry
• Since the programs were batch programs, JCL necessary to execute the programs was modified when necessary.
• Thoroughly tested changed programs.
• Developed program to extract professional and facilities claims data from the Confidential files and send that data to Confidential Inc. so that Confidential could recover its costs for treatments related to Workman’s Compensation, auto accidents, etc.
• Authored various Production Support documents
• Worked with Release Management software to ensure programs modified were properly migrated to next level.

Environment: COBOL II, DB2, SQL, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, RACF, Easytrieve, FILEAID for VSAM and DB2, CHANGEMAN, FTP, UNIX, EXCEL, Visio, ABEND-AID, SPUFI and QMF

Confidential, Denver, CO

Contract Programmer Analyst

Responsibilities:

• Developed and maintained online and batch COBOL programs on an AS400 for a subsidiary of Scottrade
• Created and modified Command Language programs to execute those batch COBOL programs
• Files used include DB2 tables and key-sequenced and sequential files

Environment: COBOL, Command Language (CL), AS400, DB2, SQL, Key-Sequenced and Sequential files

Confidential, Denver, CO

Contract Programmer Analyst

Responsibilities:

• Created COBOL ADABAS programs for Confidential to edit data to be loaded into its new SunGard Omniplus database
• Since the programs were batch programs, JCL necessary to execute the programs was modified when necessary.
• Assisted with testing software developed to load data into the Omni system sent by member schools
• Project involved loading data from the various institutions into the TIAA/CREF Omniplus database, validating the data, executing programs to load the data and responsibility for ensuring the Omniplus database loaded data properly

Environment: COBOL II, ADABAS, JCL, MVS, TSO/ISPF, VSAM and Omniplus

Confidential, Denver, CO

Contract Programmer Analyst

Responsibilities:

• Created and maintained COBOL and DB2 programs for Confidential Corp.
• Developed and modified programs including Batch and Confidential programs for the Electronic Federal Tax Payment System (EFTPS) Thoroughly tested changed programs.
• Authored Test Plans are also created and the programmer is involved from program creation / modification through implementation
• Project involved adding security to EFTPS so that user cannot use an account that is already being used by another user without confirmation from the bank that the user is authorized to use that account.

Environment: COBOL II, Confidential, DB2, SQL, JCL, SYNCSORT, MVS, TSO/ISPF, ABEND-AID, VSAM, INTERTEST, FILEAID, FTP, UNIX, RACF, Platinum DB2 Log Analyzer and other DB2 tools, ENDEAVOR, EXCEL, Visio, EASTRIEVE, SPUFI and QMF.

Confidential, Wilkesboro, NC

Contract Programmer Analyst

Responsibilities:

• Created and maintained batch and Confidential programs using COBOL and DB2
• Test Plans are also created and the programmer is involved from program creation/modification through implementation. Some of the programs modified are APS/COBOL programs. Some files are FTPd to sites outside Lowe’s Company. Files sent to UNIX system via FTP.

Environment: COBOL II, APS/COBOL, Confidential, DB2, SQL, JCL, SYNCSORT, MVS, TSO/ISPF, VSAM, ABEND-AID, PANVALET, XPEDITER, FTP, FILEAID, FTP, UNIX, EXCEL, Princeton Softech (DB2 editor), MQ Series, SPUFI and QMF