Phyllis Johnson

Abstract

Senior Programmer Analyst with experience in business analysis, application design, update, data formatting, development, reverse engineering, and conversion projects using full life cycle (System Development Life Cycle models) in small to large projects.

Individual contributor, team member, and lead programmer in single applications as well as multi-disciplinary, multi-platform projects requiring both project level overview and details such as interoperability between systems/platforms.

Successful interface at all levels of organizations.

Industry experience: Pharmaceutical, Insurance, Healthcare, Utilities, Wireless.

Software and Operating Systems
Mainframe

MVS/JES2, TSO/ISPF, DF/SMS, JCL, CMS, COBOL (ANSI thru LE), CICS (v2.1 thru TSv1.3), CICS RDO and Service Transactions, SQL, DB2 (v2 thru v6 (UDB)), VSAM, GDG, Assembler Macros, BMS, SDF/II, QMF, SPUFI, Catalogued Procedures, DB2 Stored Procedures and Global Temporary Table, Syncsort, Fileaid (VSAM and DB2), IBM MVS Utilities, Abendaid, Changeman, Panvalet, Symbol Wireless Hand-Held Technology, SAS, Xpediter, Intertest, SQL-Ease, Omegamon, BMC DB2 Utilities, MQSeries

Client/Server

Windows NT/2000, SQL, Oracle Unix via MS Acess/Sybase, DB2 via MS Access/Sybase, QMF for Windows, Visual Basic, Oracle, Power Builder

Desktop

Windows 3.1/95/98/Me/NT/2000, MS Access, Word, Excel, Power Point, SQL, SPFPC, Visual Basic, DOS Utilities, Micro Focus Workbench

Internet

HTML, Javascript, Vbscript, FTP

Consultant Experience

Project: Consignee View: Supply BIA with a more precise means to identify and analyze the volume and revenue related to specific consignees that meet a pre-defined delivery treshold.

United Parcel Service, Mahwah, NJ

01/2004 - 06/2004

Designed, coded, evaluated efficiences, unit/system/stress tested new programs according to evolving business specs for Data Warehouse, Marketing, e-Mail Notify.
Responsible for all processing required for input to Trillium Fuzzy Matcher for both daily processing, and initial load of new DB2 tables.
Environment: DB2v7 (UDB), SQL, COBOL LE, Batch, JCL, QMF, SPUFI, Expediter, Changeman, TSO, MVS, Windows NT/2000, CA SQl-Ease, Syncsort, BMC DB2 Utilities, Omegamon, Mainframe, High Volume Environment, MQS.

Project: Conversion and incorporation of COPS/WMS (Stratus Warehouse Management System) into existing DB2 RAPID Warehouse Management System.

Wakefern Food Corporation (ShopRite), Edison, NJ

05/2001 - 10/2001

Designed, coded, and tested new CICS Screens for Symbol Wireless Technology hand-held application (used to record food deliveries) based upon minimal specs.
Added the ability to test hand-held on Mainframe.
Worked on scheduling and receiving deliveries, and purchase orders.
Environment: CICS-TSv1.3, DB2v6(UDB), SQL, COBOL le, CICS, SDF/II, Batch, JCL, QMF (MVS and Windows), SPUFI, Expediter, Intertest, Panvalet, DB2 Views and Stored Procedures, TSO, MVS, Windows NT/2000, Symbol Wireless Hand-Held Technology, Catalogued Procedures, DB2 Fileaid, Mainframe.

Project: Analysis and enhancements to accomodate consolidation of multiple billing systems. Reverse engineering on 'Black Box'. Evaluation of DB2 Global Temporary Table.

Verizon Wireless, Warren, NJ

07/2000 - 03/2001

Researched and documented 'Switch to Bill' reconciliation (an auditing process that cmpares client plan information on the Switch in the field with information found in DB2 database).
Performed reverse engineering on the mysterious 'Black Box' which turned out to be a Unix computer that reformatted tapes from the Switch for input on the Mainframe.
Worked with DBA to evaluate use of DB2 Global Temporary Table to replace triple level working storage tables in billing programs.
Environment: Batch, JCL, DB2v6(UDB), SQL, GDG, COBOL LE, SPUFI, Expediter, Intertest, TSO, MVS, Stored Procedures, Windows NT, Catalogued Procedures, DB2 Global Temporary Table, Client/Server, Mainframe.

Project: Resurrection of Emergency Callout (Subsystem of Trouble Order System) frozen for 4 years in mid development without documention.

Orange & Rockland Utilities, Pearl River, NY

12/1999 - 06/2000

Incorporated architecture changes. Reverse engineered pre-existing functionality.
Developed and tested new functionality and new CICS programs.
Improved Response time in CICS/DB2 programs.
Environment: CICS, DB2v5, SQL, COBOL LE, SDF/II, QMF Procs set up, SPUFI, JCL, Expediter, Intertest, Panvalet, TSO, MVS, Catalogued Procs, DB2 Fileaid, Mainframe.

Project: Data Warehousing for RADAR (Pharmaceutical Rebate System).

Schering, Morris Avenue, NJ

11/1998 - 10/1999

Received quarterly data from business partners on tape, disk, CD, e-mail.
Automated validation and transformation of data to NDPCP format in MS Access.
Processed update of DB2 Data Warehouse via CICS Powerbuilder interface. Verified update of DB2, downloaded data, FTP'd to Oracle Unix Rebate System, verified Oracle.
Environment: DB2v4, SQL, COBOL II, GDG, JCL, Fileaid, SYNCSORT, SAS, SPUFI, Changemand, DB@ and Platinum Utilities, TSO, Windows 95, Catalogued Procedures, Oracle Unix via MS Access/SYbase, MS Access, VBA, Mainframe, Client/Server, Unix.

Project: PURR (MetLife Insurance Underwriting System) Batched AP's Project.

MetLife, Frontier Road, Bridgewater, NJ

10/1997 - 09/1998

Researched, designed, coded, and tested CICS screens after telephone conference.
Improvised testing, pending addition of new 'ID Number' and 'Indicator' to DB2.
Screen displayed in tow 'real time' modes listing all memeber and possible members of a household with MetLife insurance either by household or region.
Other CICS and batch projects.
Environment: CICS, DB2v4, SQL, COBOL II, VSAM, TSO, MVS, CMS, SPUFI, QMF, Batch, JCL, Expediter, Fileaid, Syncsort, Catalogued Procedures, Mainframe.

Project: Credit Card Project for Heavy Equipment Rental.

Hertz, Park Ridge, NJ

04/1997 - 10/1997

Translated APS code into COBOL II/ native DB2, as a protottype for move from APS.
Consolidated logic from multiple APS programs into one batch program with 13 cursors and 16 DB2 tables.
Environment: CICS, DB2v4, SQL, COBOL II, SPUFI, QMF, Expediter, TSO, MVS, Batch, JCl, APS, Mainframe.

Project: Analysis and enhancements to accomodate consolidation of multiple billing systems. Reverse engineering on 'Black Box'. Evaluation of DB2 Global Temporary Table.

Y2K In-House for Consulting Company, Jersey City, NJ

09/1996 - 04/1997

Applied Year 2000 Tool to DB2, COBOL II, COBOL, PL/1, and Assembler.
Resource for les experienced team members.
Selected to document 'Manual Resolution Process' for the Y2K Task Force.
Environment: DOS, Windows 95, MS Access, SPFPC, DOS Utilities, Client/Server.

Employee Experience

Prudential Insurance Company (Group Systems), Roseland, NJ

05/1978 - 09/1996

PRISM (Billing and Eligibility for Prudential's HMO, and services sold to self-insured companies).

Performed Research, Analysis, New Development, Maintenance, and Production Support.
Served as CICS coordinator, AIRES coordinator (Version management software).
Sat in for manager at Meetings, Special Requests, and Production Problems.
Resource for Billing, Capitation, General Ledger, Accounts Receivable, Eligibility, ID Cards.
Engineered Data Flows, Audit Trails, New VSAM files.
Wrote Specifications, Documentation, and Test Plans.
Functioned as Q.A. Analyst, Individual Programmer, Team Member, Lead Programmer.
Set up JCL, IDCAMS, and Utilities (with notes) for PRISM Q.A. and other IT areas.
Environment: CICS (v2.1 - v4.0), VSAM, DB2 (v2 - v3), COBOL (ANSI and II), Batch, IBM MVS Utilities, Syncsort, Fileaid, JCL, CMS, TSO, Assembler Macros, SPUFI, Expediter, WIndows 3.1, OS/2 Micro Focus Workbench, catalogued Procedures, SAS, Client/Server, Mainframe.

Special Projects

Received Customer Satisfaction Award for providing the new DB2 System Design Team with the best documentation fo a legacy system.

Analyzed, researched, designed the basic data flow between the new DB2 system and the PRISM legacy system for the Bridging Project. Designed, coded, tested batch program that mimicked CICS 'Add New Member' and 'Change Member' functionality. Program served as a source of 'reusable code for basic PRISM functions. Data flow and program supported new functionality with minimal changes.

East Orange V. A., East Orange, NJ

06/1979 - 03/1987

Served as head nurse for evenings on active medical units.
Enlisted nursing, medicine and the pharmacy to coordinate a system change to the replacement of emergency medication.
Designed form to simplify handing out shift assignments to team members.

Education

Fairleigh Dickinson University, Rutherford, New Jersey
B.S., Cum Laude, Phi Omega Epsilon

Continuing Education:

Union County College- IT Courses- GPA 4.0
On Site Continuing Education- IT Courses
Lunch Time Continuing Education- IT Courses
e-Learning Continuing Education- IT Courses