Advanced Excel, QGIS, Power BI
Hi, I’m
Hussein Mahenga
MERL Expert
Moshi, Kilimanjaro, Tanzania
The price of inaction is far greater than the cost of a mistake
Meg Whitman
Summary
I am a social scientist and a Monitoring and Evaluation (M&E) expert with more than 4 years of experience in designing M&E Systems and data analysis for generating evidence-based results for programming. I started off my M&E career with Life and Hope Rehabilitation Organization (LHRO), Bagamoyo Sober House, where I worked as a Project Staff in Implementing Harm Reduction Projects to People Who Use/Inject Drugs (PWUID). I am adept in the use of data analysis tools such as Advanced Microsoft Excel, Statistical Package for Social Science (SPSS), Microsoft Power Business Intelligence (BI) and Maximum Qualitative Data Analysis (MAXQDA). I am also skilled in Result Based M&E system development (Strategic Plans, Project Implementation Plans (PIP), M&E Frameworks, Performance Measurement Frameworks (PMF), M&E Plans, Performance Indicators Reference Sheets (PIRS), Database Management, Tools Development and Knowledge Translation for Policy Change, Advocacy and Use of Findings/Data from Monitoring, Evaluation and Research. In additional, I am adept in District Health Information System version 2 (DHIS2) frameworks reporting systems (Infolink, DATIM and DHIS2 Tracker); CTC2 Analytics and CTC2 Database; Quantum Geographical Information System (QGIS) for Spatial Analysis; and data cleaning using MS Power Query. I possess a Bachelor of Education in Arts (Hons.) in Linguistics and Literature in English from The University of Dodoma, a certificate in Planning for Monitoring and Evaluation from the University of Philanthropy and currently pursuing a Master of Arts in Monitoring and Evaluation (MA M&E) from The Open University of Tanzania.
Overview
6
years of professional experience
6
years of post-secondary education
Skills
- Monitoring and Evaluation
- Health Information Systems and Data Use Strengthening
- Data Quality Assessment
- Data Analysis (Excel, Power BI, MAXQDA, SPSS)
- CTC2 Analytics and Database
- Spatial Data Analysis (QGIS)
- DHIS2 Reporting Systems (INFOLINK, DATIM, DHIS2 Tracker)
- Project Performance Management Plans
- Strategic Planning
- Staff Supervision, Motivation, Capacity Building, and Performance Management
Timeline
Technical Officer - Strategic Information
Family Health International (FHI 360)
07.2023 - Current
The Open University of Tanzania
Master of Arts from Monitoring And Evaluation (M&E)
12.2021 - Current
Data Manager
YOUTH WINGS
10.2021 - 06.2023
M&E Officer
TAWIDO
11.2019 - 09.2021
Data Collection Team Lead
NACOPHA
07.2019 - 12.2019
Administrator
Life and Hope Rehabilitation Organization
01.2019 - 10.2019
The University of Dodoma (UDOM)
Bachelor of Arts from Bachelor of Education in Arts (BED Arts), Linguistics & Literature in English
11.2015 - 07.2018
Work History
Family Health International (FHI 360)
Technical Officer - Strategic Information
07.2023 - Current
Job overview
- Developed a Demand creation tracker and case management linkage form through Kobo Toolbox for EpiC project. I linked the form, using API, to Microsoft Power BI and created a dashboard that facilitated easy monitoring of Peer Educators and/or navigators during implementation of the project.
- Developed a Social Network Analysis dashboard through Microsoft Power BI, linked from DHIS2 tracker using API, for Enhanced Peer Outreach Approach (EPOA) that softened Monitoring of risk Social Networks during the implementation of the project, ie, EpiC.
- Capacitated twelve (12) EpiC technical staffs on Spatial Analyses using Quantum Geographical Information System (QGIS) that softened monitoring of implementation activities through geospatial locations.
- Capacitated thirty-one (31) technical staffs on Online Reservation Applications (ORA) in Dodoma for three days from 6th March to 8th March 2024 at Nashera Hotel in Dodoma to enhance implementation of ‘going online’ activities.
- Conducted more than four (4) Data Quality Assessments (DQA) in Kilimanjaro and Arusha Regions for EpiC Project reports.
- Supported a JICHEKI ORA web app as a backstop for Tanzania's EpiC project, and developed a JICHEKI ORA dashboard that indicates performance to CSO level as well as to peer-specific performance.
- Currently supporting central office for the health informatics position and enhanced a conducive environment for telehealth implementation of activities.
YOUTH WINGS
Data Manager
10.2021 - 06.2023
Job overview
- Observed Data Quality: As a Data Manager, I have managed to lead the team towards reporting timely, accurately and appropriately the project activities and results to the project management team; ensured that routinely collected data summaries are available in a user-friendly format for regular use in program monitoring; worked with the strategic information team to ensure electronic systems are in place to manage and disseminate program data from client to National level; facilitated generation of queries and ensured data cleaning activities are systematically conducted; and tracked referrals and conducted Data Verifications at facilities to ensure that the reported information is correct, precise and accurate.
- Ensured Data Analysis, Dissemination and Use: In addition, I managed to develop an M&E Plan as per the program activities and indicators that helped the team to easily monitor the results. As a data manager, I also enhanced the use of DHIS2 systems (Infolink, DATIM, DHIS2 Tracker, HMIS Tanzania) for both reporting and analyzing data to maximize informed and quality decision making. For the DHIS2 Tracker, I managed to enhance the use of API connections and dashboards to soften monitoring of daily data entry, cleaning, tallying, and reporting activities.
- In data analysis, I managed to enhance not only advanced Excel Dashboards, but also the use of QGIS for spatial analyses (using maps), especially in hotspots and case identification analyses across the SNUs of implementation. I also managed to develop dashboards in Infolink for easy follow up of the performance across reporting periods.
- I am also responsible for developing a data dissemination and use system not only to the project team, but also to stakeholders. In this role, I managed to ensure that the hotspot’s mapping data was much informative; monitored Viral Load data using DAC tool/CTC2 Analytics to easily identify Viral Load uptake and results and shared with CHMT (DACCs) for follow ups. With the use of DAC tool,
- I simplified monitoring of clients’ appointments in ART uptake and follow ups for IITs, TOs, Deaths and Continuity in Treatment. As a result, it improved reporting of Treatment Data accurately, timely and precisely.
TAWIDO
M&E Officer
11.2019 - 09.2021
Job overview
- Monitored progress towards key objectives, enabling real-time adjustments and proactive problem-solving strategies.
- Increased team efficiency by providing training on performance measurement and indicator tracking tools.
- Fostered strong relationships with implementing partners, facilitating collaboration and data sharing for enhanced M&E activities.
- Utilized advanced data visualization techniques to effectively communicate complex findings to non-experts.
- Led quality assurance initiatives for data collection tools, guaranteeing accurate representation of program progress against set goals.
- Boosted project outcomes with the development of strategic M&E frameworks.
- Optimized data collection methods, ensuring reliable information for informed decision-making.
- Conducted in-depth analysis to identify gaps in program implementation, leading to targeted improvements.
- Developed user-friendly reporting templates, simplifying the process of sharing results with stakeholders.
- Coordinated cross-functional teams to ensure timely submission of high-quality reports to donors and partners.
NACOPHA
Data Collection Team Lead
07.2019 - 12.2019
Job overview
- Enhanced data collection for Community-led Monitoring in Kinondoni MC, Temeke MC and Ilala MC.
- Reported the data collected to project coordinator for dissemination and use.
- Harmonized data collection tools from paper-based to electronic through the use of Microsoft Forms and Google Forms.
Life and Hope Rehabilitation Organization
Administrator
01.2019 - 10.2019
Job overview
- Handled sensitive information discreetly, maintaining strict confidentiality at all times as required by company policy or legal regulations.
- Maintained personnel records and updated internal databases to support document management.
- Organized workflow and delegated tasks effectively to ensure timely project completion without compromising quality.
- Managed office inventory levels, ensuring adequate supplies were available while minimizing waste and unnecessary spending.
- Coordinated company events and meetings to foster teamwork and boost employee morale.
- Reduced overhead costs through careful budget management and resource allocation.
- Enhanced internal communication by creating a centralized information hub accessible to all staff members.
- Improved team productivity with introduction of shared online calendar for tracking deadlines and appointments.
- Developed and maintained up-to-date database of contacts, facilitating quick and efficient communication.
Education
The Open University of TanzaniaTanzania
Master of Arts from Monitoring And Evaluation (M&E)
12.2021 - Current
The University of Dodoma (UDOM)Dodoma
Bachelor of Arts from Bachelor of Education in Arts (BED Arts), Linguistics & Literature in English
11.2015 - 07.2018
Work Preference
Work Type
Full TimeContract WorkWork Location
HybridRemoteOn-SiteImportant To Me
Career advancementWork-life balanceCompany CultureHealthcare benefitsWork from home optionPaid time offTeam Building / Company RetreatsPersonal development programsSoftware
Languages
English
Advanced (C1)
Swahili
Bilingual or Proficient (C2)
Accomplishments
- Developed a dashboard using Microsoft Power BI and DHIS2 tracker on Social Network Analysis (SNA) on implementation of Enhanced Peer Outreach Approach (EPOA) strategy for HIV Testing and Counseling Services.
- Conducted capacity building on spatial analysis of HIV testing data using Quantum Geographic Information (QGIS) to six Regions.
- Achieved improved implementation of QuickRes - customized as JICHEKI ORA in Tanzania - by being a backstop for EpiC Tanzania, supporting transliterations, dashboard creation, user accounts assignments, reporting and capacity building.
- Developed Peer Educators/Navigators demand creation tracker using Kobo Tool Box and Power BI through API-automations.
Certification
- DHIS2 Online Academy | GEN-D004-en: Aggregate Customization Fundamentals by DHIS2 issued on May 10, 2025
- From Data Collection to Data Use by Philanthropy University issued on May 1, 2025.
- FHI 360 Global Data Privacy and Protection by FHI360 on April 10, 2024
- PEPFAR | DSY110: Fundamentals of PEPFAR Data & Systems by PEPFAR | DSY110 Certificate | PEPFAR Virtual Academy on May 1, 2024
- HISP | GEN-D001-en: Introduction to DHIS2 by DHIS2 Online Academy on November 14, 2023
- Advocacy for and Monitoring of Sexual Orientation, Gender Identity and Expression by ARASA 15th -29th/11/2022.
- Monitoring and advocating for HIV prevention online short course-2022 conducted by ARASA from 27th 08 2022 to 5/9/2022.
- Social Entrepreneurship for KP-Led CSOs in Tanzania conducted by AVAC From 19th to 23rd April 2021
- Planning for Monitoring and Evaluation by the university of Philanthropy 10th – 19 June 2020
- An Introduction to Human Rights by Amnesty International 18th – 22nd September 2018
Awards
- NOW AWARDS: Noticing Outstanding work for Outstanding Dedication issued on 6th August 2024 by FHI360 (Individual Category). This is an appreciation for development of social network analysis of Enhanced Peer Outreach Approach reports; Actively supporting Jicheki ORA; Capacity building on Geographical Information System (GIS) data analysis and visualization; Report automations from DHIS2 tracker, and other databases, to Power BI through API; and advocating for licensure of Microsoft Office 365 to CSO level to enhance data safety and security.
- NOW AWARDS: Noticing Outstanding work for Exemplary Services provided on 6th August 2024 by FHI 360 (Team Category). The SI Department is acknowledged for its contribution to developing and maintaining performance metrics and dashboards that help in monitoring organizational progress and success.
Interests
Reading Novels, Studying
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Similar Profiles
Ruffin N. MAYAKARuffin N. MAYAKA
Finance and Operations Director at Family Health International – FHI 360Finance and Operations Director at Family Health International – FHI 360
David SizyaDavid Sizya
Country Program Manager at Family Health International (FHI) 360Country Program Manager at Family Health International (FHI) 360
Mbali MadonselaMbali Madonsela
Billing Analyst at family Health International (FHI 360)Billing Analyst at family Health International (FHI 360)
Harleen SohiHarleen Sohi
Associate Director, Proposals/Bid Management (Supervisory Role) at Family Health International (FHI) 360Associate Director, Proposals/Bid Management (Supervisory Role) at Family Health International (FHI) 360
Neema NyamsogoroNeema Nyamsogoro
Auditor In Charge at Ernst & Young TanzaniaAuditor In Charge at Ernst & Young Tanzania