Freelance Portfolio

Mohamed Nagy

FP&A Analyst  ·  Power BI  ·  Financial Modeling  ·  Data Analysis

I help businesses turn financial and operational data into clear budgets, forecasts, dashboards, and decision-ready insights using Excel, Power BI, SQL, and ERP data from SAP S/4HANA, Oracle, Odoo, and QuickBooks.

4+
Years experience
5
Core case studies
4
ERP platforms
About

Turning data into decisions

Financial Planning & Analysis and Business Intelligence professional with 4+ years of experience in financial planning, performance analysis, management reporting, accounts payable, tax compliance, and financial control. I combine finance knowledge, accounting accuracy, and data analytics skills to build practical reporting tools that are accurate, automated, and easy for management to use.

Ideal clients
SMEs, startups, e-commerce, manufacturing, pharma & finance teams
Value proposition
Finance + data combined — from raw ERP data to executive dashboards
Languages
English & Arabic
Delivery style
Structured, analytical, business-focused, management-ready
Services

What I can do for you

Financial Analysis & FP&A
  • Budgeting and forecasting models
  • Monthly performance & flash reports
  • Variance analysis: actual vs budget
  • P&L, OPEX & contribution margin
  • AOP support & scenario planning
Power BI & Dashboards
  • Interactive Power BI dashboards
  • DAX measures & KPI cards
  • Dashboard storytelling for management
  • Data model & ERP table optimization
Excel, SQL & Automation
  • Excel financial models & templates
  • Power Query data transformation
  • SQL extraction & analysis datasets
  • Automated monthly reporting packs
  • Operation cycle automation
ERP & Compliance Reporting
  • SAP, Oracle, Odoo, QuickBooks
  • AP tracking & supplier analysis
  • VAT, WHT & ETA e-invoicing
  • Bank reconciliation & treasury
Technical Skills

Tools & platforms

BI & Analytics
Power BIDAXSQL ServerExcel AdvancedPower Query
Financial Modeling
ForecastingBudgetingAOPScenario AnalysisP&L ModelsFlash Reports
ERP Systems
SAP S/4HANAOracle ERPOdoo ERPQuickBooks
Accounting & Tax
IFRSAccounts PayableVATWHTCorporate TaxETA e-Invoicing
Case Studies

Selected project work

01
Sales Master Data Analysis
SQL Server extraction · Power Query · Power BI dashboard
View Dashboard

Built a clean, analysis-ready sales dataset by extracting and transforming SQL Server data using Excel Power Query, then visualized sales performance in Power BI. Analyzed performance by product, channel, country, price point, and sales agent. Identified high-churn revenue products and trends requiring management action.

Deliverables
Sales trend dashboard Revenue segmentation Agent performance view Product insights
02
Financial Performance P&L Dashboard
SAP S/4HANA · Power BI · Margin & OPEX analysis
View Dashboard

Developed a financial performance dashboard connected to SAP S/4HANA ERP data to help management monitor margins, expenses, net profit, and tax impact. Connected and related ERP tables for reliable reporting, built KPIs for contribution margin, OPEX, net profit, and tax impact, and created interactive Power BI pages for financial control and management review.

Deliverables
Interactive P&L dashboard Margin analysis Expense tracking Strategic insights
03
AOP, Forecasting & Flash Reporting
Annual Operating Plan · Scenario modeling · KPI reporting
View Dashboard

Supported the Annual Operating Plan process and monthly performance reporting by coordinating finance, commercial, and operational inputs. Prepared KPI-driven performance and flash reports, built budgets, forecasts, re-forecasts, and full business simulation scenarios, and analyzed product, channel, and project-level performance to identify improvement opportunities.

Deliverables
Forecast models Variance reports KPI summaries Scenario analysis
04
AP, Tax & Compliance Reporting
Oracle ERP · VAT & WHT · ETA e-invoicing · Treasury

Managed accounting, AP, tax filings, e-invoicing compliance, treasury operations, and financial statement support across Oracle ERP. Processed 200+ invoices monthly with compliance controls, handled VAT, WHT, corporate tax, and ETA e-invoicing compliance, and prepared bank reconciliations, cash movement tracking, and monthly financial statement support.

Deliverables
Clean AP workflow Compliant tax submissions Reconciliation reports Month-end support
05
Operation Cycle Automation
Excel · Power Query · SQL · Power BI · End-to-end workflow

Designed an automated operation cycle reporting workflow connecting sales, purchasing, AP, inventory, collections, and month-end control data into one structured management view. Mapped end-to-end operation cycle stages, owners, source systems, and required control points. Created KPI views for order status, invoice processing, supplier aging, inventory movement, cash collection, and cycle bottlenecks. Added exception alerts, aging buckets, and automated monthly reporting outputs for management review.

Deliverables
Automated dashboard Exception alerts Aging buckets Faster decisions
Work Process

How I work

1
Understand
Clarify business goal, available data, reporting audience, KPIs, and preferred output format.
2
Prepare data
Clean, validate, reconcile, and structure data using SQL, Excel, Power Query, or ERP exports.
3
Build model or dashboard
Create financial model, dashboard, report, or analysis pack with clear assumptions and logic.
4
Validate
Check totals, tie-outs, trends, anomalies, formulas, and business reasonableness.
5
Deliver insight
Provide a management-ready file plus a concise explanation of findings, risks, and next actions.
6
Automate cycle
Set refresh logic, exception flags, cycle-time KPIs, and repeatable reporting steps for ongoing control.
Credentials

Education & certifications

ACCA DipIFRS
ACCA Global, UK
View Certificate
FMVA® — Financial Modeling & Valuation Analyst
Corporate Finance Institute, Canada
View Certificate
BIDA® — Business Intelligence & Data Analyst
Corporate Finance Institute, Canada
Financial Analytics Certification
Power BI, SQL, Excel Power Query — Era Soft Institute
B.Sc. Business & Finance (English Section)
Ain Shams University, Cairo
View Certificate

"I combine finance knowledge, accounting accuracy, and data analytics skills to build practical reporting tools that are accurate, automated, and easy for management to use."