COBOL DB2 CICS VSAM

Stephen Jacob

Carrollton, Texas ***** ● 469-***-**** ● ***************@*****.***

Mainframe Programmer Analyst OR Associate DBA

SUMMARY OF QUALIFICATIONS:

• Broad experience in designing, creating, and maintaining DB2 tables as well as analyzing, extracting information and producing reports from databases.

• Focused and perceptive in performing independently or as a team member in defining solutions, prioritizing actions plans and developing programs from inception to completion.

• I have designed and developed CICS screens with BMS MAP for Order Entry System, Inventory System, and Shipment Verification System for Armstrong Wood Products, Inc.

Professional Experience

Data Management Support

January 2010 - March 2015

GRAVITYTECH

Cherthala, Kerala India

Identify problems uncovered by testing or customer feedback, and correct problems or refer problems to appropriate personnel for correction.

Developed databases that support web applications and Extracted, manipulated, and analyzed data from Oracle Database to generate different reports.

Perform web site tests according to planned schedules, or after any web site or product revisions.

Mainframe Programmer Analyst

July 1999 - November 2003

ARMSTRONG WORLD IND.

Addison, TX

Analyze, code, test, implement and maintained wide variety of projects for Order Entry System, Inventory System, and Shipment Verification Systems on IBM Mainframe.

Successfully completed numerous COBOL CICS programs to develop CICS screens for user's to input, select, update, and delete records from VSAM datasets.

Supported users in their daily interactions with DB2 Database and generated numerous reports from DB2 Database and converted into Excel Spreadsheets for easy to use.

Analyze, and Audit existing processes, computer printouts, and performance indicators to locate problems to correct errors or make enhancements to improve efficiency.

Continue…

Database Programmer

August 1996 - July 1999

RAPP COLLINS WORLDWIDE

Irving, TX.

Analyze, code, test, implement and maintained several SQL embedded COBOL programs that dealt with Hilton Honor database, The Loyalty Group database, and Mead Johnson database.

Wrote several COBOL II programs utilizing VSAM file processing involving dynamic, random, and sequential access methods to read, write, delete and rewrite records.

Assisted DBA with database commands such as ACQUIRE DBSPACE, CREATE TABLES AND INDEXES, DROP TABLE, ALTER TABLE, AND DATA LOAD & UNLOAD, etc..

Read manuals, periodicals, and technical reports to learn how to develop programs that meet staff and user requirements.

Programmer Analyst

September 1992 - August 1996

LEE MARKETING SERVICES

Dallas, Tx

Worked with a team that designed and developed the first ticket less airline bookings system utilizing COBOL II for South West Airline.

I was part of a team responsible for converting all the Mainframe COBOL programs and VSAM datasets to be able to run in HP UNIX Server.

Created several UNIX Shell Scripts to schedule and run jobs in HP-UX UNIX Server that used to run with JCL on Mainframe.

Analyze user needs to determine technical requirements.

Tools & Technology

COBOL, CICS, DB2, VSAM, Micro Focus COBOL, Z/OS, OS/390, MVS JCL, TSO, ISPF, SYNCSORT, File Aid, XPEDITER, QMF, SPUFI, IDCAMS, UNIX Shell Scripting, Oracle, PL/SQL, Red Hat Linux, Microsoft Office.

Education & Training

Associate of Science - Business Computer Programming

May 1992

DALLAS COUNTY COMMUNITY COLLEGE

Dallas, Tx

Diploma - Oracle and UNIX

October 2004

SOUTHERN METHODIST UNIVERSITY

Dallas, TX

DB2 training by IBM Education and Training

November 1996

Contact this candidate