Freelancer profile translated to English.

Description

Data has always been a fascinating puzzle for me, and I have dedicated my career to solving it. For over 11 years, I have passionately navigated the world of data, combining technical expertise, curiosity, and business vision.

My journey began in Business Intelligence, where I acquired a solid foundation in modeling, reporting, and decision support analysis. This initial experience allowed me to develop a real sensitivity to business needs, an asset I have always kept with me.

Today, I am a senior/freelance Data Engineer, specializing in the design, implementation, and optimization of modern data architectures. I work on projects ranging from cloud migration (Azure, GCP, AWS) to the evolution of existing platforms, providing robust, scalable, and performance-oriented solutions.

I have had the opportunity to collaborate with various organizations, from startups to large corporations, which has allowed me to adapt to very different environments and solve complex problems at all scales.

Always staying informed, always curious, I am convinced that data, when properly exploited, can transform a business. My goal: to help my clients make the most of their data to generate tangible value.

Key Skills:

• Data Engineering (ETL/ELT, pipelines, ingestion, modeling)

• Cloud (Azure, AWS, GCP)

• Big Data & streaming (Spark, Databricks, etc.)

• SQL, Scala, Python, BI tools (Power BI, Azure analysis services, etc.)

• SI data migration & modernization projects

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

Direct Assurance
Lead Data Engineer
BANKING AND INSURANCE
April 2021 - Today (5 years and 2 months)
Suresnes, France
Context: Project to migrate the data platform (BI) to a new cloud platform (Axa Shine), which relies on the various services provided by Microsoft Azure and allows AXA entities to build, use, and share a wide range of applications for data analysis.

Achievements:
Project management with the supervision of a team of 8 Data Engineers and project monitoring from realization to delivery.
Analysis of the existing system (reverse engineering) to design an architecture adapted to the new platform, taking into account various functional and technical constraints.
Launch of POCs, benchmarks, and technological feasibility studies.
Development of a framework and a technical foundation for data ingestion and transformation in Scala/Spark, with the integration of unit tests to ensure code reliability and maintainability.
Orchestration of data flows with Azure Data Factory and data storage in Delta Lake format.
Optimization of code and data pipelines to reduce processing time when retrieving and loading historical data (over 15 years of history), thus ensuring faster data availability.
Migration of multidimensional cubes to tabular models with Azure Analysis Services.
Creation of data pipeline monitoring reports on Power BI, using Databricks logs stored in Azure Log Analytics.
Production of necessary documentation for effective communication around the delivered uses.
Support for the testing team on defining testing strategies.

Technical Environment: Databricks, Spark, Scala, Sbt, Delta lake, Python, Azure Data Factory, Azure DevOps, Azure analysis services, Power BI, Log analytics, KQL.
Scamark
Data Engineer Snowflake
AGRICULTURE
January 2021 - March 2021 (2 months)
94200 Ivry-sur-Seine, France
Context: Move to cloud project and modernization of the analytical platform on Snowflake.

Achievements:
Definition and implementation of the solution and technical architecture.
Implementation of CI/CD pipelines.
Urbanization of storage on Snowflake.
Implementation of the raw data ingestion/processing framework.
Replication of raw data via Qlik Replicate.
Design and development of the data loading and transformation pipeline using stored procedures.
Development of PowerShell script triggering the data integration pipeline via the Scamark orchestrator.
Training and support for Data Engineers on Snowflake.

Technical Environment: SnowFlake, Qlik Replicate, Azure DevOps, Shell Script.
Believe
Data Engineer
CULTURE
January 2020 - December 2020 (11 months)
Saint-Ouen, France
Mission accomplished :
— Definition, implementation, and operation of Big Data platforms.
— Administration and monitoring of Big Data platforms.
— Definition and sharing of roadmaps for major data-related initiatives.
— Collaboration and support for all Tech teams in their work.

Implementation of a new Data architecture that allows for the retrieval, centralization, and exploitation of streaming data from stores (Spotify, Apple Music, etc.) :
— Writing of a DAT (Technical Architecture Document) with a proposal for the target architecture.
— Design and development of the data ingestion and transformation pipeline using Databricks notebooks (Scala) and data storage in ADLS Gen2 in Delta lake format.
— Configuration and installation of the Spark cluster.
— Development of the Airflow DAG triggering Databricks data integration jobs.
— Training and support for BI Developers on using data with Dbeaver.

Making an almost interactive dashboard available to business users on Power BI that aggregates information (KPIs & scoring) on different artists to identify promoter artists and predict their development potential:
— Orchestration and monitoring of the entire data pipeline via Data Factory.
— Querying source data on an HDInsight cluster.
— Ingestion and loading of results into ADLS Gen 2.
— Data preparation and transformation using Databricks with Python scripts and loading data into Azure Synapse Analytics.
— Development of an Analysis Services cube that aggregates all indicators.
— Power BI querying Analysis Services for data visualization.

Technical Environment: Scala, Python, Azure Synapse Analytics, Airflow, Azure HDInsight, Hive, Databricks, Azure analysis services, Polybase, Azure DevOps.

Check out Ousama's experience

Be the first to recommend Ousama

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Professional Master's degree in the design and development of secure software
Université de Franche-Comté
2013
Specialized Master's degree in Software Quality
Université Hassan II Mohammedia
2012