Complex Internal Tooling Web Build
Custom internal tool that replaced spreadsheets and manual handoffs with structured workflows.
Problem
An operations-heavy team was juggling multiple spreadsheets and email threads to track work. Handoffs were unclear and errors were costly. They needed a single tool that matched their process, not a generic project manager.
Constraints
Limited budget for ongoing licensing. The tool had to fit into existing workflows with minimal training. Some data was sensitive and had to stay on controlled infrastructure.
Approach & Architecture
We ran a short discovery to capture states, roles, and handoffs. The app was built as a task- and state-centric web tool with clear ownership and audit trail. No low-code; full control over logic and UI.
Key Technical Decisions
Next.js and TypeScript for type safety and fast iteration.
Database schema mirrored the real workflow states to avoid impedance mismatch.
Export and reporting built in from the start so the team could trust the data.
Deployment & Ops
Hosted on the client's preferred cloud with automated deploys. Access controlled via their identity provider. Backups and retention aligned with their policy.
Impact
The team stopped losing work in spreadsheets and could see bottlenecks. Handoffs became explicit and traceable. The client has since requested a second phase for additional workflows.
Tech stack
What I'd Do Next
Add optional notifications for state changes. Consider read-only dashboards for leadership. Document the workflow model so future changes stay consistent.