Sopnilkumar Shahare
Bangalore
Summary
Results-driven MIS professional with extensive experience at GAP, specializing in sales analysis and reporting. Expert in P&L and EBITDA calculations, alongside inventory management. Proven ability to deliver actionable insights and enhance decision-making processes. Strong analytical skills combined with effective communication foster collaboration and drive business success.
Overview
10
10
years of professional experience
1
1
Certification
Work History
MIS
GAP
03.2024 - 02.2026
- Lead preparation and analysis of Daily Sales Reports (DSR) and executive KPI dashboards.
- Track internal competition, sales gaps, Big Bill contribution, ATV performance, and promotional effectiveness.
- Generate category-wise sales, sell-through, and contribution reports to support business planning.
- Prepare P&L and EBITDA reports (WTD, MTD, YTD) for management review.
- Manage inventory analytics, GRN & GRDC trackers, and external competition benchmarking.
- Calculate performance-based incentives and deliver ad-hoc analytical insights to leadership.
- Relance Retail
MIS Coordinator
Levi Strauss (India) Pvt. Ltd.
02.2022 - 03.2024
- Developed and maintained regional MIS, KPI, and DSR reports across EBO & MBO formats.
- Tracked store, partner, and regional sales performance with WOR, WTD, MTD, and YTD comparisons.
- Managed incentive calculations, door-level target collection, and new store code creation.
- Created liquidation, tertiary sales, and EOSS trackers for distress and first-quality products.
- Conducted store audits, reconciled physical vs system inventory, and updated regional leadership.
- Generate category-wise sales, sell-through, and contribution reports to support business planning.
Data Analyst
Adonis Group
02.2020 - 02.2022
- Analyzed multi-state retail sales data and store operations to identify performance gaps.
- Created KPI reports at store, sales representative, and cluster manager levels.
- Managed customer databases, lapsed & birthday customer tracking, and physical stock audits.
- Supported Dynamics AX POS system and provided operational improvement recommendations.
- Developed and maintained regional MIS, KPI, and DSR reports across EBO & MBO formats.
- Tracked store, partner, and regional sales performance with WOR, WTD, MTD, and YTD comparisons.
Data Analyst
iLead Infosolution Pvt. Ltd.
04.2018 - 02.2020
- Generated daily, weekly, and monthly MIS and database reports for senior management.
- Managed backend operations reporting for 32 branches across Gujarat.
- Prepared month-end due reports and NPA analysis to support financial controls.
Consultant (SCM)
Entercoms Solutions Pvt. Ltd.
10.2015 - 03.2018
- Analyzed customer definitions and recommended optimized customer hierarchies aligned to Account Holder (TAM).
- Worked extensively on Sales tools (SFDC, AMP, GII) and Service tools (DELTA) for customer validation and analysis.
- Conducted weekly stakeholder calls to share updated customer hierarchies and alignment changes.
- Executed complex SQL queries to extract, validate, and update customer definitions in databases.
- Ensured all transactions and updates were documented accurately with strict adherence to policies, processes, and compliance standards.
- Automated customer analysis and reporting procedures to enhance efficiency, accuracy, and turnaround time.
Education
MCA - Computer Applications
Bangalore University
Bangalore01.2013
BCA - Computer Applications
Gulbarga University
Basavakalyan01.2010
HSC - Science (PCMB)
Maharashtra State Board
Walandi01.2006
SSLC - General Education
Karnataka State Board
Kesarjawalga01.2003
Skills
- Sales analysis and reporting
- Data cleaning and validation
- Mis and dashboard preparation
- Sales performance and trend analysis
- Profit and loss analysis
- Ebitda calculation and working
- CRM data analysis
- Inventory, liquidation, and EOSS management
- Incentive calculation and target tracking
- Business dashboards and management reporting
Certification
- Harnessing the Power of Data with Power BI – Microsoft (Coursera)
- Preparing Data Analysis with Microsoft Excel – Microsoft (Coursera)
- Introduction to Data Analyst – IBM (Coursera)
Languages
- Hindi
- Kannada
- Marathi
- English
- Hindi
- Kannada
- Marathi
Disclaimer
I hereby declare that the above information is true to the best of my knowledge.
Place
Bangalore, Karnataka, India
Tools And Technology
- MS-Excel Advanced (Pivot Tables, Power Query, Automation)
- Power BI & Tableau (Basic)
- MS Power Point
- CRM Tools (SAP / Salesforce)
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Kannada
Proficient (C2)
C2
Marathi
Native
Native
Telugu
Upper Intermediate (B2)
B2
Timeline
MIS
GAP
03.2024 - 02.2026
MIS Coordinator
Levi Strauss (India) Pvt. Ltd.
02.2022 - 03.2024
Data Analyst
Adonis Group
02.2020 - 02.2022
Data Analyst
iLead Infosolution Pvt. Ltd.
04.2018 - 02.2020
Consultant (SCM)
Entercoms Solutions Pvt. Ltd.
10.2015 - 03.2018
MCA - Computer Applications
Bangalore University
BCA - Computer Applications
Gulbarga University
HSC - Science (PCMB)
Maharashtra State Board
SSLC - General Education
Karnataka State Board