Looking for a job

Ajay Singh

@ajaysingh38

IBM i modernization lead at Costco Optical who converted RPGLE routines into shared DB2 stored procedures and REST APIs.

United States

Message

At Costco Optical, I analyzed the IBM i application behind Costco Wholesale's home-grown WMS and reused existing RPGLE programs for the digital-store interface. I converted RPGLE routines into DB2 SQL stored procedures and views, then built REST APIs that accept and return JSON for order creation, RX validation, and patient look-up.

Across IBM i projects in warehouse management, ERP, insurance, banking, and payments, I’ve analyzed legacy code and dependencies, supported integrations, and modernized RPG logic while keeping IBM i at the core. I’ve also led offshore teams, supported SOX-controlled delivery, and documented system flows and designs.

Experience

Work history, roles, and key accomplishments

IBMi Modernization Lead

Costco Optical (Costco Wholesale WMS)

Apr 2021 - Aug 2026 (5 years 4 months)

Subject matter expert for Costco Wholesale's home-grown WMS, analyzing legacy RPGLE applications and converting routines to SQL stored procedures. Built REST APIs and JSON integrations for the digital store, and supported MQ and FTP/SFTP interfaces.

RPG LE Free RPG AS 400 SQL DB2 JSON JSON_TABLE Data Into REST APIs HTTP IBM MQ FTP SFTP DSPJRN Visual Explanation Index Advisor SQL Performance Monitoring Turnover SOX

System Analyst

Project Outpost (Frontier Communications ERP)

Sep 2019 - Apr 2021 (1 year 7 months)

Analyzed dependencies and DB2 constraints for purge logic, moved repeated logic into stored procedures, and built JSON interfaces between the ERP and external systems. Enhanced SQL performance and supported UAT.

RPG LE SQLRPGLE CLLE SQL DB2 Stored Procedures JSON JSON_TABLE Visual Explanation Analysis Aldon

System Analyst

Escrow Account Maintenance (Bank of America)

Feb 2019 - Sep 2019 (7 months)

Created and modified DB2 SQL stored procedures for escrow calculation and account maintenance, with validation and exception handling. Exchanged escrow data as JSON with downstream applications and prepared technical designs.

DB2 SQL Stored Procedures JSON Requirements Gathering Technical Design

System Analyst

Aspen Dental System Analysis and Data Migration (Total Denta

Sep 2017 - Feb 2018 (5 months)

Analyzed and documented existing AS/400 application ahead of migration, defined extract formats, and built programs to transfer data. Helped plan data migration and gathered requirements.

AS 400 RPG LE Data Migration Documentation Requirements Gathering

Senior Software Engineer

SIS V12 Maintenance and Support (MAPFRE Insurance)

Mar 2016 - Jan 2017 (10 months)

Onsite lead for offshore team on MAPFRE's insurance application, translating requirements into designs and cutover plans. Reviewed offshore code and enforced coding standards.

RPG LE Free RPG CLLE SQL400 Design Code Review Offshore Leadership

Senior Software Engineer

JDA MMS Payment Integration and Tokenization (West Marine)

Aug 2015 - Mar 2016 (7 months)

Delivered payment integration and tokenization for PCI compliance, designing RPGLE and CLLE programs for point-to-point encryption. Built SQL stored procedures and MQ/socket interfaces, and integrated with Java for HTTPS file transfer.

RPG LE CLLE SQL Stored Procedures IBM MQ Sockets HTTPS SSL Tokenization PCI DSS Java

Senior Software Engineer

STARS Maintenance and Conversion (Service Experts LLC)

Mar 2015 - Aug 2015 (5 months)

Maintained and converted the STARS application, including WMS and Ticket Management modules. Prepared design documents and project plans, led development team, and tracked progress.

RPG LE Free RPG CLLE SQL400 Design Project Planning Team Leadership

Senior Software Engineer

FOODSTAR WMS Maintenance and Support (Performance Food Group

Dec 2011 - Feb 2014 (2 years 2 months)

Developed and supported FOODSTAR WMS, Order Management, and Customer Management modules. Built RPGLE and CLLE interface programs, led offshore team, and managed deployments under SOX controls.

RPG LE RPG III IV Free CLLE SQL Turnover SOX Offshore Leadership Deployment

Senior Software Engineer

CWDirect WMS Maintenance and Support

Mar 2009 - Jun 2011 (2 years 3 months)

Removed warehouse hard-coding from CWDirect custom code and shifted primary warehouse. Designed, coded, and supported receiving, inventory, pick/pack, and shipping components in RPG and CLLE.

RPG III IV Free CLLE SQL WMS Design

Software Engineer

Life Support Plus Conversion (Humana Insurance, via CGI)

Nov 2006 - Feb 2009 (2 years 3 months)

Converted LSP system to Billing and Reconnaissance Insurance project for Humana, writing low-level design and technical documents. Performed impact analysis and ran conversion scripting and testing.

RPG III IV Free CLLE SQL Impact Analysis Conversion Testing