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.
• 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.

PROFESSIONAL EXPERIENCE:

Lead Mainframe Developer

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential, St Louis, MO

Responsibilities:

• 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

Confidential, Abilene, TX

Responsibilities:

• 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 CodeManaging 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

Confidential, Richardson, TX

Responsibilities:

• 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

Confidential, Richardson, TX

Responsibilities:

• 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

Confidential, Addison, TX

Responsibilities:

• 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

Confidential, Irving, TX

Responsibilities:

• 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

Confidential, Dallas, TX

Responsibilities:

• 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

Confidential, Los Colinas, TX

Responsibilities:

• 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 Confidential 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

Confidential, Richardson, TX

Senior Data Warehouse Analyst

Responsibilities:

• 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

Confidential, Addison, TX

Responsibilities:

• 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

Confidential, Plano, TX

Responsibilities:

• 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

Confidential, Addison, TX

Responsibilities:

• 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

Confidential, Abilene, TX

Responsibilities:

• 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

Confidential, Abilene, TX

Responsibilities:

• 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