Mainframe Developer
Resume:
KEVIN KEARNEY
Union, NJ 07083 **********@*******.***
PROFILE
Senior Applications Developer/Project Leader with 31+ years experience designing, developing and maintaining applications in various enterprises. Proven ability and flexibility to perform in multiple industries, technologies and roles. Demonstrated success in interaction with users and management.
Technical Background
Database Technology (Oracle, DB2, Access) 25+ years SQL experience
Mainframe Development (COBOL, CICS, Utilities, etc.)
OS/MVS, Microsoft Windows, DOS, SPF/PC, TSO/ISPF, JCL, VM/CMS, Oracle, DB2/SQL, DB2 Utilities, SPUFI, QMF, UDB, CICS, BMS, COBOL II, COBOL, Microfocus Workbench (Microfocus COBOL, Animator, XDB, etc.), Telon, VSAM, ISAM, QSAM, OS Utilities, SYNCSORT, Xpediter, InterTest, COBTEST, File-AID, ISPF Librarian, EZTrieve, Panvalet, Dimensions, ERwin, Microsoft Project, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Excel, WordPerfect, Visio, Lotus (1-2-3, Notes, Mail), EasyCASE, HTML, FTP, Connect Direct.
Employment History
ACCENTURE 05/2017-Present
Application Development Specialist – HSBC
HSBC’s US RBWM Mortgage Business has a need to move from one 3rd party hosted LOS (Loan Origination System) to a new LOS system as the current outsourced vendor has publicly announced they will be exiting the Mortgage Origination business beginning January 1, 2018. The goal is to bring in house a new Loan Origination System for end to end Mortgage processing; including Image tool; with interfaces to all necessary vendors to support a component insourcing model. COBOL/COBOL2, CICS, DB2, JCL, TSO/SPF, Endevor
Successful conclusion in a limited amount of time.
Received Recognition Award for performance
ACCENTURE 10/2016-04/2017
Application Development Specialist – Exelon Corporation
Exelon FitzPatrick IT Integration
Exelon purchased the James A. FitzPatrick Nuclear Station (JAF), located in Oswego, NY. Performing integration activities based on a combination of business and technology imperatives.
Creation and execution of DB2 load and unload processes in support of JAF data conversion processes.
Created automated processes via COBOL programs.
Successful conclusion in a limited amount of time.
Received Recognition Award for performance.
Project nominated for the ‘FitzPatrick Entergy and Exelon Beacon Award’.
ACCENTURE 01/2016-09/2016
Team Lead – Foremost Insurance
NextSTAR Project
Consolidate four Policy Administration Systems (NPD, FOCUS, NextSTAR (on NSI DB), and Access) to one for all Specialty Line products. Main emphasis on analysis, design, coding, debugging, etc. of conversion from Adabas to DB2.
ACCENTURE 03/2015-12/2015
Application Lead
Vendor Management
Application Management Services organization in the Mobility Collaboration Content Management area (AMS MCCM)
Serve as an application lead in a managed services environment leading outsourced teams responsible for operating applications on the company’s Web Operations, EPPM/MSPS and Mobility platforms.
Handle interaction between key IT business stakeholders and AMS for demand and support. Leverage existing processes and recommend process changes to best keep work progressing in all areas.
Conduct daily planning meetings with vendors to align priorities to business needs and participate in various weekly/biweekly meetings with IT stakeholders to provide transparency into AMS processes and manage ongoing demand.
Manage escalations and assist with problem resolution.
Ensure Service Level Agreements (SLAs) are being met.
MERCK 12/2012-03/2015
Application Lead
Vendor Management
Application Management Services organization in the Mobility Collaboration Content Management area (AMS MCCM)
Served as an application lead in a managed services environment leading outsourced teams responsible for operating applications on the company’s Appian BPM, Web Operations, EPPM/MSPS and Mobility platforms.
Handle interaction between key IT business stakeholders and AMS for demand and support. Leverage existing processes and recommend process changes to best keep work progressing in all areas.
Conduct daily planning meetings with vendors to align priorities to business needs and participate in various weekly/biweekly meetings with IT stakeholders to provide transparency into AMS processes and manage ongoing demand.
Manage escalations and assist with problem resolution.
Ensure Service Level Agreements (SLAs) are being met.
MERCK 02/2010-12/2012
Service Analyst
Retirement of Legacy Schering-Plough Applications
Following the merger of Merck and Schering, identified and “retired” Schering applications/data deemed to be obsolete or corresponding to Merck applications/data. Identification of business users and key players when necessary. Met with legal and affected business areas to determine data importance/significance. Creation of required forms/documents (Retirement Checklist) Retirement Plan, RMO RFS, etc.). Identification of data (Oracle & DB2) to be archived. When applicable, worked with database team to document and archive data into the IBM Optim environment. Performed downloading of DB2 data from the mainframe environment when archiving team experienced limitations in their downloading processes. Identified reporting requirements (Cognos) needed within the archiving environment. Performed User Acceptance Testing against the Cognos reports in the archiving environment. In addition, performed data verification via Oracle SQL Developer.
Group 1 Managed Services Transition
In addition to the above roles/assignments, participated in the Group 1 Managed Services Transition. The role was to develop bulk “laptop build and assigned seating” processes to facilitate the onboarding of Managed Services partners Accenture, Cognizant and HCL into the Merck environment. Prior to this, these functions were performed on a “one-by-one” basis. They were essential to the success of the transition since partner numbers were growing on a daily basis and individuals needed to be “up and running” as soon as possible. Efforts helped the program achieve critical transformational milestones in a very aggressive timeframe. Participated in Group 2 pre-planning meetings where “lessons learned” and our responsibilities were discussed in order to facilitate a smooth transition for Group 2. Received ‘Application Managed Services Outstanding Service Award’ for these efforts.
SCHERING-PLOUGH 02/2006-02/2010
Lead Analyst
Lead Analyst for application suite for maintaining the integrity of healthcare practitioner and healthcare institution universes for GPB.
Prescriber Database (PDB)
Prescriber Cross-Reference (XPR)
Prescriber Reconciliation and Maintenance (PRM)
Hospital Database (HDB)
Prescriber Validation (PVS)
Healthcare Practitioner (HCP)
Also continued responsibilities referred to in the 2000-2006 timeframe.
SCHERING-PLOUGH 03/2000-02/2006
Independent Consultant
Project Leader/Senior Applications Developer for Roster and Sales Alignment Systems (SAS)
Primary Support for Sales Alignment Systems (SAS) and Roster Data interfaces to Sales Force Automation systems
Evaluation and processing of alignments for Sales Alignment System (SAS)
Creation and execution of third party data feeds to external and internal vendors/customers
Development and evaluation of all external vendor audits (comparisons to SP Roster/SAS)
Implementation of Ad-hoc reporting and Sales Alignment Systems (SAS) and Roster client support requests
Process monthly USPS zip code changes and incorporate into Sales Alignment System (SAS)
Daily production support of Sales Alignment Systems (SAS) Jobstreams including DB2 to Oracle replication
Ongoing QA and maintenance of all SAS/Roster DB2 Tables
Backup support for Sales Force ID Maintenance
Application Security Table Maintenance
Investigation and Research of SAS/Roster data inquiries made by internal and external departments required to provide answers and direction
Project Rollout Roster support for TIPS and other departments
Analysis, design and programming support of reorganization of Field Forces, Bath processing to replace online ‘one-by-one” user entry
Design, programming and support of the MerckJV Contact List project, a joint venture between Schering-Plough and Merck to share Zetia field force information
Design, programming and support of data feeds to the Axentis and SABA Compliance Program applications
PRUDENTIAL INSURANCE 12/1999-3/2000
Independent Consultant
Project Leader/Senior Applications Developer
Working with PeopleSoft developers created Cobol/DB2 data transformation interfaces between PeopleSoft modules. A PeopleSoft solution was deemed too time consuming to be a viable alternative in meeting business processing needs. Successfully completed the project in half the allotted time.
SIEMENS MEDICAL SYSTEMS 01/1999-12/1999
Independent Consultant
Project Leader/Senior Applications Developer
Led successful effort to migrate data of 500+ data stores from a Mainframe to Client Server environment (DB2 to Oracle). Required modeling data from a variety of formats (DB2, VSAM, Total database, flat file) into Oracle tables using the Erwin modeling tool. Data transformation prior to FTP to the server was accomplished via DB2 utilities, OS utilities and programming. Population of data into Oracle tables accomplished via the Oracle Sqlloader utility.
Gathered user requirements for implementation of Cognos Impromptu tool with the Oracle Client Server environment.
Conversion of third party industry data processing from a tape driven/Mainframe environment to a CD/Client Server environment. Upon delivery of a CD, anyone can insert it into the applicable server, double click an icon and the data will be loaded. Population of data into Oracle tables accomplished via the Oracle Sqlloader utility.
Processing of third party industry data to facilitate sales and marketing efforts. Responsibilities include: negotiation of data delivery, requirements analysis with contracted data vendors, design of DB2 tables and any effort, programming, DB2, etc., required to populate the physical tables.
Process user data requests from the Mainframe to their desktop (Access, Excel, etc.);
Provide onsite and on-call Mainframe support.
GUARDIAN LIFE 05/1998-01/1999
Independent Consultant
Project Leader/Senior Applications Developer
The analysis, design and coding of a new Schedule “O” system to supply data that includes information about paid claim amounts cross referenced by the dates the claims were paid and incurred. It was segmented by various categories (i.e., coverage, plan type, etc.) to allow actuaries to perform reserved analysis and calculations. This enabled Guardian to meet the NAIC Annual Statement reporting requirements of Schedule “H” (reserve adequacy testing) and Schedule “O”. This was accomplished via Data Mart populated by data extracted from a Claims Data Warehouse. Functions and processes developed to implement this system include: data mapping to the Data Warehouse, DB2 unload and load routines for data extraction and population, utilities and Cobol programs for data manipulation and incremental update (timestamp) routines to provide historical reference for the actuaries Flat files were generated as input to a data query tool called TM1. The Data Mart also resided on a server for use with the Cognos Impromptu data query and reporting tool.
SCHERING-PLOUGH 03/1997-05/1998
Independent Consultant
Senior Applications Developer
Processing of third party industry sales and prescriber data to facilitate sales and marketing efforts. Responsibilities include: negotiation of data delivery, requirements analysis with contracted data vendors, design of DB2 tables and any effort, programming, DB2 utilities, etc., required to populate the physical tables. These efforts applied to stand alone and warehousing processes.
Creation and providing of formatted internal data to third party data vendors in support of their efforts to provide industry sales and prescriber data analysis. An example would be a monthly Region, District, Territory and Representative alignment for the Schering-Plough sales force.
Analysis, design and coding of various monthly incentive processes using each of the third party data DB2 stores created. The outputs were used for market analysis and commission calculation by Sales operations.
Analysis, design and coding of processes to transmit prescriber data to the laptops of the Schering-Plough sales force.
PRUDENTIAL INSURANCE 11/1996-03/1997
Independent Consultant
Senior Applications Developer
The Technical and Miscellaneous Revenue Act (TAMRA) became law on November 10, 1988 and was generally retroactive to June 21, 1988. The law was in response to Congressional perception that some life insurance contracts were being advertised and sold as tax sheltered investments rather than life insurance protection. The law was designed to deter people from quickly accumulating large sums of money in their life insurance contracts and then borrowing or withdrawing money on a tax-advantaged basis.
Developed and coded a system to identify contracts that have become a MEC (Modified Endowment Contract). This is any contract which has an unusually high amount of gross premiums in relation to the death benefit any time during the first seven contract years.
Worked on the Tax Database ASE team to initialize DB2 tables with the necessary information to allow implementation of the TAMRA process. This was accomplished using batch Cobol II and DB2 load utilities.
WARNER LAMBERT 01/1995-11/1996
Independent Consultant
Project Leader/Senior Applications Developer
Developed a Group Rebate System to work in conjunction with the existing contracting system. This project required the creation or adjustment of approximately 40 online and batch DB2 programs. Coordinated the phases of the life cycle to a successful completion.
Coordinated a “Contract Delete” process. This entailed identifying the eligible contracts and maintaining referential integrity with all associated tables. The entire process was done via DB2 employing Views and batch DB2/SQL.
Analyzed, developed and implemented “sales fix” process. Conducted a study to determine the reason for an imbalance in sales figures between two separate sources. The conclusion was that in certain instances, invalid input data had been passed from an external system. This had been occurring for over three years. Using utilities to create files with the affected records from years of archived data along with specially developed programs, the sales figures were brought into the system.
Developed and coded a process to pass wholesaler chargeback information via EDI, eliminating all paper reports. Verified the correct translation of data with the receiving wholesalers.
Performed DBA activities for the Parke-Davis MIS group.
Maintained the Institutional Health Care system. This included a CICS DB2 online system and an overnight batch cycle. Applications included contacting, chargebacks and customer maintenance. Onsite, beeper and overnight support was provided.
COOPERS & LYBRAND CONSULTING 12/1992-01/1995
Senior Associate
Lead team in analysis, design, coding and testing in critical/complex areas of the client.
Adept in coding, modeling and/or prototyping tools as well as training and supervising of staff.
Formulated work plans and controlled team schedule and deliverable quality. Industries include pharmaceuticals and freight delivery.
SIEMENS MEDICAL SYSTEMS 09/1990-12/1992
Senior Programming Analyst
Analysis, design and programming of interface programs between the existing POPICS Total database system and current MOSAICS DB2 system for physical inventory.
Performed maintenance and end user support for the MOSAICS CICS DB2 system. Functions include order processing, sourcing and allocation, purchasing, receiving, etc.
WAKEFERN FOOD CORP. 09/1988-09/1990
Programming Analyst
Coded and tested in the development of a Retailer Automated Product Information and Distribution System (RAPID). All programs written in DB2, CICS and Cobol II with approximately 98% being online. The project entailed warehousing and distribution related applications.
PRUDENTIAL INSURANCE 02/1986-09/1988
Programming Analyst
Coded, tested and maintained COBOL and CICS programs for the following applications:
Online Field Office/Agents system which created and updated the source for the Clerical ID Record System.
Batch Policyholder Information System which provided various financial reports.
COMMERCIAL INSURANCE INDUSTRY 06/1978-02/1986
Underwriter/Marketing Representative
Underwriter and Marketing Representative for various commercial insurance companies (Wausau Insurance, Hartford Insurance, AIG)
EDUCATION
CHUBB INSTITUTE 1985-1986
Computer Technology
SAINT PETER’ COLLEGE 1974-1978
Bachelor of Arts, (B.A.), History
CERTIFICATIONS
ITILv3, Six Sigma Yellow Belt
Contact this candidate