Senior Programmer/Analyst
Senior programmer/analyst with extensive experience in RPG, SQL, and iSeries. Proficient in all versions of RPG from RPG II to RPG/free. Advanced SQL skills on SQL Server and iSeries DB2, including windowing functions, Common Table Expressions, and recursion. Over a decade of experience with Infor XA and multiple iSeries ERP systems.
iSeries Modernization Analyst - Fox Hire
(2024-10 - 2025-10)
Working with Fox Hire on an assignment at AprilAire where I enhanced and updated parts of a legacy ERP system. Made changes to existing RPG programs, made database enhancements, and wrote SQL procedures for reporting.
Senior Programming Analyst - Sub-Zero Group Inc (Sub-Zero Refrigeration)
(2004-10 - 2024-10)
For the first decade at Sub-Zero, worked as a Programmer/analyst supporting Infor XA, first version 7 and later 9.1. Wrote RPG and CLP programs, modified Powerlink objects using Integrator, wrote SQL to import data to and export from XA, and spent two years in charge of the iSeries help desk. Later transferred to an MS-SQL server team working on the nexus of SQL Server reporting and XA.
Was also the lead support programmer analyst for applications using XA and other systems, such as Sub-Zero's MES system and Oracle Agile. In the last year, was the point of contact for creating initial XA extracts for SAP conversion consultants.
IBM S/36, S/38, AS400 and iSeries Consultant - Independent/Consulting Firms
(1984-03 - 2004-04)
Worked as a consultant for consulting firms or as an independent contractor, almost always working on IBM midrange computers using RPG. Wrote many custom RPG programs and worked on installing ERP systems, most often BPCS and PRMS. Had consulting assignments in several industries including pharmaceuticals, options trading, labor unions, software firms and various manufacturers.
BA - History - Knox College
