Open to opportunities

Dean Chigiyegiye

@deanchigiyegiye

Message

Financial and business analyst who turns data into forecasting, dashboards, and actionable decisions.

Zimbabwe

Message

What I'm looking for

I’m looking for a role where I can use FP&A, Power BI, and SQL to build forecasting and KPI dashboards, deliver scenario analysis, and turn complex financial data into recommendations that leadership can act on.

I’m a detail-oriented Business and Financial Analyst with 4+ years of experience in financial planning and analysis (FP&A), data integration, and delivering actionable insights through dashboards and reporting. I leverage Power BI, SQL, Azure Data Lake, advanced Excel, and Python to support strategic decision-making across finance and operations teams.

In my BI Analyst role at National Building Society Bank, I designed and maintained daily KPI dashboards in Power BI for management, contributing to a 2% revenue outcome. I also performed variance analysis to identify and mitigate revenue leakage, reducing revenue loss by 5%, and built financial models to track monthly revenue metrics for ZimSwitch.

Previously at First Mutual Holdings (NicozDiamond), I strengthened forecasting and scenario analysis around exchange rate impacts, reducing firm risk exposure by 7%. I built performance dashboards to track agent productivity and revenue, and supported strategy through competitor analysis and analysis dashboards for strategic business units.

I enjoy solving messy problems with analytics—automating credit note reconciliation with Advanced Excel and Power Query (reducing discrepancies by 10%) and improving performance through agent monitoring (up to 15%). I’m also actively developing through certifications like CFI’s Business Intelligence & Data Analyst (BIDA) and FMVA, and I’ve contributed research on the impact of exchange rates on short-term insurance performance.

Experience

Work history, roles, and key accomplishments

Business Intelligence Analyst

National Building Society Bank

Apr 2024 - Feb 2026 (1 year 10 months)

Designed and maintained daily KPI dashboards in Power BI, delivering insights that contributed to a 2% revenue improvement. Conducted revenue variance analysis and modelling to reduce revenue leakage by 5% and supported monthly board pack reporting.

Power BI KPIs Financial Modeling Data Consolidation Board Reporting Excel

Data Analyst & Business Dev Officer

First Mutual Holdings (NicozDiamond)

Jul 2021 - Feb 2024 (2 years 7 months)

Performed financial forecasting and scenario analysis on exchange rate impacts using Excel and Power BI, reducing firm risk exposure by 7%. Built performance dashboards for agent productivity and revenue, enabling recommendations that improved optimization and strategic decision-making.

Financial Forecasting Exchange Rate Impact Analysis Power BI Advanced Excel Performance Analytics Competitor Analysis Strategic Planning Risk Analysis

Data Analyst (WarPack/Vaitive)

WarPack / Vaitive Zimbabwe

Jan 2021 - Jun 2021 (5 months)

Automated credit note reconciliation in Advanced Excel using Power Query, reducing discrepancies by 10% and improving reporting accuracy. Implemented agent monitoring and management systems that improved performance by 15% and supported market analysis that increased market share by 5%.

Advanced Excel Power Query Performance Optimization Market Research Power BI