Matthew W. Merritt

*** *******

Dearborn Heights, Mi. 48127

313-***-****

adwgdx@r.postjobfree.com

Professional Summary

Over 35 years of IT experience in the full Software Development Life Cycle.

My areas of expertise include:

Gathering and analyzing project requirements.

Preparing macro level / High Level Design (HLD) documents, Functional

Specification documents and detailed Program Specification documents.

Application development, unit testing and validation, regression testing as well as

implementation in mainframe production environments. MVS, z/OS.

Performing Integration testing, System testing, and User Acceptance testing.

Preparing detailed Test Plans and Test Cases.

Supporting batch jobs and scheduling using CA-7 Tools.

Project Mentoring and working with end users on post implementation support.

Updating Design & User documents with the changes for the enhancement

projects, and tracking change history.

Providing post implementation support and on-call 24x7 support functions.

Code reviews, Implementation Planning, Customer and end-user training.

Technical Skills

Databases: DB2, IMS, VSAM, Teradata.

Program Languages: COBOL, SQL DB2, IMS DB, TERADATA, CICS

Development Tools: JCL, SQL, TSO/ISPF, FILEAID, ABENDAID, XPEDITER,

SFTP, Connect Direct, SPUFI, IBM File Manager, Debug,

IDCAMS, Syncsort, Queryman.

Methodology Tools: ENDEVOR, PUPS, CA-7

Functional Areas: Finance, Purchase, Inventory

Professional Experience

Ford Credit – Dearborn Michigan

Systems Engineer – 2013-Present

Global Securitization – Loans Pooled into Deals for Investors - 2022-Present

oSystems Maintenance – On-call rotation.

oConvert many programs from Cobol4.2 to Cobol6.3 – Recompile/Test.

oAutomate a Manual file transfers and validation process between FC and GDIA

SFTP, Sort Joinkey, validations, Email success or failure.

Treasury and Finance – 2013-2021

oLKE – Like Item Exchange – Maintain DB2 Tax Deferral by replacing leases.

oCCW – Centralized Check Writing – Maintain Daily & Special Requests. SPUT to banks.

oGLSUM – General Ledger – Maintain sending data to People Soft for accounting.

oDEFT - Dealer Electronic Funds Transfer – Add Comerica to system. Connect Direct.

oConvergence Project –Global DB2 Unicode Transition from EBCDIC.

oModify, Test, Implement system wide Cobol/DB2 pgms

oModify, Test Java Online Manual Entry/Tmass System

Sears Holdings / Kmart Corporation – Royal Oak / Troy Michigan - 1985-2012

Systems Engineer – 2000-2012

Open Item Team – Inventory Maintenance and Reporting System

oIMS to DB2 Conversion Synchronization Process

Corporate wide effort to shut down IMS

Coded and maintained a series of Distribution Center programs to keep

new DB2 tables in sync with the old IMS tables.

This allowed both systems to exist simultaneously for three years.

oEnable Opening unlimited DCs (Distribution Centers)

Corporate wide effort to programmatically allow Kmart to Open unlimited DC’s.

Managed changes to 284 programs affected by IMS Database restructuring.

Led a team of 10 programmers – assigned and verified test results.

Systems Developer – 1985-1999

Total Ownership Reporting System

o Y2K Conversion

Corporate wide effort to convert 2-digit year to 4-digit year.

Interviewed and had input into hiring 4 contractors.

Mentored new hires on standards / procedures which minimized learning curve reducing costs.

oRemove Access Scanner System

CICS/DB2/MQ - Retail outlets scan UPCs using a hand-held remote scanner.

Organized scanner display to include (on-order, on-hand, distribution center stock, last ship date and order quantity). Store can make informed decisions.

Created two versions of program (pilot and production). This allowed for controlled rollouts for specific stores.

Education

Grand Valley State College (1981-1984) - Bachelor of Science – Computer Science

Contact this candidate