Lead Mainframe Performance and Capacity Management

The Professional Resume of

Dana Rothrock

IBM Mainframe Performance and Capacity Management

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.

49 years experience. 25 years consulting. My skills

Computer Systems:

IBM 8561-711 IBM 8561-715

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 WLM

SysView AppTune Detector Plan Analyzer

MainviewMVS MainviewDB2 MainviewIMS MainviewCICS

OmegamonMVS OmegamonDB2 OmegamonCICS TMON CICS

Strobe TMONDB2 DB2Admin InsightDB2

Tivoli Decision Support IZPCA Visual Explain DB2 Performance Monitor

IBM Performance Expert IBM Query Monitor SyncSort/DB2 SyncSort/JOIN

IBM REORG/LOAD/UNLOAD BMC UnloadPLus RC/Query

IBM Application Performance Analyzer IntelliMagic Vision

BMC Apptune RMF Monitor III MVS TSO

ISPF CICS SDF BMS

CEMT CSMT CEDF MQ-Series

Catalog Manager File-Aid File Master Abend-Aid

QMF QBE SPUFI ISQL

JES2 JES3 HASP RSCS

SDSF OS Utilities Dialog Manager VM-SP

VM DOS VSE CMS

Software (continued)

NDM FTP ZEKE Control-M

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:

American Express Anthem Blue Cross Blue Shield Bank One Corp.

Blue Cross Blue Shield Association Blue Cross Blue Shield of Tenn Cabot Petroleum Corp.

CellTech Information Systems CheckFree Corp. Continental Airlines

DHL Airways, Inc. Electronic Data Systems ENRON Corp.

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

Fairchild-Weston Data Systems Florida Gas Transmission Foley's Department Stores Georgia-Pacific Corp. Grocers Supply Co.

Health Care Services Corporation Highlands Insurance

IBM Global Technology Services kyndryl MBNA America

Mediflex Systems Corp. Mitchell Energy Corp. Reliant Energy Shell Exploration & Production Shell Services International State Farm Insurance Sysco, Inc. Texaco Credit Card Union Texas Petroleum United Parcel Service

Dana Rothrock

e-mail: ************@**.***

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

709 Whitehall St.

Plant City, FL 33563

Languages Software

SKILLS YEARS SKILLS YEARS

Enterprise COBOL 4 IBM z/OS / MVS 35

COBOL S/390 6 IBM Parallel Sysplex 27

COBOL II 9 IBM TSO/ISPF 35

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 23

Q-Series 19 IBM TDS / IzDS / IxPCA 9

SQL 35 JES2/JES3 35

SAS / SAS SQL / MXG / MICS 17 SysView 1

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

InSight 1 Detector 4

BMC Aptune 17 BMC InTune / TriTune 13

BMC Unload Plus 12 BMC Catalog Manager 13

RMF Monitor III 24 TMON MVS/DB2/CICS 2

Strobe 27 DB2 Administration Tool 2

IBM REORG/LOAD/UNLOAD 15 IBM Performance Expert 5

IBM Performance Monitor 5 IBM Query Monitor 1

IBM Visual Explain 2 Platinum Unload 1

IBM APA 2 BMC Candle/CDB Workbench 15

IBM Mainframe Assembler 4 HASP 2

IMS DLI 5 ROSCOE 2

RPG 6 Windows 38

REXX 7 POWER 12

DB2REXX 6 OS Utilities 35

CLIST 2 DOS Utilities 10

CMS EXEC2 1 IDCAMS 45

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

Databases

SKILLS YEARS SKILLS YEARS

DB2 30 Excel 38

IMS 14 Quattro Pro 1

SQL-DS 3 MS Word 38

NOMAD 1 Wordperfect 4

System 2000 1 Multi-Mate 3

IDMS 1 PFS Write 1

FOCUS 3 Micro Focus CICS 2

VSAM 40 XDB 2

MS Access 4 DATASHARE 3

Btrieve 1 IEEE-488 2

Applications Client Companies

SKILLS YEARS CLIENTS YEARS

Credit Card 16 American Express 9

Performance Tuning 49 Anthem Blue Cross Blue Shield 2

Capacity Planning 13 Bank One Corporation 1

Quality Assurance 16 Blue Cross Blue Shield Assn. 8

Health Insurance 12 Blue Cross Blue Shield Tenn. 1

Oil and Gas 6 Cabot Petroleum Corp. 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

Health Care Service Corporation 1

IBM Global Technology Services 7

Inventory 2 Highlands Insurance 1

kyndryl 2

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 24 Union Texas Petroleum 1

Data Sharing 19 United Parcel Service 1

Experience

Performance and Capacity Management

Health Care Service Corporation May 2024 – October 2024

kyndryl

Produced monthly job performance reports for 3 departments. Rotated primary and secondary on-call support. Produced many Performance and Capacity reports in response to service requests. Modified priorities of Workload Manager service classes following analysis of production environments and operations. Participated in annual Disaster Recovery exercise. Developed dataset autopsy reports using MXG. Conducted mainframe system, subsystem and batch job monitoring and analysis. Analyzed z/OS LPAR weights in WLM using IntelliMagic. Modified DB2 DDF service classes for enhanced transaction performance.

Environment: IBM 3931-A01-701, IBM 3906-M01,IBM 3906-M02-721, IBM 2964-701, IBM 2964-N30, IBM 3931-A01-718, IBM 3931-A01-710, IBM 3931-A01-717, DB2 subsystems in data sharing mode: Workload Manager, CICS; MQ; Omegamon, MXG, Detector, Database Analyzer, Plan Analyzer, Subsystem Analyzer, DB2 Administration Tool, DB2 EXPLAIN, SPUFI, DB2 ZPARMS, Application Perrformance Analyzer, RMF Monitor III, File Master, Control-M, IntelliMagic

Performance and Capacity Management

American Express May 2015 – May 2024

IBM Global Technology Services

kyndryl

Served as DB2 DBA in PCM department. Duties included responding to ServiceNow incident tickets, emergency on-call, application software performance issues, sizing of DB2 buffer pools and coupling facility structures, DB2 utility issues, DB2 index recommendations, SQL coding improvements, batch job performance, sort efficiencies, and management reporting. Analyzed and recommended improvements to DB2 stored procedures. Converted MICS/SAS to TDS. Added dozens of DB2 automated alerts to ServiceNow software. Upgraded BMC Apptune configurations. Function testing and validation of new releases of z/OS, DB2, IMS, CICS, MQ and disaster recovery systems. Mentored new on-boarded personnel to department.

Environment: 12 IBM z/OS and z/VM z15-T01 Mainframes 8561-711,714,715 57 z/OS LPARs

12 z/VM LPARs 110,570 z/OS MIPS / 13,283 MSUs 99 IFLs 71 zIIPs 44 ICFs; 65 DB2 V15 subsystems in data sharing mode; IMS; CICS; MQ; Omegamon, IZPCA, Apptune, Catalog Manager, Buffer Pool Analyzer, DB2 EXPLAIN, SPUFI, DB2 ZPARMS, Strobe, RMF Monitor III, Abend-Aid

Performance and Capacity Management

Blue Cross Blue Shield Association Aug 2008 – Oct 2014

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. Recommended 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

Performance Engineer, DBA

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

Installer, Technical Support

Blue Cross Blue Shield of Tennessee Apr 2007 – Dec 2007

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

Performance Engineer, DBA

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

Performance Engineer

United Parcel Service Jul 2006 – Dec 2006

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

Performance Engineer

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.

Performance Engineer

MBNA America July 2004 – Dec 2004

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

Performance Engineer

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

Performance Engineer

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

Performance Engineer

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

Software Engineer

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

Software Engineer

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

Software Engineer

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

Software Engineer

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

Software Engineer

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

Software Engineer

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

IBM z/OS ABCs of System Programming

SMP/E, DFSMS, SMF, RMF, WLM, Parallel Sysplex

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