Dubai, UAE · Open to opportunities

Edwin Muchalanje

Financial Investment Analyst · Alternative Assets · CFA Candidate

I turn financial data into investment decisions: building valuation and pricing models, BI reporting and the tools around them, across private equity, energy, real estate and corporate finance.

View my work
Portrait of Edwin Muchalanje
8+ yrs▲Finance & investment
CFACandidateCFA Institute
8+Years in finance & analytics
40+VC portfolio holdings tracked
6Markets across Africa & Middle East
3Live AI-powered apps built
About

Investment thinking, backed by data I can build myself.

I'm a results-driven Financial Analyst with 8+ years of progressive experience in investment analysis, financial modelling and business intelligence across private equity, energy, facility management, real estate and corporate finance.

I manage portfolio company reporting, support fundraising and run valuations across African and Middle Eastern markets. I build dynamic pricing and investment models, and use Power BI, SQL, Python and advanced Excel to turn complex data into clear recommendations for senior management.

What sets me apart: when the right tool doesn't exist, I build it, from portfolio CRMs to AI-powered research platforms.

Expertise

What I bring to the table.

01

Investment analysis

  • Valuation (DCF, NPV, IRR)
  • Due diligence & M&A support
  • Portfolio company monitoring
  • Fundraising support
  • Market-entry research
02

Financial strategy

  • Financial & pricing models
  • Budgeting & forecasting
  • Feasibility & profitability
  • Variance & trend analysis
  • Capital allocation
03

Reporting & compliance

  • Consolidated statements
  • IFRS reporting
  • VAT & excise (UAE FTA)
  • KPI frameworks
  • Board & management packs
04

Data & technology

  • Power BI dashboards
  • SQL data modelling
  • Python automation
  • AI-powered tools
  • Cloud deployment (AWS)
ToolkitExcel · Power Query · VBAPower BISQL / MySQLPythonC#DjangoETL pipelinesLooker StudioTableauSAP FICOOdooAWS
AlsoMarket basket analysisStatistical analysisMarketing analyticsBenchmarkingProject managementFunctional specs (FSD)
Projects

Tools I've built.

Working applications with full business-analysis documentation, showing how I approach a problem from requirements to deployment.

Meridian portfolio page: performance vs S&P 500, risk measures and allocation
AI · INVESTMENT ADVISORY

Meridian

An AI investment advisor and tracker for stocks, ETFs, forex, commodities, crypto and bonds. It tracks a multi-currency portfolio against the S&P 500, monitors earnings and news, and gives buy/hold/sell analysis tailored to your risk profile.

  • Performance vs benchmark, volatility, drawdown, Sharpe, beta and VaR
  • Earnings calendar, news sentiment and price/RSI alerts
  • AI asset analysis, portfolio review, daily brief and advisor chat
PythonDjangopandasGroq · Gemini · OpenRouterYahoo FinanceChart.js
MarketScope app screenshot
AI · INVESTMENT RESEARCH

MarketScope

Pick a country and an industry, and MarketScope researches the live web to draft an investor-grade report on policy, economic conditions, market, competitors, tax and risk, with every source referenced.

  • 14-section report: executive summary to risk matrix
  • Entry-strategy comparison and due-diligence checklist
  • Edit in the browser, download as PDF or Markdown
PythonDjangoGroq · Gemini · OpenRouterWeb searchPDF export
Ask Your Data app screenshot
AI · DATA ANALYTICS

Ask Your Data

Upload a spreadsheet and ask questions in plain English. An AI analyst queries the data with real SQL and answers with key numbers, a chart and the exact query, so every figure can be checked.

  • Self-service answers in about 12 seconds
  • Read-only SQL sandbox: the data can never be changed
  • CSV/Excel import and follow-up questions
PythonDjangoSQLpandasClaude APIChart.js

// More on the way: Sales Insights Dashboard · Customer Feedback Analyzer

Experience

Where I've worked.

A progression from accounting to investment analysis, with technology at every step.

Apr 2025 — Present

Financial Investment Analyst

Private Family Office · Dubai

  • Analyse quarterly LP reporting from a VC fund position, producing performance summaries on MOIC, unrealised gains/losses, write-offs and sector composition across 40+ pre-seed holdings.
  • Screen new investment opportunities against the office's investment criteria, flagging risks and upside for senior decision-makers.
  • Monitor a Dubai car-rental portfolio company: analyse its financial and operational reports, attend board meetings and run internal audits.
  • Build data pipelines that consolidate portfolios across South Africa, Zimbabwe, Botswana, Zambia and Mozambique into one master source for CEO and shareholder reporting in Power BI.
  • Develop financial models, business cases and valuations; analyse actuals against budget and forecast; liaise with auditors, advisors and portfolio management.
Mar 2023 — Apr 2025

Financial Business Analyst

Clyde Engineering Consultants · Dubai

  • Developed project-based financial models for energy-saving projects; analysed feasibility, profitability and sustainability.
  • Led budgeting and forecasting, and analysed monthly financial statements against targets.
  • Built dashboards on energy consumption and solar production, translating daily energy data into financial value.
  • Developed in-house systems that automated data transfer, document approval, benchmarking and invoicing.
Apr 2021 — Mar 2023

Financial Analyst

Vernewell Group · Dubai

  • Prepared consolidated financial statements under IFRS with real-time Power BI dashboards for executives.
  • Used SQL to extract and analyse large datasets; automated Excel reporting with macros.
  • Wrote business plans, budgets and forecasts; developed financial policies to manage cash flow and internal controls.
  • Handled VAT and excise registration and filings with the UAE FTA for the company and clients.
Nov 2019 — Mar 2021

Price Analyst & Accounts Assistant

Repair Plus LLC · UAE

  • Built pricing models in SQL and Power BI that made pricing more accurate and more profitable.
  • Analysed competitor pricing, cost and market trends; presented recommendations to management.
Jul 2017 — Aug 2019

Assistant Accountant

Zimbabwe National Statistics Agency (ZIMSTAT) · Harare

  • Maintained AP/AR ledgers and reporting; supported budgets, audits and asset valuation.
Credentials

Achievements & qualifications.

Key achievements

  • Led the rollout of a company-wide Django systemClyde Engineering
  • Deployed an energy CRM on AWS with workflow automationClyde Engineering
  • Introduced Looker Studio for data-driven decisionsBusiness intelligence
  • Mapped and implemented company MySQL databasesClyde Engineering & Vernewell

Education & certifications

CFALevel I Candidate
CFA Institute
  • B.Com (Hons) AccountancyMidlands State University
  • Financial Modeling & Valuation AnalystCFI · 2024
  • SAP FICO · Advanced Cloud ArchitectureEdoxi · 2024
  • AWS Cloud PractitionerAWS Skills Center · 2024
  • Asset ManagementGreat Learning · 2023
  • Fintech: The Future of FinanceUniversity of Texas System (edX) · in progress
  • Business Analysis · Power BI · SQL · Looker StudioCFI · Alison · Anaconda · Analytics Academy · 2022–23

Virtual work experience

  • Investment banking comparables & valuationCiti
  • Corporate tax, OECD / BEPS 2.0PwC
  • Data analytics & Power BI storytellingAccenture
  • Data visualisationTATA
  • Fundamentals of Digital MarketingGoogle
Contact

Looking for an analyst who can model the numbers and build the tools?

I'm open to investment, financial analysis and strategy roles in Dubai and remote. Let's talk.

Request CV

Get my CV in your inbox.

Leave your details and I'll email my latest CV to you personally.

Your details are only used to send you my CV.

Chat on WhatsApp