Services
I design and implement a wide range of scalable digital solutions with a focus on **web-based**, **mobile**, and **dashboard-driven** applications for data management, analytics, and decision support. My work spans across health, agriculture, education, humanitarian aid, and finance sectors. Below are some of the key services I offer:
• Capacity building and training on advanced data tools – including Excel (Power Pivot, Power Query, DAX, M), SQL, Power BI, Tableau, and DHIS2 integration.
• Design and development of custom web and mobile applications – for data collection, tracking, quality assurance, and performance monitoring.
• Automation of data workflows – streamlining manual Excel processes into real-time reporting pipelines using Power Query, Power BI, REDCap, and other ETL frameworks.
• Dashboard development – building interactive data visualization platforms for routine program reviews and donor reporting (Power BI, Tableau).
• Elicitation and analysis of system requirements – translating user needs into functional and technical specifications.
• Development and deployment of database systems – including regulatory HR systems, training trackers, appointment platforms, and inventory management tools.
• Monitoring and Evaluation (M&E) support – including indicator framework alignment, data validation (DQA), service quality assessment (SQA/CQI), and reporting systems.
• End-user support and training – on information systems, data entry protocols, Microsoft Office Suite, and operational dashboards.
• IT infrastructure and support services – including system deployment, hardware and network troubleshooting, data backup, continuity planning, and liaising with ISPs.
System Demos
ACHIEVEMENTS/CONSULTANCY
Period | Company | Position / Role | Description (Developed Tools & Systems) |
March 2025 – To Date | World Food Programme (WFP) | Data Analyst |
(1) Developed an Interactive Performance Dashboard in Tableau – Tracks project progress and generates real-time insights. (2) Built a Central Beneficiary Repository – Centralized system improving data integrity and reducing duplication. (3) Implemented a Comprehensive Training Tracker – Monitors and reports on trained beneficiaries. (4) Automated Zambia’s Monthly Commodity Price Data Pipeline – Enables integration and visualization on WFP’s DataBridges portal. (5) Redesigned MODA Data Collection Tools – Enhanced data quality and indicator alignment for M&E. |
Aug 2024 | GIZ | Data Analytics Expert | Developed a Data Analytics-CDF System – Real-time visualization, tracking, and monitoring of CDF disbursements to promote transparency and accountability. |
April 2023 – Feb 2025 | FHI360 / CDC EPHO TA Project | Advisor / STO – Data Systems & Knowledge Management |
(1) Linked Excel Power Pivots & Power BI to DHIS2 (EPHIAS). (2) Mentored staff in SQL, Power Query, and Power BI. (3) Automated SRM indicator reporting via web-based platform. (4) Deployed GSM, SIMS, and TSS systems for monitoring site visits. (5) Developed a training tracking database. (6) Built SQA & CQI systems with interactive dashboard scoring. (7) Developed DQA for cross-system data consistency. (8) Built meeting tracker for follow-up actions. (9) Successfully deployed QuickRes for AHD client appointment tracking. |
Feb 2020 – Mar 2020 | CDC’s Quality Improvement Program (UNC Global Projects) | Data Manager |
(1) Mentored staff in SQL, Excel Power Pivot, Power Query, and Power BI. (2) Developed Facility & Provider Assessment System. (3) Created QA Cervigram Interpretation Training Tool. (4) Developed Provider Tele-Consultation System. (5) Built Daily Data Capture System with role-based access. (6) Deployed REDCap for clinical data management. |
Feb 2020 – Mar 2020 | Greenland Services Ltd | IT Consultant | Developed Inventory & Sales Management System – Tracks stock levels, reorders, supplier deliveries, and sales. |
Feb 2017 – Nov 2019 | Zambia Electronic Clearing House Limited (ZECHL) | 1st Level Support Specialist |
Onboarded banks to the Zambia National Financial Switch (NFS). Supported IST specs interpretation and transaction troubleshooting. Assisted with NETXMS and other internal application setups. |
Jul – Nov 2016 | STEP Up – Zambia (Chemonics) | IT Consultant | Developed Project Web Data Management Application – Centralizes training records and sponsorship data. |
Apr – May 2016 | Kucetekela Foundation | IT Consultant | Developed Web Data Management Application – Tracks data for sponsored students. |
Nov – Dec 2015 | Zambia National Education Coalition (ZANEC) | IT Consultant | Developed CSOs Web Data Management Application – Manages funding, registration, and reporting. |
Feb – Nov 2015 | Health Professions Council of Zambia (HPCZ) | IT Consultant | Developed Regulatory Human Resource Information System – Manages registration, licensing, accreditations, and teaching institutions. |
Jun – Jul & Sept – Nov 2014 | SPLASH Zambia | IT Consultant | Developed Project Web Data Management Application – Repository for project deliverables (boreholes, trainings, etc.). |