SUMMARY:

I’ve (30+) years of experience in IT solutions from programming, developing, testing, documenting and leading projects. I’ve knowledge, skills and techniques in a variety of client configurations of their systems based upon their needs. I’ve a great understanding of SDLC procedures (Agile, Scrum, CRM, SDM,,,) and an understanding of SOX, HIPA and other data quality of assurance procedures and methodologies. I’d like the opportunity help as a cooperative, participant of a professional team or an individual contributor committed to serving the customer. Together we can resolve anything

TECHNICAL SUMMARY:

Oncall, performance tune (COBOL, DB2, Oracle, CICS, MVS, Dyl280, Easytrieve, SAS) SAS, DB2, COBOL/COB90/COBOL II, SQL/DML/DDL, TSO/ISPF, CICS (MQ SERIES/FRQS), VSAM, JCL, QMF, SPUFI, IMS, TERADATA, MICRO FOCUS WORK BENCH, OFFICE(PRO), VISIO, QUERYMAN, WINEDIT, PLATNIUM PRINCETON, OMEGA - MAN, EXPEDITER, EASYTRIEVE, REMEDY, DIALOG, FILEAIDE, PLAN-VIEW, INFOMAN, PEGASYS, PROEDIT, BROWSER, DETECTOR, LIBRIAN, ABARS, REXX, CLIST, DATACOM, CHECKER, DATA QUERY, MEDIT, TIME-LINE, CA7, ABC, FLOW, SCRIPTS, ADS PLUS, SOLIS, SAP, PL/I, BAT, ESP, AGENER, UEBGENER, IJKEF, DFSRCC, FORTRAN, BASIC, BDF’S FoxPro, PEOPLE-SOFT, APT, MCCORMICK&DODGE, INTERTEST, ENDEAVOR, DLY280, VISION PLUS, UNIX SCRIPTS, PeopleSoft

KEY SKILLS:

• Insurance Architect/Business
• Banking / Financial
• Credit Card
• COBOL, ALC, Easytrieve
• Trouble Shooting
• Diagnosis
• Technical Writing Documentation

PROFESSIONAL EXPERIENCE:

Confidential, Addison, TX

Team Lead and Project Manager

Responsibilities:

• Project, establish, generate timelines and budgets per phase of the Six Sigma, Agile, Waterfall SDLC.
• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures - Six Sigma, AGILE, Waterfall.
• Ensure the design integrity of the solution such that it meets the agreed functional and non-functional requirements, specifications and code.
• Suggest performance solutions, for SDLC (Software Development Life Cycle) process Six Sigma, Agile, and Waterfall application enhancement, system, code,,,,
• Write status reports, review and assist in BRD, HLD, LLD and Test for all interested of current and future projects. Used SAS to create analysis for Confidential ’s Data Warehouse, for specific requirements or determination of information for projects
• Create Schedules, Traceability Matrix, Distribute tasks, coordinate kickoff meetings, assemble and coordinate documentation from SME’s (Subject Matter Experts) on a Share Point drive. Create QC Defects for every suggestion from the SME.
• COBOL, RPG, SQL, ALC code, then coordinate a meeting to resolve any issues prior to UAT and SIT groups

Confidential, Richardson, TX

Sr Technical Architect

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings.
• Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished.
• Establish deliverables, roles and responsibilities procedures, Create Timelines as well as the Traceability Matrix then store upon the Share Point Drive
• Analyze production issues as they arise.
• Then supply short and long term resolutions.
• If they are short term, I’d make the corrective resolution.
• Create performance evaluation and implementation of the feasibility of BRD, HLD and LLD.
• Ensure the design integrity of the solution such that it meets the agreed functional and non-functional requirements.
• Suggest performance ideas for IMS, PLI, COBOL, ALC, DB2, VSAM,,, for a telecommunication billing application.
• Create status reports for all interested of current and future projects.
• 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.
• Assist 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 Confidential & Confidential was Agile and Waterfall.
• Create SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .

Skills honed were: 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

Confidential, Abilene, TX

SR Programmer Analyst

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings.
• Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished.
• Establish deliverables, roles and responsibilities procedures
• 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

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

Confidential, Richardson, TX

Coordinator/PJ/SR BA

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
• Wrote the Business Requirement Documents (BRDs) and High Level Documents (HLDs) for the 7 strategic environment Projects to comply to the standard of Agile. Wrote Ad-hoc reports to determine if Specifications were accurately processed and data was not compromised. Status Reports and Traceability Matrixes, Share-Point drive folders created and filled out.
• Oncall 24 X 7 data refreshes, code and systems for all environments, disaster recovery
• 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.
• Create SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .

Skills honed were: COBOL, SAS, CICS, ALC, VSAM, Teradata, DB2 and UDB, ORACLE, SQL, BTEQ, JCL, File-Aide, Dyl280, Easytrieve, Script for testing services, TSO/ISPF, NDM, FTP, Visio, Office(Access), Outlook, Agile, Waterfall SDLC methods, Informatica, Crystal Reports, Scrum

Confidential, Richardson, TX

Senior Lead Programmer Analyst Consultant

Responsibilities:

• Gathered and wrote requirements for Architecture, Design, Development, Test and Implementation Meetings.
• Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished.
• Establish deliverables, roles and responsibilities procedures for each of us during the aggressive timeline (350) modules converted in 3 months.
• Wrote the HLDs for each of the 350 modules.
• 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 Confidential & Confidential ’s IT-using Agile SDLC methodology.
• The converted all SAS modules to COBOL, plus teaching others to meet the aggressive deadline, which we completed two weeks early.

Skills honed were: COBOL, SAS, CICS, ALC, VSAM, DB2, IMS, JCL, File-Aide, Dyl280, Easytrieve, Pearl, Script for testing services, TSO/ISPF, FTP, Visio, Office(Access), Lotus Notes, SDM methods

Confidential, Addison, TX

Senior Lead Programmer Analyst

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings to comply to the Six Sigma SDLC.
• Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished.
• Establish deliverables, roles and responsibilities procedures
• Programmed, tested, evaluated, mentored and taught Analysts of all levels COBOL, DB2, ALC, SQL and Logic through Confidential ’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.
• Create SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .

Skills honed were: COBOL, DB2, CICS, ALC, VSAM, IMS, JCL, File-Aide, SAS, Dyl280, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, SDM methods, Vision Plus

Confidential, Irving, TX

Senior Lead Programmer Analyst

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
• Wrote BRDs, HLDs and Traceability Matrix for the Agile/Waterfall SDLC. Plus 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, Dyl280, 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.
• 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.

Skills honed were: COBOL, DB2, Teradata, SQL, ALC, BTEQ, Winedit, CICS, VSAM, IMS, JCL, SAS, File-Aide, Dyl280, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, Telon, SDM methods, Vision Plus

Confidential, Dallas, TX

Senior Lead Programmer Analyst / BA

Responsibilities:

• Distributed work to two individuals in order to meet project milestones.
• Reviewed the distributed work with management for performance and efficiencies.
• Taught seasoned Consutalnts how to view Teradata, DB2 and Oracle extracts, uploads and scripts to verify all modules for project impact.
• Performance tune and enhanced; COBOL, ALC, 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 .

Skills honed were: COBOL, DB2, CICS, ALC, VSAM, IMS, JCL, File-Aide, Easytrieve, TSO/ISPF, FTP, Visio, Office (Access), Lotus Notes, Telon, SDM methods, Vision Plus

Confidential, Los Colinas, TX

Senior Lead Programmer Analyst

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings.
• Wrote BRDs, HLDs, and LLDs to comply with their Six Sigma SDLC process.
• Upper management was kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
• 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 and ALC maps, 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.
• Create SAS, Easytrieve and DLY260/280 ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .

Skills honed were: COBOL, CICS, DB2, ALC, VSAM, IMS, SAS, Easytrieve, DYL280/260, 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:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings.
• Wrote LLDs for the impacted artifacts of the Agile projects that I worked on. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished.
• Establish deliverables, roles and responsibilities procedures
• 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.
• Data mining, reporting and tuning of Teredata 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 .

Skills honed were: 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

Confidential, Addison, TX

Senior Programmer Analyst / Data Warehouse Analyst

Responsibilities:

• Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
• 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.
• Diagnosed production issues with the WorldWide Trade Transactions Data Warehouse. Once the issue was diagnosed an establish a resolution criteria with a (3) tier server system. Unix, Cisco, and IBM Z-plex systems established.
• Create SAS and Easytrieve ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .
• SunGard Enterprise engine experience establishing where issues between SunGard and the Mainframe were. Then either correct or write a project plan. Analyze, Establish and Document where any anomalies are then fix or write a project plan.

Skills honed were: 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