Media Technology · US Radio Advertising
Replacing a 15-year-old Access database with an enterprise portal.
A web-based production and billing portal for thousands of advertising campaigns across hundreds of stations — multi-user, API-integrated, with a full audit trail.

The challenge
What they were up against.
A large US radio advertising company managed production and billing through a 15-year-old 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, verified from production.
More case studies
