About Stephane
French
Native or bilingual
English
Fluent
Experience
- Natixis BPCEData Engineer & AnalyticsBANKING AND INSURANCEAugust 2023 - February 2026 (2 years and 6 months)Paris, FranceProject: Migration of data and data pipeline from Sybase IQ database to SQL Server:
- **Migration Strategy Steering**: Design of a phased and functional domain plan to ensure a smooth transition without service interruption.
- **Infrastructure Modernization**: Complete migration of table structures, historical data, and business logic (stored procedures) from Sybase IQ to SQL Server.
- **Performance Optimization**: Significant improvement in processing times through strategic indexing and optimized use of temporary tables.
- **Data Quality and Reliability Assurance**: Implementation of a daily "parallel run" and automated non-regression tests to validate the integrity of results between the migration environment and production.
- **Operational Support**: Rigorous monitoring of daily operations and on-call management to ensure high availability of the data pipeline.
Technologies used: SQL Server, Control M, Sybase IQ, Jira, Confluence, Power BI, BO - EDFSolution Architect & BI ExpertENERGY AND UTILITIESJune 2022 - August 2023 (1 year and 2 months)Colombes, FranceSolution Architect & BI Expert – Support in Digital Transformation
- **Strategic Solution Design**: Design and architecture of solutions for new commercial offers (Opt-in, boiler maintenance) in close collaboration with Product Owners and technical referents.
- **Agile Environment Steering**: Lead the implementation of projects using the SAFe methodology, ensuring alignment between business needs and technical deliverables.
- **Innovation and POC**: Realization of a proof of concept (POC) on the lead transformation tunnel using data virtualization with Denodo and reporting in Power BI.
- **Techno-Functional Expertise**: Scoping, modeling, and costing of lead import/export solutions based on the Microsoft ecosystem (SQL Server, SSIS, SSAS, Azure).
- **Documentation and Scoping**: Analysis and exhaustive drafting of requirements and specifications on Confluence to ensure the sustainability of solutions.
Technologies: SQL Server, SSIS, SSAS, Jira, Confluence, Azure, Denodo, Power BI, Safe - CHANEL FranceDelivery Lead & Data ArchitectFASHION AND COSMETICSMarch 2020 - June 2022 (2 years and 3 months)Neuilly-sur-Seine, France
- **Leadership & Project Management**: Steering the entire project lifecycle, including budget monitoring, managing 6 team members (Offshore and Onshore), and leading steering committees.
- **Azure Cloud Architecture**: Design and deployment of a modern architecture based on Azure Data Lake, Databricks (Scala), Azure SQL Server, and Analysis Services to centralize HR data.
- **Operational Excellence (DevOps)**: Industrialization of the project through the implementation of automated CI/CD deployment processes.
- **Strategic Scoping**: Creation of the Technical Architecture Document (DAT) and leading workshops to define interface contracts with data sources.
- **Data Visualization & App**: Development of BI reports in Power BI and creation of business repositories via PowerApps to provide a 360° view to HR.
Technologies: Azure Data Platform (Azure Data Lake, Databricks, Azure SQL, ADF, Power BI, Azure Analysis Services)
Recommendations
Be the first to recommend Stephane
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
- Engineer in Business IntelligencePolytechnic School of the University of Nantes (EPUN)2011Ingénieur en Informatique décisionnelle
- University Diploma in Technology in Computer ScienceIUT of Lens2008Bases de données, Réseau, Développement applicatif et web, comptabilité
Certifications
- Azure Data Engineer Associate AZ-900, DP-200 & DP-201Microsoft2021
- MCTS SQL Server BI: 70-448, MCSE SQL Server BI: 70-466, 70-467, MCSA SQL Server BI: 70-461, 70-462Microsoft2016