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.

See My Dashboards Download CV
Open for: Full-time Part-time Freelance Consulting · Remote · Worldwide
6+
Years in Enterprise BI
5
Countries: EG · UAE · KSA · DE · ES
100+
Dashboards Shipped
1K+
Daily Active Users
Dashboards

Real dashboards. Real data.

the_quiet_freeze.pbix
01

−39%
47
36
Power BIDAXPythonEN · AR
the_delivery_bill.pbix
02

$5
68%
2028
Power BIDAXWhat-ifEN · AR
the_lending_machine.pbix
03

307K
17
0.50
Power BIDAXIFRS 9EN · AR
Client Work

Delivered for real clients.

Before → After

BeforeAfter

−76%7.9 MB → 1.9 MB
−80%
−72%87,493 → 24,720
+167%3 → 8
BeforeAfter

−92%45.6 MB → 3.4 MB
−69%
−98%3.02M → 57K
−94%1,354 → 84

Selected engagements
01 / BANKING · UAE
1,000+

Power BIDAXSQL ServerBanking
02 / LOYALTY · UAE
52

Power BIDAXLoyalty Analytics
03 / HR ANALYTICS
6

Power BISQL Server DWHDAXHR Analytics
04 / GOVERNMENT · KSA
30

SAP Analytics CloudPower BIMigrationDWH
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), the General Authority for Awqaf (KSA) through Avvale (Spain), AMAN Holding, Elham (KSA), 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.

Jun 2026
Present
Senior Business Intelligence Consultant
Avvale (Spain) · General Authority for Awqaf, KSA
Leading Power BI transformation for the General Authority for Awqaf (KSA) — auditing 30 SAP Analytics Cloud dashboards, rebuilding them in Power BI, and architecting the supporting data warehouse.
Nov 2023
Jun 2026
Business Intelligence Engineer
Synechron · Client: 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.
Nov 2021
Oct 2023
Senior Data Analyst (promoted from Data Analyst)
AMAN Holding, Giza
Promoted to Senior Data Analyst in January 2023; led a team of 5 BI analysts and delivered 30+ KPI dashboards and SSRS reports across 5 business units.
May–Oct
2021
Data Analyst (Remote)
Elham · Riyadh, Saudi Arabia
Delivered data analysis and business reporting solutions for a Saudi-based client, working fully remote.
Nov 2020
Apr 2021
Power BI Specialist (Remote)
Xten · Wuppertal, Germany
Transformed logistics data warehouse outputs into executive-level Power BI dashboards for a German operations client.
Education
Nov 2020
Feb 2021
Diploma in Data Analysis
Information Technology Institute (ITI), Cairo
Sep 2014
Sep 2018
Bachelor of Computer Science
Misr University for Science and Technology (MUST), 6th of October City
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
Free Tools

Built for the BI community.

Free
Icons · 9,000+
Icon Studio
Browse 9,000+ icons across 16 categories. Customize color, style & background — download as SVG or PNG in seconds. No login, no limits.
mdi:chart-bar · mdi:database
↓ customize & export
SVG · PNG · any color · any size
SVG DownloadPNG Export16 CategoriesPower BI
Launch Icon Studio
Free
SQL · T-SQL · BigQuery
SQL Formatter
Paste messy SQL and get clean, indented output instantly. Supports T-SQL, MySQL, PostgreSQL, BigQuery, Oracle and more. Ctrl+Enter to format.
select id,name,sum(amt) from orders where status='done' group by id,name
↓ format
SELECT id, name, SUM(amt) FROM orders WHERE status = 'done' GROUP BY id, name
T-SQLMySQLPostgreSQLBigQueryOracle
Launch SQL Formatter
Free
Power BI · DAX
DAX Formatter
Format Power BI DAX measures and EVALUATE queries. Handles VAR/RETURN blocks, nested functions, and table references. No API calls — runs entirely in the browser.
Sales YTD=CALCULATE(SUM('Sales'[Amount]),DATESYTD('Cal'[Date]))
↓ format
Sales YTD = CALCULATE( SUM('Sales'[Amount]), DATESYTD('Cal'[Date]) )
Power BIDAXEVALUATEVAR / RETURN
Launch DAX Formatter
Free
Power BI · Dashboard
Color Palette Generator
Upload a logo or pick from presets to generate a full BI color palette. See it applied live on a Power BI-style dashboard — base colors, typography, chart series and more.
Upload logo → extract palette
↓ apply to dashboard
Primary · Accent · Background · Charts ×5
Power BIDashboardColorsLive Preview
Launch Color Palette
Free
Power BI · DAX · KPIs
KPI Calculator
Enter revenue, costs, and customer data — get 12 KPIs instantly. Each result includes the formula, a status indicator, and the Power BI DAX measure to copy directly into your report.
Revenue $1.2M · COGS $480K · 450 customers
↓ calculate
Margin 44% · LTV:CAC 3.2× · Churn 7% + DAX
Churn RateCAC · LTVROIDAX Ready
Launch KPI Calculator
Free
Power BI · Themes · JSON
PBI Theme Generator
Design a complete Power BI JSON theme — pick data colors, backgrounds, fonts, and visual styles. See a live dashboard preview update in real-time, then download the .json theme file ready to import.
Pick colors · font · preset → live preview
↓ generate
JSON theme · 8 data colors · Dashboard preview
Power BITheme JSONLive PreviewExport
Launch Theme Generator
Free
SQL · DAX · T-SQL · MySQL · PostgreSQL
Table Generator
Define columns visually — name, data type, length, NOT NULL, PK, Identity, Unique, Default. Get a ready-to-run CREATE TABLE query in T-SQL, MySQL, or PostgreSQL, plus a DAX DATATABLE formula for Power BI.
Add columns → pick types → set rules
↓ generate
CREATE TABLE · DATATABLE · T-SQL / MySQL / PG
T-SQLDAXMySQLPostgreSQL
Launch Table Generator
Free
LIKE · REGEXP · 9 Dialects
SQL Regex Builder
Build LIKE and REGEXP patterns visually with a clickable block palette. Live-test values to see matches instantly. Get ready SQL for T-SQL, MySQL, PostgreSQL, Oracle, Snowflake, BigQuery, Redshift, SQLite and Hive.
Pick blocks → write pattern → test values
↓ generate
LIKE · REGEXP_LIKE · 9 SQL dialects
LIKEREGEXPSQLPattern
Launch Regex Builder
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