Developer Analyst

CRAIG KAERCHER

***** ********** ** 586-***-****

Clinton Twp, MI 48038 *****.********@*****.***

http://www.linkedin.com/profile/view?id=3898441 www.ckkcollegealgebra.wordpress.com

SOLUTION ARCHITECT / SENIOR PROGRAMMER ANALYST

Programmer / Analyst / Team Leader / Project Leader / Business Analyst providing design, coding and implementation leadership on mainframe based software solutions

Very knowledgeable IBM Mainframe Programmer (COBOL (II/VMS/batch and online)/JCL/VSAM/CICS/Xpediter/FileAid/Syncsort/Easytrieve/all IBM utilities). Adept in VM MVS TSO/ISPF, COBOL(Batch and CICS), DB2, JCL, CICS, VSAM, Easytrieve, XPediter, File-Aid, Abend-Aid, Syncsort.

Experience in analytic software (SAS, R Programming).

Extremely competent in Windows, experienced in Linux/Unix, beginner in AS400. Previous work on DEC VAX/VMS.

Taken classes on my own in other languages/software (REXX, Ruby, Hadoop, Fortran, Forth).

Moderate experience in OOP (Java, VB.Net, Visual C#.Net).

Other abilities include taking two foreign languages (German and Spanish) learned on my own, teaching, and writing a book.

Technical Development & Leadership:

Good skills in DataComm, SPUFI, Data Extraction and Conversion, FTP/Email from the mainframe.

High level of expertise in problem resolution and root cause analysis in on-call situations.

Proficient in all Microsoft Office applications but mainly Word, Excel, Access, and PowerPoint.

Along with the IBM mainframe and all associated utilities and tools, have also worked coding object-oriented programming languages (Java) on Windows for 2 years. Other platforms worked on include SAP, Unix, and AS400. Coded in ABAP and modified forms in SAP.

Teach classes in object-oriented programming languages (Java, VC#, VC++, and VB.Net), traditional programming languages (C and QBasic) along with SQL at three different colleges in the metro Detroit area.

Worked in SDLC waterfall method as well as Agile/Scrum.

Selected Accomplishments:

Led Carrier Billing System as Team Leader and Business Liaison. Managed concerns of all stakeholders for projects in the billing system. Designed architecture of system changes. Acted as Project Lead when necessary.

Reduced cycle time for invoice generation from over three days to approximately six hours while making system the most reliable and maintenance free system in the company. No invoice has been late due to system downtime or software in the last 8 years.

Developed the process for moving and converting CICS screens off of the mainframe to a java based Windows portal. Gave presentations and wrote up project for IT staff.

Modified finance system to format and send data to Oracle and SAP systems when Global Crossing was acquired by Level 3. The entire effort took nine months. Previous to the conversion, Level 3 had not successfully completed an acquisition conversion in any time frame over the last five years.

PROFESSIONAL EXPERIENCE

Infosys, Farmington Hills, MI April 2019 – Present

Technical Lead / Mainframe COBOL

Analyze Dealer EFT system for changes needed for APAK implementation

Modified pseudo-conversational CICS programs for dealers

Coded changes in COBOL/DB2/JCL/Easytrieve for bank testing programs.

Did analysis and design for business user projects.

Design DB2 purge process by analyzing 50 tables, designing unload process, SQL purge process, reporting process, and reload process. Create documentation in Word, Visio, and Excel. All done in JCL, PROCS, and PARMS.

Writing COBOL XML parser program to work with decrypted XML file from vendor.

Use QMF/SPUFI for DB2 viewing

Used ENDEVOR as source code management system

Used IBM utilities such as Syncsort, FileAid, Xpediter(batch and CICS) as well as ISPF functions

BB&T Bank, Raleigh, NC August 2018 – February 2019

ADS Developer / COBOL

Worked on Stored Value System as Programmer and Analyst.

Coded changes for systems support in COBOL/DB2/JCL.

Wrote reporting jobs in SAS and Easytrieve

Used SQL Server and Oracle databases

Used QMF/Spufi and DB2 Visualizer for mainframe DB2

Did analysis and design for business user projects.

Century Link Communications, Monroe, LA November 2017 – May 2018

Century Link acquired Level3 in November 2017

Senior Systems Analyst / Developer C#.Net / COBOL

Worked on Credit Acceptance System as Programmer and Analyst.

Coded data layer which processed requests for Oracle and SQL Server data. Coding was done in C#.Net and Visual Studio with LINQ and Pencil.

Used TOAD for Oracle access, QMF Spufi and DBVisualizer for DB2 Access

Modified and created tables as well as relationships between them in SQL Server.

Used Rally for Agile tracking and planning of sprints.

Continued support of IBM batch cycle processing as well as making changes to batch and online COBOL / CICS / DB2 /Java / Sybase system.

Developed Excel testing scripts for online testing

LEVEL3 Communications, Southfield, MI

LEVEL3 Acquired Global Crossing in 2011

Financial Systems Support / Developer C#.Net / COBOL / SAP / Oracle, (2013 – November 2017)

Worked on a number of financial support systems such as the loading of mainframe financials to SAP.

Wrote and tested for extracting and FTPing data to Oracle using COBOL, JCL, Easytrieve

Did unit testing, system testing, acceptance testing for all changes to mainframe coding changes

Wrote a few small ABAP programs mostly for reports.

Used Excel script testing software to test loading of rates and several other financial data.

Continued support and small changes for mainframe batch COBOL / CICS / DB2 / Java / Sybase system.

Technical Team Lead / Analyst / Developer / COBOL / DB2 / Java / CICS, (2011 to 2013)

Functioned as Lead Programmer Analyst for the mainframe Carrier Billing move of financials and any changes to the Carrier Billing system.

Coded pseudo-conversational billing screens in CICS and non-terminal transactions in CICS

Did all system analysis related to extracting the different transactions to fit SAP’s financial system.

Designed all changes to the Carrier Billing System which was heavy COBOL, DB2, JCL, CICS, VSAM, Oracle, Sybase, Java

Wrote all system documentation for changes including business requirements, technical requirements, sign off requirements, Responsible for storing and updating system documentation in repository

Participated in the migration of customers off the mainframe Carrier Billing System. Coded and tested in COBOL / CICS / DB2 / Java / Sybase.

Global Crossing, Southfield, MI

Business Analyst and Liaison / Main Coder, Developer, & Designer / COBOL / DB2, (2006 to 2011)

Scheduled and analyzed changes proposed by business to the Carrier Billing System.

Conducted meetings, prioritized projects, ran team meetings and administration.

Planned changes to the system for minor and major changes to the hybrid batch COBOL / CICS / DB2 / Java / Sybase system. Continued coding on system.

Acted as SME and QA on all major changes to the Carrier Billing System.

Senior System Analyst / Main Coder, Developer, & Designer / COBOL / DB2 / CICS (2000 to 2006)

Senior Technical Lead in the development and maintenance of a mainframe based telecommunication billing system. This involved maximizing system efficiency to process two billion calls per month through running 10 batch billing cycles. It also involved communicating with Unix and Windows servers in the sending of invoices and making this data available to customers in a web based portal application.

Created all SDLC documentation involving business and technical specifications and testing scenarios implementation using Word, Excel, and Visio.

Led a team of 6 direct reports on an administrative basis and teams of up to ten on technical projects.

University of Phoenix, Detroit, MI 2000 - 2015

Adjunct Faculty

Serve as Adjunct faculty in the College of Information Systems and Technology as well as the College of Natural Sciences teaching math. Courses taught include C Programming, VB.Net Programming, Intro to Programming, Java I/II, and SQL for Business.

Give lectures, facilitating discussion, creating lesson plans, assigning and grading homework, and mentoring students in technical subjects.

Developed methods to effectively explain technical concepts to both technical and non-technical adult learners.

Baker College, Clinton Twp, MI 2007 - 2018

Adjunct Faculty

Serve as adjunct faculty in the College of Information Systems and Technology.

Programming classes taught include VB.NET I/II, Java I/II, Intro to Programming, and Intro to Databases

General education courses include Windows, Word and Advanced Word, PowerPoint, Access and Advanced Access, Excel and Advanced Excel.

Administered lectures, assignments, and mentoring.

EDUCATION

M.S.A., General Administration, Central Michigan University, Metro Detroit Campus, MI 8/92 – 5/88

B.A., Computer Science, Eastern Michigan University, Ypsilanti, MI 8/84 – 5/86

B.S., Social Science, James Madison College, Michigan State University, East Lansing, MI 08/80 – 05/83

OTHER ACHIEVEMENTS

Published Author: “Enough C Programming” Lulu.com ISBN 978-1-329-39394-3

PROFESSIONAL DEVELOPMENT:

Duolingo.Com - German Level 8, Spanish Level 7

Udemy - R, ggplot, and Linear Regression

CodeAcademy - Ruby Programming

ADDITIONAL SKILLS:

SAS - Have SAS Studio, University Edition, and have written scripts importing files, connecting to databases, and doing basic analysis

Python - Have IDLE on computer and have written code equivalent to a first or second level college course

REXX - Have REXX interpreter on computer and written basic I/O programs

Example Google Docs:

Aggregate SQL

https://docs.google.com/presentation/d/1O1Uqkqoc-aa7LNkNJIuuTWLtnnSX1AFy6YvyU62LuDE/pub?start=false&loop=false&delayms=3000

Normalization Basics

https://docs.google.com/presentation/d/1aRR-TzeGkFPFs0mW6cv6M2bnG0fbFSJQMuvBs7SoUYk/pub?start=false&loop=false&delayms=3000

YouTube Videos

How To Set Up Your Thumb Drive - https://www.youtube.com/watch?v=IPj-_rDTl2k

Mail Merge For Labels - https://www.youtube.com/watch?v=QKblPtINR-4

Contact this candidate