Luwizghie Herald

Designed and maintained production-ready Power BI dashboards to track progress-to-target metrics for the National Malaria Control Program (NMCP). Optimized ETL workflows using Power Query to clean and transform data from DHIS2, the WHO DQA application, and Excel. Engineered data models and DAX measures to assess SLA compliance and identify regional data discrepancies. Led system administration and testing for the OTSS tool within DHIS2 using HNQIS 2.0 architecture, supporting national system sustainability. Managed governance of localized corrective action and ISS&M action plans arising from technical reviews, and mentored district partners on routine data auditing, visualization utilization, and local data ownership.

Contributed to the formulation and institutional launch of the organization’s 5-year strategic plan (2025–2030). Translated strategic priorities into annual operational plans, defining KPIs and baseline milestones for long-term growth. Designed and launched digital data capture architectures to map community feedback loops and strengthen accountability. Led digital communications and advocacy, including website strategy, content management, and social media analytics supporting social norm change. Authored localized Monitoring, Evaluation, Accountability, and Learning (MEAL) methodologies and produced narrative/statistical donor and governance reports, including DHIS2-to-Power BI integrations for leadership dashboards.

Administered enterprise DHIS2 and DREAMS databases, managing complex metadata architecture including trackers, event programs, program rules, indicators, option sets, and organizational hierarchies. Built BI dashboards and scorecards in Power BI, Excel, and DHIS2 to support real-time performance monitoring for field teams and executives. Wrote SQL queries to extract, filter, and clean large longitudinal datasets, preparing structures suitable for star-schema reporting. Implemented data governance SOPs for user access, permissions, and data security/confidentiality. Engineered data validation rules and supported routine data quality assurance at facility and district levels to reduce duplication and missing data. Combined relational database management with spatial analysis using ArcGIS to identify underserved populations and guide targeted interventions, while coordinating quarterly data review workshops and technical capacity building.