RESUME

I. William Fanning Telephone Number: 717-***-****

*** *. ********* *****, ***. B Cell Phone Number: 717-***-****

Harrisburg, PA 17111-7006

SUMMARY OF QUALIFICATIONS

Experience in systems analysis, coding, and testing. Analyzed code for modifications to existing systems and new systems. Performed full range analysis and provided customer interface from early stages of design, to system testing, through implementation into production. Developed plans for each phase of the project specializing in the area of system testing. Project managed system implementation.

TECHNICAL EXPERIENCE

COBOL, COBOL II, COBOL LE/370, PL/SQL, IMS/DB, IMS/DC, Oracle, DB2, CICS, VSAM, JCL, FTP, MetaCOBOL, Microfocus COBOL II, Panvalet, Librarian, Harvest, TSO/ISPF, IBM Mainframe, IBM Workstation, Unix, Xpediter/TSO, TCP/IP/FTP Xpediter/CICS, Animator, Toad, SQL Plus, SQL Ease, CLIST, Visual Basic, Windows 2000/NT, Easytrieve, Microsoft Office 97 Suite, Windows Office 2007 Suite, Lotus Notes

EDUCATION

University of Pittsburgh

School of Library and Information Sciences, M.S.I.S., 1986

Grove City College

B.A. in Business Administration, 1981

Training:

New Horizons

.NET courses (Ajilon University On-Line)

SUMMARY OF WORK EXPERIENCE

AJILON CONSULTING, INC. 2003-Present

Applications Development Specialist I

HIGHMARK BLUE SHIELD 03/09-Present

Applications Development Specialist I

• Developed process to dump IMS database segments, convert to DB2, and load to new DB2 format.

• Created or modified code, etc. to access the new DB2 data format.

• Modified and tested code and jobs for Mass Updates and Audits to use the new DB2 data.

• Supported cycles for claims processing.

• Work on new project, PEGA, using PRPC software to handle errors within client based OSCAR claim processing system.

ELECTRONIC DATA SYSTEMS (EDS) 01/08 through 11/08

• Performed analysis, COBOL coding and testing to modify existing modules and programs for project requests. This is for their Blue Cross/Blue Shield of Massachusetts (BCBSMA) client. Worked on modifications to calculate payment reduction amounts of Medicare Advantage customers with certain coverages. Resolved numerous defects (code problems) in the ITS/TPS System as required, from ITS Releases 9.4, 10.0, and 10.1. For example, where Providers were not getting paid due to a defect from ITS Release 10.1. Assisted with ITS Release 10.2 work, with Reports and other code for new concept of claims in a claim set. Worked with Home Plan Aid, Response Processor, etc. Assisted in developing new code and jobs for the annual Provider Satisfaction Survey. Worked on various other projects as needed..

ELECTRONIC DATA SYSTEMS CORPORATION

(E.D.S.) 11/06 – 09/07

Applications Development Specialist I

• Performed analysis, coding, and testing on numerous programs to support TPS for the Blue Cross Blue Shield of Massachusetts account. This was in an IBM mainframe environment. Worked on National Provider Identifier (NPI) projects, as well as Personal Health Information (PHI) initiatives.

FIRST HEALTH 03/06-09/06

Applications Development Specialist I

• Performed Medicare Part D work, extracting Medical Exception data, formatting the data to a specified format, and either FTP’ing the files to the plans, or burning the data to CD’s and sending them to the plans.

• Mainframe COBOL, JCL, using Viasoft for testing.

• All database files are VSAM, and any updates, deletes, etc. were accomplished via IDCAMS steps.

• Enhanced back up jobs, adding new datasets, GDGs, etc

• Modified some CICS programs/screens.

HIGHMARK BLUE SHIELD 07/05-03/06

Applications Development Specialist I

• Involved in the coding in COBOL and IMS to perform front-end processing/mapping, as well as reporting, for new client Mutual of Omaha.

• Called AI's for DB2 table reads and updates. Created Production-level JCL and PROCs for the process.

• This was in the Financial Group Systems Support area as an adjunct from Dental and Vision Systems.

PENNSYLVANIA DEPARTMENT OF REVENUE 10/04-06/05 Applications Development Specialist I

• Conversion of the Case Tracking System from IMS to DB2.

• Writing conversion programs, as well as writing programs to be run to maintain the DB2-based system.

• Assignment of collection agencies to cases based on dollar amount owed, amount of time the account was delinquent, as well as evenly distributing cases between agencies.

• Worked on programs that interfaced with the Predictive Dialer system, which is an Avaya system to assign case outgoing telephone calls to specific case workers, and also to distribute incoming calls among case workers.

HIGHMARK BLUE SHIELD 09/03-10/04

Applications Development Specialist I

The Auto Delinquency Project 01/04-10/04

• Had responsibility to write nearly all AI's (Application Interfaces - basically DB2 access to tables) for this project, going against almost all new and existing tables.

• Involved COBOL and DB2. This was in the Membership and Billing area.

HIPAA 2003 09/03-12/03

• Mandates coded and installed. Also UMI (Unique Member ID) changes as required. This was for the Dental and Vision Systems area of Highmark, involving COBOL, some IMS, DB2, and JCL.

• Performing analysis, COBOL coding and testing to fulfill HIPAA requirements/mandates. This is also involving COBOL coding and testing for the Auto Delinquency process and creating Application Interfaces (AI’s) to access the DB2 tables. Some work on the FEP side was also done.

• Computer Environment: IBM Mainframe

PENNSYLVANIA DEPARTMENT OF TRANSPORTATION

Applications Development Specialist I 03/03-09/03

Analyzed, wrote specifications, coded, Unit tested, System tested, and User Acceptance tested COBOL code in the IBM mainframe IMS/DB2 environment. Modifications were implemented into Production from state legislative mandates. The application is the Driver Licensing and Controls system. Provided post-implementation support for these modifications. Used DB2, COBOL, MetaCOBOL, JCL, SQL, SPUFI, FileAID, DataVantage, FTP, Xpediter, and Librarian

GIANT EAGLE 1997-2002

Programmer/Analyst – Senior

Project managed the system conversion efforts and testing. Designed and implemented shelf tag system improvements. Developed test plans/scripts to identify problems and recommend solutions. Analyzed, designed, and implemented changes to existing systems to handle excess data resulting from store acquisitions. Used Oracle, DB2, Visual Basic, COBOL, Microfocus COBOL, JCL, FTP, FileAID, Toad, SQL Plus, SQLEase, InterTest, Animator, PL/SQL, Easytrieve, CICS, Harvest, UNIX, and Panvalet.

CIBER, INC. 1993-1997

HIGHMARK BLUE CROSS 1994-1997

Analyst

Analyzed existing systems, implemented modifications based upon requirements and maintained systems. This was in the Membership area, working with multiple clients. It involved re-enrollment on an annual basis. Worked with DB2, IMS DB, COBOL, COBOL II, COBOL 370, Easytrieve, Xpediter/TSO, Xpediter/CICS, JCL and other technologies at this client site.

MELLON BANK, N. A. 1993-1994

Analyst

Analyzed existing systems and performed modifications based upon requirements. This was in the Trust Department. Worked with IMS, COBOL, JCL and other technologies at this client site.

ADIA INFORMATION TECHNOLOGIES 1992-1993

Analyst

Analyzed, tested and implemented modifications to production systems. Performed requirements analysis and implemented modification to Commercial Drivers’ License System at PennDOT headquarters. Maintained and monitored production job streams for insurance claims processing for Pennsylvania Blue Shield. Used IMS DB/DC, COBOL, COBOL II, JCL, and Xpediter.

CINCINNATI BELL INFORMATION SYSTEMS

(C.B.I.S.) 1991-1992

Analyst

Developed and executed test plans/scripts to identify problems and recommend solutions on the design efforts on financial database system. Used Microfocus COBOL II, JCL, IMS DB/DC, DB2, workstations, Animator, Xpediter, and mainframes.

COMP-U-STAFF, INC. 1989-1991

Senior Programmer

Performed coding and testing, including unit, system, and integration, of Drivers’ License System at PennDOT headquarters. Drafted and developed design documents for enhancements to existing systems, and for future design efforts. Used Cobol, JCL, IMS DB/DC, MetaCOBOL, DataVantage, Xpediter for testing

ELECTRONIC DATA SYSTEMS CORPORATION

(E.D.S.) 1987-1988

Systems Engineer Development

Managed installation of several software releases for Allstate Insurance in Northbrook, IL. Installed and tested releases of major software package at the client site. Used COBOL, JCL, PROCs, IMS DB/DC, DBD’s, PSB’s, MFS’s, CLIST, and Xpediter.

WESTINGHOUSE ELECTRIC CORPORATION 1987

Self-employed Consultant

Performed technical editing of engineering documents used in the training of nuclear reactor operators.

COGNET 1986-1987

Practicum

Installed, tested, and evaluated communications software package for use on PCs.

THRIFT DRUG COMPANY 1981-1986

Operations and Merchandise Manager

Managed workforce of 5 sales clerks. Established goals and reviewed progress toward achieving the goals. Improved sales performance of the store by 40%.

Contact this candidate