RPG Engineer - Sunbelt Rentals - Fort Mill, SC
(2023-08 - 2024-05)
Remote IBMi software engineer supporting distribution and accounting divisions of a Fortune 100 credit card processing, A/R reporting, US Canada distribution shipping and receiving.
- Used Infor XA to resolve US to Canada statement mailing address overflow printing issue by researching and coding solutions, improving cross-border communication efficiency increasing mailing success by 25%.
- Developed and unit tested transfer report to address missing item locations, ensuring accurate data for QA team testing and enhancing inventory management
- Conducted functionality research for accounts receivable automatic write-offs report and process, streamlining financial operations and reducing manual errors
- Utilized Infor XA, RPG III, CL, and DB2 database architecture to modernize systems, improving data processing efficiency and supporting business operations including updates to bill of materials, routings and inventory production transfers
- Leveraged SQL, IBMi, and agile management practices to drive IBMi modernization projects, utilizing Git for version control and enhancing system capabilities and team collaboration through Jira and Microsoft Teams
RPG Developer Analyst - Alta Resources - Neenah, WI
(2019-05 - 2022-12)
In person and remote IBMi custom developer supporting divisions of a Fortune 100 company: customer order, contact processing, credit card processing, fnance reporting, distribution center shipping and receiving. Signifcant role in implementing new credit card processor with IBMi modernization, coding, testing during multi-year team effort- overall 25% increase in data calculation accuracy. Extensive RPG custom coding on IBMi system, unit testing for 2022 PCI customer contact email efforts.
- Participated in development planning for small, medium, and large business projects with local and offshore teams, and conducted unit and QA testing, which improved code quality and helped deliver projects on schedule
- Utilized ILE RPG, RPG Free, RPG IV, CL, DB2, Cobol, and DB2 database architecture on the IBMi system to enhance system functionality and maintain code versioning with Git
- Modernized AS400 to IBMi systems by implementing SQL, IBM SEQUEL, and REST services, leading to faster data processing and more effcient workfows while supporting agile project delivery with Scrum and Jira.
- Applied Kanban, Microsoft Teams, Excel, Word, PowerPoint, XML, and JavaScript to facilitate communication and project management, enhancing team collaboration and project outcomes through structured change management procedures
EDI/RPG Developer - Waupaca Foundry - Waupaca, WI
(2018-04 - 2018-07)
RPG - EDI daily processing issues with Trustedlink EDI PC interface, modifed RPG IV, CL interfaces for new EDI shipping schedule and purchase order functionality.
- Created a custom RPG IV EDIFACT trading partner shipping schedule interface for auto manufacturing, improving data accuracy and streamlining the shipping process
- Resolved daily Trustedlink EDI PC interface processing issues by modifying RPG IV code, updating DB2 schemas, and creating CL programs on IBMi, which enabled the new shipping-schedule and purchase-order functionality
RPG Developer Analyst - NSC, Inc. - Brillion, WI
(2017-12 - 2018-04)
Sole resource dedicated to ILE RPG, RPG IV, CL, DB2 modifcations to customized process software package at two foundries and a government offce- IBMi.
- Created a new interface linking the foundry's payroll system to the 401(k) reporting processor, reducing manual data-entry time
- Coded and tested RPG IV, DB2, and CL components under Git version control for a payroll/accounting package for a government offce, delivering a functional module that met all acceptance criteria and enabled accurate fnancial processing
- Implemented year-end updates to a custom RPG-CGI HTML calendar and a Land Records website, ensuring timely increase by 25% with data refresh and uninterrupted user access.
- Investigated EDI issues in Trustedlink web and RPG IV/CL interfaces, collaborating with trading partners to resolve data-transmission errors, which restored reliable EDI fow
RPG Developer Consultant - US Ventures - Appleton, WI
(2017-02 - 2017-04)
Custom ILE RPG, RPG IV application development project for nationwide auto insurance company.
- Coded and tested ILE RPG, RPG IV, DB2, and CL components to update multiple inquiry screens, enabling seamless access to Microsoft AX invoice and purchase order data
- Coded and tested customized IBMi software to expand invoice-date handling, improving 30% accuracy to over 100 files and programs related to purchase orders, sales orders, invoicing, and distribution processes as part of a system modernization project including select batch jobs, job scheduling, and automation processes
RPG Developer Analyst Consultant - Waupaca Foundry - Waupaca, WI
(2016-05 - 2016-12)
Part remote and part on-site custom ILE RPG, RPG IV, DB2, IBMi database architect, contract application development for international metal moldings frm- Waupaca Foundry- a division of Hitachi Metals, Inc.
- Led the employee-number expansion project, planning and budgeting while analyzing, developing, and testing over 200 fles and programs for accounting, payroll, and manufacturing, which streamlined data processing and supported company growth
RPG Systems Analyst - JLG- Oshkosh Corp. division - Appleton, WI
(2014-09 - 2016-02)
Application development and service desk support including after-hours/weekend support for international manufacturing frm- JLG, a maker of lift and support equipment for the Access division of Oshkosh Corporation. Tracking number expansion project analysis/development/testing of 300+ fles and programs for manufacturing expansion resulting in 33% increase in tracking precision.
- Designed, coded, and tested ILE RPG, RPG IV, RPG Free, COBOL on the IBMi, embedded SQL programs, DB2 database structures, and Infor XA fles enabling the expansion project to support over 300 fles and programs
- Implemented ServiceNow and Remedy ticketing, and used MKS/Implementer to modernize IBMi systems, reducing support response time and improving system reliability
RPG Senior Programmer Analyst Consultant - Magellan Health - Saint Louis, MO
(2014-03 - 2014-09)
Updated in-house Total Member Record project with stored procedure data access and multiple embedded SQLs within ILE RPG, RPG IV, DB2 IBMi database architect with custom package to provide detailed patient record requests- providing quicker records access including partial ID lookups. Designed, coded, tested ILE RPG, RPG IV with Free, embedded SQL programs, stored procedure and CL on the IBMi. Used Turning Point System.
- Modifed and supported the custom membership eligibility processing package, enabling faster patient-record lookups and reducing eligibility errors for the nationwide insurance support department
RPG Developer Consultant - Green Tree (Ditech)- Loan Servicing - Saint Paul, MN
(2012-04 - 2013-02)
Created screens and modifed the in-house Hardest Hit Funds government processing system to centralize and prioritize critical fnancial data into easy-to-read screens to reduce decision time in processing key user data for operations staff. This allowed a quicker release of government funds to challenged mortgage loan customers.
- Designed, coded, and tested ILE RPG and RPG IV programs with free-form syntax, embedded SQL, and CL on IBMi, enabling faster retrieval and display of loan data for operations staff
- Modifed and supported a custom loan-servicing package for the loan-servicing support department, improving system stability and reducing the number of support tickets
- Worked with Lotus Notes, JIRA project tracking, and the Implementer (MKS) system to coordinate development tasks and improve change-management processes, resulting in faster issue resolution
Programmer Analyst - Chambers and Owen, Inc. - Wholesale Distributor - Janesville, WI
(2000-05 - 2011-08)
Data mapped multiple unique customer order fles automatically through FTP process into JD Edwards World A7.3 sales ordering system-allowing a seamless company order processed and invoice generation without manual input. Automated credit returns entry program resulting in $30000 data entry staff savings annually. Led Laser AP checks conversion project - saving $50000 on pre-printed forms over 11 years.
Assisted in creating in-house ACH billing package- reduced by 1/2 the staffng needed to process ACH billing.
- Enhanced and supported A/P, A/R, GL, Order Entry and Distribution modules in JDE World A7.3, improving transaction processing speed and reducing support tickets
- Designed, coded, and tested RPG III, RPG IV, DB2 database architecture, embedded SQL programs, and CL scripts on the IBMi, delivering functional components that met business requirements
- Assisted with IBM upgrades, operations, and Extol EDI processing (RPG version), helping maintain system uptime and ensuring smooth transition during upgrades
- Created and data mapped invoice fle interface for 25 different software packages.
- Supported internal and external customers with invoice and price-book interface issues, resolving 95% of tickets within one business day
- Worked with fles transferred with FTP, SQL, JDE Dream Writers, World Writers, Data Dictionary.
