SUMMARY:

20 years of hands on experience working with programming concepts in a mainframe environment including with DB2 database, COBOL and CICS with application testing phases and methods.
7 years of hands on experience working on payroll systems with 3 years of experience working on financial systems with both batch and on-line components operating in a mainframe environment.
Well-versed with the maintenance and system upgrade of UC Berkeley online payroll system.
Successfully installed new Payroll System from University of California Office of the President, installing CICS programs for Inquiry/Update/Add also includes UCARSM (security application)
Proficient in installing batch programs; responsible for any user issues both online and batch concerns.
Well-versed in updating information using BMC to extract information from the DB2 logmaster using plan and database with from and to dates for before and after images, inserts and deletes in the system.
Successfully assisted/supported in the building of 30 test environments using CICS, MQ, DB2, Datacom, Tpns, and Strobe in support of development and testing of applications, includes maintenance to COBOL programs using TCIP/SOCKETS to retrieve stock prices.

TECHNICAL SKILLS:

Software (years of use):

EDUCATION:

EXPERIENCE:

Confidential,Berkeley, CA Nov 2004 - Aug 2010
COBOL Programmer

Code one program from programs using the same edits.
Design, code, new programs for online and batch for Class Room Scheduling.
Includes testing, QA testing and monitor in production.
Design and code Easytrieve reports based on User’s requirements; easytrieve programs used db2.
Developed IBM DB2 Stored SQL Procedure to retrieve data from class room scheduling database for web application room request availability of room and building
Create PowerPoint presentation on IBM Screen Definition Facility functionality.
Environment: IBM Mainframe. Z/OS, COBOL, DB2 TSO (ISPF), JCL, Abend- aid, Cics, Easytrieve, Xpediter, BMC, FTP SYSPLEX, BMC, IBM DATA STUDIO, Alcarmist, IDMS

Confidential, Aug 2002 – Nov 2004
COBOL Consultant/Design reports from DB2 LOGMASTER

Used BMC to extract information from the DB2 logmaster using Plan and database with from and to dates for before and after Images, inserts and deletes.
Developed report programs.
Used Cobol to produce report by table and report by unit of work; purpose was to provide a quicker review of database changes.
Created PowerPoint presentation on DB2 Log master functions and how to use the job setup for the extract and reporting of the table changes.
Maintain QA databases, LOADS, UNLOADS, RUNSTATS, RE-BINDS and Database changes.

Confidential, Aug 2002 – Nov 2004
Quality Analyst

Wrote Rexx Exec’s with panels for Migration from development to QA libraries for developers.
Design and code program to generate A thru P type claims transactions for testing.
Environment: IBM Mainframe, MVS, cobol, DB2, BMC, REXX, Xpediter, Code Coverage, Jcl, FTP, Comparex, Sysplex, IBM DATA STUDIO, IBM SCREEN DEFINITION FACILITY, Abend Aid, TSO(ISPF), Cics, Abend-aid.

Confidential, Apr 2002 – Jul 2002
COBOL Programmer

Design and code a program to select data from item database and send data via MQ to the UNIX server to publish account information; defined all MQ Series definitions for the application; if UNIX was not responding the program would put the data into a db2 table for later processing online; this program was called by15 batch application programs.
Program was written in Cobol and used DB2, DATACOM and MQ.
Developed a CICS program to run every 15 minutes to read the DB2 table and push the publish account information thru MQ to the UNIX server.
Environment: IBM Mainframe, MVS, Cobol, DB2, Datacom, MQ Series, Cics, Changeman, NDM, JCL, OMEGAMON, TSO (ISPF), Cics. IBM SCREEN Definition Facility, BMC, Xpediter, Abend-Aid

Confidential, Dec 1996 – Sep 2001
Mainframe Developer/Tester

Assist in the build of 30 test environments using CICS, MQ, DB2, Datacom, Tpns, and Strobe in support of development and testing of applications, includes Maintenance to COBOL programs using TCIP/SOCKETS to Retrieve stock prices.
Write MQ program to capture screens from tpns scripts to simulating trades being send from SIAC thru MQ’s to be posted to customer accounts.

Confidential, Dec 1996 – Sep 2001
COBOL Programmer/Tester

Write cics programs to simulate middleware transactions coming from the WEB, to process on cics and post the trades to customers account.
Setup mix jobs for performance reports on cics.
Created omegamon Reports on cics transaction usage.
Used Strobe for online transactions looking for bottlenecks

Balances, Positions & Assets System

Modified 34 maps and 34 online programs, popup windows with new fields
With new fields for Release 5.0 calculate new customer balances.
Trades posted to transaction table when customer inquired on their Position balances, Trade Balances, Transaction balances, summary balances. The new release objective was to give the customer instant balances after a trade instead of waiting for nightly posting.
Design, code, and test online transactions for trade adjustments to customer account by brokers.
Assign to get TPNS up and running so developers could use this for their regression testing.
Tpns used for online, batch check out before and after migration to production using Test accounts setup in production to insure changes were correct.
Environment: IBM Mainframe, MVS, Cobol, DB2, Datacom, MQ Series, Cics, Changeman, NDM, JCL, Omegamon, Strobe, Tpns, Assembler, TSO(ISPF), Smartest, Abemd-Aid, GTB Screen Definition Facility, BMC, Xpediter, Sysplex.

Confidential,CA May 1992 - Sep 1996
COBOL Programmer/Maintain Payroll System

Maintain UC Berkeley online payroll system.
Install new Payroll System from University of California Office of the President.
Install of CICS programs for Inquiry/Update/Add.
Install batch programs.
Apply local changes to new programs where necessary.

Confidential,CA May 1992 - Sep 1996
COBOL Programmer/Maintain Payroll System

Install application security UCARSM for the online side of payroll.
Load db2 table supplied by office of the president used by payroll system.
Setup application security (UCARSM) and test new payroll online and batch.
Responsible for any user issues both online and batch..
Apply Releases to payroll from office of the president incorporating any local changes
Test changes.
Environment: IBM Mainframe. Z/OS, COBOL, DB2 TSO (ISPF), JCL, Abend- aid, Cics, Xpediter DB2 fileaid.