Candidates About

 

Stephen Herring

 

Summary

Lead Mainframe COBOL Developer with over 20 years of extensive experience in programming, developing, testing and documenting. Expertise in software development life cycle (SDLC) of IBM Mainframe applications using COBOL, CICS, JCL and VSAM, DB2, IMS/DB.

 

HIGHLIGTHS

·         Completed more than 20 full life cycle application development projects in Mainframe environment throughout career and over 15 years of experience in leading several IBM Mainframe projects

·         Experience with POS Mainframe transaction processing, auditing, and maintenance.

·         Hands-on expertise with CICS/DB2 Mainframe systems conversions and database migrations.

·         Responsible for data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in moving data from online to Data-Warehouse (source to target), world-wide transactions.

·         Taught COBOL, SQL, DB2, JCL, DLY280, Sort, and File-Aide and other utilities.

 

Certifications

 

Professional Work Experience

Lead Mainframe Developer                                                                                        Jun 15 – Dec 16

Meridian at Bank of America, Remote 

As a Lead Mainframe Developer responsible for architecture, design and development of application for querying data from Teradata, loading and unloading data (FastLoad, FastExport, BTEQ, MultiLoad) and Performance tuning (src, apps and Queries). with help from Explain.

Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. 

Created Ad-Hoc reports with COBOL and SAS languages and CICS bitmaps

Facilitated Code Review Meetings to gather requirements, as well as Implementation warranty hand-off meetings

Reviewed code to document enhancements for other developers to code

Collaborated with any department does not have their metadata loaded into the Metadata Portal. 

 

Lead Mainframe / SAS Developer                                                                             Jul 12 – Aug 14 

TekSystems at Bank of America, Addison

Led delivery teams to deliver quality working tested software with each iteration

Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. 

Created Ad-Hoc reports with COBOL and SAS languages and CICS bitmaps

Refreshed and Reloaded DB2 (SIT and UAT) Environments upon request and scheduled

Updated SIT and UAT DB2 tables upon request

Facilitated Code Review Meetings to gather requirements, as well as Implementation warranty hand-off meetings

Administrated RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired)

Assisted and trained others with any code issue, understanding or implementation

Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster

Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those projects that they were modifying our Security DB

 

Environment: I Series, Z/OS and OS390, COBOL, DB2, Teradata, VSAM, SAS, JCL, CICS, Oracle, BTEQ, Unix scripting, TSO/ISPF, FTP, Librarian, Visio, Office (Access), SDM methods, Vision Plus, Crystal Reports, Microsoft Office (Excel, Power Point and WORD) BMC Tools

 

Mainframe Architect                                                                                                   Feb 09 – Feb 12

AT&T, St Louis, MO

Established deliverables, roles and responsibilities procedures, Create Timelines as well as the Traceability Matrix then store upon the Share Point Drive

Created performance evaluation and implementation of the feasibility of BRD, HLD and LLD.   Ensured the design integrity of the solution such that it meets the agreed functional and non-functional requirements.

Suggested performance ideas for IMS, PLI, COBOL, ALC, DB2 and VSAM for a telecommunication billing application.

Responsible for data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Onlines to Data-Warehouse (source to target), world-wide, transactions.

Created SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data.

Enhanced and created CICS Bitmaps

Migrated (2) Data Centers from San Diego and Fairfield, Ca to St. Louis, MO. 

Transferred all DB (Tables, Data, and Schemas), all unique batch programs, scheduled time to execute and site specific information for each site.

Administrated RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired)

 

Environment: Z/OS and OS390, COBOL, PLI, IMS, ALC, DB2, Teradata, VSAM, SAS, JCL, Oracle, BTEQ, Unix scripting, Expediter, File-Aide, Easytrieve, TSO/ISPF, FTP, Librarian, Visio, Office (Access), SDM methods, Vision Plus, Crystal Reports, BMC Tools

 

Senior Business Analyst                                                                                             Sep 08 – Feb 09

Abilene Independent School District, Abilene, TX

Led the Migration of the Infrastructure for PeopleSoft Enterprise Verions 8.5 to 9.0, DB and code. 

Wrote Impact Analysis Functional and Technical Specifications, Project plans and Timelines.  Contacted the Vendor when the complexity of the problem was too much for our resources.

Scheduled Oncall 24 X 7 as the primary for HR, Benefits, Payroll and Finance DB, Application and Systems

Performance Tuned and enhanced the Oracle, DB2 and Sybase DB’s, Application and Code,

Managing Billing, Payroll, Benefits and Finance errors and resolving issues

Administrated Security Access for all employees through a dashboard, DB or tool.

 

Environment: Oracle DB, People Soft Code, Admin, HCM, and Finance, Office, Project, Visio, Outlook, SDLC methods, COBOL II, Assembler, JCL, CICS, Easytrieve, Testing, VSAM

 

Senior Business Analyst                                                                                             Jan 08 – Oct 08

Caremark-CVS, Richardson, TX

Responsible for Insurance and Medical processing (Claims, Medical Record, Verification of Diagnosis, Authorizations and Prescriptions.

Wrote the Business Requirement Documents (BRDs) and High Level Documents (HLDs) for the 7 strategic environment Projects to comply with the standard of Agile.

Wrote Ad-hoc reports to determine if Specifications were accurately processed and data was not compromised

Oncall 24 X 7 data refreshes, code and systems for all environments, disaster recovery

QA Testing and script writing, spreadsheets, data analysis and documenting

Responsible for Scrum Data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Onlines to Data Warehouse (source to target) and from Production environments to SIT, QA, Unit and Parallel

Performance tuned and enhance, DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

 

Environment: Z/OS, OS390, COBOL, SAS, CICS, RPG, VSAM, Teradata, IMS, DB2 and UDB, ORACLE, SQL, BTEQ, JCL, File-Aide, DLY260 &DY280, Easytrieve, Script for testing services, TSO/ISPF, NDM, FTP, Visio, Office(Access), Outlook, Agile, Waterfall SDLC methods, Informatica, Crystal Reports, Scrum, CA and BMC Tools, Vision Plus

 

Lead Mainframe Developer                                                                                        Sep 07 – Dec 07

AT&T, Richardson, TX

Established deliverables, roles and responsibilities procedures for each of us during the aggressive timeline (350) modules converted in 3 months.

Converted all SAS modules to COBOL, plus teaching others to meet the aggressive deadline, which we completed two weeks early.

Migrated all SAS programs to COBOL (350) modules, in less than 4 months.

Wrote the HLDs for each of the 350 modules.

QA Testing and script writing, spreadsheets, data analysis and documenting

Coded, Unit Tested, Systems Tested and QA Parallel Production tested all modules impacted in production prior to implementation for quality work, 2 weeks early through AT&T’s IT-using Agile SDLC methodology.

 

Environment: Z/OS, OS390, COBOL, SAS, CICS, RPG, VSAM, DB2, IMS, JCL, File-Aide, DLY260 & DLY280, Easytrieve, Pearl, Script for testing services, TSO/ISPF, FTP, Visio, Office(Access), Lotus Notes, SDM methods, BNC Tools

 

 

 

Lead Mainframe Developer                                                                                        Feb 07 – Sep 07 

Bank of America, Addison, TX

Programmed, tested, evaluated, mentored and taught Analysts of all levels COBOL, DB2, ALC, SQL and Logic through BOA’s SDM SDLC methodology and procedures.

Gave DB2 performance enhancement and technique suggestions to upper management to establish better performance and throughput with access to old and new tables. Plus (3) new stored procedures

Wrote a couple of tools still used today to established that all specifications are in compliance, written and the result of percentage completion report sent to upper management when completed.

Verified and resolved RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired), whenever there was an issue.

 

Environment: Z/OS, OS390, COBOL, DB2, CICS, RPG, VSAM, IMS, JCL, File-Aide, SAS, DYL260 & DLY280, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, SDM methods, Vision Plus

 

Lead Mainframe Developer                                                                                        May 06 – Feb 07

CitiGroup Bank, Irving, TX

Programmed, tested, evaluated, mentored and taught Analysts of all levels COBOL, DB2 and Logic through Citi’s SDLC methodology and procedures.

Taught COBOL, SQL, DB2, JCL, DLY280, Sort, and File-Aide and other utilities.

Reviewed the distributed work with management for performance and efficiencies. As well as hands on assistance for all having to correct remedy tickets.

Responsible for SAS Demand Planning Data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Onlines to DataWarehouse (source to target) and from Production environments to SIT, QA, Unit and Parallel

Credit Card processing from Collections to Billing/Statements, modifications, projects, enhancements and corrections.

 

Environment: Z/OS, OS390, COBOL, IMS, DB2, Teradata, SQL, ALC, BTEQ, Winedit, CICS, VSAM, IMS, JCL, SAS, File-Aide, DYL260 & DLY280, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, Telon, SDM methods, Vision Plus

 

 

Lead Mainframe Developer                                                                                        Oct 05 – May 06

Odyssey Information Services, Inc., Dallas, TX

Performance tune and enhanced; COBOL, ALC, IMS, DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

Wrote the impact analysis, BRD, HLD and LLD to comply to their SDLC.

Suggested better ways to store and retrieve that data that would save time and gain access quicker.

Create SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data.

 

Environment: Z/OS, OS390, COBOL, DB2, CICS, ALC, VSAM, IMS, JCL, File-Aide, DYL260 & DLY280, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, Telon, SDM methods, Vision Plus

 

Lead Mainframe Developer                                                                                        Jun 04 – Sep 05

Midwest Consulting Group (MCG)

Neiman Marcus, Los Colinas, TX

Converted a department and their entire Database from a Mainframe to a UNIX Oracle server.

Was responsible for Technical Specifications, designing, coding, testing and the transformation process to implementation in production application development systems.

Developed enhancements to Online CICS bitmaps, Batch updates and Purge processes for the Credit Department.

Created an automated process to print Store’s General Manager Signatures on thank you letters as well as Customer Response Surveys in this Merchandising environment.

Added barcode and POS process to an old department, helped in the determination of the algorithm as well as the buying of the barcode reader to use.

Performance tuned and enhance, DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

Migrated all inventory to barcode and POS system for departments throughout all Neiman Marcus Stores.  From inception to implementation

Administrated RACF, VTAM and ACF for employees as requested by management

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, ALC, VSAM, IMS, SAS, Easytrieve, DYL260 & DLY280, JCL, Java, PAYSYS, MPS, Oracle, Unix scripting, Expediter, File-Aide, TSO/ISPF, FTP, Librarian, Visio, Office (Access), SDM methods, Vision Plus

 

Senior Data Warehouse Analyst                                                                                 Oct 02 – Jun 04

Compuros Information Technology Services, Richardson, TX

Blue Cross Blue Shield

Analyzed performance tuned, designed, developed, implemented and maintained BCBS’s Enterprise Data Warehouse (EDW) production processes.

From DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

Responsible for Data mining, reporting and tuning of Teradata DB, as well as SAS Demand Planning Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data.

Verified and resolved RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired), whenever there was an issue.

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, ALC, VSAM, SAS, Easytrieve, JCL, Librarian, Lotus notes, Office (Access), Visio, Teradata, Winedit, BTEQ, Queryman, Mload, Xload, Expediter, File-Aide, TSO/ISPF, FTP, Endeavor, Enterprise Data Warehouse, SDM Methods

 

 

 

Lead Mainframe Developer                                                                                        Aug 00 – Sep 02

JP Morgan Chase, Addison, TX

Modified/enhanced/developed production programs, data-structures and data of Cash, Custody, Accounting and Securities transactions for JP MORGAN’s EDW.

Established four country’s foreign exchange rates were off three to four digits. The issue had been going on for months, and would have continued if is not put together a daily reporting process. Found a variety issues that were just as important that I documented and resolved.

Performance tune and enhance, DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

Analyzed, established and documented where any anomalies are then fix or wrote a project plan.

Verified and resolved RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired), whenever there was an issue.

 

Environment: Z/OS, OS390, COBOL, CICS (MQ Messaging), DB2, ALC, VSAM, Easytrieve, SAS, JCL, Office (Access), Visio, Flow Chart, (Princeton, Sterling, CA and IBM Products), SunGard, Librarian, Lotus Notes, Expediter, File-Aide, Endeavor while updating and maintaining Data Warehouse through CMM methodologies and procedures

 

Lead Mainframe Developer                                                                                        Feb 98 Aug 00

JC Penney Direct Marketing Services Systems, Plano, TX

Was responsible for the programming analysis, design, development and implementation of COBOL batch and online core programs to meet JCPenney specifications. Plus, enhanced, debugged and documented (Specifications, Analysis, Status, Enhancements and Memos) for JC Penney’s management needs.

Performance tune and enhance, DB2, Oracle DB’s as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.

In the Merchandising and warehousing modifications/enhancements to performance tune slow batch programs and processes.

Migrated all of the Mainframe modules both (CICS) online and batch programs to a UNIX server.  Then established a Batch cycle, tested and implemented.

Verified and resolved RACF, VTAM and ACF access authorizations for all employees (hired, transferred/upgraded or released or fired), whenever there was an issue.

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, Teradata, SQL, BTEQ, Winedit, ALC, VSAM, IMS, Easytrieve, DYL260 and DLY280, JCL, SAS, Java, Ingenium, Expediter, File-Aide, Micro Focus Workstation, TSO/ISPF,CA7 and CA11, Librarian, Office (Access), Telon, SDM

 

Senior Programmer Analyst                                                                                        Feb 96 – Feb 98

EXCEL Telecommunications, Addison, TX

Suggested performance ideas for IMS, PLI, COBOL, ALC, DB2, and VSAM for a telecommunication billing application.

Createed status reports for all interested of current and future projects.

Microfocus and Relia COBOL Billing enhancements to their billing software as well as 24X7 Production support

 

Environment: DOS and OS2, COBOL (Microfocus and Realia), flat files (ASCII), SAS, BAT, CON or EXE

 

Senior Programmer Analyst                                                                                        Feb 95 – Feb 96

Henderick Medical Center, Abilene, TX

Responsible for Data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Online to Data-Warehouse (source to target), world-wide, transactions.

Assisted in the Business Requirement Document for functionality, specifications and requirements. Write the High-Level Design (HLD)/Integrated System Design. Identify the scope for improvement in HLD and suggest possible solutions. The SDLC at AT&T was Agile and Waterfall.

Created SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data.

Wrote an IMS sync up job to be run every week,

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, Teradata, SQL, BTEQ, Winedit, ALC, VSAM, IMS, Easytrieve, DYL260 and DLY280, JCL, SAS, Java, Ingenium, Expediter, File-Aide, Micro Focus Workstation, TSO/ISPF,CA7 and CA11, Librarian, Office (Access), Telon, SDM

 

Senior Programmer Analyst                                                                                        Feb 94 – Feb 95

IBM Consulting Abilene, TX

Migrated all 163 sites DB’s to DB2 on the mainframe

Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. 

DB’s ranged from PC’s to Mainframes; (Dbase, Sysbase, PACBASE, IMS, DB2), that had to be converted to DB2

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, Teradata, SQL, BTEQ, Winedit, ALC, VSAM, IMS, Easytrieve, DYL260 and DLY280, JCL, SAS, Java, Ingenium, Expediter, File-Aide, Micro Focus Workstation, TSO/ISPF,CA7 and CA11, Librarian, Office (Access), Telon, SDM

 

Senior Programmer Analyst                                                                                 Feb 93 – Feb 94

Information Retrieval Methods, Inc, Carrolton, TX

 

Environment: Z/OS, OS390, COBOL, CICS, DB2, Teradata, SQL, BTEQ, Winedit, ALC, VSAM, IMS, Easytrieve, DYL260 and DLY280, JCL, SAS, Java, Ingenium, Expediter, File-Aide, Micro Focus Workstation, TSO/ISPF,CA7 and CA11, Librarian, Office (Access), Telon, SDM

 

EDUCATION

Studied Courses in Computer Information Systems, Glendale Community College, Glendale, Arizona, 1979