Engineer Software

William J. Friel

** *. ***** ****** ************, PA 19119 215-***-**** *******@*****.***

Summary

Detail oriented, highly motivated Senior Programmer/Analyst with 23+ years of successful experience in designing, developing and implementing software solutions on the IBM mainframe using COBOL, DB2, SQL, JCL, and VSAM.

In addition, I have 13+ years of broad programming and software design experience in the AS400 environment using COBOL, DB2/400, CL language, SQL, and AS400 online programming, DDS. My deep knowledge extends into PowerMHS application and ALDON tools.

Empirical knowledge of all system development life cycle phases.

Excellent understanding of mainframe change management system (ENDEVOR) and the AS400 change management system (ALDON).

Core Competencies

Mainframe, AS400, COBOL, DB2, SQL, ALDON, CL, ENDEVOR, JCL, VSAM

Work Experience

PeopleShare, Philadelphia, PA

Independence Blue Cross, Inc., Philadelphia, PA

Sr. Programmer/Analyst 01/2013 – 09/2013

• Member of a team for a high profile project (Blue Core) responsible for

delivering member accumulator information and referral data information.

• Designed a date driven automated process for extracting claim referral for

migrating members and send to Highmark for processing.

• Designed a process that would send inbound member accumulator information

from Highmark and loads records on IBC’s UUIMAS file.

MISI Company, Bala Cynwyd, PA

Independence Blue Cross, Inc., Philadelphia, PA

Sr. Programmer/Analyst 05/2011 – 09/2011

• Automated a manual process using a CL program and SQL queries

eliminating human intervention by 100%

• Replaced temporary datasets in a mainframe PROC with permanent GDG’s

(Generation Datasets) saving countless hours of data investigation and review

• Performed enhancements to existing COBOL programs and provided new CL

applications based on client’s business requirements

Independence Blue Cross, Inc., Wayne, PA

Sr. Programmer/Analyst 10/2000 – 03/2010

• Produced on average 40 ad-hoc reports per month using SQL Queries based on client’s

business requirements

• Designed, developed, tested, implemented, and documented new COBOL AS400

applications providing timely reports in the desired timeframe

• Responsible for maintaining over 400 production batch and online programs and reports

• Received perfect attendance awards 8 out of 10 years

• Recipient of 10 Employee Recognition Awards. Recipients are nominated by fellow

employees to recognize exceptional service or performance.

Arcus Staffing Resources, Wayne, PA

Independence Blue Cross, Inc., Wayne, PA

Senior Software Engineer 08/1998 – 09/2000

• Core member of a team responsible for implementation of a new Claims Adjudication System

PowerMHS (Managed HealthCare System)

• Created custom COBOL reports on the AS400 system in support of the Claims Adjudication

System from specifications developed with the business clients

• Provided applications for the following functional areas: Enrolment, Member Services,

Claims, Benefits, Finance, and Accounts Receivable

Computer Task Group 11/1994 – 7/1998

SmithKline Beecham, Collegeville, PA 12/1997 – 7/1998

Senior Software Engineer

• Worked on a project team responsible for preparing files and programs to be Y2K compliant

• Developed applications to convert data to conform to Y2K standard.

• Analyzed, modified and tested programs to be Y2K compatible.

• Became proficient with File-Aid utilities

Towers-Perrin, Philadelphia, PA 4/1997 – 11/1997

Senior Soffware Engineer

• Became proficient with the use of VM SQL/REPORT system, a report writer that uses SQL

running on a VM/SP operating system.

• Responsible for maintaining a workshop administration system by producing Ad Hoc reports upon

request.

• Developed new and enhanced existing CSP applications for a Payroll system on a MVS operating

system.

University of Pennsylvania Hospital, Philadelphia, PA 4/1996 – 3/1997

Senior Software Engineer

• Developed code and procedures to interface with the Shared Medical System

• Responsible for financial capture of payments from lockbox and insurance processing.

• Developed code and tested extracts from case management and patient accounting master files.

• Became proficient with the use of VSAM and DMI tools to extract data required for reporting.

• Developed MPI reports for auditing changes to case management and PIDX segment of SMS

databases.

• Documented procedures in production JCL and programs.

E.I. Dupont, Wilmington, DE 06/1995 – 03/1996

Senior Software Engineer

• Developed and maintained applications for a large Fortune 500 pharmaceutical company using

COBOL, DB2, QMF, and JCL.

• Successfully updated a small system using COBOL and IMS.

• Interfaced extensively with users

Computer Task Group - continued

Campbell Soup, Camden, NJ 11/1994 – 05/1995

Senior Software Engineer

• Developed new and maintained existing COBOL and CSP programs.

• Defined and maintained VSAM files for the shipping and receiving departments

PECO, Philadelphia, PA 10/1987– 10/1994

Programmer/Analyst

• Designed, coded and tested new on-line and batch applications for the real estate department using

COBOL, DB2 and CSP.

• Maintained applications for a large publicly traded utility using COBOL and DB2.

• Provided production support for inventory management and real estate systems.

• Pivotal member of a team that conducted a business analysis of the real estate system using the

Knowledge-ware Case tool.

• Served as a technical advisor to clients on issues related to business requirements.

EDUCATION

BS in Computer Science

Spring Garden College

Contact this candidate