Programmer/Analyst - Chemical Engineer

PO Box ****, Middlebury, IN *****

574-***-**** (Cell)

***************@*****.***

SUMMARY:

** ***** ** ** ********** in IBM 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.

Education:

·Master of Science (Chemical Engineering)

·Bachelor of Science (Chemical Engineering)

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

Strengths

·30 years AS400 experience

·30 years RPG experience (20 years RPGLE)

·Analysis, design, programming, debugging and implementation of RPG/CLP programs

·System design using many smaller called programs

·Considerable database design and implementation

·Creative approaches to daily production problems

·Manufacturing experience

·Insurance experience

·PRMS / MRP experience

·Friedman / ERP experience

·Involved in the all phases of System Development Life cycle (SDLC).

·Revised/rebuilt multi-million dollar rebate program

·Security Officer experience

·System Administration experience

·Database Administration done with some projects

·Middleware experience

·Accustomed to working with SOX and HIPAA restrictions

·EDI Trusted Link mapping and support experience

PROFESSIONAL EXPERIENCE:

University of Pittsburgh Medical Center - Programmer/Analyst

Pittsburgh, PA

September 2016 to December 2019 (Contract)

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. Modernization included using RPG free, reusable code,and service programs. Rebuilt the 1300 files, views or indexes using SQL generated 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 IBM AS400 (V7R3), (i-Series)

Frontier Communications – Programmer/Analyst

Richardson, TX

September 2015 – January 2016 (Contract)

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 IBM AS400 (V7R1), (i-Series)

Abbott Labs / IBM – Programmer/Analyst

Waukegan, IL

June 2015 – July 2015 (Contract)

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 IBM AS400 (V5R4), (i-Series)

General Cable – Programmer/Analyst

Highland Heights, KY

March 2015 – April 2015 (6 Week Contract)

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 IBM AS400 (V7R1), (i-Series)

Jayco (RV Manufacturer) -- Programmer/Analyst

Middlebury, IN

May 2013 – December 2014 (Contract)

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 IBM AS400 (V7R1), (i-Series)

Federal Express - Services -- Programmer/Analyst

Pittsburgh, PA

January 2013 – April 2013 (Contract)

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 IBM AS400 (V7R1), (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

MasterBrand Cabinets, Inc.-- Programmer/Analyst

Jasper, IN

December 2011 – December 2012 (Contract)

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 IBM AS400 (V6), (i-Series), Multiple i-Series partitions, mainframe and servers – Data transfer through FTP procedures

Alabama Department of Public Health -- Programmer/Analyst

Montgomery, AL

December 2010 – September 2011 (Contract)

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 IBM AS400 (V5R4), (i-Series)

Federal Express - Services -- Programmer/Analyst

Pittsburgh, PA

July 2009 – June 2010 (Contract)

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), IBM (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

Titan International, INC - Programmer/Analyst

2701 Spruce Street

Quincy, IL 62301

January 2008 to October 2008 (Contract)

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), IBM (i-Series), multiple AS/400 partitions, multiple companies

Federal Express - Ground -- Programmer/Analyst

Pittsburgh, PA

February 2007 – January 2008 (Contract)

Provided project support for accounting fiscal year modifications, analysis and programming for FedEx 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), IBM (i-Series), multiple AS/400 computers and partitions environment, multiple companies

Abbott Labs – Ross Products -- Programmer/Analyst

Sturgis, Michigan (System Administrator)

January to December 2006 (Contract)

Maintenance Support/upgrade:

Software – Shawware (Troubleshooting), Kronos (ATC –Time clocks), Quadrant fax, Pentasafe auditing, Robot, MQ Series, Turnover, Data Text Merge, DBU, MAS (production system), QAWO, performance monitoring, calibration system, disaster recovery exercise, migrated software from an AS/400 to an i5 computer OS 5.2 =>OS 5.3

Hardware support: AS/400 – routine backup, system migration from AS/400 to i5 computer

Development: Cash sales upgrade (in house employee store), Perfect batch revision (quality control), Shawware (installation of code modifications (modify PO’s, Z code revision, new fax capability)),

This position was about half software development and half system maintenance and upgrades.

Environment: RPGLE, RPG, CLP, Query, DB2/400, on AS400 (V5R2, V5R3), IBM (i-Series), communications with other AS/400 computers

Federal Express - Ground -- Programmer/Analyst

Pittsburgh, PA

January – December 2005 (Contract)

Provided project support for accounting modifications – 1099's, Settlement Department, analysis and programming for FedEx contractor's compensation. Flat file conversion programs for migration to People Soft. Created or modified around 80 programs. This middleware system allowed data to be transferred from the AS400 to main frame systems. Created accounting subsystems as needed for new projects.

Reports/Projects:

·1099's, troubleshooting year-end programs

· Design and coding for new projects

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

American Electronics Components -- Programmer/Analyst

PRMS (MRP), EDI (This company has been sold and disappeared.)

Elkhart, IN

May 2004 to August 2004 (Contract)

Replaced programmer on sick leave. Provided production support, IBM PRMS 8.4, EDI TrustedLink 5.4.

Created or modified around 50 programs.

Reports/Projects:

·Management reports, cost of manufactured goods, Excel reports automatically e-mailed to user.

·EDI Forms 856, 830, 997 form generation

Environment: RPGLE, RPG, CLP, Query, DB2/400, EDI, DBU on AS400 (V4R5), (i-Series)

Syndicate Systems Inc. Programmer/Analyst

PRMS (MRP), Warehouse Boss

Middlebury, IN

March 2001 to June 2003

Reviewed the MRP system and made recommendations for improvement, provided support for the manufacturing PRMS system, helped create interface programs between PRMS and Warehouse Boss. Created or modified around 130 programs.

·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 IBM AS400 (V4R5), (i-Series)

Fairmont Homes, Inc Programmer/Analyst

Lawson, Jetform, Custom systems, Sales, Dealers and Manufacturing

Nappanee, IN

1993 to 2001

Provided production support for custom programs and Lawson/Jetform interfaces. Performed Security Officer tasks, hardware configuration and installation. Created or modified around 850 programs in a seven year period. Supported manufacturing with custom programs.

·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: IBM RPGLE, RPGIV, RPG, CLP, SQL, Query, Hawkeye, Turn Over, DBU, VISIO, MS OFFICE.

Mennonite Mutual Aid Programmer/Analyst

Custom Auto Insurance System

Goshen, IN

1987 to 1993

Provided design and support for a custom auto insurance system. New program development, analyst, maintenance, involved in upgrading these systems as needed. Trained in property casualty and health insurance. Some of these programs used the old IBM RPG logic cycle, RPG II, III.

Pioneer Exploration Company

Wichita, KS

1984 to 1986

Developed a lease income/expense accounting module using BASIC on a TI Business System 300 min-computer.

Responsible for legal compliance with state and federal regulatory agencies.

Did oilfield production and work over engineering for leases in the midwest states.

Computer Software Services

Wichita, KS

1984

Developed an accounts receivable package for a KeyTrol Fuel System using BASIC.

Other Experiences:

·Research Engineer – Silicone and urethane rubber

·Research Engineer – Tertiary Oil Recovery Techniques

·Production Engineer – Oil Field Wells

·Process Engineer – Liquefied Natural Gas Processing Plant (Alaska)

·Entrepreneur – Functional and decorative wooden windmills

·Production – Plastic extrusion

·Photographer – Semi-professional, portrait, digital – fine art style

·Conduct Plant Tours (Alaska) – VIP’s, Japanese Ambassador, China (#6 person), Senators & Representatives

Contact this candidate