About Ronald
English
Fluent
French
Native or bilingual
Experience
- Air Liquide Industrial safetyAzure Full Stack BI ConsultantENERGY AND UTILITIESOctober 2019 - Today (6 years and 8 months)In my mission, I acted as Tech Lead of a team of 5 developers, with the following responsibilities:Design and implementation of modern data architectures: Development of adapted solutions to support the client in its digital transformation and take advantage of cloud technologies.Optimization of Data Warehouse (DWH) process performance: Implementation of data structures in Azure Synapse Analytics based on logical diagrams and functional specifications, while maximizing the efficiency of semantic models.Migration of analytical models: Transition of semantic models from Azure Analysis Services (AAS) to Power BI Premium, ensuring the continuity and performance of reports.Automation and securing of processes: Development of CI/CD pipelines to simplify and secure deployments, including the configuration of Azure Data Factory to transfer source files from Azure Blob to the data warehouse via stored procedures.
- TrescalData EngineerMECHANICAL ENGINEERINGJune 2024 - November 2024 (5 months)To improve Trescal's infrastructure, I worked on optimizing and consolidating the financial semantic model by performing the following actions:
- Implementation of an incremental loading of source tables.
- Restructuring of Databricks notebooks for optimized management of bronze, silver and gold tables.
- Consolidation of data from three Atlas instances into a single version on Databricks.
- Implementation of CI/CD pipelines.
- Knowledge transfer, progress monitoring, and documentation of notebooks to ensure high-performance financial reports.
- Complete redesign of the financial semantic model.
- Societe Generale SAMS BI ConsultantBANKING AND INSURANCEJune 2018 - September 2019 (1 year and 4 months)The Business Solution Center (RESG/BSC), a shared services center, is intended to provide the entities and sectors (Finance, Risks, Human Resources, etc.) of the Société Générale Group with global IT solutions. My mission within the BSC was to respond to the needs of accounting data analysis through SSRS and PowerBI reports, develop new SSRS reports as part of the IFRS9 project, set up a PowerBI report in order to manage the status of the rating to reduce the impact of the provision linked to a lack of anticipation in the rating/re-rating. In order to promote the powerBI tool, I was asked to give training to staff from different departments. The purpose of the training was to introduce them to the tool and support them in carrying out projects around PowerBI.Technically I was led to carry out several tasks:· Setting up the infrastructures for the various projects· Database modeling· Modeling and optimization of tabular models· Creating reports from SQL and MDX queries· SQL query optimization· Development of PowerBI reports
Recommendations
Be the first to recommend Ronald
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master 2 Computer Science Speciality Decision-making Computer ScienceInstitut Galilée2013
Certifications
- DP-600: Implementing Analytics Solutions Using Microsoft FabricMicrosoft2024
- MCSE: Data Management and AnalyticsMicrosoft2018