SUMMARY:

Over twenty years experience on various platforms, interfaces, and applications for diverse clients across all phases of the structured methodologies ranging from analysis, design, development, and testing, to installation, implementation, and support. My robust experience allows me to transfer my application and technical knowledge to new environments, adjust to the client’s needs more rapidly, and make a productive contribution.

SOFTWARE:

CICS, COBOL, DB2, SQL, QMF, SPUFI, Platinum, VSAM, MQ Series, CA7/CA11, CNTL - M Enterprise Scheduling, Easytrieve, Endevor, Panvalet, MVS, JES3, DASD, TSO/ISPF, Roscoe, JCL, IBM Utilities, Abend-Aid, Sync Sort, File Aid, Intertest, Xpediter, XPTR, Infopac Report Distribution, MS Office, Word, Excel, Visio, FTP, Systems Life Cycle Methodology, MS Project 2003, CEDA, SAS, TOAD, Oracle, stored procedures, PL/SQL, Unix shell scripting, Sarbanes Oxley (SOX)

EXPERIENCE:

Confidential, Columbus, GA

Consultant

Responsibilities:

• Develop and Support FLEX, Agency and Broker Systems in CICS, DB2, and VSAM environments.
• Ensure accurate counts for Agent Bonuses through review of SQL and associated reports.
• Developed and installed defect-free Employer Verification interface with TALX Work Number.
• Develop and install Agency Electronic policy bonus interface to SmartUser.
• Designed using Visio, and developed IVR Claims Health History interface.
• Review and ensure outsourced projects meet IT standards.
• Research and determine missing Commissions for given Agents.
• Develop interface with Versata.

Confidential, Johns Creek, GA

Consultant, Senior Production Support Analyst

Responsibilities:

• Support Allocation System on multiple platforms.
• Responsibilities include mainframe development, maintenance of Unix shell scripts and DB2 and Oracle databases, creating HTML reports, design, debugging, and verification of complex SQL, documentation of procedures for SOX compliance and ETL SALES (Teradata) processes, QA tests, designing and documentation of CNTL-M schedules.
• Documented complex Confidential procedures with IGS - IBM Global Services in Change Management Specialist role.
• Tasks accomplished via Oracle, Toad, PL/SQL, SQL Tester, Platinum, QMF, SPUFI, DB2, COBOL, F-Secure, UNIX, scripts, HTML, CNTL-M Enterprise, MS Office, Excel, Word, Visio, and other tools.

Confidential, Roswell, GA

Consultant

Responsibilities:

• Support Rebates Claims Processing (Pricing) system in CICS and batch COBOL Enterprise DB2 environment.
• Improvements include DB2 design and tuning, creating complex SQL reports, streamlining FTP, correcting application errors, creating repeatable processes, and creating up-to-date documentation for outsourcing and SAP conversion.
• Tasks accomplished by using workstations with MS Office, Word, Excel, Visio (and Flowchart), life cycle system development, MVS JCL, COBOL Enterprise, DB2 SQL, QMF, SPUFI, SAS, and TSO/ISPF, Platinum, and Intertest.

Confidential, Alpharetta, GA

Consultant, Technical Team Lead

Responsibilities:

• Install/1 product from online and batch systems.
• Develop, assign, and follow-up assignments for enhancements to Cobol II DB2 batch system.
• Additional team lead responsibilities range from code and JCL review to quality assurance follow-up and maintaining consistencies between testing regions.
• Perform database and SQL design and database tuning.
• Tasks accomplished by using workstations with MS Office tools such as Word, Visio, and Excel (and Flowchart), life cycle system development, MVS JCL, COBOL 390, DB2 SQL, QMF, SPUFI, Datacomm, and TSO/ISPF.

Confidential, Macon, GA

Consultant

Responsibilities:

• Design, develop, test, and install enhancements for Cobol II DB2 Claims Processing.
• Main project included working as help desk and reorganizing Direct Check interfaces for OASIS system and producing SOX documentation.
• Responsibilities range from analysis and design using workstations with MS Office tools such as Word, Visio, Flowchart, MS Project 2003 and Excel, to development, life cycle system development, and production support using MVS JCL, COBOL II, DB2, SQL, QMF, SPUFI, and TSO/ISPF in RACF environment.

Confidential, Atlanta, GA

Consultant

Responsibilities:

• Design, develop, test, and install enhancements for Cobol II DB2 MQ Series Revenue Management Enhancement systems.
• Main project included redefining and partitioning Booking data to allow better analysis of revenue streams, and designing, debugging, and verifying complex SQL.
• Perform database and SQL design, check pending removals, db2start, table design and creation, authorizations as needed, and database tuning.
• Responsibilities range from analysis and design using workstations with MS Office tools such as Word, Visio, and Excel (and Flowchart), to life cycle system development, QA testing, and production support using MVS JCL, COBOL II, DB2, SQL, QMF, SPUFI, Platinum, FTP, MQ Series, and TSO/ISPF in RACF environment.

Confidential, Atlanta, GA

Consultant, Business Analyst

Responsibilities:

• Completed short term project of SDLC high-level analysis for DHR’s Vital Record winning statistical systems.
• Analysis established business rules to be used in developing replacement system.

Confidential, Atlanta, GA

Consultant, Business Analyst, System Engineer

Responsibilities:

• Design, develop, test, and install enhancements for Cobol II CICS DB2 IMS MQ Series transportation systems (ABC, DTSR).
• Projects include Year 2000, large scale merger, application rewrites for three tier environment (presentation layer, business rules layer, and database interface layer), dynamic train schedule generator, coding Extra train function from 30 by 60 matrix, rate inquiry matching, development of programming and testing standards for three tier architecture environment, design, debugging, and verification of complex SQL, and provide post-installation support.
• Perform database and SQL design, check pending removals, db2start, table and index creation, authorizations as needed, and database tuning.
• Responsibilities range from analysis and design using workstations with MS Office tools such as Word, Visio, Flowchart, MS Project 2000, and Excel, to life cycle system development, QA testing, debugging and verifying complex SQL, and production support using MVS JCL, COBOL II, CICS, DB2, SQL, QMF, SPUFI, Platinum, Access, FTP, MQ Series, FileAid, Easytrieve Plus, and TSO/ISPF in RACF environment.

Confidential, Atlanta, GA

Consultant, System Engineer

Responsibilities:

• Design, develop, test, and install enhancements, and provide production support for Cobol II CICS VSAM Commercial Card transaction processing system for clients such as EDS.
• Tasks include Year 2000 changes for clients, handling requests for new business requirements using tools such as Word and FlowChart, providing technical support, and implementing solutions for production problems. Easytrieve Plus and Intertest used as debugging tools in RACF environment.

Confidential, Atlanta, GA

Consultant

Responsibilities:

• Analyze, develop, and test for DB2 Cobol II import accounting systems.
• Completed receipts processing, internal transfers processing, and return to vendors processing.
• Tasks include analysis and design for import accounting systems, coding DB2 and Cobol II programs, quality assurance testing, and resolving production problems related to recent releases. Intertest used as a debugging tool.