Freelancer profile translated to English.
Back to original languageAbout Romuald
I am a Senior Developer and Tech Lead Microsoft BI and Project Manager with over 14 years of experience in designing and managing business intelligence projects. I have worked on strategic missions for clients such as SNCF Réseau, Allianz, Société Générale, and USAID, combining technical expertise on the Microsoft BI suite (SSIS, ADF, Azure Databricks, SSAS, Power BI, SQL Server) with project coordination skills. I am involved in the entire business intelligence value chain: data warehouse architecture, cube modeling, ETL flow development, and KPI and report creation. Familiar with agile and V-cycle methodologies, I also master Azure environments (ADF, DevOps, Databricks, Analysis Services). I act as the link between business and IT teams, with a strong ability to frame, structure, and deliver reliable solutions.
French
Native or bilingual
English
Basic
Can work on-site
Paris (up to 50km), Lyon (up to 50km), Nantes (up to 50km), Lille (up to 50km), Bordeaux (up to 50km)
Experience
- SNCF RESEAU – DIRECTION I2DData ArchitectTRANSPORTATIONJuly 2023 - February 2026 (2 years and 7 months)Saint-Denis, FranceSQL Server 2017 to SQL Server 2022 Migration Project•Writing the specifications•Documenting the configurations of existing SQL Server 2017 instances on TAIDO servers•Inventory and backup of existing databases on each server•Inventory and backup of existing SQL job scripts on each server•Inventory and documentation of access rights to existing databases on each server•Installation and configuration of a SQL Server 2022 instance on TAIDO servers•Database restoration•Migration of the SSIS catalog to the new instance•Restoration of SQL jobsSATIS (ATESS_V1) Integration Solution Migration to ATESS_V2 Project•Analysis of the existing system•Analysis of the new requirements and writing technical specifications•Proposal of a new project architecture (Integration flow architecture)•Definition of the project schedule with the client•Definition and task allocation•Design of STG, ODS, and ARCHIVE databases•Development of SSIS flows•Implementation of development standards•Implementation of optimization strategy for the TAIDOV4 database (Indexing, Table Partitioning)•Development of Power BI reports•Production deployment and incident management
- TIAMA France – DIRECTION FINANCIAIRETech Lead MSBIMECHANICAL ENGINEERINGSeptember 2022 - June 2023 (9 months)Saint-Denis, FranceMigration of MSBI on-Premise solution to Azure cloud• Analysis of requirements• Technical and financial project proposal preparation• Writing project technical specifications• Project schedule definition• Organization of project committees• Design of the data warehouse on Azure SQL Database• Assistance to junior developers in setting up Azure Data Factory and Azure Databricks flows• Design of the SSAS tabular cube on Azure Analysis Services• Implementation of CI/CD deployment on DevOps for continuous integration and version control with GitHub• Assistance to junior developers in Power BI report development• Assistance to business users in qualification testing• Post-production monitoring and incident management within Azure DevOps
- ALLIANZ ASSURANCE – DIRECTION ORGData Engineer Power BIBANKING AND INSURANCEJanuary 2022 - July 2022 (6 months)Paris, FranceAchievements: Migration of BO reports to Power BI• Analysis of requirements expressed through user stories by the Product Owner• Participation in Sprint Planning Meetings• Participation in Daily Meetings• Participation in Sprint Review Meetings for report presentation to business users• Data Warehouse update by creating new Data Marts• Development of SSIS packages for populating created Data Marts• Implementation of KPIs and measures under SQL Server Analysis Services (SSAS)• Design of Power BI reports• Unit testing• Production deployment of reports and post-production monitoring• Maintenance of ETLs and Power BI reports through RUN management with Jira
Recommendations
Be the first to recommend Romuald
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
- Azure Databricks and Spark for Data EngineersConsort2025Azure Databricks and Spark for Data Engineers
- Azure DevOps Engineers (AZ400)Consort2024Azure Devops Engineers (AZ400)