At County government of nakuru, I maintained 99%+ accuracy across high-volume administrative records through systematic data quality and verification checks. I also optimized data-cleaning and deduplication workflows using Advanced Excel and Power Query, increasing reporting capacity and efficiency by 20%.
I designed monthly analytics dashboards and reporting templates to track resource allocation, efficiency KPIs, and departmental outputs. My work also included weekly variance and trend analyses to identify discrepancies and share financial and performance insights with senior leadership.
For a merchandising, sourcing, and commercial performance analytics project, I used SQL to evaluate sales, stock turnover, and gross margin trends, then developed Power BI and Excel dashboards for KPI variances, pricing impacts, and inventory movements. In my academic research, I used R and Python to analyze historical datasets and report regression and trend-modeling findings.
