Kevin Bersch Email & Phone Number

Tempe, Arizona, United States

Develop Cognos Analytics models, packages, and reports. Work with business to develop specification for reports and packages. Connect to SAP Hana and Oracle tables for reporting and analytics. Deploy reports and packages to production. Create JIRA requests to add user access. Coordinate Cognos upgrades with business users to ensure SOX compliance.Develop Java classes for automatic testing of Cognos reports using Selenium and TESTNG. Technical lead/business analyst for integration of American Airlines and US Airways APAS implementations. Support upgrades and changes from vendor.Technical Coordinator for replacement of mainframe COBOL-based Flight Profitability System system with purchased APAS system from Seabury Group. Interfaced with IT infrastructure support, DBA's, business users, project managers, vendor, and IT & business management. Support final installation. Resolve user problems and create support tickets for vender as necessary.Coordinated activities with off-shore development team, IT services and business users in support of mainframe COBOL-based systems and distributed Java-based systems. Resolve technical issues with production systems. Define requirements. Write specifications for off-shore development team. Write code as necessary Review test results. Implement changes to production.

Tempe, Arizona, United States

Coordinated activities with off-shore development team, IT services and business users in support of mainframe COBOL-based systems and distributed Java-based systems. Resolve technical issues with production systems. Define requirements with client. Write specifications for off-shore development team. Write code as necessary. Review test results. Implement changes to production. Resolve technical issues with production systems. Ensure client expectations are met.COBOL batch system run time was reduced from 140+ hours to less than 10 hours.Hired full-time by US Airways in 2010.

Phoenix, Arizona, United States

* Started on a 90-day contract.* Designed and implemented modifications to software to correct problems reported by customers.* Designed, tested, and implemented enhancements to software as requested by customers and/or management.* Assisted and mentored other programmers as needed to assure timely and accurate program modifications.* Track estimated and actual hours for projects for COBOL programmers.* Introduced UltraEdit to replace text-based editors used by company. Wrote macros to enhance its use. Trained other programmers to use this new software.

Tigard, Oregon, United States

* Host-instructor for Community Emergency Response Team (CERT) training classes. * Designed and developed MS Access database to track CERT members, their skills, resources, and activity. * Assisted city Emergency Manager to organize the CERT program.* Created and moderated a Yahoo Group for the City of Tigard CERT program.* Designed and developed MS Access database to track Public Works employee training and certifications.

Portland, Oregon, United States

* Directed the activities of group of 12 – 20 ethnically diverse and geographically dispersed technicians who supported application development tools and processes on various mainframes and distributed platforms across 4 states.* Supported process for defining requirements for and selecting new technologies. * Managed $3M-$4M software budget. Ensured software purchase and maintenance costs were below budget.* Successfully led cross-functional team to define requirements for, select, and implement corporate standard mainframe debugging/fault analysis/file management software replacing duplicate software remaining after affiliation. Presented selected software recommendation to sevior staff for approval. Updated various CLISTS, skeletons, procs, and JCL to use new software. Project was completed on time. Reduced annual maintenance costs by over $500,000.* Negotiated with vendors for best price and terms for various software products.

Salt Lake City, Utah, United States

* Successfully supported COBOL claims payment system. Restructured system to be more modular. Reduced maintenance efforts and allowed IT to respond more quickly to customer requests.* Successfully updated Explanations of Claims Processed and Provider Vouchers to use laser printer. Used AFP to produce forms.* Managed effort to convert claims history file from Datacom/DB to DB2. Designed DB2 tables and wrote program specifications.* Wrote and supported various REXX execs, CLISTS, and panels used by application developers.* Successfully converted various programs from COBOL to COBOL II allowing better use of resources on CPU.* Successfully led conversion from Librarian to Endevor/MVS source code management system. Endevor allowed more control of source code and tracked compile and link options, saving time when new programmers modified programs. Wrote user exits to enforce standards.* Promoted to Supervisor of Technology Consulting in April 1999.* Successfully wrote various programs for Membership Accounts Receivable System during development of the system.* Successfully disassembled sort exits from system dump after sort upgrade and recreated the exit so batch processing could be completed during nightly window.* Team Lead for Financial Applications support team.* Promoted to Lead Analyst in May 1994.

Cheyenne, Wyoming, United States

* Implemented IPDR (Inter-Plan Data Reporting). Converted OS JCL to DOS/VS JCL. Modified COBOL programs to support fewer files.* Liaison between in-house Medicare team and outside firm writing electronic media claims system. Wrote specifications for data. Tested forms generated. Made sure specifications were met.* Supported PC hardware and software at hospitals and in internal departments.

Great Falls, Montana, United States

* Designed and wrote various CICS systems for internal Data Processing use during conversion from CONVERSE to CICS.* Converted claims history file from BDAM to VSAM during implementation of new claims processing system. * Maintained on line claims data entry system. Written in 370/assembler using CONVERSE teleprocessing system.* Led team supporting Genesys Payroll/Personnel System. Written primarily in COBOL. Installed updates. Wrote programs to determine overtime for employees. Interfaced with payroll and HR to ensure the requirements were met.* Converted various files from ISAM to VSAM.

Java

Database Concepts

2-Year, Data Processing - Programming

Activities and Societies: Office Education Association - State President 1977-1978

Computer Science

Started in 1973 with a major in Mathematics. Changed to Computer Science in 1974. Left in 1975 without completing a degree.