All case studies
Public Health — 2021

Department of Health

A pandemic-era case management system that took the Department of Health off spreadsheets and onto real-time, offline-capable reporting.

Software engineeringWorkflow automation
Department of Health — Pandemic Response CMS
The Challenge

Where it started.

At the height of the pandemic response, the Department of Health was coordinating case tracking, contact tracing, and vaccine rollout across regional offices using a patchwork of spreadsheets and manual reporting. Data lagged reality by days, field teams had no offline-capable tool, and every new reporting requirement meant another spreadsheet bolted onto the pile.

What We Built

The solution.

We replaced the spreadsheet patchwork with a single content management system built around how field teams actually report data.

01

Centralized case and contact-tracing records into one system of record, replacing the spreadsheet patchwork.

02

Offline-first data entry for field teams, syncing automatically once connectivity returned.

03

Role-based dashboards so regional offices and central office saw the same data at the same time.

04

Configurable reporting templates so new requirements didn’t mean a new spreadsheet.

The Outcome

What changed.

Placeholder metrics — replace with confirmed numbers from Bani before this goes live.

Reporting lag
-90%

From days to near real-time case data.

Regions onboarded
17

Regional offices migrated off spreadsheets.

Uptime
99.9%

During peak reporting surges.

Field adoption
3 weeks

Time to full rollout across field teams.

The Outcome

What changed.

01

Unified reporting

Regional offices moved off spreadsheets onto one shared system of record, so everyone sees the same case data.

02

Offline-first field data

Field teams could log cases without connectivity and sync automatically once they were back online.

03

Real-time visibility

Central office saw the same reporting numbers as the field, in real time instead of days later.

04

Configurable, not custom

New reporting requirements became a configuration change instead of another spreadsheet bolted onto the pile.

"Placeholder quote — swap for the real pull quote once Bani sends it over."

Bani

Department of Health — placeholder, confirm name & title

More Work

Other case studies.

View all