Wamuyu Wanjohi

Designed and implemented demographic data collection and analytics for a Kenyan ISP including predicting gender based on names for existing customers missing gender data with the aim of contributing evidence on the digital gender divide using polars, DuckDB, and Postgres.
Developed automated data scraping workflows for over 15 mobile money providers across 9 countries. This provided consistent, transparent mobile money pricing data to contribute evidence for financial inclusion initiatives.
Transformed two R and Stata-based analytical reports into interactive Power BI dashboards, applying data storytelling techniques to improve insight clarity and stakeholder engagement.

Document data and information needs for 7 field data collection monitoring activities across 3 continents.
Developed and executed SQL queries to extract critical data; built comprehensive dashboard views for 5 field activity monitoring dashboards, enhancing real-time visibility into team performance across diverse projects on three continents.
Developed automated ETL workflows with Apache Airflow that enhanced the accuracy of dashboard metrics; improved reliability in reporting across five field activity monitoring dashboards, streamlining operations for seven ongoing projects.

Engineered efficient data ETL pipelines utilising Python to facilitate a detailed analysis of more than 10,000 products; directly influenced strategic pricing adjustments resulting in optimised inventory turnover for an e-pharmacy.
Implemented and tested new features for the legal tech software product, directly engaging with 3 corporate clients and enhancing user satisfaction among over 100 active users through iterative feedback processes.
Compiled comprehensive financial information on a regional tour operator across two countries, conducting thorough due diligence that guided stakeholders towards informed decisions regarding essential debt financing.

Facilitated a series of over 20 cross-time-zone discussions, compiling essential feedback about SME growth tactics while delivering substantial contributions to research reports used for strategic decisions impacting African entrepreneurship ecosystems.
Compiled over 100 hours of detailed transcriptions and thorough notes, authoring comprehensive reports and online MOOCs designed to equip early-stage entrepreneurs across Africa with essential resources for successful business entry.