Yohan – Python, SQL, Microsoft Power BI

VBA App for a data workflow, end-to-end, with dynamic graphic reports.

• Created an end-to-end modular Python pipeline for multi-source data ingestion, transformation, metric calculation, reliability improvements, quality control, and dynamic graphical report generation.
• Rebuilt a multi-user VBA application (Excel / Access) with relational database restructuring, data security improvements, reliability improvements, and externalized configuration settings.
• Served as technical lead, analyzed business needs, designed solutions, and collaborated with business stakeholders.

The central bank of France and a member of the Eurosystem, responsible for contributing to eurozone monetary policy, safeguarding financial stability, supervising banks and insurers, issuing banknotes, and producing economic and statistical analysis.

• Designed, developed and maintained a modular end-to-end Python data pipeline for multi-source ingestion, data quality control, metric computation and dynamic report generation.
• Completely redesigned and maintained a critical multi-user Excel/Access VBA application with relational database redesign, data and code quality improvements, configuration externalisation, security hardening and network performance optimisation through caching.
• Designed, created and maintained around fifteen complex Excel questionnaires integrated with a VBA application.
• Served as technical lead for a team of Python/VBA developers and testers, providing technical guidance, design decisions, prioritisation, process simplification and rapid prototyping.
• Worked closely with business teams to gather requirements, frame problems and design solutions.
• Performed exploratory data analysis and prototyping.

A global beauty and personal care company that develops, manufactures, and sells cosmetics, skincare, haircare, and fragrance products worldwide through a portfolio of well-known brands.

• Built and cleaned databases, ensuring data quality and cross-validation across sources.
• Developed AI and ML matching algorithms to cross-reference databases and link datasets based on loosely defined criteria.
• Built Python pipelines for data processing and reliability improvements.
• Developed scraping modules and built databases from the collected data.
• Modernized and migrated legacy VBA scripts to Python.

General VBA development for accountants and other services, including fraud detection, process management, and risk management.

• Built small VBA apps, data aggregation, and dynamic reports, along with various office-automation macros.
• Developed a KPI reporting tool with statistical calculations.
• Built a fraud detection reporting tool with a data analysis pipeline and dynamic charts.