Franck Boumi

Main Activities:

• Implementation of a Medallion architecture of the data Lake (Raw, Bronze, Silver, Gold):

 Development of data ingestion flows for feeding the Raw layer: Implementation on Azure Synapse from various ERP sources (M3, JDE, SAP, K2…)

 Technical-functional management of data transformation in Databricks (bronze, silver, gold) and development of Notebooks

 Implementation of good code management practices: Creation of packages and .whl files and Databricks bundle to promote deployment.

 Industrialization and Orchestration: Implementation of continuous integration processes for the

deployment of data solutions and machine learning models and the orchestration of flows.

 Creation and deployment of Power BI reports

• Continuous improvement: Production monitoring, incident management and operational maintenance of reporting

• Agile Management with DevOps: Using Azure DevOps for sprint planning, management of

backlogs and task tracking.

• Versioning and deployment: versioning management with Git and Azure DevOps, automated deployment of solutions, promoting reusability and efficiency.

Technical environment:

Azure Synapse, Databricks, Unity Catalog, Delta Lake, Azure DevOps, Python, PySpark, Scala, SQL, Git, VS Code, SQL Server, DBeaver, Teams, SharePoint.

Project: Implementation of a decision-making tool to optimize the monitoring of the Credit department's performance, by presenting the performance of account managers (Achieved VS Objective) and also providing score predictions for each potential customer considering a loan.

Main Activities:

• Collection and analysis of needs from the business

• Design of the analysis database

• Implementation of data integration pipelines via Azure Data Factory

◦ Connection to ADLS and extraction of data from Azure Blob files

◦ Ingestion of data from Azure Storage to SQL Server

◦ Implementation of a medallion architecture (Bronze, silver and gold)

• Continuous Integration of multi-source data via the SQL Server Integration Services tool

◦ Implementation of SQL queries for data extraction

◦ Transformation and consolidation of data via SSIS components

◦ Project deployment

◦ Planning the execution of the ETL

• Development of interactive reports on Power BI Desktop

• Extraction and transformation of data with POWER QUERY

• Data modeling with Power Pivot.

• Creation of custom calculations and measures with DAX

• Publication of reports on PowerBI Services for sharing.

• Management of access to data and reports via Workspaces

• Automation of report refresh with On-premises data gateway

• Development of technical documentation and user training

• Monitoring and maintenance of existing PowerBI reports

• Implementation of queries and stored procedures for data extraction to meet customer needs

Main Activities:

• Collection and analysis of needs from a Business consultant

• Design of the analysis database

• Modeling of medallion architecture for data storage (Bronze, silver and gold)

• Implementation of Python scripts for extracting unstructured data from flat files

• Continuous Integration of multi-source data via the SQL Server Integration Services tool

◦ SQL query for data extraction

◦ Integration of python scripts into SQL Server integration Services components

◦ Transformation and consolidation via SSIS

◦ Deployment and planning of the execution of the ETL process