Pierre-Henri Martinon

- End-to-end management of the development of BlockBuster Tool (BBTool), a strategic decision-support application for executives (C-level), enabling the assessment of the viability of drug development projects based on 23 key criteria (competitive environment, innovation differentiation, commercial potential), with a potential impact of billions of euros in R&D savings while optimizing patient benefit.

- Design and orchestration of complex DAG workflows, ensuring the correct data refresh sequence and dependency management, in close collaboration with Data Engineering teams to adhere to best practices and Software Engineering standards for high-stakes data applications.

- Architecture and development of over 15 DBT data models from scratch (evolving to over 60 models after MVP), integrating internal Sanofi data with external SaaS platforms, pharmaceutical databases, and international public health sources, to build a unified and robust analytical foundation.

- End-to-end management of data preparation for the Canada and Mexico markets, with validation of advertising spend metrics (YouTube, Amazon Ads) and financial KPIs (Sell-In, Sell-Out) in Snowflake.

- Design and maintenance of ETL pipelines in Spark and Python to clean, transform, and standardize raw data into reliable DBT models, ensuring data consistency and quality upstream of analyses.

- Development of DBT data models and orchestration of deployments, followed by the provision of structured datasets for Data Science teams for the production of country investment reports (ROS, ROI, brand prioritization).

- Creation and updating of Power BI dashboards, in close collaboration with local Data Champions and Operations teams to reconcile figures, integrate field feedback, and refine visualizations.

- Point of contact role between Data Engineering, Data Science, and regional teams, ensuring smooth data ingestion, rigorous quality controls, and the production of actionable insights for strategic decision-making.

- I administered Tableau for the entire company, managing user access and the distribution of Explorer, Viewer, and Creator licenses. I acted as the primary BI professional, ensuring optimal use and accessibility of the tool across departments.

- I developed and maintained Datamarts integrating various tables, focusing on data simplification and transformation. I created comprehensive data documentation to facilitate stakeholder analysis using DBT, enhancing the company's data-driven decision-making capabilities.

- I led the analysis of key performance indicators, focusing on Customer Lifetime Value and Customer Acquisition Cost, providing valuable insights to sales and finance teams.

- I developed complex SQL queries, leveraging advanced features such as LEAD, LAG, CTE Subqueries, and other window functions, ensuring efficient and in-depth data extraction.