Freelancer profile translated to English.
Back to original languageAbout Abdellatif
With over 18 years of experience, I have developed solid expertise in two main areas:
Data & BI: Design and implementation of business intelligence solutions in on-premise and cloud environments, with expertise in Datamarts, Data Warehouses, data integration, and data valorization. Involvement in modern architectures, including the medallion architecture, process industrialization, and CI/CD approaches, with a focus on quality, performance, and governance.
Databases: Development, study, design, and administration of databases in on-premise and cloud environments. Expertise in data modeling, datamart design, OLAP models, as well as optimization, monitoring, security, and operational maintenance of data platforms.
Autonomous and rigorous, I integrate easily into multidisciplinary teams. My ability to communicate and adapt to demanding environments allows me to ensure the success of critical data projects.
Technologies:
▪️ Databases: SQL Server, Oracle, PostgreSQL, MYSQL
▪️ BI & Data Engineering: Microsoft Azure, Fabric, Power BI, ADF, Azure Sql, Synapse, MSBI.
▪️ Cloud: Azure, GCP, AWS
▪️ Automation: PowerShell, Shell, Python
▪️ System Administration: Windows Server, Linux, Unix
▪️ Virtualization: VMware, Hyper-V, VirtualBox,
- Microsoft Certified: PL-300 Power BI Data Analyst Associate.
- Microsoft Certified: 70-778: Analyzing and Visualizing Data with Microsoft Power BI
- Microsoft Certified: AZ-900 Azure Fundamentals.
- Microsoft Certified: MCSA SQL Server 2012/2014
- Microsoft Certified: MCTS SQL Server 2008, Business Intelligence Development and Maintenance
French
Native or bilingual
English
Fluent
Spanish
Basic
Arabic
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- SUEZ DSIData Azure POWER BI | FABRIC Consultant [ ADF , MS BI]ENERGY AND UTILITIESOctober 2022 - Today (3 years and 8 months)Paris, FranceIn a hybrid On-Premise and Azure environment, and in an agile project management context:
- Power BI Development (Odyssey Project – SUEZ): Design and development of interactive and dynamic reports with Power BI Desktop, complex data modeling, creation of advanced DAX measures, management of relationships, and KPI visualization for over 2000 users.
- MS Fabric: Design and development of data solutions around Microsoft Fabric in a hybrid On-Premise / Azure environment. Implementation of a medallion architecture (Bronze / Silver / Gold), development of notebooks for data ingestion, processing, and transformation, orchestration of loads via pipelines, creation of Lakehouses and Data Warehouses, as well as development of semantic models for feeding Power BI reports.
Orchestrate analytical flows and automate data processing.- Azure Data Factory: Development and orchestration of data feeding and transformation pipelines from multiple sources, with monitoring, scheduling, and security of processing, towards Data Lake, Data Warehouse, Azure SQL, and Azure Synapse storage and analysis environments.
- Data Architecture: Implementation of a medallion architecture (Bronze / Silver / Gold) to organize flows, improve data quality, and industrialize analytical processing.
- CI/CD and Industrialization: Contribution to the automation of deployments, versioning, and reliable production releases of data and BI components.
- MS BI: Development and Support of SSIS / SSRS / SQL Server solutions, data integration, report design, and SQL optimization.
- Groupe EDFPOWER BI Consultant, MS BIAugust 2018 - September 2022 (4 years and 1 month)Paris, FrancePower BI / MS BI Technical Expert – Doremhy & Hydraulics Directorate Projects
- Advanced Development and Administration on Power BI and MS BI: Design and development of interactive reports, strategic dashboards, and optimized datasets. Creation of data models, complex DAX measures, and dynamic visualizations meeting the business needs of the Doremhy teams and the Hydraulics Directorate.
- Gathering and Analysis of Business Needs: Close collaboration with functional managers to understand operational needs, drafting functional and technical specifications, and translating them into appropriate BI solutions.
- MS BI Development (SSIS / SSRS / SQL Server): Design, development, and optimization of ETL flows with SSIS (flat file integration, REST API, automation, error handling). Creation and maintenance of SSRS reports and SQL Server performance optimization.
- Database Design and Modeling: Development and maintenance of datamarts and data warehouses oriented towards reporting, ensuring data consistency, performance, and quality.
- Automation and Industrialization: Implementation of PowerShell scripts and SQL Server Agent jobs to automate backups, monitor processes, and ensure proactive monitoring of the BI platform.
- Power BI Governance and Security: Application of good governance practices (naming conventions, report lifecycle management, access rights, RLS/OLS), performance monitoring, and dataset refresh optimization.
Technologies: Microsoft BI (SSIS, SSAS, SSRS), Power BI, TSQL, DAX, M Language, SQL Server, Powershell - Groupe RenaultSenior BI Consultant MS BI, Power BIMay 2016 - July 2018 (2 years and 2 months)Within the Quality IT Department, SQL Server and MS BI Consultant for various projects.Development of SQL Server data models (DWH) (deployment management, task automation via SQL Agent and Control-M, and T-SQL query performance optimization).• Optimized T-SQL development of stored procedures, as well as MDX and DAX queries for data analysis.• Development and administration of data flows in SSIS for populating the data warehouse (STG, ODS, DWH).• Development of SSAS Cubes (tabular and multidimensional models), with a focus on the maintenance and optimization of data cubes.• Management of deliverable and environment deployments, ensuring the reliability and automation of processes.• Power BI Development (data models, reports, and Dashboards).• Power BI Service Administration (gateway configuration, access and Workspace management).Technologies: SQL Server, SSIS, SSAS (tabular and multidimensional), SSRS, T-SQL, MDX, DAX, Power BI, Power BI Service.
Recommendations
Be the first to recommend Abdellatif
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master MIAGE, Methods and Applications of Computer Science for Management,l'IUP de l'Université de Toulouse12005Master MIAGE, Méthodes Informatiques Appliquées à la Gestion des entreprises,
- DTS ofl'Institut Spécialisé de Technologie Appliquée d'Agadir.2002DTS de