Manager Project

Hugh S. Mitchell

Home Address: **** ******** ******,

Cell Phone: 908-***-****

PLAINFIELD, N.J.07060.

Home phone: 908-***-****

Email: accqdk@r.postjobfree.com

SUMMARY

A programmer/analyst with 30+ years of Application Development & Testing

experience on IBM Z/os and MVS mainframes using COBOL with DB2, IMS DB/DC,

CICS & VSAM. Achieved an expert level of understanding of Tool Development

using REXX, TSO CLISTs & ISPF DIALOG MANAGER.

Provided Technical Support to the Application and Testing teams.

HARDWARE

IBM Mainframes, and Windows PCs.

TECHNOLOGY

DB2 - SQL, SPUFI, Fileaid/DB2;

VSAM - IDCAMS, FILE-AID;

COBOL - COBOL, COBOL II, COBOL 370 (MVS), Easytrieve

Z/os, MVS - JCL, MVS utilities, MQ Series;

TSO - REXX, RXSQL, ISPF DIALOG MANAGER & EDIT MACROS, CLISTS;

CICS

IMS DB/DC - MFS, BTS, IMS utilities;

COMPUWARE Tools: Hiperstation, FileAid/RDX, DataSolutions (Encryption and

Aging)

CA TOOLS :- FileMaster, FileMaster DB2, Endevor

SYNCSORT:- Syncsort, Syncsort Report Writer

PC - WINDOWS XP, Windows 7, Office 2007, - Word, Access, Excel,

Powerpoint

SUMMARY OF EXPERIENCE

Many years of application development using IMS DB/DC, DB2, COBOL, VSAM,

CICS. Timely & accurate, designing & coding of COBOL programs.

System/User acceptance/QA testing, Y2K testing, Regression testing.

. Creating time saving tools and utilities using REXX execs and ISPF Dialog

manager facilities.

Technical support and trouble-shooter for application and testing teams.

Heavy usage of MVS JCL and the setting up and running of large system

batches.

Y2K compliance - searching for, and analyzing non-compliant dates in

programs and databases etc.

. Rapid development of ad-hoc (one off) processes for data correction, file

reformats or complex reports using available tools or creating new tools

to resolve the problem.

. Experience in the following industries: Health and PBM,

Telecommunications, Banking, Insurance, Manufacturing, Information

services.

*** The TSO TIMES carried an article I authored in their Spring 1994

issue, detailing two of my ISPF

edit macros: CBLTRACE & DELTRACE (published by Chicago Soft,

Hanover, New Hampshire).

DETAILED EXPERIENCE

System Architect at Medco/Express scripts at Franklin lakes NJ. (March

2000 - May 2013)

Tasked with developing, documenting, implementing, and supporting

proprietary automated testing tool suites for the Central QA, business

area, whose primary function was monthly production release verification.

Automated the manually, time, and resource intensive process of QA and

regression testing and claims processing in support of regularly scheduled

code releases. The tools were dedicated REXX, COBOL, Easytrieve, utilities

that encompassed the front-end Hiperstation processing of Mainframe CICS

test scripts, direct communication with other mainframe server applications

(batch and online), as well as the associated back-end baseline/testline

batch reporting functionality. In addition, these Mainframe utilities were

written with the ability to interact with feeds from server and distributed

based applications that provided users with a more modern, GUI interface.

. Developed automated testing processes for applications across multiple

platforms

. Increased the success and efficiency of software implementation by

minimizing the effort required to verify the accuracy of software

changes on a broad scale.

. Built and supported a number Adhoc production processes which used

Data on Excel spreadsheets as source to provide update through

Production CICS to modify benefit accumulators. This processing allows

for much faster data entry than a user entering by hand (using

Hiperstation scripts).

. Designed and built a system to update 50+ client profile screens from

a data file FTP'd from a server based system. The Hiperstation script

updated the screens based on the field positions defined in a cross

reference VSAM file. This allowed for screen changes and the addition

of more screens by updating the VSAM file without changing the

Hiperstation script. The system was capable of updating 20,000-30,000

screens per hour by running concurrent jobs to perform the updating -

the system is totally automatic and required no operator intervention.

. Designed and built an application to submit "canned" RDX DB2 extracts

which move data from 250+ related DB2 tables. Based on a request file

the JCL is generated to insure all requests have unique file names and

return emails of the results back to the requestor. This allows for

movement of millions of rows of data between 17 different

environments. It also tracks the data to insure that one requestors

data does not overlay the data from another requestor without

permission.

. Designed and built a unique set of flexible and system-independent

REXX-based tools that could be used to interpret standard flat-file

input data and execute the appropriate Hiperstation/CICS commands,

allowing both fellow developers and non-technical business users

access to producing and updating scripted test scenarios

. Fulfilled a variety of roles from working independently, to technical

lead, to project manager with simultaneous status reporting

responsibility for numerous consultants and other full-time dedicated

resources

. Created dozens of on-demand utilities within extremely compressed

timelines to alleviate manual work on pressing and unforeseen business

needs that did not allow for the usual full development lifecycle

. Demoed project concepts and represented project progress to upper

management, including executive committees, on multiple occasions

. Met with business clients to determine project scope and define

requirements

. Created technical specifications documenting application components

. Performed routine maintenance, trouble-shooting, and enhancements in

support of both newly developed systems and legacy applications

related to general QA support

. Rapidly devised and implemented solutions for challenging COBOL, CICS,

and JCL production problems

Y2K Conversion and testing project. (JUNE 1998 - December 1999)

An IBM managed project at Memorial Sloan Kettering Hospital, New York.

. Provided Technical Support to the team of testers, testing Cobol, DB2,

CICS systems.

. Designed/created tools for managing multiple DB2 test environments (5 for

each system being tested). Consisting of REXX execs to manage the DB2

table unload/reload & the DB2 table check/repair utilities, for testers

with a minimum DB2 knowledge (i.e. unload/reload only the tables changed

by testing etc.).

. Created a REXX/ISPF facility to AGE the dates in Hiperstation Scripts,

which can then be replayed for the future date.

. Developed an ISPF/REXX QA tool to collect all the output files created

from each test for a specific program into a logical set. This set can

then be checked for completeness for each test date (all the files for

each test exist and that all the compares were successful). Compares for

the individual files may also be submitted from here.

. Enhanced tools created on previous project (see below) to adapt them to

the new project.

A Large Y2K Conversion project. (JULY 1997 - MAY 1998)

An IBM managed project at Lucent Technologies, Newark, New Jersey.

Designed a process to Age converted dates within the Y2K windowing code to

simulate processing across the 1999/2000 boundary. Then developed and

implemented the code for the process.

Provided Technical Support to the team of 30+ testers & managers on a large

(6000+ modules,

1200+ converted) IMS DB/DC, DB2, COBOL system.

Developed REXX/ISPF system to reintegrate converted programs into the test

system and compile, link and DB2 bind all required programs.

Developed and wrote a process to Age converted dates within the Y2K

windowing code to simulate processing across the 1999/2000 boundary.

Created tools to help speed up the testing effort.

Involved in developing Code-Around techniques for IMS database calls to

databases with dates embedded in the keys.

Information Gathering Project (APRIL 1997 - JULY 1997)

An IBM managed project at Paine Webber, Weehawken, New Jersey.

I served as part of a small team gathering information on all of the

clients production programs, jobs etc., which was to be stored in IBM's

"Redevelopment Assistant" (RA). My main role was to run the

"EDGE Portfolio Analyzer" against all of the clients load libraries and

extract Load module/Csect information (2800+ load libraries found).

I built tools to:

A) Generate the JCL to run EDGE and track all the output files.

B) Convert the output Csect information file into formatted files to be

loaded into the relevant RA tables.

C) To update the RA tables using REXX execs with IBM's RXSQL product to

perform the SQL functions.

I also provided general technical assistance where required.

Application development & Date research for Y2K (APRIL '96 - APRIL '97)

CHUBB Insurance Company, Warren New Jersey.

Set up the split of a large IMS database into 5 separate databases and

changed all the application programs which access the database, to select

the correct new database. The coding used IMS "AIBTDLI" calls to reference

the correct database. Also performed Year 2000 compliance analysis of all

the copy members and programs for the group I was working in (100+ copy

members & 800+ programs). I wrote a number of REXX EXECS & ISPF Edit macros

to help accomplish the search. Changed 350+ programs to be Year 2000

compliant and interface with other systems which were upgraded separately.

Application development. (OCTOBER 1994 - APRIL 1996)

NYNEX - A Telephone Company, 6th Avenue, New York.

Developer writing COBOL II & DB2 programs for an integrated asset and

financial tracking and reconciliation system. Which uses table driven

modules to perform all file reformatting and edit processing.

Also developed a number of database reconciliation programs for comparing

the totals from tracking tables with totals from the actual data.

Set up DB2 tables to control the processing flow through the system.

Application development & system support (SEPTEMBER '93 - OCTOBER '94)

AT&T - Telecommunication Company - New Brunswick, New Jersey

Developer writing COBOL II,IMS DB/DC and DB2 programs for a financial

system.

Producing time saving tools using REXX and ISPF dialog manager.

Helped to establish and run the sub-system test environment.

Designed/wrote REXX/ISPF/COBOL2 system to update DB2 tables.

Application development and system support (MAY 1990 - AUGUST 1993)

AT&T - Telecommunication Company - Piscataway, New Jersey

Designed and wrote an on-line system to access the VSAM datastore using

CLISTS, ISPF DIALOG MANAGER, COBOL & VSAM.

Helped with the design of the VSAM files and data organization.

Wrote programs (COBOL II) and provided adhoc reports for users (usually

using SYNCSORT and SYNCSORT report writer).

Ran production and provided system support for users & fellow team members.

Setup the transfer of data from MVS to UNIX servers and DOS PCs.

User Acceptance Testing. (FEBRUARY 1988 - MAY 1990)

AT&T - Telecommunication Company - Parsippany & Somerset, New Jersey.

Conceived, designed and wrote productivity/testing tool called AUTOBATCH

using CLISTS & ISPF DIALOG MANAGER. This system permits a user to specify a

series of jobs to execute. The user has the ability to stop execution at

any point and then continue. AUTOBATCH automatically analyzes unexpected

conditions to aid the user. All activities are logged for documentation and

subsequent review.

Trouble-shooter.

. Ran and debugged test batches simulating production environment.

. Setup the migration of testing environment from one data center to

another:

- Adapted JCL, CLISTS, environment tables to work in new data center.

- Set up procedures to initialize a "processing entity" (140 IMS

databases, 20 VSAM files, 1000 GDG bases, 200 flat files).

. Developed 20+ edit macros to speed up repetitive editing tasks.

. The above tools increased productivity by 25% thus enabling a team of 10

people to do the work of 13.

External Analysis Reporting System. (OCTOBER 1986 - DECEMBER 1987)

CHEMICAL BANK - New York City, New York.

. Made major enhancements to existing production IMS reporting system to

increase efficiency and maintainability.

. Created control/logging facility to provide:

1. One control report for the whole system (error messages, control

totals/messages),

2. Prevent programs being run out of order,

3. Log start/finish times,

4. Report abends and restarts.

. Revised the production JCL, restart jobs, run books and created a

reference manual of the details as documentation.

Application Development (JULY 1985 - SEPTEMBER 1986)

AT&T - Telecommunications Company. East Brunswick, New Jersey.

. Developed IMS on-line & batch programs for the payments system.

. Sub-system tested other IMS DB/BC programs.

. Served as technical support to the application programmers, generated

. IMS PSBs, DBDs and ACBs, set up Database Create/Unload/Reload JCL, and

created generalized Database print program.

. Headed a small team developing a testing environment using CLISTS, ISPF

DIALOG MANAGER facilities and DATAVANTAGE to: Create IMS databases; List

contents of IMS databases; Unload and reload IMS databases; Run above

jobs in batch or as BMPs.

For a number of companies. (SEPTEMBER 1978 - JUNE 1985)

. Developed IMS DB/DC system to print instructions for manufacturing and

packaging of drugs.

. Developed and tested stock tracking/control software.

. Developed CICS/IMS programs to maintain information on customers &

accounts.

I will gladly provide references upon request.

Contact this candidate