Freelancer profile translated to English.

Description

Senior BI Consultant with 13 years of experience, expert in MSBI, Power BI, Fabric, and Azure BI. Holding several Microsoft certifications, I master DAX, SQL, and Python. My career combines technical development and project management across various sectors, ensuring rapid adaptation and delivery of complex solutions.

Certifications:

70-461: Querying Microsoft SQL Server 2012/2014

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

70-466: Implementing Data Models and Reports with Microsoft SQL Server

DP-900: Microsoft Certified: Azure Data Fundamentals - DP-900: Microsoft Azure Data Fundamentals

AZ-900: Microsoft Certified: Azure Fundamentals - AZ-900: Microsoft Azure Fundamentals

DP-203: Microsoft Certified: Azure Data Engineer Associate - DP-203: Data Engineering on Microsoft Azure

PL-300: Microsoft Certified: Power BI Data Analyst Associate - PL-300: Microsoft Power BI Data Analyst

DP-600: Microsoft Certified: Fabric Analytics Engineer Associate - DP-600: Implementing Analytics Solutions Using Microsoft Fabric

DP-700: Microsoft Certified: Fabric Data Engineer Associate - DP-700: Microsoft Fabric Data Engineer Associate

Languages

French
Native or bilingual
English
Fluent
Arabic
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

BNP
Role: TECHNICAL EXPERT – DATA ARCHITECT
BANKING AND INSURANCE
February 2024 - July 2025 (1 year and 5 months)
Paris, France
Power BI, SSIS, Fabric, and SQL Development
- Developed the entire ETL part using SSIS
- Designed and developed business intelligence solutions (reports, interactive dashboards)
- Advanced data modeling (Power BI semantic models with DAX optimization)
- Created dynamic reports and interactive dashboards.
- Implemented granular security (RLS - Row-Level Security)
- Fabric (Data Flow GEN2, Semantic Model, Warehouse, Lakehouse etc.)
BI Administration & Optimization
- Configured and optimized BI infrastructure (SQL Server, Power BI Service, VNet Gateway, etc.)
- Installed and administered BI servers
- Optimized performance (SQL queries, semantic models, ETL pipelines)
Designed and developed Data Warehouses according to dimensional models: star schema, snowflake schema, bottom-up, top-down
Advanced performance optimization via:
- Partitioning (SWITCH method for efficient volume management)
- Strategic indexing (Columnstore, Clustered/Non-Clustered)
- Schema redesign for improved query efficiency
Migrated DWH and ETL processes to Azure (SQL MI, ADF)
- Deployed and configured Azure services (SQL Managed Instance, Power BI Service, VNet Gateway, etc.)
- Installed and configured Self-Hosted Integration Runtimes for local/hybrid ETL execution.
- Converted and adapted SQL queries.
- Developed ADF pipelines
Project Management & Steering
- Gathered and analyzed business requirements, estimated costs, planned, and managed BI projects
- Coordinated end-to-end BI projects (from design to deployment)
Mentoring & Innovation
- Transferred skills and wrote technical documentation
- Monitored technological trends and proposed solutions
• Functional environment: Developed KPIs and indicators to track cybersecurity activities and data.
SQL Server, SSIS, SSAS, SSRS, POWERBI, AZURE BI, AZURE ADF, Fabric, MDX, DAX, SQL, TSQL, ,Visual Studio 2019/2022, JIRA Agile/Scrum, CICD, TFS
ORANGE
BI Expert
TELECOMMUNICATIONS
January 2015 - December 2022 (8 years)
Arcueil, France
Power BI & Analytics
- Designed semantic models (star schema) for high-performance datasets,
- Deployed solutions on Power BI Service (workspaces, gateways),
- Developed DAX measures for real-time analysis,
- Created dynamic reports and interactive dashboards.
Expertise in Data Warehousing & Modeling
- Designed and developed Data Warehouses according to star/snowflake schemas.
- Advanced optimization via:
- Partitioning (switch method),
- Strategic indexing (Columnstore/Clustered/Non-clustered),
- Schema redesign for enhanced performance.
- Successfully migrated platform (SQL Server 2012 → 2019) with continuity guarantee.
Proficiency in Microsoft BI Technologies (MSBI)
- SSAS (Tabular/Multidimensional):
- Developed and optimized 50+ cubes (partitions, refresh modes),
- Created complex measures in MDX/DAX,
- Managed roles and security.
- SSIS/SSRS:
- Configured and tuned services,
- Automated ETL flows and report generation.
Cloud Data & BigQuery
- Managed complex queries on Google BigQuery (GCP),
- Optimized costs and execution times,
- Integrated with cloud ecosystems.
Project Management & Leadership
- Led technical teams (Data Engineers, Analysts) using Agile/Scrum methodology,
- Coordinated BI projects from conception to deployment,
- Ensured deadlines, quality, and business alignment.
• Functional environment: Analyze the impact of campaigns and promotions on sales (online/in-store) and customer behavior. Model competitive projections using SQL, MDX, DAX, and cubes in Power BI.
• Technical environment
SQL Server, SSIS, SSAS, SSRS, POWERBI, Bigquery(GCP), MDX, DAX, SQL, TSQL, TERADATA SQL Server, SSIS, SSAS, SSRS, POWERBI, BigQuery (GCP), MDX, DAX, SQL, TSQL,