SUMMARY:

• Senior Applications Developer/Project Leader with 29+ years’ experience designing, developing and maintaining applications in various enterprises.
• Proven ability and flexibility to perform in multiple industries, technologies and roles.

TECHNICAL SKILLS:

Database: Technology (Oracle, DB2, Access)

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.

PROFESSIONAL EXPERIENCE:

Confidential

Application Lead

Responsibilities:

• 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.

Application Lead

Responsibilities:

• 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.

Service Analyst

Responsibilities:

• 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.
• 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.

Lead Analyst

Responsibilities:

• 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.

Independent Consultant Project Leader/Senior Applications Developer

Responsibilities:

• 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 in corporate 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 Axentia and SABA Compliance Program applications

Independent Consultant Project Leader/Senior Applications Developer

Responsibilities:

• 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.

Confidential

Independent Consultant Project Leader/Senior Applications Developer

Responsibilities:

• 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.

Independent Consultant Project Leader/Senior Applications Developer

Responsibilities:

• 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.

Independent Consultant Senior Applications Developer

Responsibilities:

• 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.

Independent Consultant Senior Applications Developer

Responsibilities:

• 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.

Independent Consultant

Responsibilities:

• 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.

Senior Associate

Responsibilities:

• 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.

Senior Programming Analyst

Responsibilities:

• 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.

Programming Analyst

Responsibilities:

• 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.

Programming Analyst

Responsibilities:

• 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.

Underwriter/Marketing Representative

Responsibilities:

• Underwriter and Marketing Representative for various commercial insurance companies (Wausau Insurance, Hartford Insurance, AIG)

­­­­­­­­­­­­­­­­­