FRANK WHELAN

St. Louis, Missouri

314-***-**** adee02@r.postjobfree.com

Remote RPG/COBOL Developer

Over 20 years of staff augmentation experience using RPG and COBOL. Over 20 years years development experience with MVS/COBOL. Over 20 years with IBM I Series ( AS400 ). Over 5 years experience with IBM I Series COBOL.

Strengths include productivity and adapting to new situations, ability to work with all team members.

Both screen development and batch jobs, all dialects of RPG. Including DB2 and embedded SQL, stored procedures, and MQ. Extensive use of BCD Progen and trained in WebSmart. Every client has demonstrated that they would welcome my return. Over 20 years working with warehouse management or order entry and distribution.

TECHNICAL COMPETENCIES

PROGRAMMING

IBM I also known as AS/400

RPG RPGII RPGIII RPGIV RPG Free

Embedded SQL

COBOL S/36 COBOL

DB2 IFS Commitment Control DDM Files MQ Trigger Programs Stored procedures

ILE Service programs, procedures, activation groups, binder language

SQL tuning

Multiple LPARS Data Queues Stream Files

CLP CLLE OCL

batch, interactive, sub files

Scan Optics page scanner on HP mini computer

SOFTWARE

IBM Job Scheduler

Help Systems ROBOT

Aqua Data Studio

Hawkeye – Cross Reference Tool

DBU – Data Base Utility

DFU – Data File Utility

RDI – Rational Developer for the I

Implementer – Change Control

Aldon – Change Control

TL Ashford – Labels,

Bar Codes, RF Guns

Secure FTP

GoAnywhere

Middle-ware interfacing Iseries to Java

IBM Navigator

CA1

CA7

CA11

Frank Whelan Resume Page 2

SQL Scripts

SQL Access Plans / Visual Explain

SQL Suggested Indexes

SQL Stored procedures

Scan Optics 540 Data Capture

Conveyor system wedge bar-code scanner

IBM Client Access

Reflections 5250 Emulator and FTP

APPLICATION/DEVELOPMENT SOFTWARE

Progen Plus – RPG Generator - Extensive use

Interfaces to:

Mapics XA

Marcam Prism

JDE Fixed Assets

BOSS

Training, some familiarity

Websmart - See Bradford & Galt below

HTML

Java

Javascript

IBM Mainframe Skill-set

COBOL

Easytrieve

JCL

VSAM

SYNCSORT

DB2

IMS/DB

CICS

Participated in 3 DOS/VSE to MVS conversions.

Frank Whelan Resume Page 3

EMPLOYMENT HISTORY

INDEPENDENT CONTRACTOR, St. Louis, MO 12/2016—Present

Programmer/Analyst

·Provide remote support for a mortgage banking company using RPG, all dialects, SQL.

·Maintain screens and create programs to automate creation of letters via RJS Software Systems replacing IBM Office Vision letters.

·Work with business people to better understand requirements of their submitted request.

·

·Meridian Power Group Keller Schroeder 03/2019 – 09/2019

·Programmer/Analyst Contracted to:

·ONE MAIN FINANCIAL, Evansville, Indiana

· . Analysis, programming projects to enhance CLASS applications using COBOL on the IBM I. I Develop technical specifications from the requirements document.

· Code and test changes using COBOL.

· Work with QA team to validate changes.

infrastructure included Legasuite GUI, Rational for the I, MQ, Aldon change management.

CIBER, INC., St. Louis, MO 08/2003—12/2016

Programmer/Analyst Contracted to:

REDDY ICE, Dallas, TX 10/2016—12/2016

·Member of team brought in to document EDI processes after installation of new Microsoft Dynamics ERP system resulted in missing invoicing for Alaska customers.

·Confirmed findings were in alignment KPMG findings.

·Provided on-site and remote expert analysis and programming solutions, identifying and reading code to build data flows for EDI transactions 810, 820, 850, 864, & 880.

·Met with company CEO and officers to review findings

·Met with KPMG consultants to discuss each other's findings

ELSEVIER, INC., St. Louis, MO 08/2013—08/2016

·Support new BOSS warehouse management software interface to DELTA publishing software order entry application between Linn Missouri distribution center and the order entry processing performed in the UK.

·Processed test scenarios as requested by the DELTA test team to simulate ship confirms, returns, and pick plans. DELTA is a type of publishing industry software.

·Created programs to interface with a wedge bar code scanner attached to the conveyor and the Iseries box to confirm floor spots.

·Created excel spreadsheets and reports from RPG using SQL and Iseries IFS commands.

·Extensive use of RPGIII, RPGIV, RPG Free, ILE, sub-files, SQL, FTP, IFS, DFU, Aldon.

Frank Whelan Resume Page 4

AUSTIN NICHOLS TECHNICAL SEARCH, Kansas City, MO 01/2012—08/2013

Programmer/Analyst Contracted to:

JB NUTTER, Kansas City, MO

·Facilitated change from Office Vision to RJS for creating collection letters to enhance loan loss mitigation.

·Improved screen functionality so users could access the bulk of information needed without changing to other screens.

·Improved the claims processing functionality that sped up the request for federal mortgage funds.

·Wrote program for marketing that identified borrowers who would benefit from refinancing.

·Moved from an all manual process to an application utilized across departments for forward wires to pay off mortgages, greatly reducing man hours needed, especially during peak end-of-month closings.

·Used RPG, all dialects, sub-files, SQL, secure FTP, Go Anywhere.

CIBER, INC., St. Louis, MO 11/2006—12/2011

Programmer/Analyst Contracted to:

ELSEVIER, INC., St. Louis, MO 03/2011—12/2011

·Worked on service requests to improve the efficiency of BOSS warehouse management screens interfacing with COPS order entry system running on Z/OS.

·Worked with distribution center management to standardize function keys across all screens to improve user efficiency.

·Removed thousands of unneeded records from the inventory master file.

·Extensive use of sub-files, SQL, FTP, IFS.

ACTIVE OUTDOORS, Jefferson City, MO 09/2009—03/2011

(Provider of automated fulfillment of hunting and fishing licenses for 26 states and Ontario province, plus boat and snowmobile licensing)

Florida Wild Hog Lottery

·Assisted in set up of lottery parameters for awarding wild hog hunting licenses in Florida.

Wisconsin Citations

·Reformat records to facilitate vendor changeover.

Province of Ontario

·Worked to help establish new Ontario account, loading 34 million history records.

·Supervised overseas employee for programming work.

Frank Whelan Resume Page 5

SAVE-A-LOT, Earth City, MO 11/2006—09/2009

. Supported Iseries COBOL programs interfacing to order entry and warehouse management software.

·On team that replaced expensive ($1M/year) warehouse system with in-house system that had better functionality and flexibility.

·Reduced product spoilage and waste by permitting smaller package orders.

·On team to modernize Iseries processing to interface with Java front end.

Extensive use of DB2, SQL, Aquadata Studio, ILE, Implementer.

BRADFORD & GALT, INC., St. Louis, MO 03/2002—09/2006

Programmer/Analyst Contracted to:

MALLINKRODT, St. Louis, MO

·Wrote most of the programs for a new radio-pharmaceutical distribution system using Progen Plus. Initial design was to use Websmart.

·Also included RPGIV, RPGIII, SQL, DB2, Implementer, interface to JDE orders from another LPAR, Mapics XA, TL Ashford Bar Code software, IPDS Printers .

Adherence to CGMP, FDA validation, DOT regulations, NRC regulations,

SPHERION, St. Louis, MO 01/1986—09/2001

Programmer/Analyst Contracted to:

HUBBLE POWER SYSTEMS, Centralia, MO 10/1998—08/2001

Change screens and programs to adapt DATA3 ERP to client's processes.

Work with interfaces to AP, order entry, warehouse distribution.

Environment IBM I, RPG.

RALCORP, St. Louis, MO 09/1997—09/1998

Verify NDM processes worked successfully.

Change and test interfaces to manufacturing plants. Gl, Order Entry.

Investigate program errors at direction of project manager.

MVS to Iseries conversion project.

Environment was IBM I, IBM Z/OS. RPG, COBOL DB2 FOCUS

Frank Whelan Resume Page 6

MALLINKRODT, St. Louis, MO 06/1988—08/1997

Disk space, DSN format enforcement. Apply software changes.

Wrote one assembler program.

COBOL, Easytrieve support.

DOS/VSE to MVS conversion.

MVS to AS400 conversion

Fixed assets support using MSA on MVS, JDE on AS400

Environment was DOS/VSE, MVS/XA, AS400 using SMP, other CA software products,

COBOL, Easytrieve, RPG

JEFFERSON SMURFIT 01/1986—05/1988

Change and test programs using MVS RPG, COBOL

DOS/VSE to MVS/XA conversion.

Change and test programs using Easytrieve.

Environment was DOS/VSE, MVS/XA.

State of Illinois Department of Mental Health and Development Disabilities

06/1975-01/1986

Change and test programs using COBOL, Easytrieve, IMS DB, CICS

Change and test programs for Scan Optics 540 page scanner.

Change and test programs for key to disk software.

Contact this candidate