Karim Diab

– Architected enterprise ETL pipelines using SSIS, integrating 7+ source systems (CRM, ERP, GIS, Retail, Internal Portal, External Portal, EPM) into a centralized SQL Server DWH processing 80K+ records daily at 99% availability - using structured 8-phase DWH methodology; conducted business workshops, defined 400+ KPIs, and delivered the first working dashboard in 7 weeks across a complex government environment. – Installed, configured, and optimized Microsoft SQL Server across 3+ server environments - instance setup, database configuration, indexing, and storage optimization; troubleshot and resolved 15+ critical performance issues across SQL Server and ETL pipelines - reducing average query execution time by 97% and eliminating recurring refresh failures. – Designed Star & Snowflake schema dimensional models - 5 fact tables, 15+ dimensions, SCD Type 1 & 2 — powering scalable enterprise reporting; designed scalable data ingestion patterns (Full Load / Incremental / CDC) across 7+ heterogeneous source systems - ensuring reliable, low-latency data availability for all downstream reporting layers. – Ensured adherence to defined SLAs for data freshness and availability - guaranteeing daily data delivery by agreed deadlines and maintaining 99% pipeline uptime across all production environments; reduced storage footprint by ~65% via SQL Server compression - enabling real-time national indicators updated daily (previously monthly). – Implemented data validation and reconciliation frameworks to ensure enterprise data accuracy - reducing data quality issues via proactive anomaly detection and pipeline monitoring; implemented monitoring, logging, and alerting mechanisms to ensure production pipeline stability and operational readiness across client environments. – Connected to and extracted data from 10+ source systems including SQL Server, Oracle Fusion HCM, ERP, EPM, GIS, and CRM developed automated REST API connections with daily token refresh automation ensuring uninterrupted data extraction across all 75+ reporting assets. – Designed and optimized SSAS Tabular & Multidimensional cubes as enterprise semantic layer - implementing aggregations, partitioning, and model optimization to achieve sub-second query response times; powered 75+ Power BI dashboards and 20+ PMO reports tracking 400+ KPIs for Senior Leadership (CEO, HRH, Sector Heads) across Finance, HR, Procurement, Operations, PMO, GIS, EPM, and CRM. – Implemented dynamic RLS and RBAC securing role-based access for 120 concurrent users aligned with government confidentiality standards; designed data security frameworks covering encryption, masking, and access control aligned with enterprise governance and regulatory standards. – Produced data lineage documentation, data flow diagrams, and architecture documentation aligned with enterprise governance standards - including requirements docs, data dictionaries, KPI definitions, user guides, and handover docs; mentored 10+ colleagues across teams and drove platform adoption across 120+ government users via training sessions and hands-on support.

– Designed multi-dimensional SSAS models (MDX) and delivered 20+ Power BI dashboards across 6 business departments - reducing query refresh time by 12% for 50+ users. – Embedded Power BI reports into internal business applications via Power BI Service APIs enabling automated reporting access; developed custom Power BI visuals to address specific reporting requirements beyond standard visuals. – Designed and delivered 30+ Power BI dashboards for management and administrative teams covering employee KPI tracking, operational performance, and management-level insights for 50-100 users. – Built and maintained ADF + Snowflake ELT pipelines processing 150K+ records daily - ensuring data accuracy and reliability for all reporting layers. – Analyzed and prepared large-scale government datasets using Alteryx - processing ~80K records/day from multiple ministry sources. – Delivered 15+ Power BI dashboards for government policy monitoring and analytics - enabling data-driven decision-making across ministry departments and reducing reliance on manual data preparation. – Defined and implemented data visualization standards and best practices across 3 client engagements (Danone, Mantrac, Ministry of Planning) - standardizing report templates, visual design guidelines, and KPI presentation frameworks adopted by 100+ users across government and enterprise teams. – Leveraged diverse analytics tools across all client engagements: DAX & Power Query (M) for semantic modeling and data transformation, Apache Spark (PySpark) via ADF + Snowflake pipelines (150K+records/day), SQL for data extraction and performance tuning, and Python (Pandas, NumPy) for statistical analysis and pattern identification.

– Developed 10+ Power BI dashboards and reports providing operational and executive insights across business domains - supporting faster, evidence-based decision-making for management teams. – Built 15+ SSIS ETL pipelines ensuring reliable, automated data integration; used T-SQL and Python for data extraction and analysis - eliminating manual data handling and improving data consistency across reporting layers. – Introduced and applied data visualization guidelines and reporting standards establishing consistent design patterns, chart selection rules, and data presentation frameworks across all Power BI reports delivered to business stakeholders. – Utilized core analytics technologies: DAX & Power Query (M) for report modeling and data transformation, T-SQL for ETL pipeline development, and Python for data analysis and insight generation across all business reporting domains.