IBM i • RPG • Modernization

Your AS/400 isn't
the problem.
The interface is.

I modernize IBM i systems with web frontends, mobile scanning, and real-time integrations — without ripping out what already works.

// warehouse-api/routes.js
const db2 = require('idb-connector');

app.get('/api/pallets/:loc', async (req, res) => {
  const result = await db2.query(
    `SELECT * FROM PALLETLIB.LOCATIONS
     WHERE LOC_ID = ?`
,
    [req.params.loc]
  );
  res.json(result);
});

What I Do

Modernization that
meets you where you are

Your IBM i runs your business. I make it easier to use, faster to operate, and ready for what's next.

WEBUI

Web Frontends for IBM i

Replace green screens with responsive web interfaces that talk directly to your DB2 data. Your team gets a modern UI — your RPG programs keep running.

SCAN

Mobile Scanning Solutions

Barcode and QR code scanning from any phone or tablet. Real-time inventory updates, bilingual interfaces, and no more clipboards in the warehouse.

INTG

System Integration

Connect your AS/400 to the tools your team already uses — APIs, dashboards, reporting platforms. Your IBM i data, accessible everywhere it needs to be.

DB2

Database Design & Optimization

Normalized DB2 schemas, SQLRPGLE programs, and data structures built for performance. Clean architecture that scales with your operation.

OPS

Warehouse & Inventory Systems

Purpose-built warehouse management running natively on IBM i. Pallet tracking, location management, and inventory workflows designed for cold storage and distribution.

RPG

RPG Development

New RPGLE and SQLRPGLE programs, maintenance of existing codebases, and migration from legacy fixed-format RPG to modern free-format.

FIN

Financial Process Automation

Streamline invoicing, reporting, and bookkeeping workflows tied to your IBM i data. Automated reconciliation, Excel report generation, and integrations between your ERP and accounting systems — less manual entry, fewer errors.


Recent Work

Built for the real world

Production systems handling real inventory at scale — not classroom exercises.

SQLRPGLE DB2 NODE.JS EXPRESS
11

Warehouse Pallet Management System

Full-stack warehouse management app running on IBM i. 11 normalized DB2 tables, SQLRPGLE backend programs, REST APIs via Node.js/Express, and a responsive web frontend — replacing manual tracking across 17,600+ pallet locations.

QR CODES MOBILE BILINGUAL
📱

Mobile Barcode Scanning System

Phone-based scanning workflow replacing handwritten pallet location tracking in freezer warehouse environments. QR code label generation, real-time inventory updates, and English/Spanish interface for the full warehouse team.

IBM i DDS CL RPGLE
17K+

Production AS/400 Operations

Hands-on production access to IBM i systems managing 17,600+ pallet locations in cold storage. DDS display files, CL programs, and RPGLE development deployed directly into live operational environments.


About

The new generation
of IBM i

I'm Jaden — an Operations & Inventory Analyst who learned IBM i by solving real problems in a cold storage warehouse, not in a classroom.

When our warehouse needed better pallet tracking, I didn't wait for a consultant. I learned RPG, built the database, wrote the programs, and deployed to production. When the team needed to ditch clipboards, I built mobile scanning.

Most IBM i developers are retiring. I'm just getting started. I combine deep warehouse operations knowledge with modern development skills to build solutions that actually get used by the people on the floor.

Based in Southern California. Available for remote and on-site work.

17,600+ Pallet locations managed
11 DB2 tables designed
PROD Production system access
2 Languages (EN/ES)

Let's Talk

Ready to modernize?

Whether you need a web frontend, mobile scanning, or custom RPG development — let's figure out the right solution for your operation.

jaden@midrangemodern.com