Don Hanson

www.linkedin.com/in/donhansonit

PROFESSIONAL PROFILE: IT professional with 25+ years of Mainframe development and support experience including experience with COBOL, JCL, CICS and DB2, as well as 3 years of SQL Server experience, including Transact-SQL. Applications supported included Health Care, Supply Chain Systems, Financial Systems, and Payroll/HR Systems. Comfortable with Agile and Waterfall SDLC methodologies.

Software Programming Languages:

COBOL

CICS

JavaScript

JCL

FOCUS

Transact SQL

Easytrieve

HTML/CSS

Databases/DB Tools:

DB2

IMS

SQL Server

Datacom

VSAM

SPUFI

Desktop Tools:

Word

Excel

Access

PowerPoint

Visio

Outlook

EXPERIENCE

Software Engineer, Target (contractor) Brooklyn Park, MN 4/2018 – 12/2020

Worked on Target Red Card migration project to convert Target’s credit card Statements and Letters systems from a mainframe system to a Java/Oracle system. I researched job flows and data flows, using JCL, COBOL programs and CA-7 to assist Java programmers to determine how to create a client-server set of programs and processes to replace the existing mainframe systems that would print credit card statements and letters.

Designed and wrote JCL and modified conversion programs to extract ACAPS data, converting the VSAM files into flat files and ftp’ing them from mainframe platform to client server platform. This involved extracting, transforming, and sending over 18 years of daily credit card application information (over 6,700 files). Used JCL, Syncsort and various parameters and Endeavor to create a system to partially automate this process. Part of this work also included cleaning up data discrepancies that arose when the data formats changed or data anomalies were discovered. I also tracked this process on an Excel spreadsheet which was downloaded to SharePoint.

Researched hundreds of mainframe reports on CA-View/CA-Delivery to determine report formats, layout, data requirements, run frequency, and report distribution while assisting Java programmers in determining how to re-create these reports on a client-server platform.

Worked on migrating the Standard Batch process from mainframe platform to Java platform, replacing VSAM files with text files and Json files for approximately 125 record types.

Programmer Analyst, USPS (contractor) Eagan, MN 5/2016 – 2/2018

Worked on Payroll modernization project to convert a USPS Rural Mail Carriers payroll subsystem that is used to perform rural route evaluation that is used to calculate Mail Carriers’ pay. System is being converted from a mainframe VSAM file system to an Oracle database distributed system. Created several Visio diagrams showing data flows between various subsystems. Created detailed Excel spreadsheets on over 100 reports listing report creation, timing, content and distribution.

Designed and coded a COBOL program to extract data from a VSAM file (approximately 7 million records), reformatting the data and copied the file onto a DVD to ship to St. Louis to load into Oracle tables. Created a report showing data discrepancies so they could be resolved.

Analyzed several COBOL programs and FOCUS programs to determine what fields needed to be extracted from Oracle tables and put on mainframe files so other downstream systems could continue to function in the same way when the original feeder files are no longer created.

Programmer Specialist at LSI Corporation of America Plymouth, MN 10/2015-10/2015

Wrote-COBOL programs to create and maintain a Customer Contact system

Wrote a COBOL program that used to look up information on the company’s Production Jobs

Was laid off when company went bankrupt shortly after being hired.

Seasonal Tax Pro, H&R Block Chicago, IL Jan-April 1985-1990/Brooklyn Park, MN Jan-April 2002-2020

Using H&R Block proprietary software, prepared Federal and State income tax returns

Sr. Mainframe Developer/Analyst, ESI (contractor) Bloomington, MN 9/2012 – 1/2015

Extracted, transformed, compressed and sent 1 billion records (in over 1 thousand files) for DHL (Data History Load) project for Express Scripts, Inc. merger with Medco

Improved unload jobs performance 25% by modifying the IBM unload parameters depending on the DB2 tables being unloaded

Wrote Excel macros, used Excel functions, and wrote programs to automate tracking, for data reconciliation requirements, and to create ftp parameter cards

Researched and fixed records that failed to load into DB2 tables, including reviewing COBOL programs for data mapping gaps

Mentored newer team members and created documents to provide them with useful reference information

Used Endevor and Tivoli Workload Scheduler to implement production installs

Software Engineer, Wells Fargo (contractor) Minneapolis, MN 10/2011 - 6/2012

Supported the Wells Fargo/Wachovia Electronic Windows (EW) conversion project by modifying JCL and running jobs to copy data between DB2 regions and creating test files to assist in testing

Facilitated pre-UAT meetings between developers, testers, QA personnel, and project management personnel

Modified JCL, including changing SQL selection criteria, and ran jobs to assist testing efforts and used ftp to copy files to SharePoint sites as well as providing updates on same SharePoint sites

Compiled information on numerous mainframe batch jobs to perform post-conversion BAI Monitoring by verifying job completion, file creation and file transmissions

Extracted data from the Transaction Depository (TD) in order to perform batch program testing

Programmer Analyst, Parker Hannifin (contractor) Golden Valley, MN 12/2010 - 9/2011

Modified JCL and COBOL (batch, CICS, IMS, and Telon) mainframe programs to support Parker Hannifin’s Quick Coupling Division of the Fluid Connector Group, including modifying CICS programs that printed Purchase Order and Quotation forms after meeting with users to determine their requirements

Researched several CICS and Telon programs and documented programs to fix a Foreign Currency problem for Purchase Orders using a vendor in another country

Modified several batch programs changing the output from a report to a delimited text file that was input into Excel for analysis by the Accounting Department

QA Infrastructure Analyst, ESI (contractor) Bloomington, MN 3/2010-12/2010

Provided DB2 environmental support for several DB2 regions by unloading data from one DB2 region and loading into another region as needed

Frequently worked with millions of rows of data for up to 25 different tables

Worked directly with users to narrow down the amount of data needed as most of these DB2 regions could not be brought down to load the data

Created Excel spreadsheets to log unload and load statistics

Ran jobs to move and bind DB2 programs to various DB2 regions inside of Endevor

Ind. contractor at Brandspring Solutions Eden Prairie, MN 1/2009 – 3/2010

Migrated client data from Navision to Wonder Pay for billing and administration processes

Used Remote Desktop to log onto different servers to perform various functions, including using Active Directory, SQL Servers, Altiris and Navision

Developed procedures to update SQL Server tables using Transact-SQL, and other procedures using Excel to monitor customer support issues

Wrote stored procedures and custom views to analyze data as well as used DTS to export data to Excel spreadsheets

Added content to websites using content management software such as AspDotNetStoreFront, and an internal proprietary CMS package which occasionally required adding HTML code

Senior Programmer/Analyst, SUPERVALU (contractor) Eden Prairie, MN 6/2006 – 12/2008

Provided production support for SUPERVALU’s Supply Chain Systems, Logistics Control Systems, and Division Accounting with rotating pager duty providing 24 by 7 coverage

Analyzed several job streams and programs to develop a data-mapping document that was used to identify flaws in the flow from external data sources

Created Service Requests to provide solutions for various Supply Chain problems, changing JCL, COBOL programs, and CA-7 schedule as needed

Logged onto warehouse servers in order make SQL Server table changes as needed, and stop/start/restart Server jobs, wrote and modified SQL Server stored procedures

Other companies worked at include RBC Dain Rauscher, Target, Nash Finch, ACS, Piper Jaffray, American Express Financial Advisors, Dayton’s, and Marshall Fields.

EDUCATION:

Bachelor of Science, Northern Illinois University (DeKalb, IL) in Mathematics

A.A.S. degree from Hennepin Technical College (Eden Prairie, MN) in Web Programming

Certified Microsoft Database Specialist from Hennepin Technical College (Eden Prairie, MN)

Contact this candidate