RPG REMOTE

Michael Nitka

Senior IBMi Programmer Analyst

Contact Information

Phone: 469-***-****

Email: ********@*****.***

Objective

Innovative IBMi Programmer Analyst seeks a challenging position where creative ideas can be developed into software products, solutions and enhancements.

Background Summary

Over 20 years of experience in RPG-FREE, RPGIV-ILE, RPGII, RPGIII, RPG400, DB2 for i SQL, SQLRPGLE, XML/JSON (AWS Web Services) APIs, Stored Procedures, CLLE, CLP, OCL, and Artificial Intelligence (AI). Extensive background in new software development, AI analysis, major modifications to in-house software systems, and integration with third-party systems via stored procedure APIs to customize proprietary vendor software packages. Skilled in modernizing and transforming client systems, source code, and data.

Industry experience includes: Retail, Banking/Mortgage/Financial, Distribution, Manufacturing ERP and Financials, Oil & Gas, Life/Property Insurance, Transportation, Software, Construction, and Health Care.

Professional Experience

Senior iSeries Power I RPG-FREE, RPGIV, DB2 for i - Developer / Analyst (Consultant)

Londen Insurance (Remote) 05/2023 – 05/2025

Developed and modernized applications using RPGIII, RPGIV, CLP, ILE, and RPG-FREE.

Built RESTful APIs for Credit Card & Pricing Maintenance; utilized embedded SQL.

Administered and deployed REST services via IWS; tested APIs with POSTMAN and created test scripts.

Created MFT solutions using GoAnywhere MFT for S3 processing.

Utilized LMI Change Management for version control.

Senior iSeries Power I RPG-FREE, RPGIV, DB2 for i - Developer / Analyst (Consultant)

Winn Supply (Remote) 02/2022 – 04/2023

Led RPG modernization projects and new development using RPGIV ILE, RPG-FREE, and DB2 for i SQL.

Developed DAO for MVC 3-tier architecture using Profound UI tools and stored procedures.

Converted PF DDS to SQL tables; implemented database trigger programming.

Worked in Agile environment with JIRA and ARCAD.

Senior iSeries Power I RPG-FREE, RPGIV, DB2 for i - Developer / Analyst (Consultant)

AAA Life Insurance 04/2021 – 01/2022

Developed and maintained legacy applications; implemented automated interfaces for electronic payments and transactions.

Provided production support and root cause analysis for policy software issues.

Created daily transaction reports in CSV and automated SFTP transmissions.

Managed DevOps admin functions, security, and document imaging troubleshooting.

Programmed web services for XML document transfers and web interfaces.

Senior iSeries RPG-FREE, RPGIV, DB2 for i - Developer / Analyst (Consultant)

Allsups / Yesway Stores 04/2020 – 04/2021

Led decommissioning and data extraction for iSeries systems; migrated 2TB of data to SQL Server.

Converted source code to RPG-FREE or SQL script equivalents.

Developed tools for automated data and spool file extraction, including data dictionary schema generation and tailor-made extractions.

Supported system conversion/migration to SQL Server-based accounting software.

Senior iSeries RPG-FREE DB2 for i Programmer Analyst (Consultant)

Farm Credit Bank, Austin, TX 09/2019 – 03/2020

Supported Farm View Credit Conversion project; performed DB2 SQL scripting and conversion verifications.

Senior iSeries RPG-FREE RPGIV DB2 for i SQL Programmer Analyst

USA Staffing @ SWBC, San Antonio, TX 01/2019 – 08/2019

Developed automated interfaces for inbound loan and insurance payments.

Maintained and enhanced RPG programs; automated Excel report generation and FTP scripting for data distribution.

Programmed web services and XML interfaces.

Senior iSeries RPG400 RPGIV RPG-FREE DB2 for i SQL Programmer Analyst (Consultant)

BravoTech @ Penhall Industries, Dallas, TX 11/2017 – 11/2018

Troubleshot and remediated financial database issues; enhanced ERP modules for A/P, A/R, and G/L.

Provided production support, user documentation, and training.

Programmed in RPG-FREE and developed web services for XML data transfers.

Additional Experience

Consultant @ DELL, Plano, TX – Enhanced IBM Document Management System (2017)

RHA Dallas TX / FFE Transportation – Oil & Gas billing and dispatch modernization (2016)

Matrix Resources, GM Financial Services – Data migration and FISERV application enhancements (2015–2016)

GDC General Data – HCS iSeries data migration to All-scripts (2014–2015)

Avatar Consultative Services – Long-term consulting for financial, insurance, and logistics clients (1998–2014)

FEDEX Ground, CVS Caremark, Bank of America, Victory Packaging, IBM/Perot Systems, Dicks Sporting Goods, Kronos TimeKeeper, AmeriServe, CCE Coca Cola Enterprise, Solutions Technology Inc., YMCA of Metropolitan Dallas, LXI Corporation, USTI Inc. – Various roles in RPG programming, system analysis, modernization, and project management (1989–2014)

Technical Skills

Languages & Platforms: RPG II, RPG III, RPG400, RPGIV, RPG ILE, RPG-FREE, Embedded SQL, CLLE, CLP, OCL, DB2 for i SQL, SQLRPGLE, XML/JSON (AWS Web Services), Stored Procedures

Database: DB2/400 (SQL Tables, Query, CTE Expressions, Visual Explain, SQL Optimizer), DDS Physical/Logical/Join Files, Data Dictionaries, DDM

Web & Integration: RESTful APIs, Web Services, XML, JSON, CGIDEV2, IBM MQ Series API, Sockets Programming

Tools: Profound UI, GoAnywhere MFT, POSTMAN, JIRA, ARCAD, ALDON, Turnover, Implementer, ROBOT Job Scheduler, DBU, VISIO, Microsoft Project, Hawkeye, Clarity, SMSS Data Tool, PASE QSHELL

System Administration: Security, Backup & Restore, Print Management, Job Scheduler, I Series Navigator, System Values, PTFs

Change Management: LMI, ALDON, Turnover, Implementer, ARCAD

Other: EDI, ETL, Data Migration, Data Masking, Data Modeling, Agile/Scrum, Project Management, User Documentation, Training

Education & Certifications

Available upon request.

References

Available upon request.

Contact this candidate