Clement Luyali Onyoli

Designed end-to-end Google Sheets and Apps Script data pipelines integrating KoBoToolbox, KenyaEMR and DHIS2 to automate reporting and deliver real-time dashboards to 50+ decision-makers, reducing manual reporting by ~40 hours/week and improving data accuracy to 95%+.

Led MEAL activities for USAID Tujenge Jamii project focusing on health data management, reporting, and analysis. Managed data collection systems (KHIS/DHIS2), developed automated reporting tools using Google Apps Script, and coordinated with stakeholders on program monitoring and evaluation.

Built Excel/Access query systems and automated Google Data Studio dashboards for county programs, reducing report generation from hours to minutes and improving data entry accuracy by 72%, with daily automated updates for program managers.

Converted legacy Excel systems into structured databases and automated KHIS submission and dashboards, enabling 100% on-time submissions and cleaning 50,000+ records to inform targeted program improvements that increased retention from 30% to 70%.

Managed IT infrastructure and analytics for sales and digital campaigns, implementing reporting dashboards that informed strategies driving a 15% quarterly sales increase and improving customer satisfaction to 92%.

Designed and maintained school network and labs for 20+ computers, delivered IT training to ~300 students, and implemented security and asset management practices that achieved near 99% uptime and eliminated unauthorized access.

Completed a Diploma in Information Technology focusing on practical IT skills and systems relevant to data management and analysis.

Completed a Certificate in Information Technology covering foundational IT concepts and practical computer skills.