Proactive manager with demonstrated leadership abilities, strategic planning expertise and problem-solving acumen. Assists senior managers with accomplishing demanding targets by encouraging staff and coordinating resources. Methodical and well-organized in optimizing coverage to meet operational demands.
Hi, I’m
Rohit Bhattarai
ASM - SAMNA (SALES DATA ANALYST)
Guwahati
Summary
Overview
11
years of professional experience
Work History
VARUN BEVERAGES LIMITED
ASM SAMNA (Deputy Manager)
01.2023 - Current
Job overview
- Unit - Handling 4 Units with 4 HOS.2 Unit of WB - SBN,NBN and 2 Units of North East - NE1,NE2.
- Team Leadership: Manage a team of 7, including 2 order processing pack members and 5 MIS support staff. Guide the team in stock maintenance and ensure smooth order processes while maintaining minimum buy quantities (MBQ).
- Order Process Optimization: Implement effective stock management practices to streamline order processing, improve efficiency, and ensure accurate order fulfilment.
- MIS and Reporting: Supervise the preparation of meaningful reports and dashboards using MS Excel, MS Access, Power Pivot, and Power Query. Provide guidance to the MIS team in report analysis and ensure timely delivery of reports to the sales team for target achievement.
- SAMNA Team Management: Oversee the creation of distribution reports, non-buyer reports, and detailed summary reports by outlet to support business expansion efforts.
- System Implementation: Successfully implemented a tagging system for each outlet with latitude and longitude coordinates, improving location accuracy and tracking capabilities.
- Tracking and Configuration: Developed a comprehensive tracking system for PSRs (Pre-Sales Representatives) and provided HHD (Handheld Device) configuration support to the sales team, enhancing field operations and data collection efficiency.
- Achievements: Streamlined order processing, resulting in a 20% reduction in processing time. Enhanced business expansion efforts through detailed outlet reports and tagging system implementation.
- 11 years 6 months
Varun Beverages Ltd
Assistant Manager
01.2018 - 01.2023
Job overview
- Managed data extraction processes from MS Access and developed databases to support operational needs.
- Designed and maintained dynamic dashboards and worksheets to track key performance indicators and business metrics.
- Implemented Google Sheets and Google Forms for efficient data collection and analysis.
- Delivered detailed presentations and reports to stakeholders, enhancing data-driven decision-making capabilities.
- Contributed to improved data accuracy and reporting efficiency by preparing various Distribution and Summary Reports.
- 5 years 1 month
Varun Beverages Ltd
MIS Executive
04.2014 - 12.2017
Job overview
- Tracking and maintaining records of all Sales Data to prepare a strong Database.
- Preparation of Unit Trend Brand & Pack Performance Report on Daily Basis.
- Preparation of NE Sales and Stock Report on Daily Basis.
- Preparation of Sales KPI report on Daily Basis.
- Preparation of Weekly & Monthly Review Report.
- Preparation of Territory wise Target Vs Achievement Report.
- Preparation of incentive calculation Report based on target.
- Preparation of State wise & Territory Wise Performance Report.
- Preparation of CAGR Report.
- Preparation of a FIFO Dashboard Based on Distributor wise FIFO report.
- Support Sales Team to Maintain Stock MBQ by Preparing Distributor Wise SKU Wise Stock Report.
- 3 years 9 months
Education
IDOL University
Master from Commerce
01.2016
University Overview
NIIT
from Business Information and System Management
01.2012
University Overview
Guwahati University
Bachelor from Commerce
01.2009
University Overview
Skills
Task Delegation
Timeline
ASM SAMNA (Deputy Manager)
VARUN BEVERAGES LIMITED
01.2023 - Current
Assistant Manager
Varun Beverages Ltd
01.2018 - 01.2023
MIS Executive
Varun Beverages Ltd
04.2014 - 12.2017
NIIT
from Business Information and System Management
Guwahati University
Bachelor from Commerce
IDOL University
Master from Commerce