Enterprise Waste-Operations Platform
Replaced fragmented spreadsheet workflows with a role-based operations platform for a US enterprise — built and maintained under an ongoing contract.
Frontend / product engineer
Delivered under NDA. Client identity and the live product are confidential; screenshots below use non-production sample data.
Stack
- Next.js 16
- React 19
- TypeScript
- AG Grid
- TanStack Query/Table
- AWS Cognito / Amplify
- Azure SQL
- @react-pdf/renderer
- pptxgenjs
- xlsx
Context
A US environmental-services company ran its waste-shipment operations across a sprawl of Excel files — bulk data entry, manifest tracking, and reporting all lived in disconnected spreadsheets passed between roles. I built, and continue to maintain, a single web platform to replace that, shipping new features on an ongoing contract.
This work is under NDA, so the client and live product aren't named or linked, and every screenshot here uses non-production sample data.
The problem with spreadsheets
Spreadsheets don't enforce roles, don't validate at entry, and don't produce consistent reports. Data drifted between copies, mistakes propagated silently, and every report was rebuilt by hand — slow, error-prone, and impossible to audit.
What I built
A role-based operations platform with a spreadsheet-grade data-entry experience (AG Grid) so operators keep the paste/import speed of Excel but gain validation and structure — bulk entry, CSV import, add/duplicate/fill-down, and a guided step flow.
A custom report builder lets users assemble reports and export them one-click to PDF, Excel, and PowerPoint. Analytics dashboards summarise the operation across cost, logistics, and emissions. Access is gated by role via AWS Cognito/Amplify, with data persisted to Azure SQL.
Trade-offs
Meeting operators where they are — an AG Grid surface that feels like Excel — was more engineering than a plain form, but adoption depended on not forcing users to abandon the muscle memory they already had.
Client-side generation of PDF/PPTX/XLSX keeps exports instant and serverless-friendly, at the cost of doing more work in the browser — a deliberate choice for a tool used in bursts rather than at constant scale.
Outcome
The platform replaced the Excel workflow with one auditable system and turned manual, hand-built reporting into one-click multi-format export. It's a live, ongoing engagement — the client keeps commissioning new capabilities, which is the clearest signal the tool earned its place.
Next
JobRun