Cilantrobyte.

Internal tools · 2023

Pillar
Internal tooling for a 400-person ops team

A single workspace replacing the spreadsheet-and-SaaS patchwork a 400-person ops team had been suffering through for years.

Year

2023

Sector

Internal tools

Duration

6 months

Team

3 engineers, 1 designer

(01) The story

Pillar's operations team had grown from 40 to 400 people in three years. The tools hadn't kept up. Fourteen spreadsheets tracked different workflows, three SaaS products covered overlapping territory with no integration between them, and the ops managers spent more time maintaining the tooling than doing the work the tools were supposed to support.

We started by shadowing five ops managers for a full week. Not interviewing — watching. The gap between what they said their workflow was and what it actually was turned out to be the most valuable input of the entire engagement. Three of the fourteen spreadsheets existed solely to reconcile data between two SaaS tools that should have been talking to each other.

The platform we built is a Next.js frontend with a Laravel API (Pillar's existing backend was Laravel and their team knew how to maintain it) on Postgres. We designed the workspace around the actual workflows we'd observed: task queues that matched how ops managers actually triaged work, dashboards that answered the three questions they checked every morning, and an audit trail that eliminated the 'who changed this' conversations that ate hours every week.

The 9,200-hour estimate came from Pillar's ops leadership six months after launch. It's a rough number — they calculated it by comparing the time their team spent on tooling maintenance before and after. The real number might be higher, but they were conservative and so are we.

(02) Challenges

What they were facing

  • 14 spreadsheets and 3 SaaS tools with no integration between them
  • 400-person team with deeply ingrained workflow habits
  • Needed to integrate with existing Laravel backend
  • Ops managers spent more time on tooling than actual operations

(03) What we built

The work

  • Unified ops workspace replacing 14 spreadsheets and 3 SaaS tools
  • Task queue system matching observed triage workflows
  • Morning dashboards answering the three questions ops checks daily
  • Complete audit trail for every data change
  • Laravel API integration with existing backend systems

(04) Outcomes

The numbers

9,200

Hours saved (year one)

14 spreadsheets + 3 SaaS

Tools replaced

91%

Adoption rate (month one)

-76%

Tooling maintenance time

My team stopped complaining about their tools. That's never happened before.

Sarah Chen

VP Operations, Pillar