CAREER SUMMARY

Highly experienced Functional/Technical Consultant/Developer, Business Analyst, QA Analyst and Project/Team lead with 25+ years of experience. Industry experience of Payroll/Human Resource (HR), Accounts Receivables (AR), Insurance practices, banking software and various testing methodologies. Industries are Manufacturing, Retail, Banking, Insurance and Automotive

HARDWARE

IBM Mainframe. AS400, Windows, Unix Shell, Sterling

SOFTWARE

COBOL, CICS, DB2, Quality Center, IMS, PL/1, SQL Query Language, VSAM, Datacom dB, TSO SPF/ISPF, ROSCOE, OS/MVS, JCL, XML, OS/MVS, Utilities, Intertest, Librarian, Fileaid, Endevor, Easytrieve, SPUFI, Expediter, Jobtrac, Focus, CA7, QMF, MQ Series, DB2 queries, Visual Basic, Syncsort, MS Word, MS Excel, SDLC, MS Project, MS Office, FTP, NDM, ABAP, MAINFRAME/SAP conversions, Fortran, Javascript, HTML, CONTROL-M

PROFESSIONAL EXPERIENCE

10/2015 – 08/2016 – QA Analyst

Verify QA test cases

Run data comparisons

Report defects

Work with AS400 developers to understand and determine requirements for projects that had very tight deadlines and very little analysis

Modified XML programs for team’s project specific testing

Worked with BA to insure that test cases were written based on their BRD

Tools Used: HPQC, SQL, Squirrel, MS Word, XML

7/2015 – 10/2015 – Programmer/Analyst

Analyze, code and test required security changes in multiple programs for client Home Depot

Created user documentation that enabled client’s business teams to access need information quickly and efficiently.

Tools Used: COBOL, dB2, JCL, Procs, MS Word, Excel, SPUFI

6/2014 – 5/22/2015 - BA & QA

Working with client Manheim on conversion of their AS400 menus and data to Oracle.

Responsible for meeting with the client(s), gathering requirements and creating a document that included the business and functional requirements.

Created the needed test cases based on the business/functional requirements.

Verified that test cases written in QC were correct.

Creating and unit testing technical test scenarios for data verification via QC

Review and gave input at team reviews of business documents

Running data comparison using SQL

Analysis of AS400 programs t f testing requirements for the Data Conversion Team

Created Visio documents to show current process flow

Tools Used: SQL HPQC, MS Word, Visio

6/2011 – 8/31/2013 Capgemini LLC - Mainframe Analyst/Tech Lead -- Consultant

Working with client Lowe’s in North Carolina on various releases of their online ordering systems. As Mainframe Analyst and Testing Lead, responsible for overseeing multiple systems and testing initiatives in QC.

Mainframe Analyst role included assisting offshore mainframe resources in setting up the job streams and trouble-shooting abends that offshore could not resolve.

Testing Lead role included meeting with business users to gather requirements, create test scenarios and validate with the technical lead/SME that the all scenarios were properly addressed.

Ran and validated the test scenarios in QC.

Analysis of and running of COBOL,VSAM,DB2, Javascript and HTML code and running BMC loads and unloads. Created reports and files in Easytrieve for business users use. Coding SQL queries for data mining and reporting.

Working on getting needed access for team. Conducted weekly/bi-weekly meetings with offshore team and attended weekly onshore meetings with client and onshore team.

Participating in QC testing meetings and provided updates on the testing initiatives that mainframe team is responsible for.

Working with Lowe’s technical resources, such as the MQ, Sterling and ESB teams and SMEs from various store systems and other Lowe’s outside vendor teams for credit card processing.

Validating data in various systems and tables

Working very closely with client on the Finance portion of the testing to insure that expected results were delivered and target dates met.

Reviewing and added to, if necessary, documentation created by offshore team on the systems that were worked on since there was no standard documentation.

Resolving data issues

Tools Used: COBOL, DB2, VSAM, HTML, JCL, easytrieve, Procs, SQL, HPQC, MS Word, SPUFI

1/2008 - 2/2010 Capgemini LLC - Sr. Consultant/Sr. Software Developer (Permanent Employee)

Worked with client GM in Detroit to create way to transmit data using CICS container processing to their individual dealerships in Mexico via web services. Developed 10 COBOL CICS wrapper programs to invoke existing COBOL CICS driver programs. Once data successfully placed in container(s), web services would process the containers. Created nix shell commands to access libraries on the mainframe directories and files necessary for this container processing. Participated in design meetings, daily status meetings. Participated in SOA and JAD sessions for system setup and design.

On GM and Coca-Cola projects, trained other team members, both onshore and offshore, in various mainframe tools and needed knowledge transfer. In GM, this required learning how to maneuver their workbench to access different environments, such as Endevor, Unix Shell, Output queues and more. For Coca-Cola, trained offshore and onshore resources in debugging Billing system issues which affected the Accounts Receivables system and knowledge transfer of Accounts Receivables system.

As the sole support person for Coca-Cola’s Accounts Receivables system responsibilities always included planning, design, unit testing, acceptance testing, signoff, implementation and maintenance.

Worked on conversion/migration of data from the mainframe to SAP, performed analysis, coding and testing of all COBOL, IMS, CICS, DB2 and PL/1 programs for Sales and Tax Use, Accounts Receivables and other smaller systems being sunset. Participated in weekly status meetings and met with business users as needed to give updates and review test data.

Worked as part of infrastructure team on Canadian project traveling weekly to Toronto and back. Performed project management duties such as gathering requirements, creating Visio diagrams, ensuring that resources were in place and more.

Created community website for our Capgemini business unit. This allowed the business unit that exists throughout the US and those that were traveling to keep updated on various information that pertained to our specific group.

Worked on enhancements for an upgrade of tools used for PeopleSoft documentation using XML and Javascript.

Tools Used: COBOL. CICS, IMS, DB2, PL/1, JCL, Procs, SPUFI

8/2002 – 12/2007, The Coca-Cola Company - Senior Software Developer on Capgemini Project (Consultant)

Primary Support of the USA Accounts Receivables (AR) Applications whose languages were COBOL, IMS, PL/1 and CICS. Secondary support for USA Billing and Reimbursement Systems whose languages were COBOL, IMS and DB2. Created and maintained programs for these mainframe systems for successful daily processing by the business analysts.

Team Lead for data conversion from mainframe to SAP, which involved gathering requirements, meeting with business users, talking to banking partners about how to handle ACH data, directing contractors and other team members in what needed to be done. Coded and tested needed COBOL modules.

VPN tunnel creation for sending vital data to be placed on microfiche thru outside vendor who could no longer accept tapes due to tape drive upgrade.

Created automatic draft processing from customers checking accounts which required formatting data for bank account information and processing thru existing COBOL IMS programs and database updates.

Provided 24/7 support for Accounts Receivables system. As SME for worked closely with business users to define requirements and scope requests such as ACH processing and the SAP conversion. Performed JAD sessions.

Developed and executed test strategies for AR, USA Billing and system upgrades. These strategies and testing involved yearly Disaster Recovery.

Created technical specs for team members based on meetings with the business.

Mentored junior programmers both onshore and offshore by sharing knowledge and helping develop analytic skills to debug production abends.

Project Lead for auto drafting initiative which required management of system development life cycle (SDLC) from project design to post implementation support.

Worked with onshore and offshore support personnel finding solutions to correct data and system issues.

Planned Use-Cases and scripts based on the URD over several projects for new systems and system upgrades.

Led code review for programs developed by other team members.

Worked effectively with various outside vendors to define and implement interface solution for bank drafting processes.

Worked effectively with Coca-Cola business lead to insure that data format was correctly transmitted to bank.

Project Lead on creation of FTP process with microfiche due to tape drive upgrade working with local and offshore resources. This involved creation of a VPN and performing JAD sessions with several groups including outside vendor.

SME for Legacy AR to SAP AR conversion. Participated in JAD sessions and

Coordinated with outside vendor, offshore teams, onshore groups in different states and production control to monitor and cutoff of mailing tapes now obsolete.

Tools Used: COBOL, IMS, dB2, JCL, Procs

6/2002 – 8/2002 Sallie Mae Reston, VA - Consultant - Sr. Software Developer

Managing the analysis and execution of required business changes

Developed and executed unit test scenarios alongside the business resources to insure that the DB2 changes were successfully developed and implemented.

Worked with QA to insure that needed changes were made.

Tools Used: COBOL, dB2, JCL, Procs

Volunteer Experience: CASA (Court Appointed Special Advocate for Children)

EDUCATION US International University

Manhattan Community College

REFERENCES Available upon request

Contact this candidate