Data & Analytics_ Platform Deployment, Delivery, Governance /
HEINEKEN France Paris, France
mai 2022 - septembre 2023
Support for deployment, validation and delivery on the new Group Data & Analytics platform - Support for deployment,
validation and delivery on the new Group Data & Analytics platform
Skills: Python (programming language) - Apache Spark - Scala - Azure Data Factory - SQL Azure - Microsoft Azure Machine
Learning - Azure Databricks - Azure Synapse Analytics - Microsoft Azure Function (Entity Framewok Core, Asp.NET Core, c#)
- SAP BW – Salesforce – Jira – Confluence - Azure Devops - PowerBI
Main succeeded use cases: SAP BW to Azure data lake (via Open Hub or ODP with ADF) full and incremental – Product
recommender (Azure function app) – Salesforce data integration framework (ADF) – PIM ( Akeneo and Mirakl) master data
integration in SYNAPSE via ADF.
Technical architect /
NATIXIS Paris, France
mars 2021 - mai 2022
Context: manage all the work for the redesign of a platform and integrate it fully into the AZURE cloud
Missions
Liaise between business lines and IT project teams
Framing and delivering EFC as needed
Support for teams with requests in the Azure cloud
Design of the architecture of requirements vs constraints in the cloud
Contact to CISOs
Monitor all projects in your scope
Provide a framework for access policies for all trades
Skills & mission in detail
-Azure CLOUD SERVICES: Azure SQL Server, Log Analytics, Batch Account, Storage Account, Data Factory, Key Vault, App
Service, App Service Plan, ASE, APP Insight, Power BI, Power BI Desktop.
-DEVOPS
DevOps (Deployment of infrastructures + services in IAC mode in TERRAFORM, and applications) BITBUCKET-JENKINS-XLDXLR-TERRAFORM
-ARCHITECTURE
- Cloud architecture design (Security, services, infra, flow, application)
- Participation in the security of Cloud Services and Participation in the definition and management of RISK ASSESSMENT /
THREAT ASSESMENT (Azure Policy, and Security Center)
- POC and choice of Cloud services for projects
- Definition and implementation of environments with the right Infrastructure sizing
Technical architect
HIGHCO BOX PARIS
octobre 2020 - mars 2021
Architecture study for the migration of data integration processes to AZURE (Azure Data Factory, IS Runtime, SSIS, ...).
Setting up a Gen 2 AZURE datalake. Development of pipelines under Data Factory. DEVOPS configuration. Establishment of
a cross-functional repository of retail products.
Data engineer Data Architect -
Malakoff Humanis Paris, France
juin 2020 - octobre 2021
Migration of SSIS packages in 2017. Dynamic SQL code taken into account
Migration from ODI to SSIS. Optimizing the performance of a data warehouse by incremental loading
Technical Architect - Business Intelligence expert/
CARMIGNAC GESTION Paris, France
mai 2014 - octobre 2019
Architecture
• Implementation and administration of the mapping of enterprise applications (Around 170 applications)
• Writing and publication of technical application architecture documents
Migration of a VMWARE infrastructure to AZURE
• Definition of the application migration strategy, technical recipe post-migration
TABLEAU SOFTWARE: migration of existing reporting to TABLEAU SOFTWARE (around 300 reports):
• Definition of the target architecture and deployment of TABLEAU SERVER,
• Definition of application governance (access security, tree structure, )
• Performance monitoring, implementation of audit procedures
Redesign of the corporate directory (Active Directory)
• Definition of activity profiles, rationalization of security groups, implementation of governance
Data repository company (Master Data Management):
• Presentation of the approach for implementing an MDM tool
• Choice of an MDM tool, definition of a target architecture and governance principles, implementation of the metadata of
the UNIT4 accounting application , implementation of incoming / outgoing flows
Implementation of a new CRM tool (SALESFORCE)
• Definition of the target architecture, the metadata repository, implementation of inbound / outbound flows
• Migration from SHAREPOINT 2010 to SHAREPOINT 2016
• Definition of the target architecture, technical recipe
Administration of the company's databases (around 60 SQL SERVER instances)
Implementation of best practice documents for development teams (SQL, SSIS, SSAS, SSRS)
Business Intelligence Consultant
TRIMANE SAINT GERMAIN EN LAYE (78) FRANCE
novembre 2011 - mai 2014
SGIB: reporting (SSRS)
UCANSS: HR data warehouse for Social Security organizations
Development of the MICROSOFT Business Intelligence offer (SQL SERVER BI, PowerBI)
IT Technical Architect /
Ministry of Defense Paris, France
juillet 2009 - novembre 2021
Directorate of the Armed Forces Commissariat: technical architect: application migration strategy following the merger of
the organizations of the 3 Armies, CISO (responsible for the security of information systems) of the organization
IT Project Director /
HRD Ministry of Defense Paris, France
juillet 2005 - juillet 2009
Implementation of the HR data warehouse of the Ministry of Defense (SQL SERVER, SSIS, SSAS, SSRS, SHAREPOINT). Around
350,000 people
Études et formations
Engineering Degree
Higher School of Military Engineering Versailles
1985
Engineer -
French Air Force Academy
1981
Military service Branch: Air Force
1981
Langues
Anglais - C2
Autres compétences
Certificates and accreditations
Microsoft Azure :
AZ-900 Azure Fundamentals (december 2019)
AZ-301 Microsoft Azure Architect Design (february 2020)
DP-300 Azure Database Administrator Associate (march 2022: renew march 2023)
DP-203 Azure Data Engineer Associate (july 2022 renew july 2023)
Microsoft
MICROSOFT 462 -Administering Microsoft SQL Server 2012/2014 Database
October 2013
MICROSOFT 452 PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
February 2009 to present
TABLEAU SOFTWARE:
Tableau Server Certified Associate (september 2019)
Further information
Expertise
Project management
Travel
USA, China, Russia, Tanzania, Thailand, Cambodia, Indonesia
Interests
• Biking
• Running
• Trekking
Link
• Blog: ********
• Twitter: @ yann-n-b91935193
• ********
SKILL
AZURE Architecture
IT databases
TABLEAU SOFTWARE (from 10.X to 20209.4)
• TABLEAU SERVER configuration & administration
• TABLEAU DESKTOP development
• TABLEAU PREP & T TABLEAU ABLE PREP Conductor
• DATA CATALOG
• TABLEAU Extension & Api
MICROSOFT PowerBI, PowerPIvot, Power Query
• PowerBi service, PowerBI desktop
• PowerPivot data model, SSAS tabular model PowerBI
SQL SERVER (2008, 2012, 2016, 2019 )
• SQL SERVER Administration, SQL SERVER Development, SSIS, SSAS, SSRS, AZURE SQL Database and Managed
Instance, AZURE Data Factory
