Amardeep Anandam Guntuka
Worli
Summary
Results-focused analytics professional with 12 years of experience in data analysis and sales operations within FMCG and fintech sectors. Expertise includes P&L analysis, budgeting, forecasting, and dashboard automation, enhancing business performance visibility. Currently pursuing a postgraduate data analytics programme at IIT Guwahati and Coding Ninjas, expected completion in February 2026.
Overview
4
4
Languages
13
13
years of professional experience
Work History
MIS Manager
Konkan Agro Marine Industries Private Limited
05.2026 - Current
- Designed and automated MIS dashboards for sales performance, market analysis, and trade scheme trend analysis, providing actionable insights and exception visibility to management.
- Prepared and updated monthly MIS reports for IMFL and MML industry segment, facilitating informed decision-making through Mid-Month, Monthly, and Quarterly Review reports.
- Handled primary sales planning and forecasting for current month and rolling 3-month projections, enabling strategic SKU-wise sales analysis.
- Tracked and updated issues, pending dispatches, and sales planning discussions during S&OP meetings, ensuring alignment and proactive resolution of challenges.
- Planning and monitoring secondary sales volumes at party-wise and distributor-wise levels against monthly targets.
- Daily updating and monitoring of stock and sales data distributor-wise, ASM-wise, and TSE-wise.
- Preparing monthly trade claim provision reports and validating actual distributor trade schemes and claims and Distributor and division wise CPC trend analysis.
- Led the implementation of SFA systems, streamlining processes and increasing operational efficiency.
- Automated critical reports and workflows using AI tools, significantly reducing manual efforts and improving reporting accuracy.
- Monitored competitor and industry trends to support strategic planning and identify growth opportunities.
MIS Manager (SGA Team)
B9 Beverages Pvt.Ltd
09.2025 - 01.2026
- Created and maintained daily, weekly, and monthly MIS reports, including Target vs. Achievement, Cost of Sales, and Incentive dashboards to support data-driven decision-making.
- Automated reports and dashboards, enhancing data accuracy and enabling mobile accessibility for real-time decision-making.
- Streamlined data reporting formats and workflows, enhancing report turnaround time and overall reporting efficiency.
- Conducted market-wise P&L analysis, budget preparation, and variance tracking to optimise financial performance.
- Delivered sales insights and market trends to support strategic planning and business reviews.
- Monitored competitor and industry trends to support strategic planning and identify growth opportunities.
- Managed sales operations across West Region – Maharashtra, Goa, Daman & Silvassa, ensuring smooth order flow and distributor coordination.
- Managed primary sales forecasting and coordinated indent placement with the brewery to Nagpur for timely replenishment.
- Partnered with marketing and finance teams for promotional activities, scheme tracking, and financial validation.
Sr.MIS Manager
Good Drop Wine Cellars Pvt.Ltd
09.2022 - 08.2025
- Spearheaded the development and maintenance of comprehensive dashboards using advanced MIS tools (including SFA application) to track sales performance, marketing compliance, and key business metrics, providing senior management with actionable insights for decision-making.
- Led the implementation of SFA systems, streamlining processes and increasing operational efficiency by 30%.
- Successfully implemented the SFA application, resulting in a 30% improvement in operational efficiency.
- Managed and mentored a team of 5 MIS professionals, overseeing the company’s information systems, data analysis, and technology infrastructure to ensure seamless operations and data accuracy.
- Prepared and presented detailed sales reports, forecasts, and annual budget analyses to National Sales Head, aligning insights with business goals and offering strategic recommendations.
- Collaborated closely with Marketing, Finance, HR, and Operations teams to identify system improvements and implement best practices across the organization, ensuring data consistency and process efficiency.
- Streamlined reporting workflows and improved sales performance tracking, ensuring timely and accurate data for decision-making.
- Automated key reporting processes using AI tools, significantly reducing manual workload and enhancing reporting accuracy.
- Delivered advanced Excel and system training (DBMS, SFA) to the Pan India sales and head office teams, fostering a data-driven culture and improving team capabilities.
- Mentored and trained 100+ sales team members and analysts, enhancing their proficiency in reporting and data analysis.
- Managed vendor relationships, conducting weekly meetings to track system updates and monthly meetings to discuss requirements, ensuring alignment with organisational needs.
- Regularly updated and presented management reports, including primary and secondary analysis, expense reports, and sales performance metrics across all channels.
- Coordinated with sales teams to track primary stock permits, manage stock projections, and monitor dispatch statuses, ensuring timely updates and alignment with business needs.
- Led the analysis of competitor market data, tracking trends and identifying opportunities for business growth.
- Implemented techniques to establish discipline in Travel Allowance (TA) process, reducing Sales team claims expenses by 20% per month.
MIS Executive
PhonePe
03.2020 - 03.2022
- Monitored performance dashboards for interns and team, tracking onboarding and collections progress of Key Account Managers, Cluster Managers, and Executives to ensure alignment with targets.
- Conducted pipeline reviews with Cluster and Key Account Managers, aligning onboarding progress with collection targets and strategies to enhance operational effectiveness.
- Developed weekly performance presentations and maintained daily, weekly, and monthly reports to track key metrics and operational efficiency.
- Compiled transaction reports by brand and store to identify trends and performance insights, contributing to strategic decision-making on a weekly and monthly basis.
- Created Google Forms and Sheets for efficient data collection; coordinated with stakeholders for account onboarding and ensured data accuracy through regular master report updates.
- Updated active merchant details, coordinated deployment of QR codes and marketing collaterals, and raised monthly stock requisitions with the marketing team.
- Verified employee attendance for the West region, generated software IDs/passwords for new hires, and managed merchant KYC verification and approvals.
- Verified and corrected merchant category details before submission to Head Office for compliance and reporting.
Assistant Manager-MIS (Sales Operations)
Grover Zampa Vineyard Pvt.Ltd
08.2019 - 03.2020
- Prepared weekly/monthly sales reports with performance comparisons (pack, brand, and channel-wise) and conducted primary vs. secondary sales analysis with market coverage insights.
- Maintained and enhanced performance dashboards to track sales, collections, and market visits, enabling data-driven decisions.
- Analyzed sales, finance, and service data for management reviews; monitored West region budgets vs. actuals and updated city-wise sales plans to align with business goals.
- Monitored distributor outstanding reports, managed claims and debit notes, ensuring timely resolution and submission to maintain financial accuracy.
- Verified and processed sales team attendance, travel, and TADA claims in line with policy; reviewed debit notes for finance approval.
- Managed city-wise stock requisitions and coordinated with breweries, following up with zonal teams on collections and stock permits to optimise inventory flow.
- Partnered with zonal managers to plan and execute weekly and monthly collection and stock strategies, facilitating seamless operations.
Assistant Manager-Sales Operations
B9 Beverages Pvt. Ltd (BIRA 91)
11.2015 - 08.2019
- Generated daily, weekly, and monthly reports on sales volume, performance comparisons, and cost management, segmented by pack, brand, channel, and time period.
- Developed and maintained dashboards tracking city and ASM performance metrics, enhancing visibility of sales, collections, market visits, and billing points.
- Conducted product-wise sales performance analysis to identify and address low-performing categories.
- Performed in-depth sales analyses, such as LYMTD vs. LMTD, market coverage, and billing point extractions.
- Prepared comprehensive presentations on sales, logistics, consumer finance, and service analytics for monthly top management business review meetings.
- Analyzed logistics performance metrics, including cost efficiency, TAT, and monthly stock fill ratios.
- Conducted daily stock checks at DB level against monthly MSL targets, ensuring no stockouts of critical SKUs.
- Monitored outstanding payments for outlets, ensuring timely updates to ASMs to prevent delays in stock dispatch.
- Coordinated with logistics and product teams to ensure timely stock availability.
- Coordinated daily with distributor salesmen and sales managers to ensure seamless operational processes.
- Followed up with outlets regarding outstanding payments and provided regular updates.
Executive Operations
SHARED SERVICE CENTER CMA CGM
03.2014 - 03.2015
- Coordinated with international agencies and terminal operators via email to address and resolve queries, enhancing stakeholder communication and operational efficiency.
- Managed detention, demurrage, idle notifications, and equipment control processes for USA and Brazil invoices, ensuring timely resolution and minimisation of delays.
- Approved container street turns and processed manual rebill requests, maintaining accuracy in customer communications and supporting seamless transaction processes.
- Conducted follow-ups with US truck managers, prepared detailed reports, and facilitated discount approvals.
- Ensured timely updates of empty container notifications to agencies for smooth operations.
- Maintained accurate records by updating missing container moves, on-hire, and off-hire details in the system.
Education
BMS -
University of Mumbai
04-2012
H.S.C. -
Maharashtra Board
04-2009
S.S.C. -
04-2007
Post Graduate Program - Data Analytics
Coding Ninjas & E&ICT Academy, IIT Guwahati
02-2026
Skills
- SFA applications
- Advanced Excel
- Data analysis
- Dashboard development
- Sales forecasting
- Market analysis
- Process automation
- Microsoft Office Suite
- Google Sheets
- Power Query
- DBMS software
- Business intelligence tools
- Data monitoring
- Operational support
- Cross-functional collaboration
- Training delivery
- Mentoring and coaching
Languages
English
Hindi
Marathi
Telugu
ACHIEVEMENTS & ACTIVITIES
- NCC with ‘B’CET
- Directorate of adventure promotion grade secured “A”
- Participated and won in district level athletics sports
Personal Information
Date of Birth: 19 Jan 1991
Marital Status: Married
Timeline
MIS Manager
Konkan Agro Marine Industries Private Limited
05.2026 - Current
MIS Manager (SGA Team)
B9 Beverages Pvt.Ltd
09.2025 - 01.2026
Sr.MIS Manager
Good Drop Wine Cellars Pvt.Ltd
09.2022 - 08.2025
MIS Executive
PhonePe
03.2020 - 03.2022
Assistant Manager-MIS (Sales Operations)
Grover Zampa Vineyard Pvt.Ltd
08.2019 - 03.2020
Assistant Manager-Sales Operations
B9 Beverages Pvt. Ltd (BIRA 91)
11.2015 - 08.2019
Executive Operations
SHARED SERVICE CENTER CMA CGM
03.2014 - 03.2015
BMS -
University of Mumbai
H.S.C. -
Maharashtra Board
S.S.C. -
Post Graduate Program - Data Analytics
Coding Ninjas & E&ICT Academy, IIT Guwahati