Basudev Pal

About Basudev Pal

I’m a Data Analyst with 2+ years of experience solving real business problems in pharma and healthcare analytics by turning complex, fragmented data into clear, decision-ready insights.The problem I solve:Clients and internal teams often struggle with unclear sales performance, mismatches between company-reported and market (IQVIA/Symphony) data, manual reporting delays, and limited visibility into brand-level and market-level trends. These gaps make it hard to identify sales leakage, prioritize focus brands, and take timely corrective actions.The solutions I deliver:I design and implement end-to-end analytics solutions using SQL, Power BI, Python, Tableau, Advanced Excel, Statistics, and Jira—from data extraction and validation to KPI-driven dashboards and automated reporting workflows. My work includes comparative company vs market sales analysis, CAGR and trend tracking, variance logic, and performance benchmarking across molecules, manufacturers, dosages, and strengths.The impact for clients:My dashboards and insights help stakeholders clearly understand where and why performance is changing, enabling faster, data-backed decisions on sales strategy, market focus, and portfolio optimization. These solutions have contributed to 10–15% improvements in sales focus and market alignment, reduced manual reporting effort, and improved confidence in data accuracy.Previously, at Aurobindo / Eugia Pharma, I supported sales and healthcare teams by building Power BI dashboards, optimizing SQL queries, and automating Excel reports—cutting turnaround time and improving reporting reliability.I’m driven by building analytics that are not just accurate, but useful—solutions that directly support better decisions, stronger performance, and measurable business outcomes. expertise to drive results in a dynamic team environment.

Experience

1. Associate Analyst

   Pharsights Business Solutions

   Dec 2024 — Present · Hyderabad, IN

   At PharSights Business Solutions, I solve the challenge of unclear sales performance and market mismatch by transforming IQVIA and internal secondary sales data into actionable commercial insights. I design and develop advanced Power BI dashboards that provide clear visibility into brand-level, molecule-wise, and market-wise trends across manufacturers, dosages, and strengths. By performing detailed company vs market sales comparisons, implementing CAGR, growth, and unit volume metrics, and ensuring strong data validation and integrity, I enable stakeholders to accurately identify sales leakage, underperforming segments, and growth opportunities. I also automate data integration, refreshes, and reporting workflows using SQL, Python, and Excel, reducing manual effort and improving turnaround time. My work directly supports portfolio optimization, competitive benchmarking, and strategic decision-making, contributing to measurable improvements in sales focus and market alignment (10–15%) for clients.

Education

• Sri Jayadev College of Pharmaceutical Sciences (SJCPS), Bhubaneswar

  Bachelor's degree, Pharmaceutical Sciences