Debayan Roy

About Debayan Roy

I sit at the intersection of management consulting and data analysis, dedicated to driving operational excellence across Sanofi’s global footprint. As part of the Insights & Productivity team, my mission is to transform complex data into actionable insights that move the needle on efficiency for Business Operations.I specialize in bridging the gap between technical possibilities and business needs. By collaborating with senior stakeholders, I translate organizational pain points into high-impact use cases and deliver end-to-end solutions—from robust data warehousing in Snowflake to advanced visualization in Power BI.Core Expertise:Strategic Consulting: Partnering with global leaders to design KPIs that accurately track and improve productivity.Data Architecture: Building scalable data workflows using SQL, Snowflake, and Dataiku.Automation & Optimization: Streamlining manual processes through Power Automate to reclaim thousands of hours in operational capacity.End-to-End Insights: Leading the lifecycle from data discovery and warehousing to executive-level reporting.I am passionate about building a leaner, more agile Sanofi by ensuring that every decision made across our business operation is backed by precise, real-time data.

Experience

1. Insights and Productivity Efficiency and Productivity Analyst

   Sanofi

   Jan 2025 — Present · Hyderabad, IN

   Leading data-driven transformation initiatives to optimize efficiency and productivity across Sanofi’s business Operation ecosystems.> Management & Tech Consulting: Act as a strategic partner to global stakeholders to identify operational bottlenecks, design business use cases, and architect end-to-end technical solutions.>KPI Design & Implementation: Developed and deployed standardized KPI frameworks to track productivity gains, providing the executive leadership team with a \"single source of truth\" for global performance.>Advanced Data Analytics: Leverage Dataiku and SQL to perform complex data modeling and predictive insights, enabling proactive decision-making in supply chain and research domains.>Full-Stack BI Development: Architected comprehensive dashboards in Power BI integrated with Snowflake and Access databases, automating the flow of information across Global Business Units.>Process Automation: Spearheaded the adoption of Power Automate, significantly reducing manual reporting cycles and improving data accuracy across cross-functional teams.>Data Warehousing: Manage and optimize data structures within Snowflake to ensure high-performance reporting and scalable data accessibility for global users.

Education

• West Bengal State University, Kolkata

  Bachelor of Science - BS, Chemistry

• Central University of Punjab

  MSc - Master of Science, Physical Chemistry

  2015 — 2017

• Indira Gandhi National Open University (IGNOU), Delhi

  Master of Business Administration - MBA, Operation Management