Ashok Sahani

Commercial Analytics Professional

Helping Pharma Leaders Improve Visibility, Sales Force Effectiveness & Revenue Performance.

Powered by 20 years of pharma experience, Power BI and SQL.

VILYTIX Creator of the VILYTIX Commercial Intelligence Framework
Ashok Sahani
Ashok Sahani
Pharma Commercial Analytics & Commercial Excellence
📈
Revenue Visibility
👥
Customer Intelligence
🌏
Territory Analytics
💊
Product Performance
🌟
Sales Force Excellence
Solutions

What I Help Pharma Teams Improve

Eight commercial analytics solutions designed to improve visibility, decisions and business performance.

📈
Revenue Visibility & Leakage Analysis
Identify hidden revenue losses and realisation gaps.
📊
KPI Dashboards & Reporting
Single executive view of sales and commercial performance.
🎯
Sales Target & Performance Analysis
Realistic targets using territory potential and trends.
👥
HCP Segmentation & Opportunity Mapping
Classify prescribers and identify conversion opportunities.
🏢
Key Account Analytics
Account performance, dependency risks and growth potential.
🌏
Territory & Zone Analytics
Identify market gaps and underperforming territories.
🌟
KAM Effectiveness Analytics
Evaluate KAM performance beyond achievement percentage.
💊
Product Performance Analytics
Track product trends, lifecycle risks and growth opportunities.
Case Studies

Commercial Analytics in Action

Executive-level decision support demonstrated through real pharma commercial data structures.

★ Featured — FY2021

Executive Case Study 2021

How Commercial Intelligence Exposed Revenue Leakage, HCP Concentration Risk, Product Erosion and Hidden Growth Opportunities.

Business Challenge

Leadership was reviewing achievement percentages. Behind 103.8% over-achievement: revenue leakage, product erosion, HCP attrition and ₹70.98 Cr conversion opportunity were invisible in standard reporting.

View Case Study →
Key Insights Discovered
₹90.2 Cr FOC revenue exposure running invisibly alongside paid sales
63.2% NSV driven by top 20% prescribers — multiple accounts at 86–92% YoY decline
₹70.98 Cr conversion opportunity in existing accounts — absent activation, not coverage
Key product declining 27.4% YoY, hidden by blended portfolio growth
Commercial Impact
₹90.2 Cr
Leakage found
₹70.98 Cr
Opportunity
17
Cities flagged
3
KAMs at risk
Case Study — FY2020

Commercial Intelligence Case Study 2020

Transforming Traditional MIS Reporting into Decision-Oriented Commercial Intelligence.

Business Challenge

Standard MIS showed achievement percentages only. Revenue leakage, territory opportunity gaps, product dependency risks and KAM sustainability were completely hidden from leadership.

View Case Study →
Key Findings
₹90.2 Cr revenue leakage identified — 33% of gross sales never realised as revenue
41.8% single-product dependency — top 3 products at ~80% NSV concentration
₹1,094.8 Cr opportunity gap mapped across zones, KAMs and HCP segments
4-layer intelligence framework: Revenue → Portfolio → Customer → Territory
Commercial Value
₹1,094 Cr
Opp. mapped
₹90.2 Cr
Leakage
100.8%
Achievement
Dashboard Portfolio

Commercial Analytics Portfolio

Executive dashboards and decision-support analytics built using Power BI, SQL and pharma commercial expertise.

Executive Business Review — FY2021
Executive Business Review FY2021
Executive Business Review
NSV achievement, HCP revenue concentration, zonal performance, month-wise trends and CEO briefing summary — complete executive view in one connected dashboard.
Product Growth Analysis — FY2021
Product Growth Analysis FY2021
Product Growth Analysis
Product lifecycle classification across Recover, Accelerate and Expand categories. Zone dependency, wallet share by prescriber segment and year-on-year performance trends.
HCP Opportunity Analysis — FY2021
HCP Opportunity Analysis FY2021
HCP Opportunity Analysis
HCP segmentation, conversion opportunity by segment, product wallet share comparison and engagement risk identification by prescriber tier.
National Sales Intelligence — FY2020
National Sales Intelligence FY2020
National Sales Intelligence
National commercial performance overview with zonal comparison, FOC leakage analysis, KAM risk alerts, product penetration and territory opportunity gap mapping.

Dashboards are from demonstration case studies based on simulated pharma commercial data

Ashok Sahani
Ashok Sahani
Pharma Commercial Analytics
Commercial Excellence Professional
20 Years Across Pharma Sales, Product Management, Key Account Management & Commercial Excellence
Ashok Sahani
Pharma Commercial Analytics | Sales Force Effectiveness | Commercial Excellence

“Commercial decisions are often made using reports that miss the real commercial story.”

Ashok’s career spans cardiovascular, diabetes, respiratory, inhalation therapy and fertility businesses across sales leadership, product management, key account management and commercial excellence. Today he combines this domain expertise with Power BI, SQL and commercial intelligence to help leadership teams uncover opportunities hidden within sales and CRM data.

Career Journey
FDC Ltd. & Cipla Ltd.
Sales Leadership
Cardiac • Diabetes • Respiratory
Field Force Management • Territory Development • HCP Engagement
Cipla Ltd.
Product Management
Respiratory & Inhalation Therapy
Brand Strategy • Portfolio Growth • Lifecycle Management
Merck Serono
Key Account Management
Fertility / IVF Specialty Care
Institutional Partnerships • KOL Engagement • IVF Centre Development
VILYTIX
Commercial Excellence & Analytics
Power BI • SQL • Commercial Intelligence
Sales Force Effectiveness • Decision Support • Business Intelligence
Analytics Foundation
IIM Bangalore
IIM Bangalore
Business Analytics & Intelligence
IIT Kanpur
IIT Kanpur
Applied Machine Learning & Data Science
VILYTIX THE VILYTIX FRAMEWORK
Reveal
Hidden Revenue Risks
Diagnose
Commercial Performance Gaps
Prioritize
Growth Opportunities
Act
Decision Intelligence
Get in Touch

Schedule a Discussion

Let’s discuss commercial analytics, business intelligence, reporting challenges or collaboration opportunities.

Sales force effectiveness
Revenue leakage analysis
HCP opportunity mapping
Commercial dashboard design
Territory performance analytics
Schedule Discussion
Response within 24 hours.

Handled with complete confidentiality