Oussama Samer, Developer in Paris, France
Oussama is available for hire
Hire Oussama

Oussama Samer

Verified Expert  in Engineering

Data Engineer and Developer

Location
Paris, France
Toptal Member Since
June 27, 2022

Oussama is a data consultant and Microsoft BI specialist certified as a solution expert. With nearly a decade of experience in building business intelligence solutions for multinational companies such as AXA and SocGen, he developed the necessary skill set to intervene in the BI process. Oussama specializes in designing data models, building ETL processes, analyzing data, and building SSAS cubes and Power BI/SSRS reports and dashboards.

Availability

Part-time

Preferred Environment

SQL Server BI, SQL, MSBI, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Visual Studio

The most amazing...

...thing I've built is a BI platform that helps businesses do day-to-day analytical reporting to make efficient data-driven decisions.

Work Experience

Microsoft BI Expert

2020 - PRESENT
Societe Generale
  • Developed the SSAS cubes that provide a transversal vision of permanent control teams by measuring the evolution of risks linked to activities of the group entities worldwide.
  • Designed the data model of the data warehouse and datamarts on which the cubes were sourced.
  • Built the Power BI reports and dashboards for the permanent control end users.
  • Organized the code review, troubleshooting, and best practices workshops within the technical team.
  • Managed L3 technical support for the delivered project.
  • Migrated the SQL Server database instance from 2012 to 2019.
Technologies: Microsoft Power BI, SQL Server BI, Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Warehousing, MSBI, Business Intelligence (BI), Database Design, SSAS, Data Visualization, Data Analytics, Relational Databases, PostgreSQL, Dashboard Design, Reports, Dashboards, Power Query M, Migration, Stored Procedure, OLAP, Microsoft Excel, Star Schema, Data Queries, Data Analysis, SQL Stored Procedures, Reporting, T-SQL (Transact-SQL), Data, Databases, SSAS Tabular, Data Migration, OLTP, Snowflake, Analytics, Power BI Desktop

Microsoft BI Developer

2017 - 2020
Candriam
  • Implemented the SSIS interfacing flows with CACEIS, an asset servicing banking group mandated by Candriam, to take over the functions of the RBC Group on a predefined fund scope.
  • Designed the technical architecture of the solution.
  • Implemented several evolutions on the existing SSAS cube, including dimensions, measure groups, and calculations, to manage subscriptions and redemptions.
  • Managed L2 and L3 technical support for the delivered project.
  • Maintained about 200 SSIS packages that I migrated from 2008 to 2012.
  • Built the SSRS reports for monitoring the ETL jobs on a daily basis.
Technologies: SQL Server BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL, Oracle, Performance Tuning, Azure DevOps, ETL, SSAS, Data Analytics, Data Cleansing, Relational Databases, Dashboard Design, Reports, Dashboards, Stored Procedure, OLAP, Microsoft Excel, Data Engineering, Star Schema, Data Queries, Data Analysis, SQL Stored Procedures, Reporting, T-SQL (Transact-SQL), Data, Databases, SSAS Tabular, ETL Tools, Data Migration, OLTP, Analytics, Power BI Desktop

Microsoft BI Developer

2014 - 2016
AXA Group
  • Built the SSAS cubes and SSRS operational reports to implement the European Solvency II Pillar 3 Directive (S2P3) within the AXA Group.
  • Optimized the existing SSAS cubes and SSRS reports.
  • Contributed to the migration from SSRS reports to Power BI reports.
  • Followed up and reviewed the code of the offshore team.
  • Managed L2 and L3 technical support on the existing applications.
Technologies: Business Intelligence (BI), Microsoft Power BI, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Performance Tuning, SSAS, Data Visualization, Data Analytics, Relational Databases, Dashboard Design, Reports, Dashboards, Stored Procedure, OLAP, Microsoft Excel, Data Engineering, Star Schema, Data Queries, Data Analysis, SQL Stored Procedures, Reporting, T-SQL (Transact-SQL), Data, Databases, SSAS Tabular, OLTP, Analytics, Power BI Desktop

Design and ETL Development of Data Warehouse

I designed several data warehouses and datamarts, mainly in SQL Server, for energy, insurance, and finance industries. I also built the ETL data pipelines using SSIS to ingest and transform the source data before feeding the target models.

Financial Organization's Information System Overhaul

I managed the complete overhaul of the existing solution, which suffered from data quality and performance issues. I completed the following activities:
• improved the existing design of the in-house data warehouse;
• reviewed the design of SSIS packages to efficiently log erroneous data and improve performance;
• resized the database instance and ETL server with the assistance of DBA and infrastructure teams; and
• created the SSAS cubes for KPI calculation consumed by live connection Power BI reports.

Languages

SQL, T-SQL (Transact-SQL), Stored Procedure, MDX, Power Query M, Snowflake

Tools

Microsoft Power BI, Power BI Desktop, SQL Server BI, SSAS, Microsoft Excel, Visual Studio

Paradigms

Business Intelligence (BI), ETL, Dimensional Modeling, Database Design, OLAP, Azure DevOps

Storage

Microsoft SQL Server, SQL Server Integration Services (SSIS), Relational Databases, Databases, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), PostgreSQL, SQL Stored Procedures, SSAS Tabular, Data Integration, OLTP

Other

Data Analysis, MSBI, Data Analytics, Star Schema, Data Queries, Reporting, Data, Data Modeling, Data Warehousing, Performance Tuning, Data Visualization, Data Cleansing, Migration, Reports, Dashboards, Data Engineering, Data Virtualization, ETL Tools, Data Migration, Analytics, Cloud, DAX, Dashboard Design, Google BigQuery

Platforms

Azure, Oracle, Google Cloud Platform (GCP)

2009 - 2014

Master's Degree in Computer Science Engineering and Data Analysis

Polytech Nantes - Nantes, France

DECEMBER 2022 - PRESENT

Mastering DAX

SQLBI

JANUARY 2022 - PRESENT

Microsoft Certified: Azure Data Engineer Associate

Microsoft

AUGUST 2021 - PRESENT

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

FEBRUARY 2021 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

AUGUST 2017 - PRESENT

Microsoft Certified Solutions Expert: Data Management and Analytics

Microsoft

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring