High-Volume Molding Manufacturer — PE-Backed, Post-Acquisition · Project 2 of 2 (June 2018 – January 2019)

Scheduling and execution of the critical slitter work centers ran on a complex Excel spreadsheet; the item master was another Excel workbook
Master data that Dynamics GP lacked — slit sub-component SKUs, multi-level BOMs, UOM schedules — did not exist anywhere

Build: Designed and developed ORDO on Oracle Database 12c / APEX 18.2 / ORDS on a hosted cloud service (Dev/Test and Production environments)
Master Data Generation: Auto-generated slit sub-component SKUs with an invented naming schema, three-level BOMs (finished goods → slit sub-components → finished rolls → raw-material rolls), UOM conversion schedules, and a work-order status lifecycle
Integration: One-way integration from Dynamics GP 2013 — item master and active lot-controlled inventory polled every 10 minutes via SQL Server staging and Oracle merge procedures
Output: APEX Office Print for work orders, labels, pick lists, and shortage reports; late-order dashboard by customer, days late, and priority
Adoption: Migrated users off legacy tools; trained the workforce; SLA-based hosting and support offer at close

Over 97% of data entry errors eliminated; major material shortages resolved
Chargeback and product-delay crisis with primary customers resolved
94% of post-go-live functionality traced to client requests through the component register

Oracle Database 12c, Oracle APEX 18.2, ORDS, PL/SQL on a hosted cloud service; APEX Office Print (AOP)
Microsoft Dynamics GP 2013 integration (10-minute polling)