Microsoft Excel
JOHN GABRIEL MMBANDO
Business Analyst
Dar es salaam,Dar es salaam
Summary
Business Analyst with 1+ years optimizing operations through requirements gathering, data analytics, and process improvement. Proven expertise in stakeholder management, financial modeling, compliance, and KPI reporting.
Overview
3
3
years of professional experience
4
4
Certifications
Work History
Business Analyst - Grants, Risk & Compliance
Deloitte – USAID Afya Yangu Southern Program
Dar es Salaam
01.2025 - Current
- Analyzed 150+ sub-grantee fund requests totaling TZS 6.5B against USAID compliance frameworks, identifying discrepancies and reducing request errors by 25% through data validation and process refinement.
- Conducted 200+ financial data verification assessments across 12 sub-grantees to ensure 100% compliance with donor regulations, preventing TZS 390M in non-compliant expenditures.
- Performed 45 field monitoring visits across 8 regions to validate program implementation, delivering insights that improved budget adherence by 30% and enhanced asset utilization tracking.
- Generated 50+ bi-weekly compliance reports tracking 25+ KPIs with trend analysis, informing management decisions and improving program accountability scores by 35%.
- Designed and optimized 5 grant monitoring tools and risk assessment frameworks, streamlining workflows and reducing turnaround time by 20% while increasing data accuracy by 40%.
- Led cross-functional collaboration with 15+ stakeholders across program, finance, and compliance teams, enhancing reporting accuracy by 45% and reducing submission delays by 30% through capacity-building for 20+ staff.
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
Junior Business Analyst - Finance Operations
Dhillon Business Solutions
Dar es Salaam
06.2024 - 01.2025
- Analyzed financial data covering 10+ M in monthly transactions and identified 25+ process inefficiencies, recommending improvements that reduced accounting cycle time by 20% and prevented TZS 2.5+ in potential errors.
- Collaborated with 15+ stakeholders across finance, operations, and IT teams to gather 100+ requirements for financial reporting enhancements, translating business needs into 8 solutions that improved reporting accuracy by 35%.
- Executed month-end close activities by reconciling 150+ accounts, conducting variance analysis on TZS 7+ M in transactions, and documenting 12 financial processes, reducing close time by 3 days.
- Developed 10 financial reports and 5 Power BI dashboards with 30+ metrics to support management decision-making, improving business performance visibility and enabling data-driven decisions for 25+ executives.
- Designed custom dashboards for tracking key metrics across various departments, increasing transparency in performance evaluation efforts.
- Identified trends within large datasets, providing valuable insights for management review and action planning.
- Increased collaboration between departments by developing cross-functional data sharing procedures, resulting in more informed decisionmaking.
Junior Business Analyst - Banking Operations
Akiba Commercial Bank
Dar es Salaam
06.2023 - 12.2024
- Analyzed 5,000+ monthly banking transactions and reconciled 200+ accounts to ensure 99.5% data accuracy, identifying and resolving 150+ discrepancies that prevented TZS 12M in potential errors.
- Documented 15 operational processes and spearheaded 3 improvement initiatives for banking operations, enhancing efficiency by 25% and achieving 100% compliance with Bank of Tanzania regulatory standards.
- Gathered and analyzed business requirements from 20+ stakeholders across 5 departments to improve financial reporting workflows, resulting in 30% faster report generation.
- Prepared 60+ management reports with 40+ financial metrics and trend analysis, supporting strategic decisions that optimized resource allocation and reduced operational costs by 15%.
- Collaborated with cross-functional teams to optimize workflows and drive process improvements.
Education
Bachelor of Accounting With Information Technology -
Institute of Finance Management (IFM)
Dar Es Salaam07.2024
Skills
Business Analysis & Requirements Gathering
Process Optimization & Documentation
Data Analysis & Financial Modeling
Stakeholder Engagement & Communication
Risk Assessment & Compliance Analysis
Data Validation & Quality Assurance
Project Coordination & Cross-functional Collaboration
Reporting & Business Intelligence
Business Requirements Documentation
Languages: English (Fluent), Swahili (Native)
Microsoft Excel Microsoft Dynamics NAV Grant Management Systems
Problem-Solving Analytical Thinking Attention to Detail
Certification
Certified Public Accountant, National Board of Accountants and Auditors, Tanzania, (NBAA) - Ongoing
References
- Amina, Mangu, Assistant Head of Finance, amina.mangu@mwanza.go.tz, +255 763 367 222, Akiba Commercial Bank (ACB)
- John, Ritte, Regional Program Manager, jritte@deloitte.co.tz, +255 784 209 820, Deloitte Consulting Ltd
- Gaspari, Shiliba, Head Of Cybersecurity Services, Gaspari.shiliba@ubx.co.tz, +255 767 400 288, UBX Tanzania Limited
Software
Timeline
Business Analyst - Grants, Risk & Compliance
Deloitte – USAID Afya Yangu Southern Program
01.2025 - Current
Junior Business Analyst - Finance Operations
Dhillon Business Solutions
06.2024 - 01.2025
Junior Business Analyst - Banking Operations
Akiba Commercial Bank
06.2023 - 12.2024
Bachelor of Accounting With Information Technology -
Institute of Finance Management (IFM)