Freelancer profile translated to English.
Back to original languageAbout Farouk
Data Engineer specialized in SQL Server/MSBI/Power BI with 8 years of experience in designing and deploying BI and DataWarehouse solutions for major clients (BNP Paribas, Eiffage, Sage).
Expert in multi-source data integration and development of complete BI architectures, I master the entire decision-making chain: DataWarehouse modeling, ETL development (SSIS, Azure Data Factory, Python), OLAP cube development (SSAS Tabular/Multidimensional), and design of high-performance Power BI dashboards.
My dual expertise in Data Engineering and DevOps allows me to industrialize BI solutions by integrating CI/CD pipelines (Jenkins, Git, Azure DevOps) and automating large-scale data processing.
Key skills:
Microsoft BI Stack: SSIS, SSAS, SSRS, Power BI, Azure Analysis Services
Development: SQL/T-SQL, Python, DAX, MDX, C#
Cloud & DevOps: Azure Data Factory, Jenkins, CI/CD, Git
Databases: SQL Server, SAP HANA, Oracle, PostgreSQL
Rigorous and results-oriented, I support business units in the optimal exploitation of their data while ensuring the performance, security, and maintainability of the deployed solutions.
English
Native or bilingual
French
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- BNP ParibasDevOps Power BI ConsultantBANKING AND INSURANCEJanuary 2022 - January 2026 (4 years)Montreuil, FranceMain missions:– Development of Power BI applications to drive the adoption of the banking DevOps environment– Agile facilitation and migration/optimization of existing reports– Design and maintenance of the DataWarehouse and SQL database optimization– Management of multi-source data flows (API, databases, files, web services, DWH)– Creation and maintenance of ETLs (Python + Bitbucket + Jenkins)– CI/CD administration and job scheduling– Quality control and implementation of multi-source data catalogs– User training and creation of monitoring/alerting scriptsReporting developed:● Activity indicators and tool usage rates, license control● Exploitation of DevOps data to support teams● Cost analysis and resource prediction based on consumption● Analysis and alerts for SecOps vulnerabilities● Monitoring of the migration to Cloud DevOps● Data extractionsTechnical achievements:● Feasibility study and assistance in requirements gathering● Design of the complete BI architecture● DataWarehouse modeling and maintenance (structure + SQL)● SQL/T-SQL optimization● Design and maintenance of ETLs and Power BI reports● BI/DevOps integration for task planning and execution● Access security● Support, testing, validation, and technical documentation
- PeritisPower BI ConsultantBANKING AND INSURANCEJanuary 2021 - December 2021 (11 months)Paris, FranceImplementation and maintenance of Power BI applications for our clients to automate and facilitate billing control and objective achievement.Tasks performed:• Technical analysis and feasibility study• Management of billing anomalies• ETL design and implementation• Power BI report design and implementation• Testing and validation• Technical documentationTechnical Environment: Power BI, DAX, M, Power Query
- Eiffage FranceMicrosoft BI/Power BI/SAP BI ConsultantHUMAN RESOURCESJune 2018 - January 2021 (2 years and 7 months)Vélizy-Villacoublay, France– Migration of the BI application used by HR administration to the SAP HANA environment and development of a Self-Service BI Power BI application– Redesign of the BI application used by the Purchasing administration– Optimization of existing SQL databases– Creation and optimization of procedures– Implementation of a BI application to supervise fine payments– Implementation of a BI application to facilitate the analysis of satisfaction surveys and the smooth running of various activities for branch managers– Implementation of a near real-time BI application for optimizing the analysis of routes taken by drivers– Maintenance of existing BI solutions (HR, Purchasing)– User support and training– Creation of monitoring and alerting scripts/jobsTasks performed:• Technical analysis and feasibility study• Analysis and resolution of anomalies and incidents• Modeling and implementation of the SAP HANA in-memory data warehouse• Implementation of BODS jobs for loading multi-source and multi-format files• Development of ODS/DWH loading procedures in SAP Hana• Modeling of reporting applications (SSBI + Reports and dashboards)• Design and development of Power BI reports and data models• Design and development of Azure AS data models• Testing and validation• Technical documentationTechnical Environment: SQL Server 2008 R2, SAP Hana, Power BI, Power Query, DAX, M, Azure Blob Storage, Azure AS, SSIS, SSAS, SSRS, MDX, TSQL, Dynamic SQL, PL/SQL
Recommendations
Be the first to recommend Farouk
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
- Computer Engineering Degree specialized in Business2016Diplôme d'ingénieur en Informatique spécialisé en Business
- 70-778 Analyzing and visualizing data with Microsoft Power BI.201870-778 Analyzing and visualizing data with Microsoft Power BI.