About Yannick
French
Native or bilingual
English
Conversational
Experience
- CEGOSSenior Data & AI Consultant | MCTEDUCATION AND E-LEARNINGOctober 2025 - Today (10 months)Lyon, FrancePositioning: Working with organizations and large accounts on critical performance, governance, and data transformation challenges in complex environments (up to 100M+ rows).As a Microsoft Certified Trainer (MCT), I combine technical expertise with strategic support, aligning data teams with business, architectural, and modernization goals.Mission Objectives:• Audit and Optimize BI platform performance• Ensure reliability of data models and indicators• Structure Data Governance• Accelerate team skill development• Industrialize Data & AI usesInterventionsPart 1 – BI Audit & Optimization:Comprehensive audit of BI environments (model, DAX, Power Query, visuals), performance analysis (DAX Studio, VertiPaq), root cause identification, and implementation of optimization plans.Recommendation of target architectures (SSAS Tabular / Fabric), presentation to teams, and documentation of best practices adapted to the context.Part 2 – Data/AI Training & Aculturation:Design of tailored learning paths, delivery of Data & AI training, training of various profiles (Data, IT, Business), coaching on real cases, and integration of AI uses (LLM, agents, automation).Results & Impacts:• Significant improvement in report performance• Reliability of KPIs and data models• Increased adoption of BI tools by business users• Standardization of Data practices (modeling, governance)• Reduction of technical debt• Rapid skill development and team autonomyReferencesConsulting for major accounts:Banque Cantonale de Genève, EDF, SNCF, URSSAF, Assurance Maladie, EIFFAGE, OPmobility, KONE, CEA, France Travail…Technical Environment: Power BI | Fabric | SQL Server | SSAS | SSRS | Power Query | DAX | DAX Studio | VertiPaq Analyzer | Tabular Editor | Tableau | Qlik Sense | Talend
- RocheBI Engineer – Finance & Commercial (Client: Roche)PHARMACEUTICALS INDUSTRYNovember 2023 - November 2025 (2 years)Grenoble, FranceContext: Working within the Finance department in a demanding international environment, with strong requirements for indicator reliability and commercial performance management.Problem: Need to secure and make reliable the indicators used in financial closing and improve visibility on commercial performance.Actions Taken:- Design and development of Power BI reports on commercial and financial data- Optimization of dashboards used during monthly closings- Gathering and analysis of business needs (Finance, Commercial, Marketing)- Daily support and maintenance of the RoDIS tool (Power BI)- Management and updating of commercial databases- Ad hoc analysis (Revenue, customer performance, segmentation)- Regular delivery of indicators to decision-making teams- Coordination with business teams to improve adoption and quality of reportingResults & Impacts:- Reliability of critical financial indicators- Improved visibility on commercial performance- Reduction of incidents and stabilization of the Power BI platform- Increased adoption of dashboards by Finance & Sales teams- Better decision-making during monthly closingEnvironment:Power BI Desktop | Power BI Report Server | DAX | Salesforce | SAP | Excel | Scrum
- ASSYSTEMBI Project Manager / ManagementENERGY AND UTILITIESMay 2022 - November 2023 (1 year and 6 months)Cherbourg-en-Cotentin, FranceBI Project Manager / BI Engineer – Industrial Management.Assystem | Client: EDF – EPR FLA3 Project | CherbourgContext: Participation in the strategic program for the construction of the Flamanville EPR (critical industrial project with high complexity), mechanical lot.Problem: Lack of consolidated visibility on project indicators and the need to ensure reporting reliability in a multi-stakeholder environment.Actions Taken:- Gathering and scoping business needs with operational managers- BI project management (roadmap, prioritization, tracking via Azure Boards)- Consolidation and modeling of data from project teams- Design of Power BI dashboards for operational and decision-making management- Implementation of key indicators (progress, performance, etc.)- Regular communication with stakeholders- Supervision and skill development of junior consultantsResults & Impacts:- Provision of structured and reliable BI management- Significant improvement in project progress visibility- Standardization of reporting processes- Contribution to decision-making on a strategic industrial program- Effective coordination between business and IT teamsTechnical Environment: Power BI Desktop & Service | Data Modeling | Power Query | DAX | SharePoint | Azure Boards | Agile
Recommendations
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
- Master of ScienceUniversité Claude Bernard Lyon 1M.S. Système d'information pour la Gestion
Certifications
- Professional Scrum Product OwnerScrum.org