Open To Work
Brian Stephen Otieno
Nairobi
Work Preference
Summary
Results-driven Senior BI & Data Analyst with 5+ years of experience delivering end-to-end business intelligence solutions across Sales, Finance, and Operations in high-growth FMCG and advisory environments. Professional with strong background in data analysis and business intelligence. Skilled in SQL, Python, data visualization, and statistical analysis. Known for collaborative teamwork, adaptability, and delivering impactful results. Reliable and focused on leveraging data insights to drive business decisions and improvements. Proven ability to design automated Power BI dashboards, SQL data pipelines, and SAP BW reporting systems that reduce manual effort by up to 60%, improve forecast accuracy, and enable data-driven executive decision-making. Skilled in KPI framework development, financial modeling, variance analysis, and predictive analytics. Strong collaborator with cross-functional teams including Finance, Sales, and IT, consistently delivering measurable business impact through scalable analytics infrastructure and robust data governance.
Overview
1
1
Certification
5
5
years of professional experience
Work History
MIS Senior BI Data Analyst
Golden Africa Kenya Limited
Nairobi, Kenya
07.2023 - Current
- Created and deployed 10+ executive KPI dashboards in Power BI, providing critical data visualization for informed decision-making across five business units.
- Engineered automated BI reporting pipelines utilizing Power BI and SQL, significantly enhancing reporting efficiency.
- Engineered a comprehensive sales data analytics pipeline, ensuring data cleansing and normalization of three years of regional sales data for improved analytical accuracy.
- Configured SAP BW-to-Excel reporting processes, enhancing efficiency and providing timely data insights for finance and operations teams.
- Built demand forecasting models that improved forecast accuracy by 30%, supporting proactive inventory management and reducing stockouts incidents by an estimated 25% in key product categories.
- Directed cross-functional data integration initiatives across sales, finance, and operations, consolidating data from four source systems into a unified analytical model.
- Established standardized KPI definitions and validation rules to improve data consistency across six departments, achieving a score increase from 68% to 94%.
- Conducted root-cause analytics to identify and resolve 12+ operational inefficiencies in regional execution workflows, resulting in enhanced compliance in performance tracking.
- Engaged with finance, sales, and IT stakeholders to establish and synchronize 50+ KPIs, enhancing the integrity and relevance of reported metrics across business units.
Research & Financial Analyst
Proliferate Advisory
Nairobi, Kenya
09.2021 - 04.2023
- Conducted financial and operational analysis for 5 corporate clients across sectors including FMCG, real estate, and financial services, delivering insights that directly informed investment decisions.
- Developed multi-scenario budgeting and financial forecasting models that improved client planning accuracy by 35%, enabling more precise resource allocation and reducing budget overruns.
- Executed variance analysis for clients, identifying performance gaps averaging 18% below target.
- Constructed detailed financial models assessing project proposals, aimed at optimizing resource allocation and enhancing project ROI estimates.
- Conducted comprehensive research on macroeconomic trends and market intelligence across five industries to enhance client strategies in competitive market environments.
- Developed comprehensive data visualization dashboards and presentation decks, ensuring clarity and quality in analytical deliverables for various stakeholders.
Education
Graduate Certificate - Data Science
Africa Leadership University (ALX)
Nairobi08-2024
Bachelor of Science - Actuarial Science
Multimedia University of Kenya
Nairobi12-2021
Skills
- Power BI
- Tableau
- Advanced Excel
- Statistical analysis using SPSS
- SQL programming
- Python programming
- R programming
- Dashboard creation
- ETL development
- Business analysis
- Data Modeling
- SAP BW
- SAP Analysis Add-In
- ERP Reporting
- System Integration
- Financial Modeling
- Forecasting & Demand Planning
- Variance Analysis
- Predictive Analytics
- Machine Learning
- Risk Assessment
- Cost-Benefit Analysis
- KPI Development
- Data Governance
- Process Optimization
- Stakeholder Management
- Strategic Planning
- Data Quality
- Cross-functional Stakeholder Management
- Critical thinking
Certification
- How to Analyze the FMCG Market, 06/01/25, HAS Group
- Data Science – Python Programming, 08/01/24, ALX Africa
- Machine Learning with R Programming, 10/01/22, Simplilearn
- Data Science with R Programming, 06/01/22, Simplilearn
Timeline
MIS Senior BI Data Analyst
Golden Africa Kenya Limited
07.2023 - Current
Research & Financial Analyst
Proliferate Advisory
09.2021 - 04.2023
Graduate Certificate - Data Science
Africa Leadership University (ALX)
Bachelor of Science - Actuarial Science
Multimedia University of Kenya
Personal Information
Title: Senior Business Intelligence (BI) & Data Analyst
Key Achievement
Automated Reporting
Reduced manual reporting time by 40% using Power BI and SQL automation.
Enhanced Forecasting
Improved planning accuracy by 25% through advanced demand forecasting models.
Dashboard Creation
Developed dashboard displaying 54 African countries' metrics in one interactive view.
Data Integration
Integrated cross-functional business data, resulting in 10% higher accuracy of report