InWork GlobalIntegrity. Urgency. Ownership.
Media Technology · US Radio Advertising
Replacing a legacy Access database with an enterprise portal.
A web-based production and billing portal for advertising campaigns across many stations — multi-user, API-integrated, with a full audit trail.
AnonymizedVerified outcomesProduction system

The challenge
What they were up against.
A large US radio advertising company managed production and billing through a legacy single-instance Microsoft Access database — no web interface, no API, no audit trail, no multi-user access.
What we built
The system we shipped.
Production portal
Job creation and management, integration with the order-management API for status sync, workflow routing (sales → production → QA → trafficking), file management, and a reporting dashboard.
Modern stack
Next.js frontend, Node.js/Express API, PostgreSQL replacing Access, AWS deployment (EC2, RDS, S3), and role-based access control.
Results
Outcomes.
Single → multi-user
Concurrent web access (was desktop)
Automated
Order-status sync (was manual entry)
Full audit trail
On all job changes
