SUMMARY

• 30 Years of IT experience in Confidential AS400 (iSeries) applications in analysis, design, development, maintenance and testing using OS/400, DB2/400, RPG/400, RPGILE, RPGIV, RPGIII, RPGII, SQL, CL/400, QUERY/400, BASIC, DBU.
• Proficient in program creation and support, DDS, SDA, Subfiles, System Operations and Hardware configuration and installation.
• EDI Trusted Link experience.

TECHNICAL SKILLS

HARDWARE: IBM i - Series, AS/400, PC 

OPERATING SYSTEMS: IBM OS/400, CLP, DOS, Windows

DBMS: IBM DB2/400

LANGUAGES: IBM RPG, RPG IV, RPG ILE, RPG Free, SQLRPGLE, CL, SQL, COBOL

UTILITIES: SDA, PDM, SEU, DFU, RLU, MQ Series, Websphere, RDI and Query

APPLICATION SOFTWARE: PRMS, Lawson, Warehouse Boss, Friedman

EXPERTISE: RPG / CL Program creation and modification, File (DDS)(DDL) support, EDI X12 Trusted Link, SQL and RPG free Subfiles, Open Query Files, Security Officer tasks, hardware configuration

AS/400 TOOLS (Change Mgmt): Hawkeye, Implementer, Aldon, DBU, TurnOver, Abstract, ROBOT

OFFICE AUTOMATION TOOLS: MS Office, VISIO

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

• Part of a large programming group dedicated to upgrading custom health insurance software.
• The largest program touched was around 80,000 lines.
• Program upgrade involved making programs more modular, files were changed to SQL generated DDL files.
• Some of the work was done in an Agile environment.
• This site has a test environment as well as several production sites. On site 5 days / week, remote 5 days/week.
• This medical establishment has 80,000 employees, including 1000 MD’s.

Environment: SQLRPGLE, RPGLE, CLP, Query, DB2/400, on Confidential AS400 (V7R3), (i-Series)

Confidential - Richardson, TX

Programmer/Analyst

Responsibilities:

• The general goal for Frontier is to improve program efficiency because of a huge increase in the customer base.
• Modify programs to reduce flat file usage and use a relative database model.
• Part of a large programming group.
• New coding involved SQL for file input/output and extensive usage of service programs.
• Largest program touched was 15,000 lines. On site 1 week/month, remote from my basement the rest of the time.

Environment: SQLRPGLE, RPGLE, CLP, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Waukegan, IL

Programmer/Analyst

Responsibilities:

• Design and analysis to increase productivity.
• Custom software to facilitate billing between domestic and/or international company affiliates.

Environment: RPGLE, RPG, CLP, Query, DB2/400, on Confidential AS400 (V5R4), (i-Series)

Confidential - Highland Heights, KY

Programmer/Analyst

Responsibilities:

• Design and implementation of a security audit system of 60 files and programs across a dozen systems.
• This identifies persons with authority to both buy and receive items (plus other security issues).
• Contract completed on schedule.
• Programming with RPGLE free and SQL.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Middlebury, IN

Programmer/Analyst

Responsibilities:

• Software Upgrade for Friedman ERP manufacturing software - migrating from 2.1 to 3.1 version.
• Assisted in updating and migrating 1500 programs (modified software) to interface with an upgraded version (3.1) Friedman software.
• This was a successful production cutover in November 2014.
• Some smaller projects were also revised and implemented during this period.
• Modified RPG programs were upgraded to RPGLE.
• Programming was done with RPGLE and SQL.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

• Short term project loading files based on scanner data.
• Intensive RPG free and embedded SQL - no RPG F specs used for this project.
• These files were then used for reports based on Business Objects.
• Contract completed on schedule.

Environment: RPGLE, RPG, SQL, CLP, Query, DB2/400, Websphere on Confidential AS400 (V7R1), (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

Confidential - Jasper, IN

Programmer/Analyst

Responsibilities:

• Provided intensive production support for EDI including the EDI support mailbox.
• Production support was also provided for the i-Series 24/7 operation. Created and modified EDI maps as necessary.
• Provided support for i-Series program maintenance as well as EDI projects. Worked with off shore personnel.
• This company is in the process of shifting operations to Oracle.

Environment: RPGLE, RPG, CLP, FTP, Query, DB2/400, on Confidential AS400 (V6), (i-Series), Multiple i-Series partitions, mainframe and servers - Data transfer through FTP procedures

Confidential - Montgomery, AL

Programmer/Analyst

Responsibilities:

• Provided production support for Vital Statistics (birth and death certificates), plus maintenance project/programming assignments as needed to help production effectiveness.
• Programming was done with RPG, RPGLE, COBOL and embedded SQL.

Environment: RPGLE, RPG, COBOL, CLP, Query, DB2/400, on Confidential AS400 (V5R4), (i-Series)

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

• Provided production support for downstream accounting service measurement, plus maintenance project/programming assignments to better determine driver delivery effectiveness.
• Programming was done with RPGLE, embedded SQL and RPG free using Websphere (Rational Developer).

Environment: RPGLE, RPG, CLP, Query, DB2/400, Websphere on AS400 (V6R1), Confidential (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

Confidential - Quincy, IL

Programmer/Analyst

Responsibilities:

• Programming maintenance work with PRMS 8.4 programs, worked on 44 accounting projects (some new development)
• Using SOX compliant change management system based on Implementer.
• Creation of formal testing scripts for each of the projects that I worked on. Q/A then evaluated the scripts and either promoted or rejected the implementation.

Environment: RPGLE, RPG, RPG Free, CLP, Query, DB2/400, Websphere on AS400 (V5R4), Confidential (i-Series), multiple AS/400 partitions, multiple companies

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

• Provided project support for accounting fiscal year modifications, analysis and programming for Confidential contractor's compensation working under the direction of the Settlement Department.
• Second assignment area - International Group, modify information available to terminals, data (EDI) sent and received from US Customs.

Environment: RPGLE, RPG, CLP, Query, DB2/400, AS400 (V5R4), Confidential (i-Series), multiple AS/400 computers and partitions environment, multiple companies

Confidential, Middlebury, IN

Programmer/Analyst

Responsibilities:

• Designed and helped implement an AS/400 e-mail system for non-PC work stations
• Designed and helped implement a production status system for use by the production floor.
• This helps provide almost real time information upstream and downstream of a production station.
• Provided production support for PRMS.
• Middleware modification -- provided interface support between PRMS and Warehouse Boss
• Shipping - created Commercial Invoice, modified packing list, created export papers
• Shipping - attach freight to super orders, link freight information to online programs
• Interface - provide on-line real time data transfer between PRMS and Warehouse Boss
• This process is similar to a data queue, except a file was used.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, Hawkeye, ROBOT, DBU on Confidential AS400 (V4R5), (i-Series)

Confidential, Nappanee, IN

Programmer/Analyst

Responsibilities:

• Replaced/rebuilt a multi-million dollar rebate system to reward the better dealers. (This 6 month project retained about 1/3 of the original code.)
• Middleware modification - linked custom programs to Lawson name and address information (400 programs)
• Coordinated much of the Year 2000 (Y2K) software efforts (3 man years)
• Enhanced the Gulf Stream RV Travel Club account system to function better.
• Converted the spool file check output from Lawson to a laser printed check.
• This required modifying the Jetform (Java) system.
• Simplified the annual price changes for new models, converted to a file/table driven format.
• Middleware modification - supported and enhanced production line labor payroll system.
• Set up a new system to generate Manufacturer Suggested Retail Price Stickers
• Middleware modification - Provided support for the annual standards price modifications.
• Revised / rebuilt and maintained a system to handle material rejections.
• Provided operations backup as needed.
• Responded to daily maintenance requests on a priority basis.

Environment: Confidential RPGLE, RPGIV, RPG, CLP, SQL, Query, Hawkeye, Turn Over, DBU, VISIO, MS OFFICE.