BI Consulting · Data Engineering · Power BI

The intelligence layer
your business runs on.

I partner with banks, fintechs, and enterprise teams to design data systems and reporting that decision-makers trust — and teams actually use.

View Case Studies Download CV
Open for: Full-time Part-time Freelance Consulting · Remote · Worldwide
5+
Years in Enterprise BI
4
Countries: EG · UAE · KSA · DE
100+
Dashboards Shipped
1K+
Daily Active Users
CLARITY
I don't just
deliver reports.
I build the foundation
they run on.

Senior BI Consultant and Data Engineer with a proven track record in high-stakes environments — Emirates NBD (UAE's largest bank), Avvale (KSA enterprise), AMAN Holding, and international clients in Germany.

My practice covers the full analytics stack: data warehouse architecture, ETL engineering, complex DAX development, and executive-grade reporting. Every system I deliver is built for accuracy, adoption, and long-term maintainability.

Based in Cairo. Delivering enterprise BI worldwide — remote, hybrid, or on-site.

Experience

Where I've delivered.

2026
Present
BI Consultant
Avvale · KSA Enterprise Engagement
Leading Power BI transformation for a major KSA enterprise client — auditing 30 SAP Analytics Cloud dashboards, rebuilding them in Power BI, and architecting the supporting data warehouse.
2024
2026
Senior BI Engineer
Synechron · Emirates NBD, Dubai
Designed and delivered two flagship analytics systems for UAE's largest bank: a commission tracking engine serving 1,000+ bankers, and a 52-metric loyalty intelligence suite with full DAX documentation.
2022
2024
Head of BI Analysis
AMAN Holding, Cairo
Built the BI function from the ground up — establishing data models, reporting standards, and executive dashboards across a diversified holding group.
May–Oct
2021
Data Analyst
Elham · Saudi Arabia
Delivered data analysis and business reporting solutions for a Saudi-based client, working fully remote.
Nov 2020
Apr 2021
Power BI Specialist
Xten · Wuppertal, Germany
Transformed logistics data warehouse outputs into executive-level Power BI dashboards for a German operations client.
2020
2021
BI Analyst Intern
Information Technology Institute (ITI), Cairo
Education
2014
2018
Bachelor's in Computer Science
Misr University for Science and Technology (MUST), Cairo
Services

What I deliver.

01
Dashboard Migration & Modernization
Migrate from SAP Analytics Cloud, SSRS, or Tableau to Power BI without losing a single calculation or a stakeholder's trust. Full audit, re-engineering, and structured handover.
Power BISAP ACMigration
02
Data Warehouse Architecture
End-to-end dimensional modeling, star schemas, and ETL pipelines built to scale. Clean data in, reliable analytics out — fully documented and maintained.
SQL ServerSSISDWH Design
03
Executive KPI Systems
C-suite dashboards built around how decisions actually get made — not how data is stored. Clear, fast, and impossible to misread.
KPI DesignPower BIStorytelling
04
Advanced DAX Engineering
Production-grade DAX: complex time intelligence, row-level security, calculated measures, and model optimization for enterprise-scale data.
DAXPower QueryData Modeling
05
BI Audit & Quality Assurance
Deep technical review of your reporting stack — logic accuracy, data reconciliation, performance bottlenecks, and documentation gaps. Critical before and after migrations.
AuditQAGovernance
06
Embedded BI Partnership
Senior BI expertise, without the full-time overhead. I embed into your team for a sprint, a quarter, or longer — remote-first and available worldwide.
ConsultingRemoteFlexible
Data Architecture

Schemas that
never break.

Every reliable dashboard starts with a reliable model. I design dimensional data warehouses from scratch — star schema, snowflake schema, and everything in between — and when needed, I audit and fix the ones already in production.

Star & Snowflake Schema Design
Fact & Dimension Table Modeling
Grain Definition & Business Key Design
SCD Type 1 & 2 Implementation
Conformed Dimensions & Data Vault
Already have a model?
I audit existing data warehouses and reporting models — identifying grain mismatches, broken relationships, slow queries, and missing business keys — and rebuild them to last.
FACT TABLE fact_commission PK commission_key FK banker_key FK product_key FK date_key FK branch_key M commission_amount M payout_amount M target_amount M record_date DIMENSION dim_date PK date_key — full_date · month · quarter — fiscal_year · period · is_weekday DIMENSION dim_banker PK banker_key — banker_name — grade · region · manager_id — hire_date · status DIMENSION dim_product PK product_key — product_name — product_type — commission_rate DIMENSION dim_branch PK branch_key — branch_name · city · region
ETL & Pipeline Design

From source
to insight.

Built with Informatica PowerCenter — every mapping is designed for auditability, reusability, and production-grade reliability. I design the full pipeline: extraction strategy, transformation logic, dimension loading, and error handling.

SOURCE Oracle / SQL Server Source Systems SQ Source Qualifier Extract & Filter EXP Expression Business Logic AGG Aggregator Group & Summarise RTR Router Conditional Route TGT DWH Target Load to Warehouse LKP dim_date Lookup Dimension Enrichment ERR Rejected Records Error Handling
Source Design
Oracle & SQL Server extraction
Full load & incremental strategy
Source Qualifier configuration
Change Data Capture (CDC)
Transformation Logic
Expression & business rule mapping
Lookup & Aggregator transformations
Router-based conditional routing
Reusable mapplets & shared logic
Target Loading
SCD Type 2 dimension loading
Fact table insert / upsert strategy
Session & workflow orchestration
Error handling & load balancing
Case Studies

Selected work.

01
01 / BANKING · UAE
Commission Intelligence

Commission Tracking & Reconciliation System

End-to-end commission engine for 1,000+ bankers at a tier-1 UAE bank — connecting product targets, policy rules, and payout calculations into a single auditable source of truth.

Power BIDAXSQL ServerBanking
Commission Intelligence Dashboard · Power BI
Executive Dashboard · Commission FY 2025 Live Data
Total Commission▲ 12.3%
AED 2.4M
vs Prior Month
Payout RateSafe
94.2%
Net Margin Target
Active Bankers+34 New
1,247
Qualified Advisors
Commission by Product (6M)
Target vs Actual
02
02 / LOYALTY · UAE
52-KPI Analytics Platform

Loyalty Intelligence Suite

52-KPI loyalty analytics platform spanning Member Behavior and Financial Reporting — fully documented DAX, executive-level views, and operational drill-downs across a multi-tier loyalty program.

Power BIDAXLoyalty Analytics
Loyalty Analytics Suite · Power BI Service
Active Members
842K
↑ 5.2%
Redemption
38.4%
↑ 1.8%
Points Issued
12.4M
↑ 9.3%
Avg Spend
1,240
AED ↑3.7%
Tier Distribution
Activity Trend (12M)
03
03 / HR ANALYTICS
Full-Stack BI · End-to-End

NeoHR Intelligence Suite

Full-stack HR analytics built from scratch — SQL Server data warehouse feeding a 6-page Power BI report covering headcount, attrition, payroll, performance scoring, and recruitment pipeline.

Power BISQL Server DWHDAXHR Analytics
NeoHR Intelligence Suite · Executive Overview
Hisham
Mahmoud
BI Analyst
Overview
Executive Live
Workforce
Attrition 4.7%
Payroll
Performance
Talent
Recruitment 22
Executive Overview
NeoHR Intelligence Suite · HR Analytics · 2024
Headcount
107
▲ +8.3% YoY
Attrition
4.7%
▼ Monitor
Payroll
1.29M
▲ +12% YoY
Headcount Trend
Monthly 2024 · 107 active employees
Gender Split
04
04 / ENTERPRISE · KSA
Active Engagement · 2026

SAP → Power BI Enterprise Migration

Ongoing KSA enterprise engagement: auditing and migrating 30 SAP Analytics Cloud dashboards to Power BI — DAX re-engineering, new visual standards, and connected data warehouse design.

SAP Analytics CloudPower BIMigrationDWH
Migration Tracker — SAP → Power BI · KSA
Audited
24/30
80% done
Migrated
18/30
60% done
Time Saved
340h
est./year
Dashboard Audit80%
Power BI Migration60%
DAX Re-engineering45%
DWH Planning30%
Tech Stack

The stack behind the work.

Visualization
Power BI Desktop & Service
SAP Analytics Cloud
Tableau
SSRS
Excel (Advanced · PivotTables · VBA)
Data & Modeling
DAX & Power Query (M)
SQL Server / T-SQL
Oracle SQL
Sybase · Trino · Hive
Engineering
SSIS (ETL)
Informatica PowerCenter
Data Warehouse Design
Star & Snowflake Schema
Python
Domain Expertise
Banking & Fintech
Loyalty & CRM Analytics
HR & Workforce Analytics
Commission & MIS Reporting
Logistics (Germany)
Contact

Ready to build
something that lasts?

Open to consulting engagements, full-time roles, and embedded partnerships — worldwide. Let's talk about what you're building.

Open · Full-time · Part-time · Freelance · Consulting · Worldwide
Phone
+20 105 054 2047
Email
hiishammahmooud@gmail.com
LinkedIn
linkedin.com/in/hiisham-mahmooud
GitHub
github.com/Hiishammm
Location
Cairo, Egypt — Available Worldwide