Mainframe Programmer Analyst

JOSEPH MICHAEL DUNSEITH

PROFESSIONAL SUMMARY

Programmer Analyst with over 17 years experience in the IT industry. Strong communication and team skills. Technical strengths include over 13 years of COBOL, DB2 and over ten years of IMS experience. Over 10 years experience at Ford Motor Company. Bachelor Degree in Management Information Systems.

TECHNICAL SUMMARY

Languages/Tools: COBOL II, SQL, JCL, SPUFI, CA-7, TSO/ISPF, Easytrieve, Xpediter, ChangeMan, MS Word, MS Excel, CSP, Telon, Endevor, MS Project, ADW, PowerBuilder, HTML, File-Aid, Ford Application Services Shell, GDG, Connect:Direct, DB2 Stored Procedures

Databases: IMS DB/DC, DB2

Environments: OS/MVS, DOS, IBM 390 Mainframe System, IBM/PC Compatible, Windows 2000/XP Professional, Internet, MVS

PROFESSIONAL EXPERIENCE

Ajilon Consulting September 2002 – May 2009

Production Support Duty Analyst

assigned to Ford Credit

Ford Credit Lending Automotive (LA) System

Provided production support for online and batch COBOL/DB2 programs using IMS DB/DC. Provided corrective maintenance for JCL running the batch processing.

Created test data for production fixes and new releases in JCL, COBOL, DB2 and IMS for Ford Credit Lending Automotive (LA) car loan account tracking system.

Supported vendor Lason/HOV Services, solving any connectivity or data integrity issues involving Lason input files and reports. Created customer contact information using Eztrieve to aid Lason in loan customer correspondence.

Supported Securitization application, insuring interfaces such as the Mark/Unmark files are sent intact to Fidelity for processing.

Researched COBOL and DB2 tables and layouts to meet business analysts' testing and support needs.

Manipulated complex files to produce required elaborate test conditions, using Easytrieve, File-Aid, and ISPF editor.

Sent test files to different machines and environments, including PC servers, writing Connect:Direct scripts.

Supported batch processing of new Dealer Finance (DF) System, providing same coverage as LA System.

First point of contact for DF web-based online screens support. Analyzed online issues, often solving clients' problem without having to escalate to web/networking support.

Developed data transmission processes for DF System using FTP and BDT, going to PC servers and other mainframe applications.

Single point of contact for Ford Credit LA car loan account tracking system. Responsible for LA system receiving lockbox credit account transmissions from participating banks.

Provided timely support to bank and LA system vendor (Fidelity Information Services, formerly Alltel) to ensure that customer credit account information is processed daily.

Provided single point of contact support for Europe LA nightly batch cycle, including support for United Kingdom and Germany.

Maintained excellent communications and follow-up with clients and supervisors, keeping them in the loop on current problems and issues.

Knowledgeable and mentoring resource in the area of the creation and transmission of test data through Connect Direct.

Set up and executed the Volvo Legacy Lockbox conversion project for LA system.

Produced complex Easytrieve reports for use by business analysts.

Languages/Tools: COBOL II, SQL, JCL, CA-7, TSO/ISPF, Easytrieve, Xpediter, ChangeMan, MS Word, MS Excel, File-Aid, Ford Application Services Shell, GDG, Connect:Direct

Databases: IMS DB/DC, DB2

Environments: OS/MVS, DOS, IBM 390 Mainframe System, IBM/PC Compatible, Windows 2000/XP Professional, Internet, MVS

Synova February 1999 – August 2002

Senior Programmer Analyst

assigned to Ford Motor Company Vehicle Management System

Enhanced the systems by coding new IMS DB/DC programs and JCL. New programs included new financial reports, new IMS online screens that maintained new DB2 tables and GDG, and new processing of vehicle data from other financial systems.

Created new JCL for specific scheduling needs.

Maintained DB2 stored procedures that interface with Web front-end system.

Created programming specifications for new programs or program changes, having gathered the raw information and requirements from a customer or from lead analyst.

Coded the program or modify the program according to the specs using the Ford Application Services Shell.

As Production Support Lead, received production support requests, working with customer analyst to prioritize hottest issues.

Delegated normal production support tasks to CVMS programmers.

Maintained a balanced workload for programmers to maximize whole group's productivity. Continued to be available as resource for direction and questions on said tasks.

Trained new group members on CVMS screen and batch program basics.

Addressed emergency issues and provided immediate customer feedback on resolution options and time.

Provided production support for two financial systems: Company Vehicle Management System (CVMS) tracks employee and studio lease vehicles including their initial order from assembly, maintenance, transfer to another employee, and eventual disposal/sale. Personal Accounts Leasing (PALS) tracks how the lease vehicles are paid for, such as monthly employee payroll deductions.

Provided production support for online and batch COBOL/DB2 programs using IMS DB/DC. Provided corrective maintenance for JCL running the batch processing.

Responded to customer requests for functional problems with the system, providing timely solutions.

Assisted customers that were having problems processing specific lease vehicles through the system.

Support was also provided for several financial reports, most of which ran at month end.

Analyzed and modified datasets for customers using File-Aid

Languages/Tools: COBOL II, SQL, JCL, CA-7, TSO/ISPF, Xpediter, ChangeMan, MS Word, MS Excel, File-Aid, Ford Application Services Shell, GDG, Connect:Direct, DB2 Stored Procedures

Databases: IMS DB/DC, DB2

Environments: OS/MVS, DOS, IBM 390 Mainframe System, IBM/PC Compatible, Windows 2000/XP Professional, Internet, MVS

EDS September 1995 – February 1999

Information Analyst

assigned to General Motors NAO Finance

Created and modified technical designs for online and batch COBOL DB2 programs for GM’s Worldwide Product Costing System.

Implementation Analyst: responsible for creation of JCL and datasets for new assembly and component plants. Developed work breakdown task list for new overseas plant implementation including measurable milestones that were met on time.

Successful production support troubleshooter - Provided quality control by participating in program and technical design walkthroughs. Contributed support and solutions during month-end peak processing using knowledge/skills associated with scheduling of month-end jobs.

Conducted two successful disaster recovery drills involving customer interaction.

Extensively revised implementation documentation for putting new plants into costing system. Organized the documentation into easy to read, logical segments.

Mentored resource within the group, provided direction and technical assistance to new team members.

Languages/Tools: COBOL II, SQL, JCL, SPUFI, CA-7, TSO/ISPF, Xpediter, MS Word, MS Excel, Endevor, HTML, File-Aid, GDG

Databases: DB2

Environments: OS/MVS, DOS, IBM 390 Mainframe System, IBM/PC Compatible, MVS

Covansys January 1993 – August 1995

Programmer Analyst

Analyzed and modified COBOL II source code for Employee/Payroll/HR systems, using ISPF and Endevor. Supported project planning for the Employee Group using MS Project.

Involved in the system design of the NOMADS Project for the State of Nevada Welfare Division, working with ISSC (IBM) using the CASE tool ADW.

Worked with IBM on a project for the State of North Carolina for automating the Child Support System using TELON and COBOL II.

Created applications in CSP (Cross System Product) for the Michigan Department of Natural Resources.

Created a client/server demo system using PowerBuilder, including server/hardware setup and documentation.

Languages/Tools: COBOL II, SQL, JCL, TSO/ISPF, Xpediter, MS Word, MS Excel, CSP, Telon, Endevor, MS Project, ADW, PowerBuilder, GDG

Environments: OS/MVS, DOS, IBM 390 Mainframe System, IBM/PC Compatible, MVS

Research Data Analysis Inc. March 1992 – November 1992

Programmer

Managed computer survey project for Chrysler, including pen interface computer setup and direct customer involvement.

Languages/Tools: MS Word, MS Excel, ABase (internal survey collection language)

Environments: DOS, IBM/PC Compatible, Windows

EDUCATION

Bachelor of Science Degree in Management Information Systems, Minor in Computer Science 1991

Oakland University

Contact this candidate