Shubham Kumar Singh
Manduadih Varanasi
Summary
Supply chain professional with extensive experience at Varun Beverages, specializing in data analysis and KPI tracking. Proven expertise in predictive analysis and strategic planning, resulting in improved logistical operations and enhanced vendor performance. Skilled in team coordination and proficient in BI tools to generate actionable insights.
Overview
9
9
years of professional experience
Work History
Asst Manager at SCM
Varun Beverages
01.2023 - Current
- Create processes and methods to gather supply chain data.
- Analyse data to identify problematic areas and suggest improvements.
- Evaluate vendor operations (e.g., freight forwarders) according to quality standards.
- Track KPIs and report on supply chain's performance.
- Utilized Predictive Analysis to remove redundancies in forecasting model.
- Boosted KPIs and continuous improvement strategies to enhance logistical operations and meet supply chain needs.
- Directed planning and procurement of raw materials and coordinated logistics.
- Determined inventory goals, product stock and risk management objectives and oversaw techniques to maximise inventory.
- Conducted vendor monitoring and supply chain management activities in compliance with internal logistics standards.
- Implemented clear and effective planning strategies to meet supply chain needs and optimise distribution.
Sr. Officer at Sales Analyst
Dabur India Limited
01.2022 - 01.2023
- To provide Sales Analysis of business parameters to meet out the projections per Organization's expectations.
- To monitor the Mid /Month Closing to achieve the month plan smoothly.
- To prepare the Several Presentations towards Sales Meet/New Product and other business segments.
- To monitor the channel health basis credibility, business volume, compliance and cheque bouncing.
- To track the Daily Receipt against the monthly forecast at SKU/Brand Level & Stockist level.
- Handling data analytics for top management, presenting data-based decision-making dashboards and reports to the management.
- Analysis of different Web Reports SSFA, Web Analyzer Etc.
- Handling business analytics, sales force effectiveness, SFA implementations, implementation of SSFA, order booking tool for Field force.
- To track the YTD Achievement at various level for Last 5 Years onwards.
- To coordinate with Sales team to collate various information/data as per business requirement and submission to the Corporate Authorities.
- To validate various Payout /Incentive working as per circular to avoid calculation mistake and settlement with accuracy and priority.
- To monitor the claims of channels and Sales team (TA/DA) to be processed on priority after proper validation & required deduction.
- Processing Of Vendors Bills (Generation of Service Invoices in SAP) as per guidelines from corporate team.
- Handling various business applications related to sales force. Responsible for enhancements and usage of the applications.
- Worked on DMS (MWT, Drishti MDM) for on boarding / De boarding of new stockist & stockist profiling.
- To monitor the channel appointment/closure to avoid dissatisfaction among channels and trade.
- To Track annual budget for RGA (Damage) for claim purpose & Co-ordination with CFA Team for audited stock.
- Responsible for arrangement of amenities for Monthly/Quarterly Conference meetings.
- To coordinate with IT-Support team to resolve the various issues occurs with trade and sales team on priority.
Zoco Exe.
Bharti Airtel
09.2020 - 01.2022
- Complete Co-Ordination with Sales & Distribution Team with all KPIs for two zone (Varanasi).
- System MIS development to evaluate daily / weekly / monthly & Yearly performance.
- Maintenance of Master Data - Distributors, Retailers, DSR, FOS, KRO, RSPs, TSMs, Town & District Wise.
- Channel Partner / Distributor Development based on product distribution.
- Keeping a track of Daily business in terms of Requirement Report.
- Handling Distributors Billing (Botree).
- Daily Collection Report (Billing Zone wise, Agency wise, Category wise, Day & Till date Wise Performance including Ranking Agency Wise).
- Managing New Channel joining formality.
- Making ROI Sheet of Distributor's as required.
- Handling New Channel Partner and F & F related documents (Category wise:- AAP, ADP, MD DCP,LMP).
- Maintenance of MIS related Tracker and Providing All KPI trackers to DGM\ZSM\TSM\DCP.
- Managing Channel Partners and their FOS and Tracking of their problems and resolve on top priority.
- Handling of Zonal Team.
- Maintain the staff Attendance and his claims.
- Conduct the Employees learning & development program.
- Billing Efficiency (Distributor Stock & Re-ordering levels).
- Taking Daily Sales Plan and Tracking the execution by the team.
- Revenue Analysis (Primary/Secondary/Tertiary) with daily, weekly, Monthly & Yearly.
MIS Executive (CSCC)
Dabur India Limited
01.2019 - 08.2020
- System MIS development in SAP to evaluate daily / Weekly / Monthly & Yearly Performance of CFA.
- Maintaining all MIS tracker of CFA and providing to DGM & Zone.
- Preparing Monthly Cost Analysis Reco and Analysis the Various.
- Periodic Revision of Inventory and IBT through Location.
- Disposal of Expiry Material through Write off and Preparing CSR Distribution through location of Near Expiry Material.
- Maintaining All Agreement of CFA's.
Zonal Sales Coordinator
Aircel Private LTD.
04.2016 - 01.2019
- Complete Co-Ordination with Sales & Distribution Team with all KPIs for two zone (Azamgarh and Varanasi).
- System MIS development to evaluate daily / weekly / monthly & Yearly performance.
- Maintenance of Master Data - Distributors, Retailers, DSR, FOS, KRO, RSPs, TSMs, Town & District Wise.
- Channel Partner / Distributor Development based on product distribution.
- Keeping a track of Daily business in terms of Requirement Report.
- Making monthly target of DCP\FOS and provide daily basis tracking to bottom to Up line.
- Handling Distributors Billing (in SAP).
- Daily Collection Report (Billing Zone wise, Agency wise, Category wise, Day & Till date Wise Performance including Ranking Agency Wise).
- Managing New Channel joining formality.
- Handling Lager, Service Tax invoice, required of all channels.
- Making ROI Sheet of Distributor's as required.
- Handling New Channel Partner and F & F related documents (Category wise:- AAP, ADP, MD DCP,LMP).
- Maintenance of MIS related Tracker and Providing All KPI trackers to ZBM\ZSM\TSM\DCP.
- Managing Channel Partners and their FOS and Tracking of their problems and resolve on top priority.
- Handling Two Zone's (AZM & VNS).
- MIS (Management information system) - Processing of E-top up outlet of different channel partners.
- Handling of Zonal Team.
- Maintain the staff Attendance and his claims.
- Conduct the Employees learning & development program.
- Billing Efficiency (Distributor Stock & Re-ordering levels).
- Taking Daily Sales Plan and Tracking the execution by the team.
Education
B.COM -
Sai Nath Univercity
Jharkhand01.2019
10+2 -
Baijnath I.C School
Varanasi01.2016
High School -
Divine Sainik School
Varanasi01.2013
Skills
- MS Office proficiency
- Data analysis and reporting
- KPI tracking and trend analysis
- Business analytics
- Email, internet, and SAP usage
- BI, BW, and Tableau expertise
- Power Apps knowledge
- Team coordination
- Problem solving
- Strategic planning
Languages
- English
- Hindi
- Urdu
Key Achievements And Activities
- Activity for creating the good relationship with the CSM & Distributer.
- Got appreciation certificate for best MIS in circle from Sales head.
- Solving problem of CSM`s & Distributor.
- Handle TBA territory of our Zone.
- Winner of marketing management game.
- I have working experience in windows 7/ 8 and MS Office2007/2010.
Personal Information
- Father's Name: Ram Dayal Singh
- Date of Birth: 09/23/97
- Marital Status: Un Married
Timeline
Asst Manager at SCM
Varun Beverages
01.2023 - Current
Sr. Officer at Sales Analyst
Dabur India Limited
01.2022 - 01.2023
Zoco Exe.
Bharti Airtel
09.2020 - 01.2022
MIS Executive (CSCC)
Dabur India Limited
01.2019 - 08.2020
Zonal Sales Coordinator
Aircel Private LTD.
04.2016 - 01.2019
B.COM -
Sai Nath Univercity
10+2 -
Baijnath I.C School
High School -
Divine Sainik School
Similar Profiles
PRATIBHA TIWARIPRATIBHA TIWARI
Operation Analyst Intern at Varun BeveragesOperation Analyst Intern at Varun Beverages
PREETI YADAVPREETI YADAV
Customer Executive at Varun BeveragesCustomer Executive at Varun Beverages
Shekh JunedShekh Juned
Customer Executive at Varun BeveragesCustomer Executive at Varun Beverages
Arpit KushwahaArpit Kushwaha
Risk Manager at Axis BankRisk Manager at Axis Bank
ASHUTOSH KANNAUJEEYAASHUTOSH KANNAUJEEYA
Technical Support Representative at GenpactTechnical Support Representative at Genpact