toptal.com
Contact us: +1.888.867.7001
Oussama Samer, Data Engineer and Developer in Paris, France
Oussama Samer

Data Engineer and Developer in Paris, France

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.
Oussama is now available for hire
Hire Oussama

Portfolio

  • Societe Generale
    Microsoft Power BI, SQL Server BI, Microsoft SQL Server...
  • Candriam
    SQL Server BI, SQL Server Integration Services (SSIS)...
  • AXA Group
    Business Intelligence (BI), Microsoft Power BI, Transact-SQL...

Experience

Location

Paris, France

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.

Employment

  • 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, Transact-SQL, 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, Data, SSAS Multidimensional, SSAS Tabular

  • 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, Data, SSAS Multidimensional, SSAS Tabular

  • 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, Transact-SQL, 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, Data, SSAS Multidimensional, SSAS Tabular

Experience

  • 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.

Skills

  • Languages

    Transact-SQL, SQL, T-SQL, Stored Procedure, MDX, Power Query M

  • Paradigms

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

  • Storage

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

  • Other

    MSBI, Star Schema, Data Queries, Reporting, Data, Data Modeling, Data Warehousing, Performance Tuning, Data Analysis, Data Analytics, Data Cleansing, Migration, Reports, Dashboards, Data Engineering, SSAS Multidimensional, Cloud, DAX, Data Visualization, Dashboard Design

  • Tools

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

  • Platforms

    Azure, Oracle

Education

  • Master's Degree in Computer Science Engineering and Data Analysis
    2009 - 2014
    Polytech Nantes - Nantes, France

Certifications

  • Mastering DAX
    DECEMBER 2022 - PRESENT
    SQLBI
  • Microsoft Certified: Azure Data Engineer Associate
    JANUARY 2022 - PRESENT
    Microsoft
  • Microsoft Certified: Power BI Data Analyst Associate
    AUGUST 2021 - PRESENT
    Microsoft
  • Microsoft Certified: Azure Fundamentals
    FEBRUARY 2021 - PRESENT
    Microsoft
  • Microsoft Certified Solutions Expert: Data Management and Analytics
    AUGUST 2017 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM