Summary
Overview
Work History
Education
Skills
Certification
Work Preference
Timeline
BusinessAnalyst
JOHN KIGOZI

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
Nairobi
11-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/hr

Timeline

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
JOHN KIGOZIBusiness Data Analyst