Oussama Samer
Verified Expert in Engineering
Data Engineer and Developer
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.
Portfolio
Experience
- SQL Server Integration Services (SSIS) - 10 years
- MSBI - 8 years
- SQL Server Reporting Services (SSRS) - 8 years
- SQL Server Analysis Services (SSAS) - 8 years
- Business Intelligence (BI) - 8 years
- Data Warehousing - 8 years
- Data Virtualization - 5 years
- Microsoft Power BI - 5 years
Availability
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
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.
Microsoft BI Developer
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.
Microsoft BI Developer
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.
Experience
Design and ETL Development of Data Warehouse
Financial Organization's Information System Overhaul
• 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.
Education
Master's Degree in Computer Science Engineering and Data Analysis
Polytech Nantes - Nantes, France
Certifications
Mastering DAX
SQLBI
Microsoft Certified: Azure Data Engineer Associate
Microsoft
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Microsoft Certified: Azure Fundamentals
Microsoft
Microsoft Certified Solutions Expert: Data Management and Analytics
Microsoft
Skills
Tools
Microsoft Power BI, Power BI Desktop, Microsoft Report Builder, SQL Server BI, SSAS, Microsoft Excel, Power Query, Visual Studio
Languages
SQL, T-SQL (Transact-SQL), Stored Procedure, MDX, Power Query M, Snowflake
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
Platforms
Azure, Oracle, Google Cloud Platform (GCP)
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, Dashboard Development, Cloud, DAX, Dashboard Design, Google BigQuery
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring