Customer Service Programmer Analyst

Jon D. Lalla

*** ********** **. 610-***-**** (Home)

Downingtown, PA 19335 610-***-**** (Cell)

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

SUMMARY

Experienced and proven developer and lead programmer in the insurance, banking and retail industries.

Software: z/OS, MVS/ESA, TSO/ISPF, COBOL, JCL, DB2, SQL, CICS, Endevor, MQ, VSAM, Easytrieve, QMF, SPUFI, File-AID, File-AID for DB2, XPEDITER, STARTOOLS, ZEKE, MS Word, MS Excel

PROFESSIONAL EXPERIENCE

The Judge Group / Vanguard, Malvern, Pa 2015-2016

A contractor on a 1 year assignment to the Performance Reporting Application. Using the Agile methodology, the application team was responsible for developing a new three–tier system to extract data from the Enterprise database and supply it to a third party vendor. My responsibilities include analyzing business requirements and designing, coding, unit testing and supporting integration testing for mainframe components. The software utilized is primarily COBOL, JCL, DB2, SQL, SPUFI, SYNCSORT. Some of the tools utilized are BMC, INSYNC & CONTROL-M.

Aetna, Blue Bell, PA 1998-2015

Senior Application Developer, Programmer Analyst II/Business Systems Delivery Specialist,

Independent Consultant

Lead Programmer for the Traditional Claims System’s (ACAS) Archive & Recall process. The initial archive process involved migrating over 2 billon rows off of the DB2 tables. The current monthly process archives over 250 million rows and the current recall process restores, upon request, a few hundred rows daily.

Principal programmer on a pilot three-tier project using DB2 stored procedures.

Sole mainframe developer for the Corporate Commissions Application. Performed Impact Analysis, Design, Coding, Unit Testing, and Change Control procedures.

Generated Lifecycle Documentation including Component Design Documents, Unit test Plans, Unit Test Scripts and updated application documentation for all assigned projects and service requests.

Reviewed DB2 SQL for performance and applied version enhancements.

Assisted Lead Programmer for the Member Application with Infrastructure changes.

Developed and executed DB2 initial load jobs using load utility for COB application.

Developed a series of request jobs and programs for the Claims Reporting System (CRS) which received data from various applications. The programs verified the data, reported on invalid data, & processed the valid data for user reports.

Supported a series of called programs for the Service Code/Service Rates Application. The programs were called from the Claims application and would return provider rates for medical procedure codes and other criteria. The rates data was stored on DB2 tables.

Mainframe Security Coordinator for Commissions application.

CSC Systems & Integration, Berwyn, PA 1997

Consultant / Technical Designer ( Client: JPMorgan)

Handled production support & emergency technical requests.

Determined implications, defined technical specifications & alternate solutions for various user requests. Solutions were documented and presented to ascertain their feasibility.

Coopers & Lybrand Consulting, Chesterbrook, PA 1996-1997

Staff Consultant

Team member responsible for selecting, developing and testing Y2K tools & methodologies for the local branch.

Evaluated software products, developed questionnaires and procedures to assist in the strategy & conversion phases for Y2K projects.

Cap Gemini America, Bala Cynwyd, PA 1996

Senior Consultant

Researched the impact of Y2K on mainframe applications.

Conducted interviews with application managers and senior programmers to determine the general complexities of their applications. Documented and submitted my findings.

QVC Network Inc., West Chester, PA 1990-1996

Systems Engineer III

Conducted a benchmark project to convert the financial system from Teradata to DB2.

Supported portion of the Order Enter / Customer Service application located on the IBM platform.

Supported the Disaster Recovery Order Entry System.

Responsible for the programs & jobs which posted sales and return data to the financial ledger.

Representative to the Data Processing Standards Committee.

AIG, Wilmington, DE 1987-1990

Lead programmer / Senior Programmer

Lead Programmer for the Production Support Team assigned to the Domestic Group Accident & Health Systems.

Responsibilities included supervising programmers, analysis and estimating user requests, developing release schedules and coordinating the change control process.

Actively involved in the development of Programmer Trainees.

Blue Cross of Greater Philadelphia, Philadelphia, PA 1984-1987

Senior Programmer Analyst / Programmer Analyst

Girard Bank / Mellon Bank, Philadelphia, PA 1981-1984

Programmer Analyst/ Programmer Analyst Trainee / Data Processing Trainee

EDUCATION

B.A – Computer Science – LaSalle University

Contact this candidate