The Problem: Teams were stuck in 5250 emulators and rigid RPG reports. Simple tasks took too many steps, remote access required VPNs, and every “small change” needed a developer. Data lived in silos, so analysts copied numbers into spreadsheets, creating delays and errors. The Solution: I built a modern web interface on top of the existing AS/400 (IBM i) data and logic. The new app runs in any browser—desktop, tablet, or phone—no emulator, no VPN. Users navigate with a clean UI, run flexible reports, and export to Excel in one click. Secure APIs now feed Power BI, Excel Power Query, and other tools without manual rework. Outcomes (business impact): Faster work: Common tasks now take minutes, not hours. Self‑service reporting: Analysts create or tweak reports without dev tickets. Data integrity: One source of truth; fewer copy/paste errors. Lower training time: New users ramp faster with familiar web patterns. Secure remote access: Browser‑based, MFA‑protected—no clunky VPN. Key features: Modern UI over legacy systems: Friendly web screens instead of 5250. Flexible reporting: Filters, pivots, saved views, and one‑click JSON/CSV/XLSX. Role‑based access: See only what you should—down to field level. Search that works: Full‑text and faceted search across core entities. Audit & traceability: Who changed what, and when. API endpoints: Secure REST endpoints for BI tools and integrations. Responsive & mobile‑ready: Works on shop floor tablets and phones.

Project Overview
The Problem:
Teams were stuck in 5250 emulators and rigid RPG reports. Simple tasks took too many steps, remote access required VPNs, and every “small change” needed a developer. Data lived in silos, so analysts copied numbers into spreadsheets, creating delays and errors.
The Solution:
I built a modern web interface on top of the existing AS/400 (IBM i) data and logic. The new app runs in any browser—desktop, tablet, or phone—no emulator, no VPN. Users navigate with a clean UI, run flexible reports, and export to Excel in one click. Secure APIs now feed Power BI, Excel Power Query, and other tools without manual rework.
Outcomes (business impact):
Faster work: Common tasks now take minutes, not hours.
Self‑service reporting: Analysts create or tweak reports without dev tickets.
Data integrity: One source of truth; fewer copy/paste errors.
Lower training time: New users ramp faster with familiar web patterns.
Secure remote access: Browser‑based, MFA‑protected—no clunky VPN.
Key features:
Modern UI over legacy systems: Friendly web screens instead of 5250.
Flexible reporting: Filters, pivots, saved views, and one‑click JSON/CSV/XLSX.
Role‑based access: See only what you should—down to field level.
Search that works: Full‑text and faceted search across core entities.
Audit & traceability: Who changed what, and when.
API endpoints: Secure REST endpoints for BI tools and integrations.
Responsive & mobile‑ready: Works on shop floor tablets and phones.
Project Details
Web Application
Completed
Related Projects

The Chemical Management App is a Django-based enterprise tool designed to manage and govern chemical …

To maintain OEKO-TEX® Standard 100 certification, every finished product must be linked to valid OEKO-TEX® …