At VillageMD — a value-based primary care network — I developed clinical reporting pipelines
and population health dashboards that surfaced actionable insights for care management teams,
supporting proactive outreach to high-risk patient populations.
VillageMD
Population Health Analytics
Responsibilities
- Queried EHR and claims data using SQL to build population health cohorts by chronic condition and risk tier
- Developed Tableau dashboards tracking care gap closure rates, preventive screening completion, and A1C control
- Collaborated with clinical operations and care coordinators to translate data into actionable outreach lists
- Maintained and documented data pipelines for recurring monthly reporting
Key Project — Care Gap Dashboard
Designed and built a Tableau dashboard enabling care management teams to identify patients
overdue for preventive screenings (mammograms, colorectal cancer, diabetic eye exams) and
prioritize outreach. The dashboard reduced manual reporting time and improved care coordinator
efficiency for a panel of several thousand patients.
Impact
The care gap dashboard was adopted into the team's standard workflow, contributing to improved
HEDIS measure performance and supporting VillageMD's value-based care quality metrics.
Gained deep exposure to EHR data structure, claims data, and clinical quality measurement frameworks.