Power BI, SAP, SQL, SSBI, Excel, Powerpoint
Bhupendra Singh
Cluster Sales Analyst
Dehradun
Summary
Dynamic and results-driven leader with over a decade of experience in sales and business development, consistently demonstrating strong work ethic and core values. Proven ability to foster effective communication and cultivate team cohesion, earning the trust of clients and associates. Currently spearheading a business unit and eager to embrace a challenging opportunity in sales analytics that involves full ownership of driving business growth and enhancing workforce efficiency through innovative strategies. Committed to leveraging expertise to contribute meaningfully to organizational success.
Overview
16
16
years of professional experience
1
1
Language
Work History
Assistant Manager – Sales Analyst
DIAGEO INDIA PVT LTD
Dehradun
07.2024 - Current
- Developed and executed sales strategies and business plans, including annual budgeting, and forecasting.
- Plan and coordinate sales and distribution activities to achieve sales targets and market penetration goals.
- Plan sales volume and calculate AOP & Generation spends.
- Calculate customer & brand wise slab & additional rebate.
- Accountability of all the BTL expense like Primary scheme, Secondary Scheme, CSMs Scheme, Tertiary Scheme and etc.
- Provision, PO uploading & releasing in SAP.
- Developed comprehensive MIS reports on competitive changes, and implemented effective models for budgeting, forecasting, and cost card construction.
- Utilized Power BI to create insightful dashboards and reports, managing a centralized and automated database using Power Query.
- Weekly and monthly review with sales team.
- Execution Matrix like Sales Call coverage, Activation, Visibility, MDM & SFA.
- Industry – FMCG
Assistant Manager – Data Analyst
DELMONTE FOODS INDA PVT LTD
Gurgaon
04.2022 - 06.2024
- Sales Planning
- Development & Execution of AOP plan regarding sales capability and infra development in line with stakeholders of the company.
- Customize, implement & track trade marketing initiatives such as primary & secondary schemes, NPI development, Variable Payouts etc. on field to help improve the business across functions.
- Enrollment & Re-Structuring of channel royalty programs for better execution in the GT/WS market.
- Transforming annual GTM agenda such as Coverage & Manpower expansion, NPI launches, Market research etc.
- Support the sales team with robust & timely MIS reports & Dashboards on key sales KPI’s (Distribution WOD, Coverage, Productivity, Focus Products, NPD Launches, Retail Environment & many More).
- Own the development & complete backed support for DMS (Bizom) & SFA (Bizom mobile app).
- End to End responsible for SFA/DMS development, backend support, Tech improvements, creative visualization, any activity related to SFA/DMS.
- SFA & Portal training to all the sales team.
- Market route planning and execution.
- Build insightful and interactive Dashboards and Reports using Power BI.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Developed complex dashboard and reporting tools to track business performance metrics.
Sr. Data Analyst
PERNOD RICARD INDIA PVT LTD
Gurgaon
01.2016 - 04.2022
- SFA Management.
- PJP & Route Planning, Visibility & availability Norms Planning.
- SFA & Portal training to all the sales team, new development, Complete Backend Support to all sales team.
- Activation & promotion management.
- Annual budgeting and Forecasting exercise.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Improved data storage efficiency with redesign of database structures, optimizing for faster query responses.
- Analyzed data to identify root causes of problems and recommend corrective actions.
MIS EXECUTIVE
SAMSUNG INDIA PVT LTD
Gurgaon
08.2014 - 01.2016
- Analytics and Reporting: Worked with Samsung in CE (Consumer Electronics) department where we used to see distributors daily Sell in and Sellout sales.
- Product wise daily sales report for management.
- Coordination with sales team and vendor.
- Industry – Sales
MIS Executive
WIPRO LTD
Noida
09.2012 - 03.2014
- Using Microsoft SQL Server Data Management, data extraction, Data modification & Procedure Writing.
- Creating package in SSIS to perform ETL (Extraction, Transformation & Data Loading) activities.
- Created Customer Transaction report for all the states.
- Consolidate data of all the partner and uploading data in MS Access.
- Coordinate with partner and client for data and query.
- Creating weekly, Monthly review report for different of all the partners after analyzing their performance according to Log received from partners. This report is created using PivotChart, Pivot and PPT Slides.
- Automation: Created Macros using VBA coding for different Process (CTA) and Department (Customer Support) also create macros / Automate for logs report to increase the efficiency of process. Also automate the reports which help reduce the time, error and human error.
- Industry – BPO
Executive
MED LIFE GLOBAL SERVICE
Gurgaon
12.2009 - 06.2012
- Validating and uploading document through SFTP server.
- Prepare daily productivity report.
- Industry – Health Insurance
Education
Master of Science - Computer
Mahatma Gandhi University
New Delhi 04.2001 -
Bachelor of Arts - Economics
Delhi University
New Delhi12.2010
Skills
EXECUTIVE PROFILE
- Given the modern fusion of digital technology and business operations, I aim to apply my skills to effectively fuse technology with strategic business objectives.
- With more than ten years of experience in Sales Analytics and Strategy, I specialize in seamlessly integrating analytical insights with sales planning and execution.
- Skilled in extracting, manipulating data, and transforming it into actionable business insights.
- Proven success in boosting sales, enhancing customer buying experiences, and elevating brand presence in target markets.
- Experienced in conveying complex data insights in an understandable manner, training stakeholders, and offering ongoing support.
- Contributed significantly to organizational growth through operational excellence, process automation, strategic client communications, cost reduction, SOP development, and team skill enhancement.
Software
Timeline
Assistant Manager – Sales Analyst
DIAGEO INDIA PVT LTD
07.2024 - Current
Assistant Manager – Data Analyst
DELMONTE FOODS INDA PVT LTD
04.2022 - 06.2024
Sr. Data Analyst
PERNOD RICARD INDIA PVT LTD
01.2016 - 04.2022
MIS EXECUTIVE
SAMSUNG INDIA PVT LTD
08.2014 - 01.2016
MIS Executive
WIPRO LTD
09.2012 - 03.2014
Executive
MED LIFE GLOBAL SERVICE
12.2009 - 06.2012
Master of Science - Computer
Mahatma Gandhi University
04.2001 -
Bachelor of Arts - Economics
Delhi University