EXECUTIVE SUMMARY

Senior Mainframe COBOL Programmer, Systems Analyst and Consultant with 30 years extensive experience supporting various clients within the Manufacturing, Financial, Insurance, Brokerage, Telecommunications, and Auto Rental industries. Have full Lifecycle Mainframe COBOL / CICS development and support experience. Experienced COBOL CICS Designer and Developer with significant experience supporting DB2, ORACLE, IDMS, TOTAL and VSAM file structures using File-Aid, Easytrieve, TOAD, IDCAMS, and SPUFI. Extensive experience using the IBM systems Utilities and testing tools.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Contractor-Mainframe

• Developed a process that allows users to re-create New DB2 data by Account number. This process was created to account for Accounts that for some reason became out-of-sync with the new database.
• Developed a process to run daily, that compare the Old DB2 tables to the New tables to ensure that the new tables are in sync with the old tables. Any differences are reported.
• Developed DB2 Stored procedures that will be triggered when certain existing DB2 tables are updated. These stored procedures access a New process that takes the changes and applies them to the New DB2 tables.
• Developed a process to take existing DB2 and IDMS tables and converting them into New DB2 tables that would be used as the backend for the LMS system. The new DB2 tables will be accessed via JAVA front-end applications Via CTG .
• Primary Responsibilities are for modifying, testing, and implementing changes to programs within the Customer Statements System.
• Specific duties entailed, developing, testing and implementation of the Conversion of the LMS List Management System . The conversion process consisted of:
• Specific duties entailed, developing, testing, and implementation of enhancements for the UMA Unified Managed Accounts project, which will address the needs of larger net worth, taxable clients and offer improved tax efficiency. The UMA accounts will include stocks, bonds, mutual funds and ETF's, all within a single account.
• Specific duties entailed, developing, testing, and implementation of enhancements for the CST Customer Statements project, which will enhance the AAG At-A-Glance customer statements, by giving the customer more options and control of the content presented on their statements.
• Specific duties entailed, developing, testing, and implementation of enhancements for the CAI Customer Account's Information / NotePad project, which will replace the existing Green Screens / Mainframe application with a GUI application that Adds more functionally and convenience for the users. My specific task has been working with the new COBOL programs that communicate with the GUI front-end, accepting request for information and supplying the requested information back to the GUI environment. These COBOL programs are Both standard On-Line CICS and Common modules that can be used in either a Batch or On-Line environment.
• All testing was performed by doing a unit test and then moved to a Clone environment that is a mirror of the production environment.
• Development was accomplished using SQL to access DB2 tables within COBOL programs, SPUFI for Inquiry and maintenance of DB2 tables, DMLO for Inquiry of IDMS tables, TSO/ISPF for program coding, Workbench for Program, JCL, and Proc version control, Expeditor for testing and debugging CICS programs.
• Developed, Coded and Tested changes to batch COBOL and CICS programs utilizing IDMS and DB2.
• Developed and modified JCL and PROC's required for changes.

Environment: COBOL, CICS, DB2, IDMS,VSAM, SPUFI, WORKBENCH, PLATINUM, QUALITY CENTER, MKS, CTG,STORED PROCEDURES

Contractor-Mainframe COBOL Programmer

• Primary Responsibilities were for modifying, testing, and implementing changes to programs within the Triad Delinquent Loan Processing systems.
• Specific duties entailed, developing, testing, and implementation of enhancements for the Triad project, which analyses delinquent loans and makes recommendations on how best to work these loans, so as to minimize any financial losses.
• All testing was performed through a Parallel test environment that is refreshed with Production data upon user request.
• Developed, Designed, Coded and Tested changes to batch COBOL and CICS programs utilizing VSAM and DB2.
• Wrote test plans for each production change.

Environment: COBOL, CICS, VSAM, DB2, SPUFI

Contractor-Mainframe COBOL Programmer

• Configuration program that takes the Export Orders entered by the Export Wholesalers and configuring those orders into shipping containers.
• Primary Responsibilities were for modifying, testing, and implementing changes to programs within the Dynamic Order Writing, Freight Payment, and Product Supply systems.
• Specific duties entailed the, developing, testing, and implementation of enhancements for the Dynamic Order Writing project, to allow for the automation of entering Export Orders for products into the shipment system.
• Secondary responsibilities were Developing, Testing, and Documenting the Export
• Handled Production support issues on occasion.
• Developed, Designed, Coded and Tested changes to batch COBOL and CICS programs utilizing ORACLE.
• Wrote test plans for each production change.

Environment: COBOL, CICS, ORACLE, TOAD, DB2, MQSERIES, SPUFI, CHANGEMAN

Contractor-Mainframe COBOL Programmer

• Primary Responsibilities were for modifying, testing, and implementing changes to programs within the CarRent system to accommodate bringing the country of Brazil into the CarRent system.
• Specific duties entailed, analyzing each program that has been identified for possible changes to determine what changes are required and to work with the user is identifying the necessary changes based on the function and requirements of the program.
• Secondary responsibilities were for handling Production support issues on occasion.
• Responsible for writing test plans for each production change.
• Developed, Designed, Coded and tested changes to batch COBOL programs, utilizing IDMS and DB2.
• Developed, Designed, Coded and tested changes to IDMS On-line programs, utilizing ADSO.

Environment: COBOL, IDMS, IDD, ADSO, DB2, SPUFI, CHANGEMAN

Contractor-Mainframe COBOL / CICS Programmer

• Responsible for the Support and Maintenance of the OAS Outage Analysis System . The OAS system takes outage calls from customers and makes a determination on what course of action to take. The OAS system is primarily a CICS on-line system, accessing various DB2 tables.
• Was responsible for writing test plans for each production change.
• Developed, Designed, Coded and test changes to CICS programs.

Environment: COBOL, CICS, DB2, SPUFI, MQSERIES

Sr. MIS Technical Analysts-Mainframe COBOL / CICS Programmer

• Responsible for the Support and Maintenance of various Systems for a major Brewery in St. Louis.
• Responsible for writing technical specifications for each production change.
• Responsible for writing test plans for each production change.
• Developed, Designed, Coded and tested changes to Batch and CICS programs for the Freight Management, Requirements Planning, Volume Budgeting Systems.
• Provided 24 hour support for above systems.
• Coded Tested COBOL programs for a Production Allocation Model system.
• Made modifications to Batch COBOL programs.
• Provided testing documentation of modified COBOL programs.
• Coded Tested COBOL programs for a Product Conversion Management system.

Environment: COBOL, CICS, DB2, ORACLE, MQSERIES