Data & MEL professional

Hi there, I'm Tracey.

I'm a statistics graduate based in Nairobi, and I build the data systems behind good decisions, from KoboToolbox forms in the field to Power BI dashboards for reporting. For the past two years I've supported monitoring, evaluation and data quality for public health and community development programmes across Kenya.

Tracey Onyango, data and MEL professional, outdoors in Nairobi
2+
Years in M&E and data roles
8
Counties covered in programme data work
8+
Digital data-collection tools built
What I do

Services built around clean, reliable programme data

From the first field form to the final dashboard, I support each stage of getting programme data right.

Data cleaning & quality assurance

Validation, deduplication and completeness checks that catch errors before they reach a report.

Field data collection & supervision

Digital tool design in KoboToolbox and ODK, enumerator support and multi-county field coordination.

Statistical analysis

Analysis in SPSS, Stata, R and SQL to turn raw datasets into findings that hold up to scrutiny.

Dashboards & reporting

Power BI dashboards and Advanced Excel workbooks that make programme data easy to act on.

Experience

Where I've worked

Roles spanning data entry, field research, quality remediation and MEL support across Kenyan public health and development programmes.

Apr 2026 – Jun 2026

Temporary Data Clerk

PATH Kenya, Nairobi

Entered and verified programme data, corrected discrepancies and built Excel trackers to monitor data entry progress and support timely reporting.

Apr 2025 – Jun 2025

Data Analyst — Data Quality & Remediation

Clinton Health Access Initiative, Nairobi

Cleaned and verified programme data across 8 counties, followed up with field teams on missing information, and prepared summaries and Power BI dashboards.

Dec 2024 – Mar 2025

Data Clerk

PATH Kenya, Nairobi

Set up validation checks, built Excel trackers for reporting deadlines, and flagged and followed up on errors and missing information.

Oct 2024 – Dec 2024

MEL Assistant (Internship)

Kenya Community Development Foundation, Nairobi

Developed 8+ digital data-collection tools in KoboToolbox and built monitoring trackers consolidating records from multiple counties.

Aug 2024 – Sep 2024

Quantitative Research Assistant

B&M Consult Kenya, Nairobi

Collected and entered field data using structured survey forms and helped prepare research reports from the results.

May 2023 – Sep 2023

Research Assistant (Attachment)

AMREC Consultants, Nairobi

Supported data collection and entry, interviewed respondents, and compiled findings into structured reports.

Jun 2022 – Aug 2022

Field Research Assistant

Leonard Cheshire, Kisumu (Nyamira and Muhoroni)

Collected and verified field data for M&E activities in rural communities, engaging directly with community members.

Projects

Independent data work

Two personal projects, chosen to show both ends of the pipeline: cleaning messy raw data, and turning clean data into a dashboard people can actually use.

Kenya vs East African Peers development indicators dashboard in Power BI, showing life expectancy, under-5 mortality, GDP per capita and access to electricity charts

Kenya vs East African peers: a development indicators dashboard

A Power BI dashboard comparing Kenya against Tanzania, Uganda, Rwanda and Ethiopia across eight indicators in health, economy and education, pulled live from the World Bank API. One parameterised Power Query function fetches all eight indicators rather than a separate query for each, so the dashboard is built to refresh as new figures are published.

Kenya is highlighted in navy against muted grey peers, with headline cards for life expectancy, under-5 mortality, GDP per capita and electricity access, all driven by DAX measures.

Power BI Power Query DAX World Bank API
Download the .pbix file
18,204
Loan records analysed
65% / 93%
Model accuracy / sensitivity
36
Variables in the source dataset

Logistic regression analysis on bank loan default

My BSc Statistics capstone project at the University of Nairobi, built with a team of four coursemates under Prof. George Muhua. Using a Bondora peer-to-peer lending dataset of 18,204 loan records and 36 variables, we built a binary logistic regression model in R to predict the probability of loan default from demographic, socio-economic and loan-specific factors.

The workflow covered bivariate and correlation analysis, backward stepwise variable selection, and model evaluation with Wald's test, a likelihood ratio test and a confusion matrix. The final model reached 65% accuracy, with age, gender, employment status, occupation, home ownership and loan terms all coming out as significant predictors of default.

R Logistic Regression Stepwise Selection Confusion Matrix
Download the full report

Public health incident data cleaning

A 199-record, 28-column public health incident dataset from Insecurity Insight, hosted on HDX, with inconsistent country naming, missing fields and overlapping disease tags. I standardised country names with an ISO-code lookup, removed empty columns, and restructured six disease fields into binary flags to preserve multi-disease incidents rather than collapsing them into one category.

Every cleaning assumption is documented, such as treating blank counts as zero, and the results are validated through summary breakdowns by country, year and disease type.

Excel VLOOKUP PivotTables COUNTA
Read the write-up
199
Records cleaned across 28 columns
Certifications

Continued training

Ongoing coursework in data analysis, monitoring and evaluation, and applied AI tools.

Data Collection and Analysis
InsDev Consulting, 2026 (ongoing)
Data Analysis Bootcamp
InsDev Consulting, 2026
View certificate
AI for Research, Insights & Data
PoliSync Centre for International Policy Engagement, 2026
View certificate
AI for Operations, Admin & Planning
PoliSync Centre for International Policy Engagement, 2026
View certificate
Artificial Intelligence Training
ICT Authority, Kenya, with Pathways Technologies, 2026
View certificate
Monitoring and Evaluation
Jomo Kenyatta University of Agriculture and Technology, 2024
View certificate
Introduction to Data Analysis
AMREC Consultants, 2023
View certificate
Introduction to Mobile Application Tools
AMREC Consultants, 2023
View certificate
Get in touch

Let's talk about your data

Whether it's cleaning a dataset, running a field data collection exercise, or building a dashboard, I'd like to hear about it.

Based in
Nairobi, Kenya