About Lucas
English
Fluent
French
Native or bilingual
Experience
- HermèsBI Transformation & Data GovernanceLUXURY GOODSFebruary 2024 - May 2025 (1 year and 3 months)Paris, FranceMission: Transformation of business processes and data reliability through tailor-made Power BI solutions, covering several departments (Material/Component Development, Products, Launch/Manufacturing, Regulatory, DDO).🧩 Context & challenges:Hermès wanted to strengthen the quality and traceability of its product data, while streamlining collaboration between its internal systems (PLM Centric, ERP, MDM, ordering application). The objective: to have a unified, reliable, and usable vision for decision-making.🚀 Key achievements:• BI Scoping and management: leading weekly meetings with business units, formalizing needs, and defining strategic KPIs.• Data integration & governance: coordinating flows between systems (PLM, ERP, MDM), improving data completeness and quality.• Power BI design and development: creating interactive reports aligned with business processes, with documentation and BI governance standards.• Testing and deployment: conducting tests, monitoring bug fixes, and writing test reports.• Training & adoption: designing user guides and leading sessions for business teams.💡 Results achieved:• Over €3 million in savings generated by the Regulatory department, thanks to a Power BI data quality analysis report ensuring better product traceability.• Significant time savings for operational teams through an automated data entry quality evaluation report, detecting errors at the source.• Improved data reliability and increased adoption of BI tools across all concerned departments.
- Ma French bankRegulatory Reporting & BI AutomationBANKING AND INSURANCEJune 2023 - September 2023 (3 months)Paris, FranceMission: Management of a strategic regulatory reporting project for the Banque de France, aiming to ensure the reliability of payment methods mapping and automate the production of compliance reports via Power BI and SAP BusinessObjects.🧩 Context & challenges:The compliance department wanted to secure and sustain the transmission of sensitive regulatory reports, while reducing processing time and manual errors related to data preparation.🚀 Key achievements:• Scoping & coordination of regulatory needs with the Banque de France, IT department, and business units.• Data process optimization: creation of SAP BO queries and automations reducing consolidation times by several days.• Design of interactive and analytical Power BI dashboards for fraud monitoring, performance, and compliance.• Documentation & skills transfer: design of user materials and training for teams to ensure reporting sustainability.💡 Results achieved:• Reporting “Payment Methods Mapping & Fraud Guideline” now industrialized and integrated into Ma French Bank's recurring processes.• Report automation: reduction in production time and handling errors.• Strengthened compliance and better visibility for regulatory teams on key performance and fraud data.
- L'OréalRegulatory Reporting & Global BI ManagementFASHION AND COSMETICSSeptember 2021 - April 2023 (1 year and 7 months)Paris, FranceMission: Management of complex projects related to international chemical regulations, to ensure product compliance, anticipate legal changes, and automate monitoring via Power BI.🧩 Context & challenges:L’Oréal's R&D and regulatory teams had to continuously monitor thousands of cosmetic formulas affected by multiple regulations (REACH, FDA, etc.). The objective: to have a global, real-time view of at-risk products, while rationalizing coordination between international teams.🚀 Key achievements:• Data extraction & analysis (SAP BusinessObjects): creation of advanced queries and variables to identify critical formulas and estimate their regulatory impact.• Economic analysis & business reporting: data cleaning in Excel / Power Query and calculation of the financial impact of new regulations.• Action plan management: coordination of regulatory and business teams to ensure formula compliance within deadlines.• Power BI dashboard design (DAX): real-time monitoring of products, automatic alerts, compliance and performance indicators; training of laboratory managers on the tool.💡 Results achieved:• Industrialization of over 10 regulatory projects deployed globally.• Real-time monitoring of affected formulas via an automated Power BI report, improving R&D team responsiveness.• Increased business autonomy: significant reduction in IT team dependency and accelerated decision-making.
Reviews
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 Science in Neuroscience, specialization in Molecular, Cellular, and IntegratedAix-Marseille University2020- Analyse avancée et développement de l'esprit critique sur des sujets d'actualités en Neurosciences : Maladies neurodégénératives, Epilepsie, neuroendocrinologie, mémoire, sensory-motricité, plasticité cérébrale, perception sensorielle et développement. - Analyse statistique avancée et interprétation des données sur R pour répondre à des problématiques de recherche. - Communication scientifique : entraîné à communiquer et vulgariser auprès d'un public non scientifique sur des sujets techniques et complexes.
- Certification "Data Science Designer - Developer"Jedha Bootcamp2020- Maîtrise de l'ensemble de la pipeline data : Python, SQL, analyse et interprétation des données (niveau licence MIASHS en statistique), création de modèles algorithmiques (supervisé et non-supervisé), deep learning, NLP, Traitement Big Data, Web scraping et déploiement. - Réalisation de différents projets répondant à de vrais problématiques d'entreprises. - Certification équivalent à un niveau Master.