Web Application
SAI Creative Manager
A bespoke creative asset tracking system for an advertising agency.
The Challenge
Simple Advertising Ideas had 20+ years of creative jobs tracked in spreadsheets — thousands of entries with no searchability, no file linking, and no way for the team to collaborate on task status. Finding a specific job from 2005 meant scrolling through endless rows.
The Solution
We built a Flutter web application backed by a serverless Go + AWS Lambda API (7 Lambda functions deployed via Docker/ECR). Features include global search with 300ms debounce across all historical data, auto-generated job IDs, AWS S3 file uploads with progress tracking, Excel export with hyperlinked file downloads, and Cognito-based authentication. The backend uses DynamoDB for fast lookups across decades of records.
The Outcome
Consolidated 20+ years of creative job history into a searchable, file-linked system — from spreadsheet chaos to instant lookup in under 300ms.
Technologies
- Flutter Web
- Go
- AWS Lambda
- DynamoDB
- AWS Cognito
- S3
Next Project