Chedy B.

• Orchestration and development of MS Fabric Flows and Pipelines.

• Participate in the maintenance and development of the data warehouse on a Fabric architecture for the finance and HR departments for the France, Brazil, and USA entities.

• Development of additional Power BI reporting with a focus on performance optimization and Dashboard models.

• Establish a Fabric capacity Optimization strategy by converting dataflows gen2 to PYspark notebooks (40% performance improvement).

Assume RUN and Data Product Owner functions:

• Define a list of priorities for the Optimization of Large and complex Power BI Dashboards at the data model and Dashboard query level by applying necessary best practices (25% performance improvement).

• Monitoring and tracking of anomalies on Datadog.

• Participate in architecture workshops to establish the feasibility and scope of integrating the Databricks platform.

• Audit and determine the redundancy of cloud services and reports present in Vallourec (20% reduction in volume and load).

Scoping and maintenance of the "Self-service BI" initiative scope

• Audit of all Power BI reports and dashboards in the ADP organizations in France, Romania, Tunisia, and Switzerland.

• Training of end-users on best practices for consuming Power BI dashboards.

• Taking charge of the development of critical dashboards.

• Optimization of underperforming Power BI data models.

• Redesign of the look and feel and functionalities of High-Traffic Dashboards to provide a more ergonomic experience and drive adoption.

Migration project of the architecture entirely managed by Oracle on ODI to a modern architecture on MS Fabric

• Participate in initial meetings with the tech-lead and business teams to design the Fabric architecture plan.

• Development of the Fabric environment to host data (Workspace, pipelines, datalakehouse, connections, access distribution).

• Development of the medallion layers for the data warehouse as well as the necessary transformations with dataflows gen2 (simple and reduced tables) and PySpark notebook (large and complex tables).

• Development of the CI/CD part with Fabric deployment pipelines from a test environment to a production environment

Consultant Data Engineer Azure Data Factory and Azure Synapse mission for the client Groupe Enovos Luxembourg:

• Creation of Azure Data Factory pipelines for accounting data transformation according to specs provided by the business team on Azure Databricks.

• Participation in meetings regarding the development of CI/CD pipelines with the team lead and senior developers on Azure DevOps.

• Development of a medallion architecture based on the bronze, silver, and gold model in the form of a data warehouse in Azure Data Lake.

• Development of PowerShell scripts to automate the pausing and starting of SQL pools on Synapse Analytics.

• Debugging of data pipelines on Azure Data Factory in an Agile context.

BI Engineer MS BI (SSIS, SSAS, SSRS, Power BI) consultant mission for the client Encevo Luxembourg:

• Migration of ETL flows present in SSIS packages to Azure Data Factory.

• Development of orchestration on Azure Data Factory to replace SSIS jobs.

• Migration of reporting dashboards from SSRS and SSAS to Power BI.

• Participation in and leading training workshops on the Power BI Service platform.