Message

Vidhita Agarwal

Enthusiastic Analyst eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Clear understanding of projects and training in MS Excel and My SQL. Motivated to learn, grow and excel

Key Skills

MS Excel and Google Sheets
Multiple Project Management
MySQL
Client and Interpersonal Communication
MS PowerPoint
Problem Solving Skills

Professional Experience

May 2020
Present
Analyst
PharmaACE Pune, IN
 Sales Force Outreach Analytics
  • Leading design, execution and operationalization of PAN US sales team effort utilization and commercial outreach tracker using Veeva CRM data for US pharmaceutical client 
  • Facilitating key decision making to drive targets by highlighting weekly/monthly insights and gap analysis in sales team outreach efforts and visible financial implications to the client 
  • Identifying the outreach trend and workload utilization for PAN US sales team force as in when new market strategies are inducted into the sales outreach through forecasting, ad-hoc analysis and prepared a Compliance Tracker to plan for tasks, resources and timelines and to detailed out falls through the cracks
  • Streamlined the report generation with error-free calculations by designing and developing automated data processing system

Sales Performance Tracker
  • Providing performance snapshots of tangible results using information and data resources that efficiently communicates between goals and achievements by collating weekly sales trend of marketed products with the historical data trends and baseline (Pre Covid Market) for revenue and procedural growth rate for PAN US 
  • Examining trends, deriving contributing factors and Customers Tracking through determination of customer retention rate and developing new customers by leading development of weekly sales outreach performance dashboard 



SFE Supporting Projects 
  • Supporting operations and reporting of existing and newly developed monthly Commercial dashboard presented to the client leadership team
  • Supporting Goal setting and Incentive Compensation (IC) operations with client partner and other stakeholders for existing and new products
Practice Areas: Business and Commercial Analytics, Sales Force Effectiveness
Tools: MS Office suite , SQL , Tableau 

 
Jul 2019
Dec 2019
Business Analyst Intern
Udaan.com Bangalore Urban, IN
Buy Sell Margin Model
  • Built out the profit loss margin data and reporting infrastructure from the ground up for Fast Moving Consumer Goods across PAN India through Operating Margin model expressed on a per-sale basis after accounting for variable costs
  • Facilitated Root Cause Analysis for teething issues by developing an automated tool in tracking Gross Merchandising Volumes and generating hierarchical reports across divisions and product lines 
  • Ensured business and data alignment by collaborating with Business Development and Warehousing team across the organization 
  • Boosted profit-margin by 5% by executing in-depth analysis on weekly basis for business and pricing optimization
Practice Area: Financial Planning and Analysis
Tools: MS Office suite , SQL , Google Sheet 

 

Education

Aug 2016
Apr 2020
Bachelor of Pharmacy (GPA-7.72) in Birla Institute Of Technology And Science, Pilani
Apr 2014
Apr 2015
Class XII (Percentage - 90.4%) in Kendriya Vidyalaya

Achievements

2020
Emerging Pacer
 Rising star and Future Leader Segment for inherent passion and contribution to the team in PharmaACE 
2021
PharmaACE Excellence Award
For excellent and extra-ordinary dedication to the Sales and Commercial Analytics

Hobbies & Interests

  • Dancing
  • Painting

Languages

English
(Native)
Hindi
(Native)

Get in touch with Vidhita