SQL · Python · Power BI

Clear analysis
for better
decisions.

I use data to understand performance, identify patterns and gaps, and build reporting and visualizations that help teams make informed decisions.

My experience includes public-health and programme data, with transferable skills across data analysis, reporting, operations and business intelligence.

View my work
Background

Who
I am.

Data analyst with hands-on experience in public-health and development data.

I work with health and programme data to improve reporting, understand performance, identify gaps and communicate findings clearly to technical and non-technical teams.

My background includes HIV, TB, PMTCT, maternal and child health and GBV programmes, alongside data validation, quality assessments, dashboards and donor- and Ministry of Health-aligned reporting.

I approach analysis practically: understand the data structure, document assumptions, check quality and build outputs that help people use the numbers in review meetings and day-to-day decisions. My skills transfer across data analysis, reporting, operations and business intelligence.

Areas of focus
HIV Cascade Analysis Healthcare Planning Donor Funded Programmes M&E Systems Design County-Level Disaggregation Data Quality Assurance
Selected work 6 projects

Case
Studies.

Data work from Kenya's public health sector — HIV cascade, health workforce equity, and evidence tools.

/001/
Independent public-health analysis 2026
Kenya Pediatric HIV Cascade Dashboard

Examined where children are being lost across Kenya's HIV care pathway - from diagnosis and treatment to viral suppression. The analysis translated cascade data into estimated child-level gaps and connected them to evidence on retention, adherence and programme support.

Care cascade From diagnosis to suppression
HIV PostgreSQL Data storytelling PowerPoint National estimates
Read case study
/002/
Kenya MOH / SDG review 2024–25
Kenya Health Workforce Gaps

County-level analysis covering health worker density, cadre mix, brain drain patterns, and staffing gaps against the SDG 3c threshold of 44.5 per 10,000 population. Eight companion CSV datasets and a PostgreSQL schema. Findings surfaced material shortfalls in 31 of 47 counties, with Turkana and Mandera furthest from the SDG floor.

County comparison 47 counties · density gap
PostgreSQL Power BI Kenya MOH SDG 3c Publication-quality
Read case study
/003/
Independent public-health analysis 2025
Kenya Tuberculosis: Progress and Gaps in 25 Yrs

Examined Kenya's tuberculosis response over time, bringing together disease burden, case detection, treatment outcomes, TB/HIV integration and programme financing to identify progress and remaining risks.

25-year trend Progress, gaps and risk
Tuberculosis Trend analysis Data storytelling
Read case study
/004/
Independent public-health analysis 2024
Maternal & Child Health Outcomes

Explored how national progress can conceal differences in access and outcomes across wealth groups, locations and care pathways.

Equity lens Outcomes and access
Health equity MCH Programme analysis
Read case study
/005/
Operational analytics tool 2023
Facility Viral Load Analyst

Built an analytical tool to classify viral load outcomes, identify patients requiring follow-up and support more consistent facility-level monitoring.

Follow-up workflow Classify · review · act
HIV programme data Python Operational analytics
Read case study
/006/
Programme mapping tool 2023
Supported Sites Mapper

Combined programme and geographic data to create a clearer view of supported health facilities, service coverage and programme reach.

Programme geography Sites, coverage and reach
Programme mapping GIS Python
Read case study
Capabilities

Data, analysis
& reporting.

I combine programme knowledge, analytical methods and clear communication to support reporting, performance review and evidence-based decisions.

Data management
Data cleaning & validation Structured checks, reconciliations and quality assessment for reliable reporting.
SQL & database design PostgreSQL queries, joins, views and repeatable analytical models.
Data transformation Python and spreadsheets for shaping raw programme data into usable analysis.
Analysis & reporting
Programme performance Indicator analysis, trend review and interpretation of operational gaps.
Reporting & communication Donor and government reporting, performance summaries and clear analytical narratives.
Visualization Power BI, Python and web-based dashboards designed for review and decision support.
Monitoring & evaluation
Routine data review & DQAs Indicator tracking, data-quality assessment and performance-review support.
Results monitoring Reporting frameworks, data flows and practical measurement for programme teams.
Public-health systems HIV, TB, PMTCT, maternal and child health, health workforce and DHIS2/KenyaEMR workflows.
Get in touch

Let's
work together.

I'm open to data analysis, monitoring and evaluation, health information and public-health analytics roles across Kenya, East Africa and remote teams.

wayne@wayneowillis.com