Pierre Legendre

Designed and implemented an automation workflow using Tableau, developing standardized Prep flows and dashboards connected to the ClearlyRated database to deliver NPS reports more efficiently. Delivered ad-hoc survey and research reports to help clients assess satisfaction, benchmark against competitors, and identify key drivers of customer experience and growth opportunities. Produced quarterly client summaries in Tableau, consolidating core satisfaction indicators (Net Promoter Score, Response Rate) and analyzing results by customer segments and satisfaction drivers.

Led the Rationalisation des offres project, migrating up to 20,000 outdated business customer lines weekly to newer offers, improving database efficiency and scalability. Managed extensive databases using Teradata SQL, working with 50+ data tables and datasets exceeding 100,000 rows. Created and optimized advanced SQL queries to extract insights and meet business requirements. Developed and maintained Power BI reports and dashboards to support stakeholders and drive data-driven decision-making.

Coordinated and ensured quality control of PMSI data for 20+ partner healthcare institutions. Developed statistical tools and performance indicators to analyze healthcare activities and financial performance, supporting audits and consulting services. Prepared annual activity reports for partners, using QlikView to summarize KPIs and insights.