AASHUTOSH KUMAR SINGH
Ghaziabad
Summary
Dynamic Key Account Manager with a proven track record at Sun Pharma Ltd., leveraging SQL and Power BI to drive data-driven insights and enhance client relationships. Expert in variance and competitor analysis, I consistently identify growth opportunities, resulting in improved account retention and revenue performance across diverse territories.
Overview
11
11
years of professional experience
Work History
Key Account Manager
Sun Pharma Ltd.
04.2023 - Current
- Manage key client relationships and align account strategies with data-backed sales performance insights.
- Coordinated with key clients to address queries, present dashboard/report findings, and resolve concerns, strengthening relationships and supporting retention.
- Conduct competitor analysis and customer retention analysis to identify market-share opportunities and reduce account attrition.
- Performed variance and root-cause analysis of sales fluctuations to enable timely, corrective business decisions.
- Conducted revenue analysis by hospital, product/SKU, and cluster segmentation to identify top-performing accounts and products within division.
- Build and maintain interactive Power BI dashboards, backed by SQL-extracted datasets, to analyze sales, profitability, customer and regional performance (MTD/YTD/YoY) exclusively for my division.
- Prepare Advanced Excel-based MIS trackers and division-wise sales & revenue reports, automating recurring reporting workflows for the division.
- Collect and consolidate stockist-level primary/secondary sales data; prepare secondary sales reports and sale-purchase (S&P) statements for accurate business tracking within the assigned division.
Zonal Business Manager
Bouniful Life Sciences
10.2019 - 03.2023
- Coordinated with area managers and marketing executives, and spoke directly with key clients, to align territory strategies with zonal objectives and drive consistent revenue growth.
- Oversaw end-to-end collection of stockist-level primary and secondary sales data across multiple territories in the zone; prepared secondary sales and sale-purchase (S&P) reports for accurate business tracking.
- Consolidated hospital revenue analysis and product/SKU performance tracking across zone, identifying growth opportunities and underperforming areas.
- Conducted variance analysis and root-cause investigation of sales ups/wings/downswings across territories to guide timely corrective action.
- Conducted competitor and customer retention analyses to safeguard market share and minimize account attrition across zones.
- Compiled cluster revenue segmentation and division sales & revenue reports through MIS dashboards for management review.
Area Manager
Larenon Healthcare Ltd
Delhi
02.2018 - 09.2019
- Collected stockist-level primary and secondary sales data to prepare actionable secondary sales and sale-purchase (S&P) reports, enhancing strategic decision-making for assigned territory.
- Conducted revenue-wise analysis by hospital and product/SKU-wise performance tracking to monitor territory growth.
- Performed variance analysis and root-cause analysis of sales fluctuations to identify growth opportunities and address shortfalls.
- Tracked cluster-wise revenue and division-wise sales & revenue reporting, fostering client relationships through regular communication to address queries and ensure satisfaction.
- Carried out competitor analysis and customer retention analysis to strengthen territory performance and reduce attrition.
Marketing Executive
Lupin Ltd
Central Delhi
01.2016 - 02.2018
- Tracked product/SKU-wise sales and revenue trends, providing insights for revenue analysis by hospital to inform strategic planning.
- Managed cluster-wise revenue tracking and division-wise sales and revenue reporting, engaging with stockists and clients to obtain valuable market feedback.
- Conducted variance analysis and root-cause analysis of sales fluctuations to support business planning.
- Contributed to competitor analysis and customer retention analysis to guide marketing strategy.
- Collected stockist-level sales data and prepared secondary sales and sale-purchase (S&P) reports for assigned markets, enhancing data-driven decision-making.
Education
B.COM - Commerce
CCS University
Meerut03-2010
Skills
- SQL (Data Extraction, Joins, Aggregation, LOD) Power BI (Dashboards, DAX, Data Modeling) Advanced Excel (Pivot Tables, MIS Automation) Tableau visualization
- Hospital revenue analysis
- Variance analysis
- Root-cause analysis
- Product performance analysis
- Market Trend Analysis
- Revenue segmentation
- Sale-purchase data preparation
- Division sales reporting
- Account management
- Customer Loyalty Strategies
- Tableau visualization
Personal Information
- Title: Data & Sales Analytics Professional | SQL Power BI Advanced Excel Tableau
- Date of Birth: 1991-12-28
Languages
Languages: English, Hindi
PERSONAL DETAILS
Strengths: Punctual, Organized, Team Leadership, Goal-Oriented
Timeline
Key Account Manager
Sun Pharma Ltd.
04.2023 - Current
Zonal Business Manager
Bouniful Life Sciences
10.2019 - 03.2023
Area Manager
Larenon Healthcare Ltd
02.2018 - 09.2019
Marketing Executive
Lupin Ltd
01.2016 - 02.2018
B.COM - Commerce
CCS University