Robert J. Routh
7820 Ridgeway
Raytown, Mo 64138
816 737-2121
Robertr0@yahoo.com
Confidential Resume
Professional Summary
Robert is a Sr. Programmer/Analyst with over 20 years of MVS mainframe
development experience including 20 years of experience using COBOL and DB2. He
possesses over six years of experience using CICS using VSAM and DB2. He is
experienced using JCL and TSO/ISPF (20 years using both). Robert is adept
providing extensive development, testing and enhancements.
Technical Experience
Software Tools:
DB2 Version 9, IBM Enterprise COBOL Z/OS 4.1.0, NDM, FTP, SQL, Z/OS, TSO/ISPF,
CICS, QMF, SPUFI, Syncsort, Fileaid, VSAM, Expediter, Intertest, Viasmart, CSP,
Librarian, Eztrieve, Total, SUPRA, SAS, Mantis, Visual Basic, File Marvel,
Comparex, DATACOM DB, CASE TEAMWORK/SA, TEAMWORK/SD, Yourdon and Demarco
Methodology System Design. Microsoft Office, Excel, MS Word, WeBuilder 9.41,
Coffee Cup HTML Editor 2008, DreamWeaver CS4
Operating Systems:
MVS/ESA, Windows 2000/XP/Vista, DOS
Relevant Project History
Independent Consultant Feb 2009 to Present
Web Master
· Designed and wrote web pages for clients using Adobe Dreamweaver and Microsoft
SharePoint Designer.
· Used Corel Draw to edit jpg files so they would load faster on Web pages.
· Tested Web pages
· Used FTP to upload Web pages
Technisource, Kansas City, MO Feb 2008 to Jan 2009
Client: DST Senior Programmer/Analyst
· Conversion of Hartford Retirement System from Excel files to DB2.
· Utilized NDM to transfer files to other companies and other nodes
· Responsible for writing 8 COBOL/DB2 programs.
· Wrote proc's, JCL, overrides, sort controls and test scripts for the COBOL/DB2
programs.
· Unit tested the Cobol/DB2 programs.
· Modified 4 Cobol/CICS/DB2 programs.
· Modified 2 COBOL subroutines.
· Reviewed, analyzed, validated and tested files data from Hartford Insurance
· Compared files to production files for correct size/name/format in a
batch environment.
· Worked with Hartford to migrate data from Excel files to DB2.
Technisource, Kansas City, MO Feb 2007 to Feb 2008
Client: Waddell & Reed Senior Programmer/Analyst
· Responsible for maintenance for mutual funds and insurance systems
· Utilized NDM to send/receive files from DST
· Utilized FTP to send production files to various clients
· Responsible for COBOL/DB2/VSAM development and maintenance.
· Responsible for correcting invalid data in user files
· Created 4 new programs that created a report and a comma delimited data file
for Excel. Reported sales by state and year.
· Responsible for creating proclib, procdata and job cards for new jobs.
· Performed unit testing
· Performed writing test plans.
· Responsible for using Visual Basic in Excel to trap errors.
· Created automated program that updated user-defined field on security master
file.
· Designed and wrote 529 Quarterly Summary Project that reported 529 data to
Arizona.
Comsys, Overland Park, Ks July 2005 to June 2006
Client: JP Morgan, Kansas City, MO Consultant
· Saved JPMorgan 99.9 CPU hours and one million dollars by converting their
statements processing to COBOL/DB2
· Moved FTP from statement processing to stand-alone because the records were
single threaded.
· Responsible for optimizing 12 SQL programs, and 8 sorts.
· Extensive SQL usage to access the database.
· Rewrote 8 Sun guard programs so they accessed DB2
· Split sorts and backup from 1 to 19 so they could run concurrently
· Created JCL and Proc’s for new programs.
· Performed unit testing on the applications.
· Worked on SunGard conversion
· Analyzed and validated data for statements processing
· Reviewed, analyzed and tested files. Comparing them to production files for
correct size/name/format in a batch environment.
· Migrated data from flat files to DB2.
TEK Systems, Overland Park, Ks Nov 2004 to May 2005
Client: Blue Cross and Blue Shield of Kansas, Topeka, KS Systems Analyst
· Developed a COBOL/DB2 load program.
· Performed extensive analysis of Medicare system change from VIPS to MCS.
· Utilized spreadsheets extensively to track all test and production Medicare
jobs from IBM.
· Extensive user interaction. IBM’s File Manager Aid and Sync Sort for data
extraction.
· Created JCL and Proc’s for new report programs for test and production.
· Created VSAM files and VSAM files with alternate indexes.
· Performed unit testing.
· Used Changeman for application life-cycle management.
· Extensive Systems Analysis
Comsys, Overland Park, Ks Dec 2003 to Nov 2004
Client: Associated Wholesale Grocers, Kansas City, KS Senior
Programmer/Analyst
· Developed 25 new COBOL2/DB2 programs.
· Created JCL and Proc’s for new programs.
· Performed unit testing on the applications. Utilized IBM DEBUG for debugging
programs.
· Extensive SQL usage to access the database.
· Utilized IBM’s File Manager and File Manager for DB2 for data extraction
· Loaded eight DB2 tables with data.
· Developed 12 new CICS/DB2 programs.
TEK Systems, Overland Park, Ks July 2001 to May 2003
Client: Blue Cross/Blue Shield of Kansas, Topeka, KS Senior
Programmer/Systems Analyst
· Supervised four BC/BS employees.
· Converted 75 COBOL batch programs that use flat files to COBOL/DB2 cursor
select processing.
· Suggested improvements on SQL performance
· Created JCLs and Proc’s for new programs.
· Wrote program that converted BCBSKS claim format to Washington FEP Modified
FEP Claim Record format using COBOL II and DB2.
· Wrote separate subroutines that call professional provider services, call
outpatient institutional provider services, and call inpatient institutional
provider services.
· Utilized COBOL II and DB2 to write a program that determines type of payment
response data received back from Washington and match it with BCBSKS claim data
· Wrote subroutine that updates all fields.
· Taught FEP a class on SQL.
· Created copybooks.
· Provided troubleshooting for program and SQL problems and fixed programs that
did not work correctly.
· Created JCL and Proc’s for new programs.
· Performed unit/system testing.
· Utilized File-Aid and Syncsort for data extraction.
· Reviewed, analyzed and tested files. Then compared them to production files
for correct size/name/format in a
batch environment.
· Experience working with customers to migrate data from flat files to DB2
MidWest Consulting Group, Sept 2000 to Feb 2001
Client: American Century Investments, Kansas City, MO Senior
Programmer/Analyst
· Conversion from in-house mutual fund processing to DST mutual fund processing.
· Conversion from flat files to DB2 load files and loaded DB2 databases.
· Discovered and corrected problems with record layout for DB2 load.
· Wrote four matching programs that accessed DB2, wrote exception files for
unmatched records.
· Utilized File-Aid and Syncsort for data extraction.
TEK Systems, Overland Park, KS March 1999 to Sept 2000
Client: Sprint Corporation, Overland Park, KS Tester
· Provided extensive system testing and analysis of how changes affected
different interfaces.
· Established different environments to do system tests.
· Loaded/unload DB2 databases.
· Loaded/unloaded ADABAS databases.
· Wrote system test plans.
· Established and executed required processing.
· Documented issues encountered during system tests.
· Extensive client involvement.
· Extracted data from production for system testing using File-Aid and
Syncsort.
DHS & Associates, Overland Park, KS April 1998 to March 1999
Client: Payless Cashways, Kansas City, MO Senior Programmer/Analyst
· Developed 14 new COBOL II/DB2 batch programs.
· System tested 40 existing COBOL/DB2 batch programs for Y2K using Endeavor.
· Created JCL and Proc’s for all new programs. Three new programs corrected
invalid data in DB2 database.
· Developed additional new programs including sales report programs, accounts
assigned to multiple representatives, sales summaries, sales rep incentive, sales
recap, sales ranking, projected sales, and monthly insurance premiums for bonus
and commissions, and affirmative action programs.
· Extensively utilized SQL.
Best Computer Consultants, Overland Park, KS June 1995 to April 1998
Client: DST Systems, Kansas City, MO June 1997 to April 1998 Software
Engineer
· Developed 77 EZtrieve programs that access various flat and VSAM files.
· Wrote two COBOL/VSAM matching programs that read one VSAM files sequentially
and randomly read another VSAM file for matching keys.
· Provided analysis of three complicated mutual funds programs to add logic and
fields for future enhancements.
· Wrote batch COBOL/DATACOM/DB2 programs.
· Enhanced five COBOL/CICS/VSAM programs and maps.
· Utilized File-Aid, Syncsort and SQL for data extraction.
· Utilized NDM for file transfers to different companies
Best Computer Consultants, Overland Park, KS
Client: Yellow Technologies, Overland Park, KS Feb 1997 to June 1997 Senior
Programmer/Analyst
· Enhanced eight CICS/VSAM programs that use new MCMS employee file.
· Wrote four programs that converted VSAM vehicle maintenance files to VSAM MCMS
equipment file.
· Researched and enhanced two VSAM report programs that were printing wrong
data. Enhanced three CICS/VSAM programs that passed data to AS400.
· Wrote new payroll program that pulled off data by date and other criteria.
· Wrote test plans and JCL for new programs.
· Performed unit/system testing.
· Extensive user involvement.
· Wrote program that converted VSAM vehicle maintenance mechanic file to
Maintenance Control and Management System (MCMS) VSAM employee file.
Best Computer Consultants, Overland Park, KS
Client: Sprint Corporation, Overland Park, KS June 1995 to Jan 1997 Senior
Programmer/Analyst
· Coded and tested Volume term discount and Volume term discount allocations
project.
· Wrote 12 COBOL/DB2 programs, JCL, File-Aid, Syncsort, Proc’s, overrides and
migrations. Sprint said this was the best, fastest and easiest installation they
had ever done. Project was submitted to Sprint's Board of Directors and to
Malcolm Baldridge for Quality Award.
· Enhanced complex programs that navigated the entire database and corrected
program problems.
· Developed new program that determined cost on all the telephone circuits
Sprint used. They were able to go back to local telecommunication companies and
get refunds of millions of dollars per month because program proved Sprint was
using the cheaper circuits instead of the more expensive circuits.
· Wrote reports that accessed DB2 database.
· Extensive SQL usage.
Century Computer Consultants, Overland Park, Ks April 1993 to April 1995
Client: Marion Merrill Dow, Kansas City, MO April 1994 to April
1995 Senior Programmer/Analyst
· Enhanced Bid Award Notification System, consisting of four Report/EDI programs
using COBOL II/DB2/SQL and translator for EDI.
· Reported changes, deletions, and additions of members and products per
contract.
Century Computer Consultants, Overland Park, Ks April 1993 to April 1994
Client: Universal Underwriters, Overland Park, KS Senior Programmer/Analyst
· Performed Systems Analysis and created DB2 databases.
· Converted multiple insurance systems flat files to batch DB2.
· Coded four new report programs accessing new DB2 database. Programs summarized
data by account, nationwide totals, and regional totals.
· Performed unit/system/user acceptance testing. Several groups failed to
accomplish this process.
· Extensive user involvement and SQL usage.
Source EDP Aug 1992 to Jan 1993
Client: DST Systems, Kansas City, MO Senior Programmer/Analyst
· Enhanced 12 CICS/VSAM programs to CICS/DATACOM/DB/COBOL II.
· Developed new CICS/DATACOMDB/COBOL II program.
· Enhanced four existing CICS/DATACOM DB programs.
· Developed 17 BMS/GT maps from screen prints.
· Utilized SQL.
· Utilized NDM to transfer files to different companies
Computer Sciences Corporation Sept 1988 to Aug 1992
Client: United States Air Force October 1991 to August 1992 Senior
Programmer/Analyst
· Stock Control and Distribution System (inventory) in Dayton, Ohio.
· Protected Computer Sciences from $1 billion lawsuit by finding errors that
caused inventory shortage.
· Troubleshooter for onsite programmers at five Air Force Logistic Centers
around the country.
· Extensive user involvement and SQL usage.
Client: Cincinnati Gas & Electric Financial Group April 1990 to October 1991
Senior Programmer/Analyst
· Accomplished System Design, Systems Analysis and coding for Detail Correction
process that utilized CASE/COBOL II/DB2/CICS in IBM MVS/ESA environment.
· Showed header records; detail records based on certain criteria.
· Allowed user to correct records online.
· Developed CASE/COBOL II, Batch Cash Refund program.
· Read DB2 payment tables for billing overpayments, refund of security deposits,
and writing batch checks to customers.
· Performed unit/system/user acceptance testing.
· Extensive user involvement and SQL usage.
Client: AT&T September 1988 to April 1990 Senior Programmer/Analyst
· Developed DB2/COBOL personnel database which tracks/monitors employee
histories, skills, and training. Wrote nine DB2 report programs.
· Reviewed user requirements for conversion of the system from RAMIS VM/CMS
environment to DB2/SQL.
· Recommended enhancements.
· Performed unit/system/user acceptance testing.
State of Kansas, Topeka, KS Jan 1985 to Sept 1988 DBA/Programmer
· Responsible for all batch and online applications of water tracking
environmental system, all DBGENS and record layouts.
· Converted TIS database to Supra (similar to DB2).
· Responsible for integrity of test and production databases.
· Designed and coded online Water Utilities Control and Tracking System (order
entry); unloaded, repaired and reloaded Supra, TIS, and TOTAL databases.
· Top Secret Security Administrator.
|
