Kavyasree Kudikala
Bangalore
Summary
Results-oriented Commercial Analytics and BI professional with 7 years of experience in delivering impactful analytics solutions for pharmaceutical, healthcare, and retail sectors. Expertise in patient journey analytics, market access insights, and KPI-driven BI dashboards. Focused on translating complex data into actionable insights that drive strategic decisions for senior stakeholders.
Overview
7
7
years of professional experience
Work History
Pharma Consultant | Commercial Analytics & BI Solutions
Trinity Life Sciences
Bangalore
10.2022 - Current
- Lead end-to-end analytics delivery for pharma clients across brand, patient, and market access workstreams.
- Designed and deployed enterprise-level dashboards for a rare disease brand, optimizing marketing strategy, patient journey analysis, and territory alignment.
- Performed advanced patient journey analysis using Specialty Pharmacy (SP) and HUB datasets to uncover referral-to-conversion patterns, Patient Cohorts & market dynamics.
- Built a Territory Alignment Report enabling field teams to track real-time HCP and anonymized patient activity by Region, District, or Territory.
- Developed HCP Field Dashboard for prospecting, streamlining identification and engagement of high-potential healthcare professionals.
- Developed a Patient Referral Algorithm to identify the right HCP mapping for patients.
- Build and optimize SQL & Databricks pipelines, reducing refresh time from 120 mins to 30 mins and improving data reliability.
- Trained and onboarded 150+ analysts as an SQL/backend SME, improving delivery consistency and self-sufficiency.
- Cross-Functional Collaboration: Worked closely with business teams, commercial analytics, data engineers, and stakeholders to refine analytics solutions, and provide actionable insights based on real-world evidence.
- Key Skills: Pharma Commercial Analytics, HCP & Payer Targeting, BI & Dashboarding (Tableau, SQL), Patient Journey Analytics, Market & Brand Performance Insights.
- Datasets: MMIT, Breakaway(Formulary), IQVIA LAAD Claims, Specialty Pharmacy, Patients Data, Call Activity Data
Senior Business Analyst
Meesho
Bangalore
10.2021 - 09.2022
- Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
- Conducted marketing analysis on the DOD campaign to ensure the ROI and delivered Presto dashboards that track the effect of pricing on the Campaign days on different metrics.
- Performed Pre-Post analysis which enables internal stakeholders to understand the impact of campaigns and discounts on the products.
- Tracked 'WhatsApp Super campaign' performance of different segments on the website like Banner, Widget, PDM's to understand the demand of the products in the segments and automated the reports for daily analysis, which decreases the manpower by 40 hours.
- Segmented customers into different cohorts like DAU, NEW and REPEAT to check the loyalty of customers and also to monitor multiple metrics which helped the stakeholders and program managers to take decisions.
- Built end to end tracking dashboard to check the retention curves at different frequencies like daily and monthly.
- Performed a drop-off analysis to identify at what stage of customer acquisition the resellers have dropped off.
Decision Scientist
Mu Sigma Inc.
Bangalore
10.2018 - 10.2021
- Leading a team of 7 trainee decision scientists, responsible for gathering business requirements data design, Building Logical Model, Insight Generation and maintaining Data Governance standards in the Insurance Claims Domain.
- Responsible for on-boarding, training and upskilling the new resources in the team with ensuring smooth delivery.
- Design and implement extract, transform and load (ETL) mapping procedures following the standard development life cycle.
- Developed Conformed model (Using Type 2 SCD logic) and Reporting layer Insight along with 4 Regulatory and Management dashboards in Tableau supporting the Enterprise Complaints and to improve the ability to conduct Complaint Analysis therefore reducing the risk of potential unresolved complaints escalated to Australian Regulatory Body.
- Built fast and effective dynamic Enterprise Model that distributes Budget optimally across different product hierarchies which help in maximizing enterprise level revenue using Marginal ROAS equalization and had a projected Dollar impact of ~$150M.
- Performed detailed analysis of the campaign by measuring the performance at an item level hierarchy which included calculating the gross profit margin % lift (in sales, units and visits), identifying top and bottom performing items, therefore contributing to 35% of YOY sales lift, 21% of gross profit margin and about 16% of revenue generated by campaign.
- Designed and developed weekly, monthly, quarterly and yearly performance at different product hierarchy measured KPI’s that facilitate category managers to take weekly decisions.
Education
B.Tech. - Computer Science
Kakatiya Institute of Technological Sciences
Telangana, IN05.2018
Skills
- Client Communication
- Teamwork and Management
- Story Boarding with Data
- Problem Solving & Decision Making
- MySQL
- MS SQL Server
- Presto
- AWS Redshift
- Netezza
- Windows
- Databricks
- IBM Infosphere Change Data Capture Management Console
- Tableau
- Cognos
- Excel
- Exploratory Data Analysis
- Hypothesis Testing
- Forecasting
- Campaign Measurement
- Data Modelling
- Microsoft Office
- JIRA
- Pharma Commercial Analytics
- HCP & Payer Targeting
- BI & Dashboarding
- Patient Journey Analytics
- Market & Brand Performance Insights
Analytical Skills
MySQL, MS SQL Server, Presto, AWS Redshift, Netezza, Windows, Databricks, IBM Infosphere Change Data Capture Management Console, Tableau, Cognos, Excel, Microsoft Office, JIRA, Exploratory Data Analysis, Hypothesis Testing, Forecasting, Campaign Measurement (Test–Control analysis), Data Modelling
Timeline
Pharma Consultant | Commercial Analytics & BI Solutions
Trinity Life Sciences
10.2022 - Current
Senior Business Analyst
Meesho
10.2021 - 09.2022
Decision Scientist
Mu Sigma Inc.
10.2018 - 10.2021
B.Tech. - Computer Science
Kakatiya Institute of Technological Sciences