Skip to content
← All entriesLOG 03/08
DV-001 · dataData Manager

Disease Surveillance System

R Shiny applications for a major city public-health commission that supported disease surveillance, geographic trend review, and configurable notifications.

Part No.DV-001
RoleData Manager
StackR · Shiny · SQL Server · EDSS
Data SourceSQL + EDSS
AlertsAuto SMS/Email
ReportsOn demand
Surveillance signalTrend + alert layer
SQL + EDSSOn-demand reporting
01

Public Health at Scale

The commission monitors disease trends across a major city to protect public health. Epidemiologists needed faster access to trend data, geographical analysis, and automated alerting when surveillance metrics crossed critical thresholds.

02

Building the Tools

I built multiple R Shiny applications that pulled data from SQL Server and the Electronic Disease Surveillance System (EDSS). The tools refreshed with new case data, generated interactive epidemiological charts and geographic heat maps, and sent text and email notifications when configured indicators triggered. Epidemiologists could generate reports on demand for a selected date range or geography.

03

Real-World Impact

These tools reduced repeated manual extraction and made emerging patterns easier for epidemiologists to review. Automated notifications surfaced configured threshold events, while the geographic views supported follow-up by neighborhood.

RShinySQL ServerEDSS
← All entriesLOG 03/08