max contreras
Email: *********@********.***
Address: ** ***** **** ****
City: sausalito
State: CA
Zip: 94965
Country: USA
Phone: 415-***-****
Skill Level: Experienced
Salary Range: $100,000
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
MAX G. CONTRERAS
84 Cloud View Road
Sausalito, Ca. 94965
*******@*********.***
HARDWARE: IBM MAINFRAME Z10, 3090, 30XX, 370, AMDAHL 5890, CDC, HP 2100.
SOFTWARE: COBOL, COBOL II, ENTERPRISE COBOL, DB2, CICS, IMS DB/DC, VSAM,
FORTRAN, ASSEMBLER, MVS/ESA/XA, VM, Z/OS, TSO/ISPF, CMS/ISDP,
JCL, JES3, VSE/ESA, CICS/ICCF.
SOFTWARE
UTILITIES: REMEDY, ENDEVOR, MVS/DB2/IMS UTILITIES, FILEAID for MVS/DB2/IMS,
CA-1, CA-7, CA-10, CA-11, DBRC, DBCTL, NDM, FTP, QA PROCEDURES,
CHANGEMAN, LIBRARIAN, PANVALET, XPEDITER, QMF, SPUFI, DLT0,
OMEGAMON, IMS CHECKPOINT RESTART, IMS FASTPATH, MFS, BMS,
BTS II, ADF, CSP, CAPEX, SYNCSORT, LINKAGE EDITOR, BMC DBTOOLS,
VSAM-ASSIST, DATAXPERT, DATAVANTAGE, DATABASIC, TOTAL DB,
FOCUS DB, DATA KNOWLEDGE, MQ SERIES, RACF, TRI-TUNE, TWS,
IBM FILEMANAGER for IMS/DB2/ZOS, FAULTANALYZER, DEBUGGER,
SAR/EXPRESS, COMPAREX, SUPERC, SEARCH, JCLPREP, QUICKREF,
CICS TSQ/TDQ, DB2 EXPLAIN, DB2 APPTUNE, TRANSFER FILE, PDSMAN,
CONNECT DIRECT, DYL280, VPS, RJE, MS OFFICE, VISIO, ZEKE.
EDUCATION: B.S. COMPUTER SCIENCE, CALIFORNIA STATE UNIVERSITY, CHICO
TRAINING: DB2 CONCEPTS & FACILITIES, DB2 APPLICATIONS PROGRAMMING,
DB2 QMF, DB2/IMS DATA BASE DESIGN, DB2/IMS DEBUGGING & DUMP
READING, IMS FASTPATH, CICS CONCEPTS & FACILITIES, CICS CMD
LEVEL PROGRAMMING, TANDEM COMPUTER CONCEPTS & FACILITIES,
RELATIONAL DATA BASE DESIGN, STRUCTURED DEVELOPMENT
METHODOLOGY, PROJECT PLANNING & CONTROL, CONSULTING
WORKSHOP FOR DP PROFESSIONALS, SDLC, SOA, REMEDY.
EXPERIENCE:
03/2012 WORKERS COMPENATION INSURANCE RATING BUREAU CONSULTANT
TO
10/2012 Member of mainframe technical team responsible for the migration of a mainframe
based COBOL VSAM CICS/Batch workers compensation insurance rating system to
a PC based off shore developed rating system.
01/2008 MCKESSON CORPORATION CONSULTANT / APPLICATIONS ANALYST
TO
03/2012 Technical lead for the transition team responsible for the migration of all IMS/DB2/
VSAM mainframe Central Data Base system master data to the UNIX based SAP/
VISTEX system. Responsible for the design / implementation / maintenance of all
Full load and daily delta load data extraction and connect direct transfer jobs.
Worked on the specifications and verification of all the mainframe syndication files
being replaced by the new SAP / VISTEX system.
Member of Transaction Systems application project group for supporting all
development and maintenance for the McKesson Corporation mainframe Central
Data Base System project group, during migration to SAP software. The application
Utilized DB2/IMS/VSAM data bases within a CICS online and batch environment.
Worked on multiple online and batch development tasks, along with numerous
Maintenance and utility functions, to include data base and file cleanup, and the
decommissioning of many online and batch functions and jobs. Tasks included the
conversion from RJE remote report printing and job submission to VPS, SAR Express
Delivery, and Connect Direct procedures.
10/2002 KAISER PERMANENTE DBA / DB INTERFACE PROGRAMMER ANALYST
TO
12/2006 Member of Data Base Administration Data Base I/O Interface Programming Group.
Project responsibilities include design, code, test, and maintain over 450 DB interface
Programs used to access and update all production DB2 and IMS data bases. These DB
Interface programs are executed through dynamic calls within both online and batch
application programs. Project tasks include supporting the Data Base / Applications
programming Help Desk, PSB / Control Block generation and installation, support
and maintain Data Base Tools online utilities using Rexx, Dialog Manager, Clists.
Supported Systems Software group with testing of new versions of DB2, IMS, and
Enterprise COBOL. All DB interface programs communicate with the MQ process.
10/1998 BANK OF AMERICA CONSULTANT / APPLICATIONS ANALYST
TO
01/2002 Technical Lead for applications project group responsible for supporting vendor
supplied (AMS) CICS and Batch Collections System (CACS). Provided support
and maintenance, along with providing technical assistance to other group assistance
to other group members for online (CICS) software. and batch portions of applications.
06/1995 KAISER PERMANENTE CONSULTANT / DBA / APPLICATIONS ANALYST
TO
10/1998 Member of the Y2K / Medical Record Number Expansion project within the Data Base
Administration group. Project responsibilities included conversion of all KP physical
IMS and DB2 data bases and all IMS/DB2/VSAM DB I/O Interfaces (COBOL II) to
Handle expanded dates and medical record numbers. Tools used for this conversion
and both online and batch testing were: IMS, DB2, CICS, BMS, VSAM, FILEAID,
DATAVANTAGE, DXT EXTRACT, XPEDITOR, DBCTL, OMEGAMON, QMF,
SPUFI, DLT0.
10/1992 SOUTHERN PACIFIC LINES/ISSC CONSULTANT / APPLICATIONS ANALYST
TO
06/1995 Member of project team with responsibilities to include design, code, test, and
Implementation of five new miscellaneous bill types within the Revenue Miscellaneous Bill system. The modifications required: new online functionality (COBOL II, APS, IMS,
CICS, DB2); database changes (IMS); and major batch restructure (IMS, DB2, VSAM,
Report Writer) to load/update new bill types on new misc bill data base, produce new
Misc bill reports and interface with new RMS financial system.
Worked with accounting group to enhance and maintain automatic freight bill rating
System, using COBOL II, APS, IMS DB2, VSAM, and text editors (TSO, VM, Roscoe).
03/1992 PACIFIC BELL CONSULTANT / APPLICATIONS ANALYST
TO
09/1992 Provided technical support to new billing system integration testing group, to include
submission, monitoring, and correction of new and modified testing procedures,
maintenance of DB2, VSAM and flat file data in test environment, and perform and
report on validation and certification procedures.
01/1987 BANK OF AMERICA DATA BASE ANALYST / APPLICATIONS ANALYST
TO
01/1992 Provided IMS data base design, testing, implementation, and consultation for IMS
application development. Supported IMS control block and procedures creation and
Maintenance, to include CA-10 update and migration. Provided consultation for data
base performance issues, and provided recommendations for testing, training and
production implementation strategies. Provided primary DBA support for all IMS
testing environments, performed data base monitoring and review, member of Cross
Systems Product (CSP) software evaluation team.
As senior programmer analyst, World Banking Systems, provided IMS DB/DC
Development, testing, and implementation support for WBS systems. Provided
Technical support for WBS Corona Commitment systems provided online and batch
Tech support for all WBS production and test systems, acted as DBA interface.
Maintained current WBS Corona IMS ADF online system using IADF.
07/1979 BLUE CROSS OF CALIFORNIA PROJECT LEADER / APPLS ANALYST
TO
01/1987 Led IMS claims, membership and DBM online inquiry system development and
support. Provided support for all online transactions and related batch jobs.
As senior technical specialist, designed, coded, and implemented a batch entry claims
system, which included a Tandem computer front-end for network claims acceptance
and user reporting. Converted online claims edit and update system to a batch process.
As project leader, led the Applications Development Center, including ADF
Administrator, new software package review, and technical support to the applications
Programming areas.
As Senior programmer/analyst converted all in-house systems accessing BDAM/ISAM
Master data bases to IMS DB/DC.