Hi, I’m
Nikhil Gawand
Data Analytics
Mumbai,MH
Summary
Accomplished Data Analytics Executive with a proven track record at Ajanta Pharma Ltd, enhancing business strategy through expert data analysis and market research. Demonstrated ability to lead teams in high-stakes environments, achieving significant insights for expansion planning. Skilled in budgeting and problem-solving, driving strategic decisions and operational efficiency.
Overview
14
years of professional experience
Work History
Ajanta Pharma Ltd
Executive :- Data Analytics
04.2023 - Current
Job overview
- Target Setting: Establish target metrics at the brand level and HQ-Wise.
- Incentive Planning: Develop incentive plans and address related queries.
- Automation Review Format: Incorporate Sales and Effort data alongside customer level insights for comprehensive Business Team reviews.
- Analysis: Conduct brand-wise, Hq wise and customer-wise analysis for the Marketing Team.
- Place Mapping & Expansion Planning: Engage with the Business Unit Head and Senior Vice President to discuss place mapping and expansion strategies.
- Project Collaboration: Work on the Anglo Africa project with Vector, focusing on the addition and removal of doctor lists, segmentation of doctor lists, and customer-wise analysis.
- IT Coordination: Collaborate with the IT department to ensure data validation and standardize SAR reporting.
Cipla Ltd
Associate :- SFE Analyst
04.2022 - 04.2023
Job overview
- Target Setting: Establish target metrics at the brand level and HQ-specific levels.
- Incentive Management:-Handle incentive-related queries and calculations for two clusters: Vitalis and Uro_Impulse.
- Monthly Sales Trend Analysis: Review sales trends and Brand Standard Operating Procedures (SOPs) for both Core and New Brands at the start of each month.
- Automated Review Format: Develop and maintain an automated review format that integrates Sales and Effort data with Market Research insights for Business Team evaluations.
- Sales Trend Analysis: Analyze sales trends to identify prescriber losses and evaluate Field Team performance against these metrics.
- Field Force Segmentation: Perform FF segmentation analysis to assess Field Team performance based on their efforts and sales results.
- Market Insights: Extract and interpret insights from IQVIA data to identify changes in market share by state and metropolitan areas.
Dr Reddy's Laboratories Ltd
Team Member
06.2020 - 03.2022
Job overview
- Sales Analysis and Review Preparation: Conduct sales analysis and prepare review slides at the beginning of each month.
- CRM and Marketing Budget Analysis: Analyze CRM data and assess marketing budget investments on a monthly basis.
- PR and PO Creation: Generate Purchase Requests (PR) and Purchase Orders (PO) for the Marketing Team and draft agreements with vendors.
- HCP Engagement and CME Arrangement: Manage HCP engagement payments and coordinate Continuing Medical Education (CME) events and Advisory Board meetings as required by the sales team.
- Quarterly Meeting Arrangements: Organize venues for quarterly cycle meetings.
- Sample and Promotional Material Distribution: Coordinate the dispatch of samples and promotional materials to the Field Team each month.
Wockhardt Ltd
Associate Sales Support
06.2010 - 05.2020
Job overview
- Sales Analysis and Review Preparation: Conduct sales analysis and prepare review slides at the beginning of each month.
- CRM and Marketing Budget Analysis: Analyze CRM data and assess marketing budget investments on a monthly basis.
- PR and PO Creation: Generate Purchase Requests (PR) and Purchase Orders (PO) for the Marketing Team and draft agreements with vendors.
- HCP Engagement and CME Arrangement: Manage HCP engagement payments and coordinate Continuing Medical Education (CME) events and Advisory Board meetings as required by the sales team.
- Quarterly Meeting Arrangements: Organize venues for quarterly cycle meetings.
- Sample and Promotional Material Distribution: Coordinate the dispatch of samples and promotional materials to the Field Team each month
- Stakeholder Coordination: Collaborate with various stakeholders to ensure the completion of day-to-day tasks, including Finance: Follow up on client and vendor payments, as well as marketing monthly budget allocations.Supply Chain: Coordinate with the supply chain team to manage sales forecasts and sample stock levels.
Education
D Y Patil Pune
MBA from Marketing
04.2001
Welingkar Institute of ManagementMumbai, India
Diploma in Supply Chain from Supply Chain
04.2001
Mahatma English SchoolMumbai, India
Bachelor of Commerce from Commerce
04.2001
Skills
Data Analysis
Business Strategy & Insights
Budgeting & Incentive Plan
Market Research
Problem Solving
Team member
Accomplishments
Best Support Function in Dr. Reddy's Ltd :- 2020-21
Best Support Function in Wockhardt Ltd :- 2015-16
Languages
English
Hindi
Marathi
Interests
Playing Cricket, Travel & Listening Music
Corporate Activity
Dreams Trophy T20 :- Best Bowler of Tournaments 2017.
Wockhardt Trophy :- Across all Man of Match, Player of the Tournaments 2019.
Timeline
Executive :- Data Analytics
Ajanta Pharma Ltd
04.2023 - Current
Associate :- SFE Analyst
Cipla Ltd
04.2022 - 04.2023
Team Member
Dr Reddy's Laboratories Ltd
06.2020 - 03.2022
Associate Sales Support
Wockhardt Ltd
06.2010 - 05.2020
D Y Patil
MBA from Marketing
04.2001
Welingkar Institute of Management
Diploma in Supply Chain from Supply Chain
04.2001
Mahatma English School
Bachelor of Commerce from Commerce
04.2001