Yann - Architecte SQL SERVER

Ref : 200106N002
Photo de Yann, Architecte SQL SERVER
Compétences
Expériences professionnelles
  • Data & Analytics_ Platform Deployment, Delivery, Governance /

    HEINEKEN France Paris, France
    Jan 2022 - Jan 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
    Jan 2021 - Jan 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
    Jan 2020 - Jan 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
    Jan 2020 - Jan 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
    Jan 2014 - Jan 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
    Jan 2011 - Jan 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
    Jan 2009 - Jan 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
    Jan 2005 - Jan 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
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: patyandco.com
• Twitter: @ yann-n-b91935193
• GitHub:@ynguyenluat
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

D'autres freelances
Architecte SQL SERVER

Ces profils pourraient vous intéresser !
CV Chef de projet / Architecte / Sysops / DevOps
Sylvain

Chef de projet / Architecte / Sysops / DevOps

  • VELAUX
WINDOWS PROJECT MANAGEMENT OFFICE POWERSHELL BASH SQL SERVER ENTERPRISE ARCHITECT DEVOPS Cloud AWS AZURE
Disponible
CV Ingénieur de développement JAVASCRIPT
Said

Ingénieur de développement JAVASCRIPT

  • CLAMART
JAVASCRIPT JAVA J2EE Angular ORACLE SQL SERVER SQL PL SQL JAVA J2EE MYSQL
Disponible
CV Architecte - Consultant Technique
Cyprien

Architecte - Consultant Technique

  • LOUVRES
.NET IIS SHAREPOINT SQL SERVER ACTIVE DIRECTORY ENTERPRISE ARCHITECT
Disponible
CV Consultant Boomi
Yacine

Consultant Boomi

  • PARIS
Boomi INFORMATICA SQL API RESTful SOAP DATA EAI ESB ORACLE SQL SERVER CONTROL M
CV Développeur C++
Thierno

Développeur C++

  • ROMAINVILLE
C++ SQL SERVER ORACLE
CV Architecte Solution
Jonathan

Architecte Solution

  • BILLY-BERCLAU
Cloud AWS SQL SQL SERVER C# .NET JAVA PHP Spring Boot AZURE APACHE KAFKA
CV Développeur .NET
Ulrich Steve

Développeur .NET

  • VIGNEUX-SUR-SEINE
.NET C# ORACLE SQL SERVER Angular PL SQL SQL
CV Architecte C# AWS
Jérôme

Architecte C# AWS

  • TARBES
C# .NET Cloud AWS DOCKER SQL SERVER
CV Architecte / Consultant SAP Basis
Matthieu

Architecte / Consultant SAP Basis

  • TRAMOLÉ
SAP SAP BC SQL SERVER WINDOWS VMWARE LINUX UNIX SHAREPOINT ACTIVE DIRECTORY ORACLE
CV Architecte
Laurent

Architecte

  • EYSINES
CITRIX VIRTUAL DESKTOP INFRASTRUCTURE SQL SERVER ACTIVE DIRECTORY WINDOWS VMWARE TOGAF ARCHIMATE C++ ADSL