Yann - Architecte SQL SERVER
Ref : 200106N002-
95590 PRESLES
-
Architecte, DBA, Consultant technique (60 ans)
-
Télétravail si le client est à plus de 2h de son domicile
-
Mandataire social de sa structure Freelance (SARL, SAS, EURL, etc)
-
Data & Analytics_ Platform Deployment, Delivery, Governance /
HEINEKEN France Paris, FranceJan 2022 - Jan 2023Support 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, FranceJan 2021 - Jan 2022Context: 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 PARISJan 2020 - Jan 2021Architecture 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, FranceJan 2020 - Jan 2021Migration 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, FranceJan 2014 - Jan 2019Architecture
• 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) FRANCEJan 2011 - Jan 2014SGIB: 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, FranceJan 2009 - Jan 2021Directorate 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, FranceJan 2005 - Jan 2009Implementation of the HR data warehouse of the Ministry of Defense (SQL SERVER, SSIS, SSAS, SSRS, SHAREPOINT). Around
350,000 people
-
Engineering Degree
Higher School of Military Engineering Versailles1985 -
Engineer -
French Air Force Academy1981 -
Military service Branch: Air Force
1981
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 !
Architecte J2EE
- PARIS
Développeur C++
- ROMAINVILLE
Architecte Solution
- BILLY-BERCLAU
Développeur .NET
- VIGNEUX-SUR-SEINE
Architecte C# AWS
- TARBES
Architecte / Consultant SAP Basis
- TRAMOLÉ
Architecte
- EYSINES
Architecte .NET / Tech Lead
- SAINT-ÉTIENNE
Développeur .NET
- HÉRICY
Développeur .NET
- CORBAS