HEALTHCARE/ COMMUNITY HEALTH
Role: Business Analyst (Health Informatics)
WAGILE
A Primary Health Centre (PHC) and local public health authority sought to improve vaccination coverage across multiple community wards. Immunisation data was collected manually through paper forms, phone logs, and Excel sheets, making it difficult to track progress, identify defaulters, or allocate staff efficientlys
The organisation needed a streamlined immunisation workflow, centralised data visibility, and accurate reporting to support coverage targets and health outreach activities
The objective was to achieve a coverage rate of ≥95%, improve operational efficiency, and enhance decision-making with clean and reliable data
The immunisation programme faced several operational and data management obstacles
Manual, inconsistent data collection across wards
Difficulty tracking defaulters, missed visits, and high-risk children
No centralised dashboard for monitoring performance
Delays in reporting, impacting national programme submissions
Resource allocation challenges due to limited visibility
Inefficient workflow between PHC workers, supervisors, and local authorities
These issues weakened service delivery, slowed outreach activities, and impacted vaccination outcomes.
I served as a hybrid BA & Public Health Analyst, helping the organisation optimise workflows, improve reporting, and strengthen the performance of its immunisation programme
Worked with immunisation officers, PHC leads, community health workers, and local authorities
Identified gaps in the immunisation process and data collection flow
Mapped stakeholders and clarified reporting roles across wards
Conducted field interviews and workflow observation
Captured functional and reporting requirements for immunisation tracking
Documented business needs for defaulter tracking, scheduling, and ward-level reporting
Designed AS-IS immunisation workflow, highlighting manual steps and duplication
Created TO-BE optimised workflow integrating digital data capture and ward-level dashboards
Introduced standardised data entry templates for health workers
Identified automation and reporting improvements
Cleaned and consolidated data from multiple wards
Created Power BI dashboards showing: Coverage by antigen,Ward-level performance,Missed appointments & defaulters,Outreach success rates
Built performance indicators aligned with national immunisation goals
Provided recommendations for staff allocation to underperforming wards
Introduced a weekly performance review structure
Developed guidelines for data quality and reporting consistency
Trained community health workers on data entry templates and reporting processes
Provided documentation for PHC supervisors and local authority officials
Ensured a smooth handover of dashboards and workflows
Excel (advanced)
Power BI
Miro
WhatsApp Coordination Flow
Paper-to-Digital Templates
Achieved >95% immunisation coverage within the target timeframe
Reduced data entry errors and inconsistencies by over 50%
Strengthened monitoring through ward-level dashboards and clear KPIs
Improved defaulter tracking accuracy and follow-up effectiveness
Enhanced collaboration between PHC workers, supervisors, and local authorities
Delivered a standardised workflow that improved reporting speed & quality
Enabled data-driven planning and resource allocation