Freelancer profile translated to English.

Description

SQL Server Consultant for 10 years, I will help you choose your SQL Server and Azure architectures.

My experience and background have allowed me to work on performance issues for many clients.

I have therefore developed audit scripts and a personal monitoring solution that allows me to be as effective as possible during my audits.

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Champs-sur-Marne (up to 50km), Aix-en-Provence (up to 40km)

LOREAL
SQL Server BI Architect and Team Lead
LUXURY GOODS
January 2019 - Today (7 years and 5 months)
Solutions: SQL Server 2012/2016 (BI Suite), Windows 2008/2012/2016, SharePoint 2013, Informatica 9.6/10.1, PowerShell, PowerBI

Description :
Full BI infrastructure implementations
- Technical Architecture Design
- Application Installation
- Implementation of operational procedures with the service provider
- Project support

SQL Server and BI Suite Technical Referent
- SQL Server Audits
- Troubleshooting
- Support for development teams
- Application / Technical Migrations
- Maintenance and modification of the monitoring solution

Team Lead
- Daily team monitoring
- Definition and assignment of weekly tasks
- Definition of objectives and roadmap

Team Transition Manager L'Oréal infrastructure
- Planning definition
- Facilitation of knowledge/skill transfer
- Monitoring of the Shadow period with the teams
- Daily monitoring
- Qualification of user feedback and final team validation

Daily run management
- Incident and change management
- Coordination of corrective and preventive actions with the service provider
SQL Server Business intelligence Team Management troubleshooting Audit Project Management
LOREAL
SQL Server BI Architect
LUXURY GOODS
July 2017 - December 2018 (1 year and 6 months)
Solutions: SQL Server 2012/2016 (BI Suite), Windows 2008/2012, SharePoint 2013, Informatica 9.6/10.1, PowerShell, PowerBI

Description :
Full BI infrastructure implementations:
- Technical Architecture Design
- Application Installation
- Implementation of operational procedures with the service provider
- Implementation of an Audit solution
- Project support

SQL Server and BI Suite Technical Referent:
- SQL Server Audits
- Troubleshooting
- Support for development teams
- Application / Technical Migrations
- Development and implementation of a monitoring solution (perfmon, extended events, etc.)
SQL Server Business intelligence Audit tuning Transact-SQL Troubleshooting Design writing Project Management
ESSILOR
SQL Server Expertise
HEALTH AND WELLNESS
April 2017 - July 2017 (3 months)
Île-de-France, France
Performance Audit (SQL 2005/2014)
Installation and configuration of an Avanade monitoring tool
Environment configuration (Best practices, etc.)
Deployment of a new maintenance plan (Ola Hallengren) on the different environments.
Query tuning and index creation

Solutions: SQL Server 2005/2014, Windows Server 2003/2012
SQL Server Transact-SQL Audit Tuning troubleshooting