Shubhankar S.

Experience

• 

  ProcDNA

  Sept 2021 - Nov 2021

  Intern - Analytics

  - Assisted in the pre-launch of an ointment drug in the Psoriasis market by analyzing market trends, refill patterns, and physician behavior to create patient and physician-level summaries.- Contributed to establishing the backend of an analytics tool prototype targeting oncology market HCPs for identification.

• 

  ProcDNA

  Jul 2022 - Jan 2024

  - Led analytics for a pre-launch breast cancer (oncology) drug, utilizing extensive APLD claims data to understand market landscape and treatment trends.- Executed end-to-end market sizing and drug share calculations, aligning with a top pharma manufacturer's perspective. Acted as the point of contact for recommending business rule changes and testing.- Automated monthly line-of-therapy (LoT) and projection calculations on DataBricks, saving 20+ hours monthly. Established trackers and quality checks for ongoing data updates. Show less - Utilized 7+ years of IQVIA LAAD data to establish patient universe business rules for Psoriasis (Derm) indication using advanced SQL. These rules were adopted for similar dermatology indications by the client.- Conducted market access analytics within the claims dataset, analyzing drug fulfillment, reversals, rejections, and identifying patient payment trends and key payers.- Managed weekly IC operations and contests for the client, overseeing a $1 million payout budget. Ensured data integrity, implemented quality controls, and delivered Tableau scorecards to sales reps with monthly refinements.- Generated monthly and weekly reports on customer (HCP) behavior derived from sales and calls, focusing on market-related conferences attended by customers. Show less

  • Team Lead - Analytics

    Jun 2023 - Jan 2024

  • Business Analyst

    Jul 2022 - May 2023
• 

  PharmaScroll

  Jan 2024 - now

  Business Analytics Manager