Professional Experience
Data Analyst Intern
Jan 2020 – Apr 2020National Social Security Fund (NSSF) | Kiambu, Kenya
- Analyzed employer contribution data using advanced Excel techniques.
- Generated defaulter reports and supported recovery actions.
- Maintained accurate records and delivered high-quality customer service.
IT Assistant & Teacher
Jan 2023 – Dec 2023 & Feb 2021 – Dec 2021Koinange Mixed Secondary School | Kenya
- Taught Mathematics, Physics, and Computer Studies.
- Developed a custom student performance ranking system using Excel/Python that automated grading and class positioning.
- Mentored students in peer learning and group projects.
Data Analyst
Dec 2023 – PresentAstral Aviation Ltd | Kenya
- Built XGBoost and time-series models to forecast cargo tonnage, improving operational planning accuracy by 15%.
- Designed and maintain interactive Power BI dashboards used by management and operations teams for real-time decision-making.
- Conducted competitive benchmarking using Xeneta, enabling data-driven pricing adjustments and market advantage.
- Led data quality initiatives, implementing automated checks that reduced errors and increased reporting speed by 20%.
Education
Bachelor of Applied Science – Actuarial Science
Mount Kenya University | Thika, Kenya
Microsoft Power BI Data Analyst Certificate
Edureka | Remote
Certifications & Credentials
Featured Projects
Airline Fleet Performance Optimization & Predictive Maintenance Analytics
Developed a comprehensive fleet analytics platform that monitors aircraft performance data, maintenance records, and operational metrics to predict maintenance needs, optimize flight routes for fuel efficiency, and reduce unplanned aircraft downtime through predictive analytics.
Aviation Safety Management System (SMS) Analytics Platform
Created an advanced safety analytics platform that integrates safety reports, incident data, compliance audits, and operational metrics to provide proactive safety insights, automated compliance monitoring, and risk assessment for aviation organizations.
Air Traffic Management & Airport Operations Optimization Dashboard
Built an integrated air traffic and airport operations analytics platform that combines flight scheduling, ground handling, passenger flow, and resource allocation data to optimize airport efficiency, reduce delays, and improve passenger experience through data-driven insights.
NGCDF Kenya Constituency Data Analytics — Shiny App
Built an interactive R Shiny application that visualises National Government Constituency Development Fund (NGCDF) data for all constituencies across Kenya, enabling transparent exploration of fund allocation, disbursement trends, and regional comparisons through dynamic charts and filters.
Cargo Tonnage Forecasting Model — XGBoost & Time Series
Developed machine learning models using XGBoost and time-series analysis to forecast cargo tonnage for Astral Aviation, improving operational planning accuracy by 15%. The solution automated demand prediction and helped the operations team allocate aircraft capacity more efficiently.
Aviation Operations Power BI Executive Dashboard
Designed and deployed a suite of interactive Power BI dashboards for management and operations teams at Astral Aviation, providing real-time visibility into fleet utilisation, cargo performance, route profitability, and competitive pricing benchmarks sourced from Xeneta market intelligence.
Technical Expertise
Python
R
Power BI
Excel
MySQL
VS Code
Xeneta
XGBoost
