Harsh Malhotra
Mumbai
Summary
Results-driven analytics and operations professional with over 8 years of experience in facilitating critical decision-making processes. Proven expertise in data analysis and problem-solving, contributing to significant growth and operational improvements within organizations. Committed to leveraging analytical skills to drive strategic initiatives and enhance overall performance.
Overview
15
15
years of professional experience
Work History
Sales Planning Analyst
L'Oréal
Mumbai
01.2024 - 01.2025
- Creating Daily, Weekly and Monthly Reports and Dashboards in Microsoft Excel to track sales performance
- Tools used to download data were SAP for primary data and boost for secondary data
- Collecting, organising, and analysing sales data to identify patterns, trends, and opportunities
- Daily Tracking of number of Calls/Visits made by the field sales team
- Collaborating with sales managers to forecast future sales based on historical data
- Coordinating with the finance team for settlement of distributor claims
- Follow up with internal stakeholders for vendor and customer code creation
- Incentive file preparation on a monthly basis
Sales Operations Manager
Piramal Pharma Solutions
Mumbai
02.2022 - 11.2022
- Preparation of daily primary report for sales performance tracking by use of SAP for modern trade key accounts
- Secondary data collection from field sales managers on a monthly basis
- Co-ordination with the finance team for distributor claims settlement
- Generating insights from large data sets by summarizing them into meaningful information used for monthly presentation for middle and top management
- Co-ordinating with the MDM team for customer and vendor code creation
Sales Analyst
Cipla
Mumbai
01.2020 - 02.2022
- Created a comprehensive dashboard in excel that tracked sales performance of 9 countries
- Collection of secondary data from country managers on a monthly basis for generating useful insights
- Successfully integrated large data sets into tableau by collaboration with the tableau team resulting in creation of dashboard which showed number of visits done by medical representatives
- Preparation of Incentive files on a monthly and quarterly basis
- Use of various formulas in excel which reduced the time by 40 percent in preparing the reports
Senior Analytics and MIS Officer
Marico
Mumbai
10.2018 - 01.2020
- Creating regular primary and secondary reports by use of SAP for Primary and MIDAS(Marico Industries Distributor Application Software) for Secondary
- Offtake data collection from modern trade key accounts to understand market share at brand level on a monthly basis
- Summarizing data for new product launches and keeping a track of the same
- Preparation of sales tracker which shows the sales trend based on the promotional offers given by the company for certain products
Sales Coordinator
Frigorifico Allana Pvt Ltd
Mumbai
01.2018 - 10.2018
- Preparing daily dispatch (Primary) sales report by downloading the report from Oracle software
- Checking the basic cost and landing rate of purchase orders for modern trade before sending to the managers for order processing for modern trade key accounts
- Keeping a track of the purchase orders
- Co-ordinating with the supply chain team for invoicing of the orders
- Co-ordinating with the key accounts for NOC submission
MIS Executive - Third Party Payroll
Britannia Industries Limited
Bangalore
08.2015 - 09.2017
- Preparation of MIS reports of modern trade key accounts at brand and SKU level
- Data preparation of new product launches
- Sending new product launch details to the category managers of key accounts
- Collection and preparation of offtake data for preparation of market share analysis
- Preparation of Ad-Hoc reports as and when required
Intern
Edelweiss
Mumbai
05.2014 - 06.2014
- Lead generation through cold calling about personal financial planning
- Fixing up meetings for the managers with prospective clients
- Achieving a daily target of 3 meetings
Executive
Iksula
Mumbai
01.2010 - 01.2011
- Collection of data from the internet and Structuring it in Excel as per client's requirement
Education
Masters in Management Studies -
Aditya Institute of Management Studies & Research
01.2015
Bachelors of Commerce -
Gokhale College
01.2010
MIS -
NIIT
01.2010
Advance Excel And Dashboards -
Compufield
MumbaiSkills
- Microsoft Excel
- Relationship building
- Sales operations
- Data analysis
- Sales reporting
Accomplishments
- 1st prize in Business Standard Quiz competition held at Aditya Institute of Management Studies and Research.
Training
- Advance Excel and Dashboards.
- Tableau.
Affiliations
Was the "Study Forum Co-ordinator" at Gokhale College from 2007 to 2010. Included organizing activities for students.
Timeline
Sales Planning Analyst
L'Oréal
01.2024 - 01.2025
Sales Operations Manager
Piramal Pharma Solutions
02.2022 - 11.2022
Sales Analyst
Cipla
01.2020 - 02.2022
Senior Analytics and MIS Officer
Marico
10.2018 - 01.2020
Sales Coordinator
Frigorifico Allana Pvt Ltd
01.2018 - 10.2018
MIS Executive - Third Party Payroll
Britannia Industries Limited
08.2015 - 09.2017
Intern
Edelweiss
05.2014 - 06.2014
Executive
Iksula
01.2010 - 01.2011
Masters in Management Studies -
Aditya Institute of Management Studies & Research
Bachelors of Commerce -
Gokhale College
MIS -
NIIT
Advance Excel And Dashboards -
Compufield
Similar Profiles
Israel DuranIsrael Duran
Vendor Representative at L'OréalVendor Representative at L'Oréal
Susana Rodriguez EscuderoSusana Rodriguez Escudero
Chief Digital Marketing Officer at L'OréalChief Digital Marketing Officer at L'Oréal
Elena KhatriElena Khatri
IT Retail Project Manager UK & Ireland at L'OréalIT Retail Project Manager UK & Ireland at L'Oréal