Otieno Clifford

Data analyst

Freelance

2022

Designed and deployed 4+ data collection systems using ODK for development organizations including Agha Khan Foundation. Developed 4 interactive Tableau dashboards enabling real-time performance monitoring and impact tracking. Conducted data quality assurance, cleaning, validation, and data mapping across 20+ projects, ensuring high-quality reporting rates. Automated PDF data extraction processes, improving workflow efficiency by 70%. Developed 2 Power BI dashboards improving operational efficiency by 15%. Utilized SQL to join and aggregate data from multiple sources, creating a 'single source of truth' for business performance tracking.

Data Analyst

AMREC AFRICA

2022 - 2022

Supported development of M&E systems and baseline assessments for 3 public health research projects focusing on HIV and TB program monitoring. Performed comprehensive data quality checks and developed data dictionaries following SOPs, increasing operational efficiency by 15%. Developed and revised 5 data collection tools using ODK, Survey CTO, and CommCare. Consolidated, mapped, and harmonized 8 large health datasets, supporting Data Warehouse (DWH) testing workflows and minimizing data turnaround times. Applied epidemiological principles using R and STATA to generate program insights supporting HIV and TB monitoring and evaluation. Conducted capacity building sessions with 15 team members, strengthening organizational data use and reporting capabilities. Developed 6 technical and non-technical reports translating complex statistical findings for diverse stakeholders across varying levels of seniority. Assisted in developing program monitoring dashboards using Tableau for subnational reporting.

Research Assistant

Tropical Institute of Community Health

2021 - 2021

Collected qualitative data from 50+ study participants through multiple methods (reports, audio, photographs). Provided 6 weekly progress reports to senior project management on data collection covering 4 study sites. Conducted 4 capacity building session with study participants during site visits. Supported resource distribution to more than 50 participants following project protocols.