Operations platform
Studio Kids Management
A connected platform for a children’s talent management business: internal operations, family onboarding, and a public website. CRM, casting, invoices, documents, and communications share one data model.
The problem
Staff and families were working across spreadsheets, paper packets, and disconnected tools. The replacement needed to make daily work simpler while handling sensitive family records carefully.
How I approached it
I built three applications around a shared PostgreSQL database, with separate access boundaries for staff, families, and public submissions. The internal AI assistant uses permission-filtered tools and turns proposed changes into drafts for human review.
Inside the build
- Unified talent profiles, casting projects, invoicing, commissions, documents, and email workflows.
- Built a staff AI assistant with 27 tools, permission filtering, and human review before changes.
- Protected sensitive fields with encryption and Azure Key Vault, with separate staff and family access controls.
- Replaced a seven-page registration packet with guided digital onboarding and document uploads.
- Added scheduled email, deployment automation, and operational runbooks for ongoing maintenance.
The result
Built an integrated workflow from public application to family onboarding and internal operations, including a digital replacement for a seven-page registration packet. The admin platform is backed by more than 700 automated tests.