Finance and administration platform for a creative studio
Operations Consultant (Finance, Administration & Systems)
The studio had no financial baselines or per-project figures, and its payments, payroll records and collections lived in separate spreadsheets. The platform brings them into one ledger, so the directors can see where the studio stands and payments go out on a weekly schedule, with approvals.
Designed and shipped the studio's internal finance and administration platform, in production on AWS since July 2026: ledger, collections and retainers, payment requests with approvals and a weekly payment run, quotations with a costing engine, payroll records, invoice tracking with fiscal checks and director dashboards.
Changes reach production only after automated integration tests against a real database, so the platform can be extended every week without interrupting the team's work.
The platform also hosts a daily ingestion pipeline from the Meta Marketing API into Postgres and Google Sheets, and an LLM assistant that calls the platform's own tools under the user's role permissions.
Confidential client. Screenshots use fictional demo data.
Stack
- React
- Tailwind
- Node
- Postgres
- AWS
- GitHub Actions
- Vitest
- Meta Marketing API
- LLM APIs
Director view: cash position, runway, receivables, monthly margin and recurring revenue on one screen