JOHN KIGOZI
Business Data Analyst
Nairobi
Summary
Results-driven business analyst with expertise in Power BI and SQL, enhancing operational efficiency at Sama. Achieved a 40% reduction in reporting turnaround time through effective cross-functional collaboration. Proficient in data visualization and process optimization, translating complex data into actionable insights for strategic decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Analyst
Sama
Nairobi Area
01.2024 - Current
- Analyzed large-scale operational datasets (100K+ records weekly) to identify efficiency gaps, driving a 15% improvement in project delivery timelines
- Translated business requirements into structured datasets using SQL, facilitating faster and more accurate reporting for AI training projects
- Delivered real-time performance dashboards in Power BI, improving visibility of operational KPIs and reducing reporting turnaround time by 40%
- Automated recurring reporting workflows using Power Automate, reducing manual effort by 30% and minimizing reporting errors
- Conducted trend analysis and forecasting for resource planning, enhancing workforce allocation accuracy
- Partnered with cross-functional teams (operations, tech, delivery) to align data insights with business objectives, strengthening decision-making
Data Analyst - Project Assistant
HAKI Africa
Nairobi Area
06.2023 - 12.2023
- Performed deep-dive analysis on community program data, identifying trends that enhanced program targeting and impact delivery
- Built interactive dashboards to track program KPIs, increasing reporting efficiency and stakeholder visibility by 35%
- Cleaned and validated datasets to ensure data integrity, minimizing inconsistencies by 25%
- Collaborated with program teams to digitize reporting processes, enhancing data accessibility and turnaround time
- Generated ad hoc reports for leadership, facilitating data-driven decisions on project funding and execution
Data Analyst
Mwananchi Credit Limited
Nairobi Area
11.2022 - 05.2023
- Developed KPI dashboards for loan disbursement, collections, and customer acquisition trends, facilitating informed decision-making
- Conducted customer segmentation analysis, improving targeted marketing efforts and increasing loan uptake by 12%
- Monitored loan portfolio performance and customer repayment behavior, achieving 10% reduction in default rates
- Supported loan demand forecasting using historical data trends, improving planning accuracy
- Worked with credit and risk teams to improve data-driven lending decisions and reporting accuracy
Data Analyst
Phi Sigma Mu Consult Ltd
Nairobi Area
01.2022 - 11.2022
- Analyzed business and financial data to uncover growth opportunities and operational inefficiencies
- Delivered actionable insights that shaped client strategy and improved business performance
- Developed SQL queries to extract and transform data, reducing data processing time by 25%
- Designed and maintained dashboards for client performance tracking, enhancing reporting efficiency
- Supported automation of reporting processes, reducing manual intervention and improving consistency
Education
Bachelor's - International Relations & Security Studies
Daystar University
Nairobi11-2022
Skills
- Business Performance Analysis
- KPI Tracking
- Data Visualization
- Power BI
- Excel Dashboards
- SQL
- Data Modeling
- Predictive Analytics
- Forecasting
- Business Intelligence Tools
- Workflow Automation
- Automation
- Process Optimization
- Customer Analysis
- Transaction Analysis
- Application Development
Certification
- Certificate in Data Analytics (Excel, SQL, Power BI, Python), Sigma Academy Global
- Project Management Foundation, Project Management Institute
Work Preference
Salary Range
$10/hr - $50/hrTimeline
Business Analyst
Sama
01.2024 - Current
Data Analyst - Project Assistant
HAKI Africa
06.2023 - 12.2023
Data Analyst
Mwananchi Credit Limited
11.2022 - 05.2023
Data Analyst
Phi Sigma Mu Consult Ltd
01.2022 - 11.2022
Bachelor's - International Relations & Security Studies
Daystar University