The Professional Resume of

Dana Rothrock

IBM Mainframe Software Architect

Comprehensive information systems expertise - systems, database and

application performance tuning, analysis, design, coding, testing,

quality assurance, installation, legacy systems, software evaluation,

project management, programming development environment set-up,

dump analysis, conversions, interfaces, consolidations; systems,

programming, and user standards and documentation; multi-platform.

Full Life Cycle proficiency from system inception to decommission.

I have "slain the dragon" at several companies after their strike teams and

subsequent consultants failed.

40 years experience - 25 years consulting. My skills

Computer Systems:

IBM 2817 z/196 IBM 2094 IBM 2084 IBM 2064

IBM 9672 IBM ES/9000 IBM 3090 IBM 3083

IBM 3081 IBM 3033 IBM 4381 IBM 4341

IBM 4331 IBM 370/158 IBM 370/148 IBM 370/138

Honeywell Series 50 Datapoint 6600 Datapoint 1800

Datapoint 1500

Commodore 8032 Commodore 32N

Languages:

Enterprise COBOL COBOL-390 COBOL-LE COBOL II/COBOL

Command Level COBOL OS COBOL IDMS COBOL Macro Level COBOL

Assembler DLI REXX DB2REXX

CLIST EXEC2 FOCUS MARK IV

Easytrieve RPG II Easytrieve Plus FORTRAN IV

Dial 260 QUIKJOB Micro Focus COBOL II BASIC

Java SQL*Plus DB2 SQL 6502 Micro Assembler

Software:

Parallel SysPlex IBM z/OS IBM OS/390 Catalog

Manager

SysView AppTune Detector Plan Analyzer

MainviewMVS MainviewDB2 MainviewIMS MainviewCICS

OmegamonMVS OmegamonDB2 OmegamonCICS TMON CICS

Strobe TMONDB2 DB2Admin InsightDB2

Tivoli Performance Reporter DB2 Performance Monitor Visual

Explain

IBM Performance Expert IBM Query Monitor SyncSort/DB2

SyncSort/JOIN

IBM REORG/LOAD/UNLOAD BMC UnloadPLus RC/Query

BMC Apptune RMF Monitor III MVS TSO

ISPF CICS SDF BMS

CEMT CSMT CEDF MQ-Series

QMF QBE SPUFI ISQL

JES2 JES3 HASP RSCS

SDSF OS Utilities Dialog Manager VM-SP

VM DOS VSE CMS

Software (continued)

ICCF SPM VOLLIE POWER

IDCAMS PANVALET ROSCOE RPF

Intertest Xpediter CA EasyTest SyncSort

CA SORT CA 7 CA 11 TMS

Windows XP/2000/NT/ME/98/95/3.x CA DYNAM T CA DYNAM

OS2 MS DOS LOTUS MS Excel

QUATTRO PRO MS WORD Wordperfect Multi-Mate

PFS Write Micro Focus CICS XDB SPF2

AD-MVS IMSVS86 DATASHARE IEEE-488

Databases:

DB2 IMS SQL-DS Oracle8i

NOMAD System 2000 IDMS FOCUS

VSAM XDB IMSVS86 FOXPRO

MS Access Btrieve Sybase

Applications:

Banking Transportation Performance Tuning

Capacity Planning

Oil and Gas Credit Card Government Management Reporting

Retail Manufacturing Hospital Medical

Health Insurance Mortgage Finance Savings &

Loan

Inventory Payroll General Ledger Accounts

Receivable

Billing Systems Accounts Payable Wholesale Budgetary

Accounting

Utility Y2K Remediation Statistical Analysis Aircraft

Maintenance

Client Companies:

Anthem Blue Cross Blue Shield Bank One Corp. Blue

Cross B. S. Assn.

Blue Cross Blue Shield of Tennessee Cabot Petroleum Corp.

CellTech Info. Sys. CheckFree Corp. Continental

Airlines DHL Airways, Inc. Electronic Data Systems

ENRON Corp. ENRON Oil & Gas Co. EXXON, U.S.A.

Fairchild-Weston DSI Florida Gas Transmission Foley's Dept Stores

Georgia-Pacific Corp. Grocers Supply Co. Highlands

Insurance MBNA America Mediflex Systems Corp.

Mitchell Energy Corp. Reliant Energy Shell E & P

Co.

Shell Services Intl. State Farm Insurance Sysco, Inc.

Texaco Credit Card Union Texas Petroleum United Parcel

Service

Dana Rothrock

e-mail: abj3s1@r.postjobfree.com

cell: 813-***-****

709 Whitehall St.

Plant City, FL 33563

Languages Software

SKILLS YEARS SKILLS

YEARS

Enterprise COBOL 4 IBM z/OS 10

COBOL S/390 6 IBM Parallel Sysplex 8

COBOL II 9 IBM OS/MVS/TSO/ISPF 12

COBOL 22 IBM DOS/VSE/CMS 8

Command Level COBOL (CICS) 20 IBM VM-SP/CMS 2

Macro Level COBOL (CICS) 2 CICS 27

OS COBOL 2 BMS/DMS/SDF/GTB 20

IDMS COBOL 1 CEDA/CEDF/CSMT/CEMT 22

Micro Focus COBOL 5 QMF/SPUFI/ISQL 16

SQL 16 JES2/JES3 15

SAS/SAS SQL 5 SysView 1

MainviewMVS/DB2/IMS/CICS 4 OmegamonMVS/DB2/CICS 4

InSight 1 Detector 3

BMC Aptune 8 BMC InTune / TriTune 3

BMC Unload Plus 3 Catalog Manager 4

RMF Monitor III 5 TMON MVS/DB2/CICS 2

Strobe 9 DB2 Administration Tool

2

IBM REORG/LOAD/UNLOAD 4 IBM Performance Expert 1

IBM Performance Monitor 2 IBM Query Monitor

1

IBM Visual Explain 2 Platinum Unload 1

Candle/CDB Workbench 6

IBM Mainframe Assembler 4 HASP 2

IMS DLI 5 ROSCOE 2

RPG 6 Windows 3.x/95/98/ME/NT/2000 17

REXX 7 POWER 12

DB2REXX 6 OS Utilities 19

CLIST 2 DOS Utilities 10

CMS EXEC2 1 IDCAMS 28

FOCUS 3 Dialog Manager 4

MARK IV 2 PANVALET 6

Easytrieve 2 ENDEVOR 3

Easytrieve Plus 12 Xpediter 7

FORTRAN IV 3 CA Easytest 2

Dial 260 2 Syncsort 19

Quikjob 1 CA Sort 4

CA Earl 1 CA 7 / CA 11 2

BASIC 3 TMS/EPAT/CA DYNAM T 21

Mini-COBOL 1 CA DYNAM D 4

DATABUS 3 MS DOS 10

FOXPRO 1 LOTUS 2

6502 Micro Assembler 2 FileAid / FileAid-DB2 5

SAS/SAS SQL 5 OmegamonMVS/DB2/CICS 4

MQ-Series 6 SCLM

3

Databases

SKILLS YEARS SKILLS

YEARS

DB2 15 Excel 7

IMS 5 Quattro Pro 1

SQL-DS 3 MS Word 11

NOMAD 1 Wordperfect 4

System 2000 1 Multi-Mate 3

IDMS 1 PFS Write 1

FOCUS 3 Micro Focus CICS 2

VSAM 30 XDB 2

MS Access 4 DATASHARE 3

Btrieve 1 IEEE-488 2

Applications Client Companies

SKILLS YEARS SKILLS

YEARS

Performance Tuning 16 Anthem Blue Cross Blue Shield

2

Capacity Planning 4 Bank One Corporation

1

Quality Assurance 16 Blue Cross Blue Shield Assn.

8

Health Insurance Claims 8 Blue Cross Blue Shield Tenn.

1

Oil and Gas 6 Cabot Petroleum Corp. 1

Credit Card 7 Celltech Information Systems 1

County Government 4 DHL Airways, Inc. 1

Wholesale/Retail 3 ENRON Corp. 1

Manufacturing 3 ENRON Oil & Gas Co. 3

Hospital/Medical 2 EXXON, U.S.A. 1

Insurance 10 Fairchild-Weston Data Systems 1

Mortgage/Finance 1 Foley's Department Stores 1

Savings and Loan 2 Georgia-Pacific Corp. 2

Inventory 2 Highlands Insurance 1

Payroll 2 MBNA America 1

General Ledger 4 Mediflex Systems Corp.

1

Accounts Receivable 6 Mitchell Energy Corp. 1

Billing Systems 4 Reliant Energy 1

Accounts Payable 2 Shell Services Co. 1

Transportation 3 State Farm Insurance 1

Budgetary Accounting 2 Sysco, Inc. 1

Statistical Analysis 4 Texaco Credit Card 6

Management Reporting 8 Union Texas Petroleum 1

Y2K Remediation 4 United Parcel Service 1

Blue Cross Blue Shield Association Aug 2008 - Current [pic]

Chicago, IL

Hired full time as Software Architect. Telecommute to Chicago to continue

administration and operations of Performance Engineering Department (2-man

department). Redeveloped COBOL programming standards, developed DB2 SQL

and JCL guidelines. Developed COBOL, SQL and JCL development checklists

and QA procedures. Updated and maintained standards and best practices.

Designed and implemented DB2 Multi-Row FETCH architecture in database purge

processes cutting time and CPU to a small fraction. Initiated two IBM

APARs in correction of Websphere DB2 Task Scheduling software resolving

deadlocks at high web transaction rates. Resolved Help Desk tickets from

BCBS companies. Function tested new releases of z/OS, DB2, CICS, IMS, MQ

and performance software. Performance tested new releases of BCBSA

software. Recommeded hundreds of performance improvements in all software

systems. Achieved 69% reduction in total CICS CPU consumption by

correction of claim entry and maintenance system. Achieved further 38%

CPU reduction in CICS by correction of pricing system. Achieved 66%

reduction in batch pricing system. Redesigned DB2 indexes for web claims

processing application enabling wild-card search capabilities. Implemented

disaster recovery plans for my department. Designed platform migration of

SAS network billing system.

Environment: IBM 2817 z/196, z/OS 1.12, DB2 V10, IMS, CICS TS 3.2, MQ,

SysView, Mainview, AppTune, InSight, FreezeFrame, Plan Analyzer, Subsystem

Analyzer, TMON CICS, InfraEnterprise, ServiceNOW, IBM Rational ClearQuest,

SAS

Blue Cross Blue Shield Association Jan 2008 - Jul 2008

Chicago, IL

Telecommute to Chicago BCBSA to upgrade Performance Engineering databases

and testing environment to DB2 V8 and new application software releases.

Documented COBOL code improvements in 46 programs. Authored white papers

on DB2 index design. Recommended index changes on dozens of tables.

Architected a re-design of application database structure for 35%

improvement in operational costs of application software.

Environment: IBM 2086-320, z/OS, DB2 V8, IMS, CICS, MainviewDB2/MVS,

AppTune, TriTune

Blue Cross Blue Shield of Tennessee Apr 2007 - Dec 2007 [pic]

Chattanooga, TN

Commissioned by BCBSA to support installation, testing and monitoring of

BCBSA-developed software at BCBS of Tennessee. Converted 6 Easytrieve-DLI,

6 batch and 2 IMS/DC COBOL-DL/I programs from IMS to DB2 in claims

processing systems. Converted dozens of batch job streams from IMS to DB2.

Supported and debugged web-based inter-company HIPAA document transmission

service software. Served as liaison contact to BCBSA technical support.

Environment: IBM 2094-704 z/OS, DB2 V8, IMS DB/DC, IBM LOAD / UNLOAD, IBM

Performance Expert, IBM Performance Monitor, IBM Query Monitor, IMS DB/DC,

S390 COBOL, QMF, DSNTEP2, Easytrieve-DLI/DB2, SyncSort-DB2, SyncSort-JOIN

Blue Cross Blue Shield Association Jan 2007 - Apr 2007

Chicago, IL

Contracted for performance monitoring and tuning of IBM DB2 inter-corporate

health insurance systems. Administrated Performance Engineering database

instances. Reconfigured PE database system for optimum indexing and

referential integrity and proposed adoption of these standards in

distribution software. Developed automated PE database re-load and

regression test procedures. Proposed 20 performance enhancements to

software including DB2 index redesign, buffer pool resizing, SQL code

modifications, and COBOL source code improvements.

Environment: IBM 2086-320, z/OS, DB2 V7, CICS, MainviewDB2/MVS, AppTune,

InTune,

RMF Monitor III

United Parcel Service Jul 2006 - Dec 2006 [pic]

Morristown, NJ

Contracted for performance monitoring and tuning of corporate billing

systems and general systems technical support. Scope was all corporate

mainframe systems, production, development, and stress (quality assurance

implementation). Authored 22 white papers on performance improvements to

DB2 BMC Unload Plus applications and software utilization, IBM DB2 unload

and batch SQL utilities (DSNTIAUL, SPUFI, DSNTEP2, DSNTEP4), and DB2 V8 New

Function Mode Multiple Row FETCH and INSERT enhancements. Recommended new

DB2 indexes on payment and invoice tables in international CICS

applications and SQL join techniques in java accounts receivable

applications. These methods fostered 100+ CPU hours per month improvement

in operations. Served as monitor and technical support analyst of peak

season operations and bi-annual implementation periods.

Environment: IBM 2094-705, 2084-305, z/OS, DB2 V8, CICS, Websphere,

OmegamonDB2/CICS, Detector, Strobe, BMC Catalog Manager, BMC Unload Plus,

MXG/SAS, DB2 Performance Monitor, DSNTEP2, DSNTEP4, RMF Monitor III

State Farm Insurance Feb 2005 - Feb 2006

Bloomington, IL

Contracted for z/OS DB2 performance tuning, monitoring and systems support

in nationwide mainframe networks. Used a prolific package o f system and

subsystem monitoring software to observe DB2, DDF, batch, IMS, and CICS

systems, subsystems, applications and cross-system transactions. Responded

to system alerts, performance thresholds, and application owner requests

for support by providing development advisories and help desk support

tickets. Recommended the redefinition of Tivoli PR tables to eliminate

freespace, decrease CPU consumption, reduce response times, and to sustain

database organization, resulting in a 75% reduction in CPU utilization and

runtime. Developed an intranet reporting system of DB2 timeouts and

deadlocks in MS Access. Developed a series of top-down performance reports

on web-based IMS/DB2 monthly transaction statistics using SAS and IBM

Tivoli Performance Reporter (PR). Developed 32 monthly DB2 performance

reports for corporate, regional office, CICS, and test systems for intranet

publication. Developed numerous ad-hoc performance reports in SAS/SQL/PR,

Visual Explain/PR, and MS Excel Pivot Tables and Reports (graphs).

Crosschecked and validated IBM PR, Performance Monitor (PM), MainviewDB2,

and SMF for DB2 parallelism elapsed and CPU time collection. Developed

intranet reports of DB2 Catalog Stored Procedure ASUTIME CPU time limit

parameters. System tested BMC Apptune software. System tested new

releases of DB2, Mainview, and Strobe functionality. Developed before- and

after- performance comparison reports of DB2 V8 upgrade in production

systems.

Environment: IBM z/OS, Parallel SysPlex, DB2 V7-V8, IMS, CICS, MQ-Series,

MainviewDB2/IMS/CICS/MVS, Detector, Strobe, DB2Admin, SAS, Tivoli

Performance Reporter, RC/Query, DB2 Performance Monitor, BMC Apptune,

Visual Explain, RMF Monitor III, HP Service Desk.

MBNA America July 2004 - Dec 2004 [pic]

16001 Dallas Parkway

Dallas, TX

Contracted for z/OS, DB2, and storage system performance tuning.

Recommended SQL and DB2 table definition changes for a daily job resulting

in savings of 230 runtime hours and 135 CPU hours per month. Recommended

database compression for a major system saving 275 runtime hours and 40 CPU

hours per month. Recommended database purge for a third-party software

product saving 8 CPU hours per month. Recommended the substitution of an

assembler TRT (Translate and Test) subprogram for millions of COBOL INSPECT

TALLYING calls saving 54 hours of runtime and 27 hours of CPU per month.

Recommended LSR optimization of a batch VSAM file saving 34 hours of

runtime per month. Recommended the decrease in number of TCBs and

enablement of automatic new instance creation in DB2 stored procedures

address spaces in order to resolve periods of hyperactive CPU utilization.

Instituted a WLM refresh command for DB2 stored procedures. Served as

z/OS, DB2, CICS and storage system technical support and problem resolution

analyst.

Environment: IBM 2084-316 2084-313 2064-2C6 2064-112 z/OS Parallel Sysplex

OmegamonMVS OmegamonDB2 OmegamonCICS Catalog Manager RMF Monitor III

Strobe Insight DB2 Detector CICS MQ-Series

Anthem Blue Cross Blue Shield May 21, 2003 - June 2004

Park Central III

Richmond, VA

Contracted for DB2 systems performance analysis and tuning, database purge

process analysis, design, development, testing and implementation. Reduced

DB2 database storage 20% by redefinition of DB2 tables. Reduced DB2

database storage an additional 15% in installation of purge processes.

Decreased CPU consumption of on-line systems by 65% by database

redefinition, addition of indexes and application SQL tuning.

Environment: IBM 2064 z/OS BMC Apptune Catalog Manager RMF Monitor III

TMON Strobe DB2 IMS MQ-Series CICS

Bank One Corporation Nov 5, 2001 - Mar 1, 2002

1111 Polaris Parkway

Columbus, OH

Contracted for IMS database and application performance analysis on an

OS/390 Sysplex system using Mainview and Strobe. Recommended over 60

improvements in systems and software.

Environment: IBM 9672 OS/390 Parallel SysPlex SDSF B&B Mainview Strobe DB2

IMS CICS IDCAMS

CheckFree Corporation May 8, 2001 - May 30, 2001

4411 East Jones Bridge Road

Norcross, Georgia

Contracted for performance analysis and resolution of DB2 CICS and batch

applications. Used Strobe to diagnose dozens of long-running CICS

transactions and MVS job streams. Used B&B Mainview to diagnose the OS/390

Sysplex operating system.

Environment: IBM OS/390 SDSF B&B Mainview Strobe Platinum DB2 CICS

Grocers Supply Co. Oct 2000 - Apr

2001

Houston, Tx

Contracted for VSAM to DB2 conversion of warehouse inventory system

software. Converted and tested 36 CICS COBOL DB2 menus, functions, and

screens. Modified and tested 28 batch DB2 COBOL programs and job streams.

Modified 6 SAS programs to accept DB2 unload files. Tuned performance of

problem queries and database issues using TMONDB2, SPUFI and FileAid-DB2.

Environment: IBM MVS TSO CICS COBOL II DB2 TMONDB2 SPUFI SAS FileAid-DB2

Electronic Data Systems Aug 2000 - Sept 2000

Houston, Tx

Contract support of VM CMS FOCUS and MVS ISPF COBOL applications for a

major airline. Documented 3 systems in HTML and installed on the intranet

server.

Environment: IBM VM CMS FOCUS

IBM MVS COBOL

Reliant Energy, Inc. Oct 1999 - May 2000

Houston Lighting & Power

1111 Louisiana, Houston, Tx

Contracted to develop an interface between a legacy mainframe power

outage maintenance dispatching system and Advantex Mobile Data

client/server software. Coded, tested and installed 5 CICS COBOL sub-

programs and expanded the mainframe VSAM database to hold new data

fields. Defined new files in IDCAMS. Used SAS programs and FileAid

to analyze VSAM files. Modified about a dozen CICS programs and BMS

maps to handle expanded functionality. Coded, tested, and installed

CICS / MQ-Series message queue handling. Coded, tested, and installed

2 batch resequencing programs and associated daily and weekly job

streams for reset of MQ-Series message queues. The system was

successfully installed in February and now serves metropolitan Houston

(Houston Lighting and Power). I was then assigned as production

support analyst and resolved batch and online glitches. I reviewed,

re-defined and tuned VSAM databases for storage efficiency and

performance after full production implementation.

Environment: IBM OS/390 MVS COBOL-390 Command Level CICS BMS VSAM

Xpediter-CICS SAS FileAid Lotus Notes

Georgia Pacific Paper Mill May 1998 - Oct 1999

Crossett, Ar

Member of 5-person team interfacing Work Order Requisitions,

Purchasing, Accounts Payable, Accounts Receivable, Inventory,

Manufacturing, Human Resources (Payroll), and General Ledger systems to

Dunn and Bradstreet Accounts Payable financial accounting package (DBS).

Database software used included VSAM, CICS, IMS/DLI and SQL/DS.

Programming languages used were RPG, COBOL and COBOL II.

I wrote and tested the initial extract procedures for Purchase Order

(VSAM), Vendor (DLI), and P/O Receipts (VSAM) databases as well as the CICS

transaction capture functions for these files in 14 Command Level COBOL

CICS programs. Two batch RPG programs were modified to capture generated

Purchase Orders. I wrote and tested account number conversion programs

for 8 VSAM/KSDS master files, 9 VSAM/KSDS table files, 2 VSAM/ESDS A/R

transaction files, 7 IMS/DLI database segments, and 7 SQL/DS database

tables. I replaced a source library table of department codes with a

VSAM/KSDS table in 7 batch RPG programs. I wrote and tested a COBOL II

program to generate price variation adjustment Jounal Vouchers for a

Chemical Inventory system. I wrote and tested 2 special Purchase Order

Receipt capture programs, a P/O Item Location conversion program, and a

general purpose Journal Voucher interface for the new A/P system.

Next, I wrote and tested a program to cull erroneous purchase order and

work order numbers from a weekly invoice transaction file and create a CICS

maintenance file for the data. I wrote and tested the CICS error

correction program and a batch program to update the original invoice

transaction file from the correction file. Also, I wrote and tested a

program to list vendors with more than 3 address lines.

In August, I began research, coding, and testing of 417 CMS files

impacted by the Year 2000 Problem. These files consisted of COBOL, RPG,

Assembler, DMS panels and tables, JCL, IDCAMS file definitions, and BMS map

sources. Of these, 107 were found to be non-compliant, modified, tested,

user certified, and installed by October 22.

In November, I researched 4 CICS shipping control programs and

associated files and developed a Bill of Lading batch interface to the

corporate SAP Custormer Order Entry System.

In December, I created a year-to-date Tissue Transaction History file.

Then I designed and created an SQL/DS Tissue_History database and a host of

queries to provide two years of history for mill floor inquiries. A

Parent Roll System transaction file was expanded and an RPG purge program

was modified to include 6 months of transaction history instead of one

month.

In January 1999, I wrote a CICS/VSAM Bill of Lading Maintenance program

to handle emergency changes to loading schedules in the case of server

outage. The program updated local shipping files and adjusted the SAP

transaction files for retro-active processing.

In February 1999, I analyzed 4 systems for pending rewrite - Raw

Materials Inventory, Vital Supplies Inventory, Outbound Shipping, and

Tissue Production Statistics.

In March 1999, I wrote 3 "cut-over" conversion programs for the SAP

interface and local shipping files.

I began the re-design and rewrite of the Raw Materials Inventory System

to incorporate accruals and variances from the new DBS A/P system. New

functionality of vendor-managed inventories was required.

In April 1999, I wrote 8 COBOL II programs, modified 2 COBOL II and 9

RPG II programs, and modified production JCL to parallel the month-end

accounting of the Raw Materials Inventory System. I designed and

implemented the new R/M Inventory Master file to capture A/P reconciliation

data.

In May 1999, I modified 8 CICS COBOL programs and DMS panels to

incorporate the new R/M Inventory Master file and associated transaction

data.

In June 1999, I modified 6 CICS/DMS programs to handle emergency

outages of the SAP shipping interface. The system ("IMPRINT") was

installed over the July 4 weekend.

In July 1999, I completed parallel testing and Year 2000 Certification

of the new Raw Materials Inventory System, and installed the system in the

production environment. I also wrote 2 COBOL II CICS programs to sort and

display Bill of Lading records in the IMPRINT system.

In August 1999, I wrote 2 CICS COBOL II programs to sort and display

Delivery Orders and to inter-act with existing Order Inquiry and Customer

Inquiry functions in the IMPRINT system. I also wrote and installed a Low

Inventory Report in the new Raw Materials Inventory System.

September thru October 1999 I reviewed 9 remaining systems for Y2K

Certification. Dozens of programs were remediated, tested and installed.

I assembled certification packages and delivered them to department

managers for approval.

Environment: IBM ES/9000-9221 VM/ESA DOS/VSE CMS IMS/DLI SQL/DS

CICS DMS BMS RPG II COBOL COBOL II

Command-Level COBOL II QMF Assembler

TEXACO Credit Card Marketing Apr 1990 - Jan 1996

490 Fournace Place

Houston, Tx

Contracted to convert batch systems from UNISYS to IBM MVS DB2 for credit

card issuance, collection agency and credit bureau reporting, charge-off

accounting, remote card reader account controls, DB2 table conversions, and

report dispatching systems. Wrote programs for collection agency

statistics, CICS operator work queue statistics, credit bureau reports,

collection account and charge-off statistics. Standardized, quality

reviewed, and installed most of the developed system programs. Served as

24/7 technical support for 4 years after system implementation. Converted

several critical batch DB2 jobs to IMS/BMP using checkpoint/restart and

GSAM files. Programs were written using COBOL II, DB2, and IMS/BMP.

System testing was done using Xpediter/TSO/CICS, QMF, and DB2I. Designed

and developed CASE-type tools for system testing using REXX, DB2REXX, and

ISPF Dialog Manager. Developed zipcode sorting and batching algorhythm for

statement postal savings of $180,000 per year. Developed conversion

programs to retro-fit third-party Fleet credit card system into new in-

house credit card system. Modified existing credit card issuance and

embossing programs to handle special fleet conditions. Fleet system

programming and testing was done with a PC workstation using OS/2, AD-MVS,

SPF2, XDB, and Micro-Focus COBOL II and Micro-Focus CICS. Converted credit

card embossing and data formatting program from assembler to COBOL II.

Environment: IBM ES/9000-900 MVS/ESA CICS DB2 SQL IMS BMP TSO ISPF

COBOL II REXX DB2REXX ISPF Dialog Manager

QMF

Xpediter/TSO/CICS CDB/DB2-Workbench

Strobe

Easytrieve-Plus/DB2 Candle/DB2

IBM PS/2 77 486 OS/2 AD/MVS SPF2 IMSVS86 XDB

Micro Focus COBOL II Micro Focus CICS WIN-

OS/2 DOS

SYSCO Corporation Jul 1989 - Apr 1990

1390 Enclave Parkway

Houston, Tx

Contracted to develop a Procurement (Purchasing) system in IBM MVS

environment. Coded, tested, and installed on-line Purchase Order and Work

Order processes using CICS, DB2, and SQL. Wrote 6 VSAM to DB2 conversion

programs, 2 buyers reports, and 6 DB2 table unload and merge jobs. Other

duties included writing enhancements for a DOS VSAM CICS Inventory

management system affecting 3 inventory analysis reports, 22 conversion and

database "fine tuning" programs, and modifications to 10 CICS transactions

and 15 batch programs. Developed an inventory item-level sales projection

algorythm and associated Suggested Purchase Order report which resulted in

increased revenue of $1 million dollars per warehouse per month (24

warehouses).

Environment: IBM 3090-150 OS/MVS-XA TSO CICS DB2 SQL

Command Level COBOL

IBM 4381 / 4361 DOS/VS2 CMS CICS Command Level

COBOL

Education

CBT - SmartForce

OOP, OOD, GUI, HTML, Java, JavaBeans, Swingset,

Oracle8i DBA, PL/SQL, SQL*Plus

Computer and Accounting Book Clubs

Basic Accounting, Systems Analysis and Design, Yourdon Structured

Programming, FORTRAN IV, RPG III, Motorola 6800 Microcomputer System

Architecture and Principles of Operation, MOS Technology 6502 Microcomputer

System Assembler, Architecture and Principles of Operation

IBM and Honeywell Programmed Instruction

IBM 360 Assembler, IBM 360 Principles of Operation, Honeywell Mini-COBOL,

Honeywell Series 50 DOS

ASI and DELTAK Video Courses

IBM VSAM, DOS JCL, CICS, Command-Level COBOL, IMS DB/DC, IDMS ADSO, IDMS

DC/UCF

Lakewood Senior High School

Independent Study Program

St. Petersburg, Florida

Analytic Geometry, Trigonometry, Calculus, Laboratory Chemistry II,

Laboratory Physics, Scientific Philosophy, general curriculum.

South Side Junior High School

St. Petersburg Senior High School

Advanced Studies Program

St. Petersburg, Florida

Spanish Language - 2 years, Exporatory Language (Latin, German, French),

Algebra I, II, III, Geometry, Laboratory Chemistry I, Basic Electricity,

Biology, Typing I, general curriculum.

Commodore Business Machines, Inc. - Atlanta

Dealer Service Training

Computer Electronics, Service, and Repair

Contact this candidate