Freelancer profile translated to English.

Description

Data Engineer with a background in Traditional BI.

Passionate about Data, always looking for new challenges.

Familiar with technologies:

Azure SQL DB, Azure Synapse Analytics, Power BI, Azure Data Factory, Azure Storage, Azure Analysis Services, SNOWFLAKE, Terraform, Powershell, AzureDevops ...

I have substantial experience in:

ELT/Data Engineering, Cloud Migration, Multidimensional Modeling, Data Warehousing, Data Visualization, and Data Storytelling.

+10 years of experience in data solutions.

Languages

French
Native or bilingual
Arabic
Native or bilingual
English
Fluent
Italian
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km), Paris (up to 10km), Courbevoie (up to km), Nanterre (up to km), Montrouge (up to km)

AXA DIRECT
DATA ENGINEER
BANKING AND INSURANCE
September 2020 - October 2020 (2 months)
Project Move to cloud

With the support of a Tech Lead, I was responsible for writing a technical architecture document (DAT) aimed at identifying a strategy for migrating the on-premise BI platform to AZURE, taking into account infrastructure, security, network prerequisites, and group bounding principles. My tasks consisted of:
- Preparation and facilitation of workshops (Infra, Security, Network, DB, Release mechanisms…).
- Study of the existing architecture.
- Collection of various metrics (Memory, I/O, CPU, processing times…)
- Identification of risks and constraints.
- Definition of 3 migration scenarios with their solution architecture (Full Cloud, Hybrid, Private IaaS).
- Advice on the Migration/Modernization vs. Transformation approach and strategies.
- Writing of the DAT.
SQL Server BI 2014 IBM Private Cloud Azure Datalake Azure Data Factory
SFR DISTRIBUTION
DATA ENGINEER
TELECOMMUNICATIONS
May 2020 - July 2020 (2 months)
POC Azure SFRD on the Sales Bonus Calculation part.

In a team of 4 people (1 Tech Lead and 3 Data Engineers), we carried out a POC for SFR Distribution on the Sales Bonus Calculation part in AZURE (Azure Databricks and Synapse VS Snowflake). I was responsible for the Snowflake part and my tasks were:
- Creation of BRONZE, SILVER, and GOLD SNOWFLAKE tables
- Creation of SNOWFLAKE loading procedures.
- Creation and scheduling of procedure call tasks
- Simplification of the T-SQL code implemented for loading the fact table (from 1500 lines of code to 200 lines) using SNOWFLAKE's Variant types.
- Assistance with Azure Databricks and Synapse: Development of notebooks in SCALA.
Azure Datalake Databricks Terraform DevOps Microsoft Power BI Snowflake
BUFFALO GRILL
SENIOR DATA ENGINEER
RESTAURANTS AND FOOD SERVICE
November 2020 - Today (5 years and 7 months)
BI Redesign / Data Modernization / Digital Transformation Project

In a team of 4 people (1 Tech Lead and 3 Data Engineers) for a project to migrate a cross-functional solution (Sales, Suppliers, Purchasing, Inventory…) from an on-prem SQL SERVER architecture to Azure Synapse (Full MS):
- DWH Synapse modeling of the new point-of-sale system.
- Creation of Terraform scripts for infrastructure deployment (Synapse, Datalake, Aas, Keyvault, Virtual Network…).
- SQL Synapse loading (sources: SQL Server, API, Fileshare, Oracle).
- Environment management (1 dev environment per developer, 1 prod environment).
- Creation of a Sales Tabular cube (Net/Gross Price incl./excl. VAT, number of tickets, Amounts…)
- Implementation of BI chain monitoring.
- Implementation of CI/CD pipelines (Terraform, SQL, Azure Functions, ADF, and Aas deployment).
- Automated installation of SQL scripts (sqlcmd).
Azure Synapse Analytics Microsoft Azure Terraform Azure Datalake Microsoft Power BI Powershell Data Engineer DevOps SSAS Tabular