PARUL BATRA

Tableau Dashboard for tracking HCP and Account Performance

• Built an interactive dashboard for Physician profile by adding KPIs to create an overarching profiling summary for all the physicians and their accounts, dosing schedules of patients, patient claims, adoption rate of newly launched drugs, switch dynamics, etc. for the end users.
• Developed a comprehensive project plan that outlined the timeline, facilitated team meetings and provided regular updates to stakeholders, resulting in improved communication and collaboration.
• Moving this manual process to an automated dashboard has reduced the run time from 2 days to ~3 hours and improved the team efficiency by 85%.

Brand Performance Reports and Data Migration

• Creating brand performance reports at the Account, Ecosystem, and Site level which included KPIs like sales, market share, and growth at different time intervals for different brands across different Therapeutic areas
• Worked on data migration project where the codes were migrated from Power BI to Redshift

Asthma Paediatric Opportunity

• HCP Segmentation exercise to identify high opportunity in the Asthma space which included finding HCPs that have high Pediatric patient potential and preference to brand.

Marketing Mix

• Setting up the data pipeline for the Marketing Mix project for a prominent Oncology brand.
• Worked on different data which includes Sales, Calls, and Promotional Channels.

Market Access Scoring

• Provided technical support for team and involved in data gathering and data cleaning process.
• Writing detailed documentation to ensure understanding of operations and process.

Regular Deliverables

• Created more than 12 distinctive monthly / weekly deliverables to track overall brand performance .
• Reduced turnaround time by ~75% and improved quality by automating the existing deliverables.