Project Analyst

Susan M. Dunn

** ****** **, ******, ** *****; Cell 678-***-****; Email:

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

Summary:

* 20+ years experience as Programmer Analyst

* 10+ years COBOL

* 10+ years IMS DB/DC

* 4+ years DB2

* 4+ years CICS

Software / Hardware / Operating Systems:

Programming Languages: COBOL, APS, EDI, MicroFocus COBOL, SAS, Natural,

SQL, PL/1, EZTRIEVE, ADR IDEAL, ADSO, MQ, Cognos

Software: TSO/ISPF, SDSF, QMF, CICS, JCL, Panvalet, GSAM, ISAM, VSAM, IMS

Data Dictionary, Predict (Adabas Data Dictionary), Strobe (application

profiler), Excel, Word, IMS-Xpert, Data-Xpert, Syncsort, Abend-aid, SQL-

Loader, FTP, Connect Direct, IMS ADF, MFS, PSB, BMP(Batch Msg Proc),

Windows NT, 95, 98, 2000, XP, MVS-XA, MVS-ESA, OS/390, z/OS, UNIX

Hierarchical DBMS: IMS DB/DC, ADABAS

RDBMS: DB2, Datacom DB-DC, Oracle 7 & 8

Network DBMS: IDMS

Change Mgt / Source Mgrs: Endevor, N2O

Hardware: IBM 3090, IBM 4381-Q14, Data General, VAX

Debuggers: BTS, XPF/COBOL, Natural Debugger, Micro Focus Debugger, ADR

Ideal Debugger, Smart-test

EXPERIENCE:

08/07 - Present: Company Confidential (on contract)

. Provide analysis and specs for Claims processing system project including

HIPAA 5010 project;

. Coded and tested programs including APS, Cobol, IMS, DB2, CICS, MQ and

EDI entry channels (Web, Cardswipe, 837, 270/271, 276/277) ;

. Coded Easytrieve DB2 and QMF queries; Resolved defects for Claims Test

System for Cobol, DB2, Easytrieve programs; Coded efficiencies changes

to Cobol/IMS Batch programs and JCL;

. Updated screens using Micro Focus screen painter; mapped feed data into

Excel; (Enterprise Cobol, APS, EDI, MQ, DB2, CICS, IMS DB, JCL,

TSO/ISPF, MVS, z/OS, Endevor, Easytrieve DB2, QMF, PC Mailbox)

12/09 - 01/10: Created Cognos mfg reports for client in CA. (Cognos, SQL)

09/99 - 08/03 - RG&E / Energy East -Rochester, NY- Sr. Programmer Analyst

. Created test plans/cases and defect reports; provided Y2K fixes for

COBOL/CICS programs; modified COBOL programs for CA-Endevor install

(included Assembler replacement) and conversion from CA-Panvalet

. Received Executive award for increasing cash flow and reducing arrears by

approx. $1.1million via modifications to Dept. of Social Services (DSS)

billing subsystem; converted 10 PL/1 programs to Natural/ADABAS.

. Performed analysis, design, coding/testing on CIS Plus subsystems (DSS,

Payments, Adjustments and Billing) changing approx. 110 Natural

online/batch/maps programs for DSS; wrote conversion programs to fix DSS

financial data; completed program that generated approx. $600K in

adjustments (4 yrs of financial data);

. Responsible for posting of $30 million in Home Energy Assistance Program

grants (HEAP - Gov't disbursement) by changing payment programs (used

weight calculation and multi-dimensional tables to plan and distribute a

payment)

. Changed EFT (Electronic Funds Transfer) Natural programs (CIS Plus,

Natural/Adabas, Predict 3.4, N2O(source mgr), OS390, z/OS,

TRIM(performance monitor), PL/1, COBOL, EZTRIEVE, TSO/ISPF, MVS, SDSF,

$AVRS, JCL, CICS, Panvalet, Endevor, Debugger, Strobe (application

profiler))

09/99 - 12/99 - Xerox: Continued at Xerox part-time on the Oracle project.

06/97 - 09/99 - Xerox - Rochester, NY - Sr. Programmer Analyst (on

contract):

. At Xerox (11/98 - 9/99) worked on Data Warehouse team building Oracle

Revenue system.

. Performed analysis on IMS, DB2 databases, Cobol/IMS/DB2 jobs for input

into Erwin; using DDL from Erwin, created table scripts manually using

Oracle 7/8;

. Researched /documented all jobs; performed analysis, wrote specs, coded

Cobol programs to FTP and loaded files via SQL-Loader into new Revenue

Oracle system; created table / mainframe file program cross-reference

for reporting.

. Researched 300+ tapes from Equip Billing (EBS) and Corp Revenue Reporting

(CRR) systems to load history data (20+ mo.'s) into Oracle; manually

reviewed 1.2 million invalid dates; loaded dates into Excel for review;

used SPACESQL to validate dates on new Oracle tables; created Report

Definitions in INFOSPACE (Oracle) to test/QA tables;

. Researched and documented Equipment Billing (EBS) and Corp Revenue (CRR)

processing to create the EBS current bill file and the CRR unbilled file;

managed issues and resolution list for user group; downloaded IV/IL data

into Microsoft Access to create query syntax and produce revenue amts to

match CRR Cobol program output for QA; trained new programmer; (COBOL

II, JCL, MVS, Oracle 7 & 8, PLSQL, UNIX, SQL-Loader, Infospace, IMS

DB/DC, DB2, File-Aid, FTP, FTP/Connect Direct, Endevor, Microsoft

Access).

. At Xerox/ EDS (6/97 - 8/98), supported 17 mfg. systems (i.e. MALS, MLS,

WIP, MRP, Procurement, etc.);

. On-call 365 days; handled 85+ production problems ; on-call for 50 Mfg

systems;

. Wrote 6 new COBOL, DB2/IMS pgms; Trained new programmers (IMS DB/DC, DB2,

COBOL, JCL);

. Created FTP jobs thru firewall to external company; updated Prod. IMS DB

using ADF and coded Cobol/IMS pgms to modify PO's; Received Employee

Award. (MVS, COBOL II, Embedded SQL, QMF, IMS DB/DC, DB2, QMF, Hoskins,

MVS, TSO/ISPF, SDSF, JCL, ISAM, VSAM, GSAM, ADF, File-Aid, XPF-COBOL,

Syncsort, Abend-aid, Endevor)

06/96 - 05/97 - JTS/Ajilon Consulting - Rochester, NY - Sr. Programmer

Analyst - (on contract):

. At Blue Cross/Blue Shield: (10/96 - 6/97) wrote spec's using Micro

Focus tools to analyze and test over 100 pgms for Year 2000; (MicroFocus

COBOL, Revolve, Windows NT).

. At ACC Long Distance Corp (6/96 - 9/96) wrote 11 pgms including several

COBOL pgms for Internet billing (CDR Unload, billing and rating pgms);

. coded EZTRIEVE pgms (VSAM database load pgms and Label pgms); coded COBOL

pgms to convert call detail records for rating and billing, tested rating

job stream (approx 9 pgms) to test converted data. (COBOL, EZTRIEVE,

TSO/ISPF, DOS/VSE, DOS JCL, VSAM)

07/95 - 4/96 - Kodak - Rochester, NY - Sr. Programmer Analyst - (on

contract):

. At Kodak (12/95 - 4/96) for the AP Electronic Feed project and Workers

Comp Dept, determined requirements; Performed analysis on the current on-

line and batch system; Wrote specs for 7 batch programs based on input

from an external company. Wrote the project plan, spectrum checklist

and attended walk-thru for sign-off. Downloaded data via Datavantage and

wrote 2 new PL/1 pgms to convert/unpack data for FTP to Legal Lan.

(MVS, File-aid, IMS DB/DC, PL/1, FTP, TSO/ISPF)

. At Kodak (07/95 - 12/95) Rewrote the on-line billing programs to prevent

lost data due to paging; modified batch pgms; wrote 12 spec's for DB

restructure; wrote procedures and trained new programmer. (ADR/IDEAL,

SQL, Datacom DB-DC, Dataquery, TSO/ISPF)

01/95 - 7/95 - Wegmans - Rochester, NY - Sr. Programmer Analyst - (on

contract)):

. On a Retail System and team of 7+ (key expansion project) converted 110

batch pgms/JCL;

. Modified CULPRIT pgms; created DBDC/DMLO test data; created 7 JCL PROCs

to convert physical to perpetual inventory system. (COBOL II, MVS,

TSO/ISPF, ADSO, IDMS (Network DBMS))

09/92- 01/95 - Xerox/EDS - Rochester, NY- Sr. Programmer Analyst (on

contract):

. Supported Xerox Order Entry System (CAPS), on-call 365 days, fixed 60+

defects; reduced calls to 30 per month .

. On a team of 10, modified several programs, trained 5 new programmers

(COBOL, IMS, TSO) for a Corp. project intended to increase revenue by $65

million;

. Wrote new batch and online programs (COBOL-SQL, IMS & DB2); modified IMS

MFS's and PSB's. Gathered requirements, completed analysis, design, specs

and coding/testing for 5 Faultless Installed projects; provided user

training documentation, QA analyst support; created test plans, test

cases and defect reports. (COBOL II, Embedded SQL, DB2, QMF, IMS DC/DB,

Endevor, Panvalet, MVS, TSO/ISPF, SDSF, FTP, Micro Focus COBOL, debugger,

Syncsort, Abend-aid)

03/91 - 11/91 -- Kodak - Rochester, NY - Sr. Programmer Analyst (on

contract ):

. At Kodak, modified 33 ADF transactions, ADF audit modules, 18 PL/1 pgms

and wrote 5 new PL/1 pgms for a billing/Equipment tracking system;

. wrote SAS pgms and Datavantage modules for testing; (PL/1, IMS DC/DB,

ADF, SAS, MVS, TSO/ISPF)

07/89 - 02/91 - Xerox - Rochester, NY - Sr. Programmer Analyst (on

contract):

. At Xerox, working on a Billing system (XEEP) that invoiced equipment

financed through Xerox. On a team of 8 and for 12 projects, modified

approx. 119 COBOL/IMS/DB2 programs,

. Wrote 21+ new programs (including MFS's & PSB's), resolved QA PN's,

modified Mark IV pgms, wrote new SAS pgms, and provided production

support. (COBOL II, IMS DB/DC, DB2, SAS, Mark IV, MVS, TSO/ISPF, SDSF,

FTP, ISPF, Syncsort, Abend-aid, file-aid, XPF-COBOL, BTS, Endevor)

08/88 - 07/89 - University of Rochester, Rochester, NY - Programmer

Analyst:

. Supported a Financial Accounting System (FAS) and worked with customers

to install new FRS accounting software.

. Wrote functional, technical batch specs and coded and tested COBOL &

Natural/Adabas pgms. (COBOL, NATURAL, ADABAS, MVS, TSO/ISPF)

05/81 - 08/88 - Xerox - Rochester, NY - Programmer Analyst:

. Supported Order Entry System (CAPS); on team of 17assisted with design,

analysis and implementation on several projects (CP1, Rel 3.5, Rel 5,

CP2C). Designed model FML (mainline pgms); wrote batch/online specs;

. Coded/tested COBOL/IMS DC pgms, maps, PSB's, FML Equip Cancel process and

front-end batch COBOL/IMS pgm; coded/tested IMS table/DB calls to handle

unlimited accessory;

. Provided training on IMS DB/DC, COBOL and IBM utilities to new

programmer; provided on-site coverage for base case; prepared BMP access

map; resolved 120+ PN's. Wrote 30+ SAS programs to automate the Program

Librarian tasks.

. Completed 45 online/classroom courses in Structured Analysis, Structured

Design, IMS DB/DC, JCL, etc. Converted to employee 4/19/82. (COBOL

II, IMS DB/DC, BMP, MFS, PSB, BTS, XPF-Cobol, IMS-Xpert, file-aid, SAS,

MVS, TSO/ISPF, FTP, PANVALET, Syncsort, Abend-aid, Endevor).

EDUCATION:

Monroe Community College, Rochester, NY - A.A.S. Data Processing

AWARDS:

RG&E Executive Award for DSS Project

RG&E Project Award

Xerox/EDS Employee Award

Xerox Recognition Award for Corp project

Contact this candidate