Abhishek Pawar

Forecasting | Analytics | Incentive Compensation Expert in Life Science and Emerging BioPharma Industry

India

About

Driving commercial growth in the Life Sciences and Emerging BioPharma sectors requires more than just processing information; it requires translating complex market dynamics into actionable, high-level strategy. As a Data-Driven Pharma Strategy & Analytics professional, my core focus is empowering leadership teams with the foresight and technological infrastructure needed to navigate highly competitive, global landscapes. I approach problem-solving inherently with the mindset of a business owner. This means looking beyond the raw data pipelines to fundamentally understand the underlying Go-to-Market strategies, Resource Allocation needs, and long-term revenue objectives of an organization. Much like calculating multi-step tactical sequences on a chessboard, I believe in anticipating market shifts and strategically positioning data assets to capture sustainable value. In today’s rapidly evolving tech landscape, speed to insight is critical. I embrace a highly agile, modern approach to development leveraging functional building blocks, advanced prompting, and large language models to rapidly prototype and deploy solutions. Whether it is engineering scalable architecture or building custom copilot agents to automate end-to-end commercial workflows, I focus on delivering seamless, augmented analytics that directly scale the customer experience. 🎯 Core Competencies & Philosophy - Advanced Forecasting & Demand Planning: Deep expertise in developing multi-layered forecasting models. By mastering epidemiological and trend-based methodologies, I help organizations map out long-term trajectories and mitigate market risks. - AI Innovation & Augmented Analytics: Advanced capability in conceptualizing and building copilot agents, as well as developing applications for augmented analytics. I streamline complex Data Management and Marketing Analytics into intuitive, real-time insights that drive decisive action. - Commercial Strategy & Sales Force Effectiveness: Proficient in designing robust Go-to-Market (GTM) strategies and executing precise Segmentation. I focus on optimizing Dynamic Targeting and Resource Allocation to ensure commercial efforts generate the highest possible ROI. I thrive in cross-cultural, dynamic environments and am deeply passionate about bridging the gap between advanced data engineering and executive strategy. I am always open to connecting with talent acquisition professionals, industry leaders, and innovators within the European biotech and digital health ecosystems. 📧 Contact: [email protected]

Experience

  • Assistant Manager at WNS Analytics
    Jul 2025 - Present · 1 yr 1 mo

    Project 1: Tableau and Dataverse Projects - Built a real-time Tableau dashboard connected to Databricks via API token authentication with automated 30-min refresh cycles, replacing delayed weekly reports. Incorporated advanced KPIs such as monthly projections, attainment, NPS trends, SKU-level distribution, and dual-currency net sales, resulting in improved transparency and stakeholder alignment across technical and non-technical teams. - Streamlined KPI views, dosage distribution, DoT, adherence and other ad hoc analyses from 1–1.5 weeks post-month-end to real-time by designing product-specific SQL queries directly on Databricks, and creating automated graph generation, reducing turnaround to 10–20 seconds. Project 2 : Intelligent Forecasting AI Assistant - Designed and implemented an agent built on copilot studio, capable of handling end-to-end commercial forecasting workflows, including data querying through Microsoft Dataverse, integration with finance models, and dynamic visualizations for strategic reviews. - Built advanced logic for currency/FX handling, patient metrics, and waterfall analyses, ensuring compliance with corporate forecasting standards (e.g., MRP, MYC cycles). - Delivered automated assumption summaries, risk assessments, and competitive scenario analyses, improving forecast cycle consistency and reducing manual effort by over 30%. - Used Natural Language Processing, Dataverse APIs, Power Platform, and Python for data processing and visualization. Project 3 : Accelerated NPS-to-Demand Insights Framework - Built a scalable NPS-to-Demand model, integrating IQVIA claims data and shipment data for multiple brands. Reduced analysis time from 7+ days per brand to ~20 minutes, influencing enterprise strategy by uncovering gaps in SD NPS estimation and leading the VP of Insights to redefine DoT and NPS metrics across brands. - Partnered with market research leads to design claims-based scenarios using IQVIA data, enabling precise scenario planning.

  • Consultant at PharmaACE
    May 2024 - Jul 2025 · 1 yr 3 mos

    - Led an offshore team of analysts to deliver demand planning and forecasting solutions for the France and Nordics division of client, contributing to $750+ million YTD revenue. - Partnered with client's France leadership team to revitalize the promotional activities of the dormant kidney transplant drug, resulting in $60 million revenue in 2025 and a 76% growth compared to 2023. - Oversaw the allocation of resources and planning for one of the largest portfolio projects, supporting forecasting and analytics for 8 drugs across 3 therapeutic areas - Provided advanced forecasting and demand planning insights, aiding clients in strategic decision-making for both existing and new product portfolios. - Built and maintained strong client relationships by delivering consistent, high-quality analytics and forecast support, driving client satisfaction and retention. - Worked closely with cross-functional teams, including sales, marketing, and operations, to align forecasting solutions with broader organizational objectives. - Identified and implemented process improvements within forecasting and analytics workflows, enhancing efficiency and accuracy across client projects. - Delivered impactful forecasting strategies and insights, directly influencing revenue growth and market penetration for key client portfolios. - Collaborated with the leadership team to establish forecasting frameworks and processes for large and medium-sized client organizations, enabling them to evaluate opportunities and project potential for new initiatives. - Conducted comprehensive training sessions for internal teams and clients, ensuring proficient utilization and interpretation of forecast models to support data-driven decision-making.

  • Data Analyst at IQVIA
    Nov 2021 - May 2024 · 2 yrs 7 mos

    Project 1: Incentive Compensation Strategy – Neurotrophic Keratitis Launch (USA) - Designed and implemented a comprehensive Incentive Compensation (IC) plan for a 40+ member sales team, resulting in $2.5M annual payouts and driving 30% YoY sales growth, generating $800M in revenue. - Introduced motivational contests and SPIFF initiatives to align team morale with business objectives, improving engagement and performance. - Led a team of 4 analysts, delivering IC administration, performance dashboards, ophthalmology-specific reports, and high-stakes ad-hoc analytics for senior leadership. Project 2: Forecast Model Development – Fortune 100 Pharma Clients - Developed robust forecasting models leveraging Patient Flow, Epidemiology, and Trend-Based methodologies to accurately predict sales for a Sickle Cell Disease therapy and competitors, achieving ±2% forecast error margin. - Directed the standardization of long-range forecasting for a $5B pharmaceutical portfolio, improving operational efficiency by 30%. - Delivered structured training programs for internal teams and client stakeholders to enhance utilization and interpretation of forecasting outputs, enabling faster, data-driven decisions. Project 3: Automation & Process Optimization Initiatives - Drove enterprise-level automation projects, streamlining repetitive workflows using Excel/VBA, Alteryx, and proprietary tools, saving 1,600+ hours annually across core processes. - Built tailored data visualization dashboards using Tableau and Excel to present actionable insights for executive decision-making. Installed and configured Tableau Server, implemented associative data models, and created custom user interfaces to improve reporting efficiency. - Delivered advanced patient-level analytics via AWS Redshift, uncovering strategic insights for a major drug launch and enabling market-readiness planning. Recognition: Impact Award 2022 (Top 5%) for innovation, automation in analytics and forecasting workstreams.

  • Strategy Associate at EMIC INDIA ELECTRIC LLP
    May 2021 - Nov 2021 · 7 mos

    - Analyzed a decade of motorbike sales data and developed over 20 dashboards, enabling comprehensive sales reporting, marketing spend tracking, and competitor analysis for the VP of Marketing. - Collaborated with IT and Production departments to ensure system readiness for vehicle pre-booking and delivery tracking, achieving the on-time shipment of over 1,500 vehicles within the first month of launch. - Led a strategic revamp of the after-sales chat support system, reducing ticket inflow by 45% and lowering workforce costs by 40%. - Designed and implemented streamlined processes for cross-functional collaboration between Marketing, IT, and Production teams, enhancing operational efficiency and delivery timelines. - Conducted detailed competitor benchmarking to identify market trends and gaps, providing actionable insights that shaped marketing strategies and improved decision-making for senior leadership.