Mainframe Developer Cobol, Cics, DB2, Jcl, Idms, Ims

Steven Steinbrecher Page * of *

Email: ******.************@*****.*** Phone: 678-***-****

Summary: I have diverse experience in the areas of COBOL, IDMS DB/DC, ADS/O, DB/2, CICS and mainframe utilities.

I have worked with clients in various sectors such as Government, Finance, Health Care, Insurance, and

Communications.

Applications/Packages/Utilities/Tools

CA-IDMS (ADS/O, ADS/ALIVE, IDD, OLQ), Changeman, CICS, DB2, CLIST, Easytrieve, Access, BMC Tools,

Excel, Endevor, ESP, FileAid, HP Quality Center, ISPF, JCL, Librarian, Microfocus COBOL, Monarch, MVS,

Oracle, Platinum Tools, QMF, HP Quality Center, Putty, ROSCOE, SPUFI, SQL Developer, SQL Server,

Teradata, TSO, UNIX, VM/XA, VSAM, Word, XEDIT, Z/OS.

EXPERIENCE

Experis 10/2012 - Present

CALWIN Project

• Analyzing and creating SQLPACKS for the Eligibility portion of CALWIN. Benefit programs consist of MEDI-CAL,

FOODSTAMPS, CALWORKS, CMSP, and Immediate Need.

Environment: Microfocus NetExpress, HP UX, Microfocus COBOL, Putty, Tuxedo

IBM Global Services 10/2011 – 09/2012

State of California MEDI-CAL Project

• Analyzing and making recommendations for impact changes to Programs, JCL, PROCS, SYSINS & Copybooks

for the ICD-9 to ICD-10 project due to Federal requirements

Analyzing requirements for Diagnosis Report Grouping. Currently Claims are billed by Revenue Code for MEDI-

CAL. The modification would save millions of dollars as rates for inpatient procedures would be billed on a

per diem basis and also is a requirement for Federal matching funds.

• Examining COBOL, SAS, Easytrieve & DYL280 code as well other mainframe entities including VSAM files.

Environment: COBOL, CICS, DYL280, Easytrieve, JCL, SAS, VSAM, Z/OS.

Genesis Networks Solutions 03/2011 – 08/2011

Senior Subject Matter Expert, Abilene, TX

Provided support for land based billing for AT&T. Tasks include client support and testing batch (back-end)

applications for defects before a software upgrade is released. Coordination of testing is between domestic and offshore

personnel. Testing and defect tracking is done using HP Quality Center .

Used ESP for scheduling batch processes. Created/modifed ESP networks for automation of jobs versus manual

triggering of jobs and applications.

Overrode JCL when required for ESP triggered jobs and events.

Create/modify FILEAID executables.

Environment: AT&T Connect, COBOL, DB2, ESP, FileAid, IMS, JCL, HP Quality Center, VSAM, Z/OS,

United Parcel Service Atlanta, GA

11/2010 – 02/2011

Drivers Helper

• Assisted drivers in delivery of packages during the holiday season and other busy delivery times.

Department of Commerce, US Census Bureau, Atlanta, GA

Enumerator 04/2010 – 05/2010

Interviewed people for the 2010 census.

Spoke in both English and Spanish in order to receive information pertinent to the questions asked on the

2010 census form.

IT-Resources, East Setauket, NY

Senior Analyst 05/2009 – 07/2009

Used Microfocus SOA Express, Mainframe Express and Endevor to develop/modify Web Services for

Blue Cross/Blue Shield of South Carolina. Blue Cross is modifying their applications to be web based instead of

mainframe CICS based and is using the Microfocus SOA product suite to serve as middleware through

Websphere and MQ Series. The Microfocus product acted as a code generator for Mainframe COBOL and Java

front end.

Environment: IBM Z/OS, COBOL, CA7, Endevor, CICS, UNIX, Java

Steven Steinbrecher Page 2 of 4

Email: ******.************@*****.*** Phone: 678-***-****

Wal-Mart Stores Inc., Bentonville, AR

Programmer/Analyst 03/2008 – 04/2009

Maintained and supported MARS (Multinational Accounts Receivable System), COOPS and DEALS for US,

Canada, Mexico, Great Britain, Argentina, India, Japan, China & Brazil. Also supported Pharmacy Systems if

required.

Developed a Remedy screen to track manual bills for Shared Services. The screen replaced a manual process

using Excel which was prone to error and did not provide traceability for the manual bills. The new functionality also

generated e-mail reminders to ensure better cash flow for collections or sending out Dunning notices.

Environment: IBM Z/OS, COBOL, DB2, Easytrieve, IMS, SPUFI, TERADATA

Technology Partners, Chesterfield, MO

Edward Jones, Maryland Heights, MO

Consultant 03/2007 – 12/2007

Corrected and implemented changes to production problem tickets

Converted programs from CA-IDMS to DAL (Data Abstraction Layer).

Client is in the process of converting from CA-IDMS to DB2.

Worked on compliance issues for legal and regulatory requirements.

Developed DB2 programs for the Financial Advisor oversight project.

Environment: IBM Z/OS, COBOL, DB2, IDMS, SPUFI, ORACLE, TUXEDO

Southeastern Data Cooperative, Tucker, GA

Consultant 11/2006 – 02/2007

• Applied changes to Microfocus COBOL code for GIS Stored Procedures.

• Modified scripts when necessary.

• Tested both batch and online web based programs.

• Ran database queries using Oracle SQL Developer.

Environment: HP 3000 & 9000, Microfocus COBOL, HP UX, Oracle

Longhill Enterprises, NY, NY

Centers for Medicare and Medicaid Services, Baltimore, MD

Senior Systems Analyst/Consultant 11/2005 – 05/2006

• Executed, tested, & analyzed batch and on-line programs for the new Medicare Part D system (MARx).

The system is written in COBOL & DB2. There is also a Web based User Interface to enroll beneficiaries

in as well.

Tested scenarios are written to correct software design problems or add functionality to the system when

required.

Environment: IBM Mainframe, COBOL, DB2, SPUFI, QMF, BMC tools, JCL.

Indecon, Indianapolis, IN

Sallie Mae, Fishers, Indiana

Senior Systems Analyst/Consultant 06/2005 – 10/2005

Analyzed, designed, developed, tested and modified batch & online systems for Sallie Mae. Provided

assessment and recommendations to remedy production abends.

Business System Design and Technical Systems Design were written for both domestic and offshore work

forces in order to comply with IRS guidelines and requirements for the Taxpayer Relief Act (TRA).

The changes made are for reporting of Capitalized Interest (1098-E forms) and W9-S (SSN verification)

forms for Sallie Mae's student loan clients.

Environment: COBOL, CA-IDMS 15.0, COBOL, DMLO, Endevor, OLQ, Z/OS, JCL, TSO/ISPF and CA-IDMS ADS/O

AGSI, Atlanta, GA

Verisign

Senior Systems Analyst/Consultant 02/2004 – 06/2005

Analyzed, designed, developed and maintained on-line and batch programs for a third Party wireless

billing system for Verisign.

Environment: UNIX (SCO, AIX). Zortech COBOL, TextPad, Borland Starteam, Applix

Steven Steinbrecher Page 3 of 4

Email: ******.************@*****.*** Phone: 678-***-****

Global Commerce and Information Systems, Fredericksburg, VA

Sallie Mae, Fishers, Indiana

Senior Systems Analyst/Consultant 11/2003 – 12/2003

Analyzed and modified CA-IDMS 15.0 maps and dialogs due to expansion of field sizes or replacement

of database records for the Reserve, School & Retirement screens.

Environment: CA-IDMS 15.0, ADS/O, IDD, ADSALIVE, COBOL

CSC (formerly DynCorp), Atlanta, GA

Centers for Disease Control and Prevention Financial Management Office 07/1999 – 01/2003

Senior Systems Analyst/Consultant

Primary responsibility was for analysis, development, review, execution and debugging of the Federal

Success system. Duties also included enhancement to existing on-line IDMS-DC and IDMS-DB batch

reports.

Retrofit code to solve problems incurred due to Year 2000.

Modified budget reports due to Fiscal Year 2000 changes in the codebook (General Ledger).

Implemented and maintained the Production Control System in production. The Production Control

System is used for scheduling of batch jobs as well as allowing the users to print ad-hoc reports. The

Production Control System includes security to allow or prevent access to functions depending upon

department requirements.

Developed models in Monarch for Accounting & Budget users. The models are used to create EXCEL

spreadsheets and ACCESS databases which the users can use for analysis.

Environment: IBM Mainframe, CA-IDMS 10.2 DB/DC, OS 390, Microsoft SQL Server, COBOL II, Monarch.

S2 Systems, Atlanta, GA

GE Capital - Retail Financial Services, Atlanta, Georgia 09/1998 – 06/1999

Senior Systems Analyst/Consultant

• Analyzed, developed, reviewed and executed test scripts for validation of the CARMS financial system for

Year 2000 compliance. The testing involved validation of 13 specific days to secure Federal Deposit

Insurance Corporation (FDIC) validation.

Environment: IBM Mainframe, CA-IDMS 10.2 DB/DC, OS 390, Microsoft SQL Server, COBOL II, CA-ADS/ALIVE,

CA-DMLO, Easytrieve and HourGlass for date simulation.

ASAP Staffing, Norcross, GA

Southern Company, Atlanta, Georgia 06/1998 – 09/1998

Senior Systems Analyst/Consultant

Analyzed, reviewed, and recommended modifications to CA-IDMS 14.0 DB/DC programs and CA-IDMS ADS/O modules

for Southern Company’s Millennium project. Date fields were reviewed for Year 2000 compliance and retrofitted to either expand

the size of the date where required or windowing logic was implemented to handle the

21st century.

Environment: OS 390, VM/ESA, TSO, XEDIT, REXX

Keane (formerly METRO Information Services)

Norfolk Southern Railroad, Atlanta, Georgia 06/1997 – 06/1998

Senior Systems Analyst/Consultant

Analyzed, enhanced, tested, debugged and implemented CA-IDMS 10.2 DB/DC programs for the Norfolk

Southern Contract Refund system. Enhancements included modifications to augment search and optimize

performance efficiency in the online environment.

Analyzed, coded, tested and debugged CICS/DB2 online screens for the ROAD Control system. Debugging was

done using Compuware’s XPEDITER for CICS, as well as SPUFI and QMF.

Environment: OS 390, ROSCOE, TSO, DB2, IDMS DB/DC, CICS, SPUFI, QMF, XPEDITER

Steven Steinbrecher Page 4 of 4

Email: ******.************@*****.*** Phone: 678-***-****

Aquent 06/1995 – 06/1997

Metropolitan Life Insurance (Pensions), Atlanta, Georgia

Senior Systems Analyst/Consultant

• Analyzed, enhanced, tested and debugged CA-IDMS 12.0 ADS/O dialogs and CA-IDMS programs for

Metropolitan Life’s CTS online Pension system. Analyzed, enhanced, tested, and debugged IDMS 12.0 batch

programs for Metropolitan Life’s pension contracts in a VM/XA and MVS Environment

Also uploaded/downloaded files from an IBM MVS environment to an MS Access database using

PKZIP/PKUNZIP for tracking of data integrity for batch loading of pension contract data. Environment:

OS 390, ROSCOE, TSO, IDMS DB/DC, VM/XA

Bank of America, Concord, California

Senior Systems Analyst/Consultant

Analyzed and documented Bank of America’s internal float system. The system was developed by J.D. Carreker

and heavily modified for bank standards. Documentation included written documentation as well as high level dataflow

diagrams.

Environment: PC

Pacific Bell Communications, Pleasanton, California

Senior Systems Analyst/Consultant

Developed user specifications for Toll-Free (800/888), Usage Processing System, Product Services and Fraud

systems for initial product rollout in early 1997.

Environment: PC

The Doctors’ Company, Napa, California

Computer Consultant

• Developed, modified and maintained programs in IDMS DB and COBOL II. Created data and validation reports for

migration from an IDMS 10.2 environment to a Microsoft SQL Server Environment Tasks included population of

primary and foreign keys and data validation/translation. Additional tasks included maintenance of sweep and

merge programs in order to develop the required relationships on the relational database.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Education:

B.S. Computer Science,

Florida International University, Miami, Florida.

Training

CA-IDMS 12.0 Database Definition.

CA-IDMS 12.0 Implementing and Maintaining a Database

CA-IDMS IDMS DB/DC

CA-IDMS IDD

CA-IDMS CULPRIT

C (U.C. Berkeley Extension)

C++ (U.C. Berkeley Extension)

Contact this candidate