Operations workspace
Internal tools that replaced spreadsheets for day-to-day business operations.
- Role
- Full-stack development
- Context
- Employer work, anonymized
- Category
- Internal tools
This is client or employer work, so it's anonymized: no names, links, internal details or screenshots. The visual below is concept art, not the real product.
The problem
Growing businesses often run operations on spreadsheets, chat threads and memory. That works until it doesn't: nobody knows the current status of a job, approvals happen in messages that get lost, and the same data is typed into three places.
The product
Internal workflow applications for day-to-day operations: structured records, clear statuses, approvals, and the views each team needs to see what's waiting on them. ERP-style in scope, but shaped around how the team actually works.
My contribution
Full-stack development on internal systems and workflow tools.
Technical approach
- One record per real-world thing. Jobs, orders or requests live in one place with a status history, instead of being copied between sheets.
- Status changes are explicit. Moving a record forward is an action with an owner and a timestamp, which makes "who changed this, and when?" answerable.
- Views per role. Each team sees the queue that matters to them rather than one giant table.
Engineering decisions
- Modelling workflows as states and transitions instead of free-form fields, so invalid jumps (approving something that was never submitted) can't happen.
- Shipping small tools that replace one spreadsheet at a time, instead of a big-bang ERP migration that blocks the business.
Challenges and trade-offs
Internal tools compete with the spreadsheet, which is infinitely flexible. Every constraint you add makes the data more reliable and the tool a little less flexible, so the work is finding the few rules that matter and leaving the rest open.
Outcomes
Day-to-day operations moved from spreadsheets and messages into structured internal tools.
Technologies used
- Next.js
- React
- TypeScript
- SQL