Data Analyst | Uasin Gishu County Government (Data workflow automation and standardized preparation for analytics)
Built automated reporting and data processing workflows that operationalize cleaned, transformed datasets for downstream analytics use. Developed reusable templates for financial assumptions, validation logic, and documentation to standardize how underlying data is prepared and interpreted. Implemented VBA macros and Power Query pipelines to reduce manual data handling and improve data quality for departmental reporting. • Automated operational dashboard for inter-departmental budget tracking (35% reduction in manual entry time) • Implemented interactive forecasting models using scenario-based Excel modeling (50% increase in decision speed) • Built robust data cleaning pipelines and standardized validation logic (99.9% error reduction) • Created reproducible documentation system and assumption templates to improve audit readiness (40% improvement)