Maxwell Simiyu
Data Analyst
Profile
I am a detail-oriented Statistician with expertise in sampling, validation, and data analysis using standard statistical practices. I am adept in statistical modeling, forecasting, data mining, trend analysis, and data interpretation. With a strong background in software programming, particularly in R and Python, I excel in developing software applications for statistical modeling and graphic analysis.
Professional Experience
Assistant Statistician
Kenya National Highways Authority | 09/2023 – present
- • Impact Evaluation on the Mau Summit—Kisiani World Bank Road Project, constructed in the 2010s. Tasked with post-survey analysis, data visualizations with R, and statistical testing, determining the road's impact on the regional economy.
- • Monitoring and evaluation practice on roads in central and eastern Kenya, checking progress status of regional projects and tracking finances.
- • Data cleaning and wrangling for post-survey analysis, working with string and numeric data to prepare for frequency distributions and text analysis.
- • Creating the Roads Project Dashboard reporting key metrics such as total km laid, cost per km, start date, progress status and contract sum.
Field Statistical Researcher and Analyst
University of Nairobi | 01/2023 – 06/2023
- • Developed survey and interview questions for research personnel
- • Conducted demographic surveys in Nairobi areas, including counts of crime victims in hospitals and individuals in police custody
- • Created databases with specified IDs to ensure data inferential integrity and reduce redundancy
- • Distributed and analyzed collected field cases to identify demographic patterns
- • Created visualization dashboards for demographic data reports
Education
Bachelor's of Science in Statistics
University of Nairobi | 09/2019 – 06/2023
Excelled in Social Statistics Concepts and Parameter Estimation, gaining strong foundation for applying statistical methods to social sciences and economic settings.
Data Analysis
Jomo Kenyatta University Enterprise School | 10/2021 – 01/2022
Enrolled for data analysis classes using R at JKUATES. Achieved certificate of distinction, gaining knowledge in applying statistical theories to practical survey/research techniques.
Kenya Certificate of Secondary Education
St. Peters' Boys Mumias High School | 02/2015 – 11/2018
Achieved an impressive overall grade of B+ while participating in various extracurricular activities.
Kenya Certificate of Primary Education
Gateway Junior Academy | 01/2008 – 12/2014
Completed primary education with Certificate of Merit, reflecting strong academic performance and dedication to studies.
Projects
Kenya National Highways Authority Road Projects Dashboard
09/2023 – present
- • Collecting and integrating road construction and maintenance project data from various sources
- • Designing and implementing interactive dashboard with R shiny, including collecting modules and caching
- • Creating visualizations using leaflet maps for geographic distribution of projects
- • Implementing real-time updates and user-friendly interfaces for stakeholders
Performance Based Budgeting
01/2024 – present
- • Implementing Activity-Based Costing (ABC) for accurate cost allocation
- • Utilizing percentile rankings for budget position and achievement categorization
- • Developing decision-making frameworks for budget allocation
- • Applying anomaly detection for historical budget data patterns
- • Incorporating Time Series analysis for budget forecasting
- • Creating comprehensive visualizations including heatmaps and pivot tables
Crime Trends and Patterns Dashboard
01/2023 – 08/2023
- • Collected and cleaned crime data from police stations and hospitals
- • Created interactive web-based dashboard using R Shiny
- • Implemented SARIMA modeling for trend analysis
- • Designed time series plots and interactive charts
- • Integrated geospatial analysis for crime hotspots
- • Developed predictive models for crime trends
Skills
Data Analysis
Highly knowledgeable in EDA, visualization, inferential testing, and data wrangling using tidyverse framework for SQL.
Data Mining
Experience with web drivers, POST/GET requests, and API configuration for data mining and integration.
Statistical Modelling
Strong foundation in statistical modeling through academic and practical experience, specialized in software applications for modeling and graphic analysis.
UI Development
Proficient with Shiny for R, Ambiorix, HTMX, and NextJS for modern web development and dashboard creation.
Advanced Excel
Expert in nested functions, pivot tables, Power Query, VBA programming, macro development, and Power BI integration.
SPSS Analysis
Five years experience in ANOVA, factor analysis, cluster analysis, and advanced statistical methods for research design.
Certificates
R for Data Analysis
Distinction in EDA libraries, data visualization with ggplot2, interactive plots with high charter and Plotly. Advanced knowledge in parsnip and tidy models
Computer Science Academy
Star certificate awarded for outstanding performance in computer science competition at Moi Girls High School, demonstrating strong fundamentals and problem-solving skills.
Advanced Excel Certification
Completed at Datanova training camp, UoN. Mastered advanced Excel functions, data analysis tools, visualization techniques, complex formulas, pivot tables, and VBA applications.
Languages
English
Kiswahili
Interests
Music Producer and Sound Designer/Mixer by profession
Rugby Enthusiast, both as a player and pitch-side technician
References
Mr. Isaya Okeyo
Snr. Statistician, KeNHA
i.okeyo@kenha.co.ke
+254 719699168
Ronald Odhiambo
Ast.Director, KeNHA