The problem
Operations lived in spreadsheets, SQL snippets, and tribal knowledge. Every "quick question" about tenants, staff performance, or rewards became an engineering interruption.
The system
A single Next.js portal with role-based access — executives see cross-company rollups, managers see their communities, support sees the debugging surfaces — backed by the same APIs the product runs on, so numbers never disagree with production.
How it's built
- Next.js app with granular RBAC roles and scoped multi-tenancy
- Cross-domain modules: companies, associates, rewards, tours, email, bulk upload
- Debug tooling built in — support answers questions without engineering
- Deployed on Cloud Run with branch-per-environment auto-deploys
Delivery
Shipped screen-by-screen alongside daily operations; each release replaced one spreadsheet workflow at a time.
Results
- A dozen operational surfaces consolidated into one permissioned portal
- Cross-tenant data-leak classes eliminated by scope-checked queries
- New-hire operator onboarding no longer requires SQL
Client anonymized by industry. Detailed numbers and references available on a call.