ASUX Tier Escalation System

Built for Aptiv's ASUX division, this system replaced email threads & spreadsheets as the way plants escalate & track production support issues across tiers. Any plant can log a support ticket, route it to the right tier of ownership, and track every action item through to resolution on a searchable, sortable, color-coded coverage table (DataTables, with CSV/Excel/PDF/print export built in).

The bigger win was closing the notification gap: instead of people forgetting to check a shared inbox, the system pushes real-time updates via email and WhatsApp, through the Ultramsg API, the moment a ticket changes status or needs attention. Dashboards give leadership visibility across every plant covered by the division without chasing anyone down for a status update.

It's PHP & mysqli under the hood, an older codebase from 2022, and it's still what runs in production today. I'm mid-rebuild on it now (asux-rebuild) to move it onto prepared statements & a proper MVC structure, so I'm calling that out plainly rather than overselling the current state of the legacy code.

Digital Transformation: it took a manual, email-driven escalation process across a global division and turned it into an automated, real-time system, exactly the kind of before/after that phrase is supposed to mean.