Quality Assurance Project

PROFILE

Dedicated, Information Technology (IT) professional, providing 15+ years of mainframe and object-oriented technical experience in the areas of Systems Analysis and Application Design with background in the Healthcare, Automotive, Financial, Transportation, Retail and Wholesale industries. A skilled (senior / lead) Mainframe Programmer/Systems Analyst searching for challenging and enriching systems development and support opportunities; willing to relocate.

TECHNICAL SKILLS &KNOWLEDGE

Languages: COBOL, Visual Basic, HTML, Javascript, FOCUS, WebFocus Easytrieve, SQL, JCL, DCL, C, C++

Databases: DB2, IMS, CICS, Sybase 8.0, VSAM, MS Access, Oracle

Management Tools: Changeman, Endeavor, DCCS

Transfer Tools: Network Data Mover, File Transfer Protocol

Applications: ABC Flow Charter, Abend-Aid, CA-7, Crystal Reports, FileAid, JES, Lotus Notes, MS

Office Suite, Microsoft Outlook, RACF, SPUFI, SYNCSORT, Viso Pro, Xpediter

Operating Systems: Windows (95, 98, 2000, XP, 7), MVS, TSO/ISPF, VM/VSE, VAX

Methodologies: SDLC, LEAN, SIX SIGMA

PROFESSIONAL EXPERIENCE

Cobol Programmer/QA Tester – Apex Systems/Navistar, Chicago, IL 3/2012 – 8/2012

Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL/SPUFI, IMS, Visual Basic, Changeman, XPEDITER, MS Access, RACF, CA-7, FTP, SYNCSORT, IBGENER, FOCUS, MS Outlook, VSAM, IDCAMS

On assignment as a Cobol Programmer/Quality Assurance Tester at Navistar in Lisle, Illinois. Duties include developing batch programs to conduct quality assurance tests for Marketing and Retail Accounting System (MRAS) Decommission project.

Systems Programmer – John Galt, Boston, MA 12/2009 – 8/2011

Environment: VAX, COBOL, FOCUS, DB2, SQL, DCL, Lotus Notes

On assignment as a Mainframe Tester and Programmer at Ryder Logistics in Novi, Michigan, accomplishments include establishing standardized procedures and policies for change management through the team LEAN process and was awarded two $100 gift certificates for this and other suggestions. General duties included enhancing VAX FOCUS and COBOL mainframe batch and interactive invoice programs plus related DCL, creating new FOCUS transportation accrual cost programs, generating new and updating DB2/SQL tables, writing and implementing project test plans, providing business requirements and project estimates, producing technical and user system documentation.

Systems Programmer - Kelly Services, Troy, MI 11/2007 – 6/2008

Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL, Visual Basic, EasyTrieve, Network Data Mover,

DCCS (in-house change management application), Lotus Notes, SYNCSORT, IBGENER

Completed all aspects of the SLDC life cycle phases of Chrysler Financial and Daimler Financial system separation for three financial system. Gathered business requirements, composed required documentation and obtained authorization of work. Modified, tested and implemented a minimum total of 50+ mainframe online CICS, batch COBOL, Easytrieve and related JCL programs for financial systems mainframe Dealer Reserve and Added Value Coupons. Updated functionality for Visual Basic 6.0 financial application Chargeoffs including related DB2 tables, data files and Crystal reports. Setup new jobs schedules. Separated data files with IBGENER and data within files using SYNCSORT. Produced documentation as required for three rounds of testing.

Systems Programmer ( Level 1) – Comerica Bank, Auburn Hills, MI 1/2006 – 4/2007

Environment: IBM TSO/ISPF, COBOL, JCL, CICS, Sybase/SQL, Visual Basic, Crystal Reports, Endeavor,

Lotus Notes, VSAM, IDCAMS, SYCSORT, IBGENER, FTP

Highlights as a Lending Technology Credit Systems team member include converting a six hour manual process into automated mainframe process by producing COBOL/JCL batch programs and secure FTP delivery process of customer reports/address files which eliminated SOX violations. Developed a Visual Basic application to track differences within Sybase SQL tables containing mortgage application information. Programs produced Crystal reports that identified errors and data was reconciled. In one month successfully completed 30 system enhancements and 10 required process changes for Loan Tracker, a Visual Basic mortgage application, after a two year halt of the project.

Systems Programmer - Compuware Corporation, Detroit, MI 10/1998 – 12/2005

Computer Methods Corporation, Livionia, MI 3/1995 – 10/1998

Environment: IBM TSO/ISPF, COBOL, JCL, DB2/SQL/SPUFI, IMS, Visual Basic, Changeman, XPEDITER,

MS Access, RACF, CA-7, FTP, SYNCSORT, IBGENER, FOCUS, MS Outlook, VSAM, IDCAMS

Contractor for 10 years at Ford Motor Company in Dearborn, MI serving on two system teams overseeing five mainframe applications: National Employee Service Center (NESC) ( health care), Workforce Profile (WP)(human resource), General Employee Number (GEN) (joint FORD/UAW employee tracking) and Education Management System (EMS) (training), PRISM (data warehouse) . NESC, WP, GEN and EMS consisted of batch and online COBOL/DB2/IMS/FOCUS programs; PRISM databases were accessed by FOCUS batch and online programs used to produce customer requested reports/files.

Accomplishments include:

• Served as the NESC subject matter expert on Health Update to Dependent Database web system (HUDD) project. Role called for analyzing system, developing COBOL/DB2/IMS specifications and conducting code reviews.

• Served as lead of NESC Systems team; assisted other team members, provided specifications, advised supervisor(s) on assignments, conducted training courses and composed related documentation on new features and applications when required, scheduled job using CA-7 responsible for system security.

• Reworked GEN monthly reporting process, breaking up a 20 step JCL job into three smaller, logical jobs, adding a FOCUS program to determine job parameters in place of manual calculation and updating COBOL programs to forward file status data to JCL jobs. Enhancements eliminated parameter errors, job reruns and programmer intervention.

• Developed MS Access joint UAW/FORD NESC Employee Training application which listed course information, tracked enrollment and produced reports used to evaluate employees.

• Developed MS Access Project List System used by management to track the status and progress of team projects.

• Completed Sarbanes-Oxley (SOX) analysis of NESC and resolved violations.

• Decommissioned EMS COBOL/JCL, DB2 tables and data files

EDUCATION

Masters of Science in Computer and Information Systems 8/2006

University of Detroit, Detroit, MI

Bachelors of Science in Computer Information Systems 5/1994 University of Dayton, Dayton, OH

Contact this candidate