← Work

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

Next.jsTypeScriptPostgresTailwind CSS

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.