database expert on both personal computers and mainframe computers

Resume of Fred A. Kirsch

**** ***** ****

Medina, Ohio 44256

********@**********.***

Qualifications Profile :

•Proven senior mainframe systems developer and supporter with over 30 years of experience working multiple times for multiple Fortune 500 companies as a contractor.

•Proven senior mainframe systems developer and supporter with 24 years of experience working for Ohio Edison (now First Energy Corp.) as a full time employee.

•Information systems professional specializing in all aspects of system life cycle.

•Experienced mainframe system developer, systems analyst, requirements analyst, team leader and IT project manager.

•Strong engineering, math and science background.

•Very detail orientated.

•Extensive insurance, medical, electric utility and manufacturing company experience.

•Proven problem solver, management advisor, system designer, program designer, and program coder.

•Specialist in large mainframe projects for both new applications and improvements to existing applications.

•Developer of special reports for Department Managers, Vice Presidents and the Board of Directors.

Computer Hardware : IBM and similar mainframes (most models) and personal computers (most makes).

Previous Employment :Computer Tool : CICS, Batch, COBOL, SAS, DB2, TSO, ISPF, MVS JCL, VSAM, IDMS, SQL, QMF, XPEDITER, DEBUG, TELON, REXX, Endeavor, Changeman, Agile SDM, HP ALM, Tablebase and many others.

Personal Computer Tools : Microsoft Project, Microsoft Office, Microsoft Outlook, PowerPoint, Access, VISIO, Excel, Word, SharePoint, Teams and many others.

Baystate Health System, Springfield Massachusetts.

Senior Mainframe Engineer working on their Patient Financial System.

October 2021 to February 2023 (17 months).

A fully remote position.

Completed a major documentation project for one of their largest mainframe systems for the second largest hospital chain in the state. Management was planning to out source parts of their Patient Financial System but it was so poorly documented management did not fully understand all of the existing processing. My assignment was to completely document the entire system which contained 400 mainframe jobs (some of them containing up to 5000 lines of mainframe JCL and 750 different reports). Documentation also included 500 report writer programs (some of them containing up to 10,000 lines of COBOL code) with the file names in and out, reports out and any exceptional logic. The project was completed on time and ahead of schedule. Tools used were DB2, VSAM, COBOL, CICS, TSO, ISPF, MVS JCL and Microsoft Word and Excel.

Progressive Insurance, Campus I, Mayfield Village, Ohio.

Corp IT / Financial Systems / Statistical Reporting Department.

April 2018 to June 2020 (28 months).

Senior Mainframe System Developer – Stat Reporting.

A fully remote position.

Completed two major projects and many smaller ones for the Stat Reporting Department on my fourth assignment with Progressive Insurance.

Progressive is required to report various claim related data to the Independent Statistical Service or ISS for short. The claim data is then distributed to every state where Progressive does business. This data includes counts for new claims and existing claims. It was known for some time that the claim counts produced by the existing mainframe system were not accurate. They were too high and some of the states complained about the errors. ISS has published documentation describing how the claim counts should be calculated. Most of the ISS procedures were not being performed in the existing mainframe system. Also, the mainframe system counted every claim as being new since there was no way to determine if a claim had been previously counted. No claim history was being used. This project eliminated those errors by creating history files and using them to identify if a claim had been previously counted. Also new data fields were used to help with applying the ISS rules that previously were not used. A major redesign of the system was started in 2018 to correct the claim counting errors. It was the largest Stat Reporting project completed in the last ten years.

Over 1500 mainframe computer jobs were run to create the needed history files going back to the fourth quarter of 2018. Over 60 COBOL and SAS programs were changed some extensively. Completely new COBOL and SAS programs were written. Many mainframe computer jobs, procs and copybooks were modified and tested. The ISS procedures were successfully applied for the first time, and the claim counts produced are now correct. In addition to my new COBOL programs I wrote many new SAS programs for the end users and made many inprovements to the existing SAS programs they already had written. Some of their SAS pprograms took four hours to run which I reduced to only 20 minutes. The project was successfully elevated in May 2020.

Progressive Insurance, Campus II, Mayfield Village, Ohio.

July 2014 to April 2017 (34 months).

Senior Mainframe System Developer – Billing Systems – ProBill.

Completed two major new development projects resulting in new income and improved fraud prevention for the company saving millions of dollars a year on my third assignment with Progressive Insurance.

August 2015 to Aprin 2017. Completed the CVV2 Fraud Prevention Project. In order to reduce credit card fraud, the security code on the back of all credit cards was now required for all credit card transactions. Many changes to the ProBill Billing System and interfaces were completed and elevated. Extensive coordination with eleven different points of service apps and the billing processor (Chase Bank) were completed. Over 160 programs and jobs both CICS and batch were changed, some extensively. New DB2 batch fraud jobs and reports were designed, programmed, tested and elevated. Changes to complex billing processes were designed, tested and completed. Over thirty people were involved in this project, but only two were mainframe developers. New corporate SDM was used for the first time.

July 2014 to August 2015. Completed the Agent Code Expansion Project for the ProBill Billing System – the largest mainframe computer system at the company. Progressive sells many of its products through agents both employees and independent. Agents are identified by a five-digit numeric agent number. There are so many agents now that not enough new agent numbers were available. It was necessary to change the numeric agent code field to alphanumeric every place it was used. Over 400 mainframe programs and files (CICS and batch) were changed, tested and elevated to production. This project touched every computer system in the company and required extensive coordination with all of them.

Parker Hannifin Corporation in Mayfield Heights, Ohio.

April 2013 to January 2014, Mainframe Systems Analyst / Senior Programmer.

Was hired by Parker’s HFD division in Metamora, Ohio and allowed to work from home. The HFD Division had recently purchased new companies in Canada and Mexico, and the mainframe systems used by HFD needed to be set up to work at the new locations. Many programs and jobs (batch and CICS) were changed to work with foreign currency, by different users and at different locations. Printed reports were changed so they could be sent to remote servers by FTP. 200 batch jobs were modified, tested and installed at the new locations. The batch job schedule for the new locations was created and implemented. There was heavy involvement with MVS JCL, TSO, COBOL, Xpediter, VSAM, DB2 and IMS.

Western Reserve Group in Wooster, Ohio - A multi-line insurance company.

July 2012 to November 2012, Mainframe Systems Analyst / Senior Programmer.

Completed a major mainframe, batch, COBOL, VSAM / DB2 project to reduce the company mailing costs using a VS/ICCF system. WRG markets 16 different lines of personal and commercial insurance and is represented by independent agents in two states. The agents can go to the company web site and enter various codes to either allow or suppress printing the agent’s copy of a policy. This file is uploaded to the mainframe and read by policy print programs. Ten programs, copybooks and JCL were changed and extensively tested for each policy type. Test policies were generated using the company CICS policy systems. The project was completed in seven weeks - half the expected time. Four additional batch and CICS projects were then completed.

Goodyear Tire and Rubber Company, Akron, Ohio

October 2010 to April 2011, Mainframe System Developer – CHESS System.

Completed my second assignment on the Corporate Health and Environmental Safety System. Made major system improvements to add new capability and new functions. Designed, programmed and tested four new screens and programs using Telon, COBOL, DB2 and CICS. Added new conversion factors to change from English to metric and metric to English. Added several new DB2 tables to support the new screens. All changes were tested, approved and moved to production.

Medical Mutual of Ohio – Strongsville, Ohio location.

March 2009 to September 2009, Mainframe System Developer – Broker Commission and RX Drug Systems.

Completed production support and enhancements for two production systems. For the Broker Commission System completed three requests needed to correct production problems and enhance system performance. For the Rx Drug Claim System modified 20 COBOL programs, half of them CICS, to use and pass the new fields through the system. Updated procedures, parms and JCL as needed. .

Progressive Insurance – Mayfield Village, Ohio.

April 2007 to December 2007, Mainframe System Developer – Litigation Management System.

Completed work on a major project for the Claims IT Department to implement a new Litigation Management System. Eight new DB2 programs were designed, written and moved into production. This addition produced a large cost savings for the company.

Medical Mutual of Ohio – Strongsville, Ohio location.

March 2006 to March 2007, Mainframe System Developer, TOPPS System.

Completed two concurrent projects on the TOPPS System (Total Online Payment Processing System. The federal government required that a national provider number (NPI) with more digits must be implemented by year end, and many system changes were required. The project also included an expansion of the claims, claim history, revenue, and revenue history records to include more occurrences and additional years of history data. Over 70 CICS and batch programs were changed and tested to accommodate the requirements. CICS screen changes were made, files were reformatted and expanded, old history files were converted to the new format and batch jobs were rewritten.

Parker Hannifin - MSS System - Corporate Headquarters, Mayfield Village, Ohio.

August 2004 to March 2006, Mainframe System Developer.

Completed Cobol updates for the MSS System, the largest CICS business system used at Parker Hannifin. Supported 44 external divisions in multiple countries that also used the core system and along with their own custom division exit code. The updates provided a significant cost savings for the company.

Progressive Insurance – Main Campus II, Mayfield Village, Ohio

September 2003 to May 2004, Mainframe System Developer – ProBill Billing System (An all New System).

The ProBill System replaced the previous billing system and provided real time processing with 24 x 7 availability using CPSM (CICS Prod Plex System Manager) running concurrently in six different CICS regions. My primary responsibility was to write all the production batch jobs, procs and parms (382 jobs, 200 procs), test and debug them, set up and monitor the simulation system, resolve testing problems and to prepare the batch cycle for production elevation

Medical Mutual of Ohio - Beachwood, Ohio location.

March 2002 to May 2003. Mainframe System Analyst / Senior Programmer.

Completed work on the Managed Care System. Completed a number of improvements requested by the system users and an outside client. Many CICS and DB2 programs and DB2 batch programs were designed, written and moved into production.

Medical Mutual of Ohio - Downtown Cleveland, Ohio

August 2000 to August 2001, Mainframe Systems Analyst / Senior Programmer.

Completed work on the WEB Quote System. This was a large project that involved 14 people.

Used Microsoft Project to develop a detailed project plan, to allocate individual resources and to track progress on over 300 tasks. Prepared summary reports for management and helped to keep this large project on schedule and on budget. Used an Access database system to record project issues and to document their resolution.

Medical Mutual of Ohio – Beachwood, Ohio location.

October 1999 to April 2000, Senior Programmer – Managed Care System.

-Completed my assignment on a new addition to the Managed Care System to be used by the State of Ohio Bureau of Workman’s Compensation. Functioned as the team leader primarily responsible for the design, analysis, programming and testing of new COBOL / DB2 programs for the batch part of this new system.

Goodyear Tire and Rubber Company, Akron, Ohio.

August 1997 to July 1999, Management team and consultant – Y2K Project.

Hired by IBM who was the project manager and was a member of their management team.

Completed the Y2K project for an 80 person project team run and managed by IBM.

Was a member of the MVS Platform Analyst Team, the team that managed the Y2K conversion and testing for all Goodyear’s mainframe computer systems. Designed and wrote custom COBOL and DB2 programs, ISPF screens and REXX programs needed to build and manage the databases. Was head of the tools team responsible for the development of automated processes used by the entire project. Wrote new COBOL and REXX programs (MVS and PC) that eliminated manual tasks, helped maintain accountability and produced status reports for management. Served as the in-house project consultant for anyone requiring help with the TELON, MVS assembler and REXX programming languages.

Medical Mutual of Ohio, Beachwood, Ohio.

January 1997 to March 1997, System Developer – Interconnection Billing System.

Corrected problems and improved several COBOL CICS programs that were part of the Interplan Teleprocessing System (ITS). Performed the analysis, programming and testing required to correct problems that occurred during the online processing of medical claims that were received electronically from other medical insurance companies.

Medical Mutual of Ohio, Beachwood, Ohio.

February 1996 to January 1997, Mainframe System Developer – TOPPS System.

Completed a major history file reformat and expansion project for the Total Online Payment Processing System (TOPPS). Many system improvements were completed and installed including converting VSAM master files from RRDS to KSDS format and rewriting production MVS JCL to improve efficiency (400 JCL procedures). Improved batch and online COBOL programs. Standardized the MVS JCL for all batch jobs running to support six CICS test regions.

The Goodyear Tire and Rubber Company, Akron, Ohio.

September 1995 to Janaury 1996 – System Developer – CHESS System.

Completed program and system enhancements to CICS programs using COBOL DB2, and the TELON programming language for the Corporate Health and Environmental Safety System (CHESS). Completed a new DB2 batch program that converted any units of measure from metric to English or from English to metric. Completed changes to interface the CHESS system database with other company systems allowing for the automatic updating of the chemical inventory database.

Medical Mutual of Ohio, Beachwood, Ohio.

November 1994 to September 1995 System Developer – Internal Data Processing System.

Designed and programmed an online training system used for the orientation and training of all newly hired contractors. Demonstrated this system to the entire department at a Vice President staff meeting. Designed and programmed new COBOL / DB2 programs to extract medical provider data from internal DB2 databases to be used by an outside vendor system.

Ohio Edison Company (now First Energy Corp.), Corporate Office in Akron, Ohio.

1971 to 1994 as a full time employee.

Was employed for 24 years by the Ohio Edison Company (now First Energy Corp.) in their Information Systems Department (14 years) and Project Management Department (10 years) working as a Project Manager, Systems Analyst, Programmer, Business Analyst, and team leader.

Created, developed and implemented special reports for the company Board of Directors, Vice-Presidents and Department Managers. Because of their confidential nature I ran them and delivered them in person.

Created and was responsible for many of the CICS and batch computer systems used by the company using COBOL, assembler, DB2, VSAM, CICS, Telon, Fortran and other mainframe tools. Was a team leader, trained other programmers and analysts, gave demonstrations to management and trained system users.

Developed, programmed, installed and supported many new mainframe and PC systems by both engineering and business users.

Designed, programmed and supported the following systems : Management Reporting, Project Management, Construction Budgeting (400 million per year budget), Substation Inventory, Transmission Line Losses, Emissions and Fuel Needs, Fuel Purchase Optimization, Capital Expenditures and Special Report for the Board of Directors.

Evaluated, selected, installed and supported both mainframe and PC project management software used companywide to help manage a construction budget ranging up to 400 million dollars a year.

Installed complete mainframe computer systems of my design at other electric utilities (Construction Budgeting, Project Management Information, Management Special Reports), supported them and trained others in their use.

Was offered and took an early retirement with benefits in 1994.

Formal Education :

Attended the University of Akron night school for 10 years while employed by Ohio Edison. I completed many college credits and had a high GPA. Completed every IT course that they offered. Did not graduate since they did not offer a degree in Computer Science or Information Technology at that time. My majors were Information Technology, Math and Physics.

Completed 1600 hours of company sponsored computer training.

Completed 2 week Supervisor Management training.

Completed 2 week Project Management training taught by Project Management Institute.

Rev. 11/2025

Contact this candidate