Pierre-Henri Martinon

• Led end-to-end development of BlockBuster Tool (BBTool), a strategic decision-support application enabling C-suite executives to evaluate drug development viability across 23 critical criteria (competitive landscape, innovation differentiation, sales potential), potentially saving billions in R&D investment while optimizing patient impact. • Designed and orchestrated complex DAG workflows ensuring proper data refresh sequencing and dependencies, collaborating closely with Data Engineering to maintain best practices and meet Software Engineering requirements for application development. • Architected and built 15+ DBT data models from scratch (scaling to 60+ models post-MVP), integrating internal Sanofi data with external SaaS platforms, pharmaceutical databases, and international public health sources to create a unified analytical foundation. Skills: Snowflake · Dbt · Python · GitHub · Airflow · SQL

• Owned end-to-end data preparation for Canada and Mexico markets, validating spend metrics (YouTube, Amazon Ads) and financial KPIs (Sell-In, Sell-Out) in our Snowflake tables. • Built and maintained ETL pipelines using Spark and Python to clean, transform and standardize raw data into DBT models, ensuring consistency and accuracy upstream of analytics. • Developed DBT data models and orchestrated deployments, then delivered curated datasets to data scientists for building country-level investment reports (ROS, ROI, brand prioritization). • Created and updated Power BI dashboards; partnered closely with country Data Champions and Operations to reconcile figures, gather feedback, and refine visualizations. • Acted as a liaison between Data Engineering, Data Science and regional teams—ensuring seamless data ingestion, rigorous quality checks, and actionable insights for strategic decision-making. Skills: Azure Databricks · Snowflake · Power BI · Dbt · Python · GitHub

• Administered Tableau for the entire company, managing user access and distributing Explorer, Viewer, and Creator licenses. Acted as the main BI professional, ensuring optimal usage and accessibility of the tool across departments. • Developed and maintained Datamarts integrating various tables, focusing on data simplification and transformation. Created comprehensive data documentation to facilitate stakeholder analysis using DBT, enhancing the company's data-driven decision-making capabilities. • Spearheaded the analysis of key performance indicators, focusing on Customer Lifetime Value and Customer Acquisition Cost, providing valuable insights to sales and finance teams. • Developed complex SQL queries, leveraging advanced functionalities including LEAD, LAG, CTE Subqueries, and other Windows Functions, ensuring efficient and deep data extraction. • Collaborated closely with cross-functional teams to ensure relevant data insights and KPIs were timely and effectively communicated, driving informed decision-making processes. Skills: Azure Databricks · Snowflake · PostgreSQL · Tableau · Dbt · Python · GitHub

Skills: MetaBase · PostgreSQL · Snowflake · Python

• Addressed advance analytics questions regarding player behavior and in-game monetization needs for our Paid & Free to Play offerings and effectively communicate findings to both technical and non-technical audiences. • Developed models to forecast acquisition, retention, and monetization at player level. • Collaborated with stakeholder teams; Understood the brand and marketing objective and the major initiatives; Established a benchmarking methodology and set target for a key metrics identified. • Built cohort analyses to identify trends in player behavior and measure impact of content release on activity and monetization. Build and evolve in-game measurement and experimentation methodologies. Skills: SQL · Tableau · Snowflake · Microsoft Excel

Skills: SQL · Tableau · Microsoft Excel