Experience

PharmaScroll

• India
• Research Services
• 1 - 100 Employee

• Senior Associate - Business Analytics

  • Oct 2023 - Present



Axtria - Ingenious Insights

• United States
• Software Development
• 700 & Above Employee

• Associate - Decision Science

  • Apr 2023 - Aug 2023

  Market Campaign Analysis | Test-Control Analysis, SQL• Developed an automated SQL-based data collection pipeline for implementing the Test-Holdout method.• Proposed optimized campaign strategies by precisely identifying and prioritizing critical segments for strategic allocation of resources.Website Traffic Analysis | Power BI, Adobe Analytics, Excel• Gathered web analytics data and performed extensive processing to tailor the data to the specific business case.• Created various dashboards for distinct pharmaceutical websites, illustrating visitor behavior trends via a range of KPIs across categories and channels, and enriching them with crucial insights. Show less

• Analyst - Decision Science

  • Jul 2022 - Apr 2023

  Market Mix Modeling (MMM) | Regression, Budget Optimization, AWS• Performed a multi-channel marketing mix analysis on promotion data using Direct-To-Consumer (DTC) promotional channels.• Quantified the impact of the promotional inputs, calculated ROI and helped in budget allocation.

• Analyst - Decision Science

  • Jan 2022 - Jul 2022

  • Tested and implemented Static and Dynamic Row-Level-Security (RLS) features in Power BI using DAX.• Migrated various SQL reports and data tables from Redshift to the Snowflake platform.• Migrated back-end supported SQL queries for multiple Power BI Dashboards.• Streamlined business processes through automated QC checks and Excel-based formula-driven standard file generation, reducing effort while enhancing quality.• Developed an understanding of the pharmaceutical industry and the healthcare markets in the US and EU, through hands-on experience working with various healthcare data (IQVIA, Veeva) such as Sales, Calls and Execution. Show less



National Institute of Technology, Tiruchirappalli

• India
• Higher Education
• 500 - 600 Employee

• Teaching Assistant

  • Sep 2020 - Jun 2022