oracle
Executive - MIS
Samsonite
Mumbai, IND
Full-time
Mid · 5–8 years experience
Onsite
Discovered 2 days ago
excelpower-bisapsqltableau
Key Skills for This Role
excelpower-bisapsqltableau
Full Job Posting
Key Responsibilities
- Sales Performance Monitoring & Reporting
- Prepare daily, weekly, monthly, quarterly, and annual business performance reports.
- Track achievement against budget, target, outlook, and previous year performance.
- Monitor primary sales, secondary sales, tertiary sales, and collection performance.
- Provide branch-wise, territory-wise, state-wise, dealer-wise, and channel-wise analysis.
- Publish daily sales flash reports and management dashboards.
- Highlight gaps against targets along with recovery opportunities.
- Prepare YTD, MTD, QTD, and LY comparison reports.
- Conduct trend analysis and identify business growth or decline patterns.
- Key Deliverables
- Daily Sales MIS
- Weekly Business Review (WBR)
- Monthly Business Review (MBR)
- Zonal Performance Dashboard
- Plan vs Achievement Analysis
- Channel Performance Analytics
- Monitor and analyze performance across all channels including:
- General Trade (GT)
- Modern Trade (MT)
- Institutional Business
- Hypermarket
- LFS Chains
- Franchisee Stores
- Distribution Channel
- Exclusive Brand Outlets (EBO)
- Track channel contribution and profitability.
- Analyze channel growth trends.
- Identify underperforming accounts/channels.
- Monitor channel productivity and business velocity.
- Prepare channel scorecards and ranking reports.
- Track business performance across all branches within the zone.
- Prepare branch scorecards against target.
- Monitor execution of branch outlook commitments.
- Identify branches requiring intervention.
- Conduct variance analysis between forecast and actual achievement.
- Support Zonal Head in branch reviews and performance discussions.
- Branch Ranking Report
- Branch Outlook Accuracy Report
- Recovery Tracking Dashboard
- Branch Productivity Analysis
- Forecast Accuracy
- Outlook Reliability
- Target Coverage Ratio
- Monitor inventory across warehouses, branches, distributors, and key accounts.
- Track stock ageing and liquidation requirements.
- Identify slow-moving and non-moving inventory.
- Monitor stock availability against sales demand.
- Analyze fill rate and service levels.
- Inventory Ageing Report
- Stock Health Dashboard
- Liquidation Tracker
- Fill Rate Analysis
- Ensure accuracy of all business reports.
- Validate sales and inventory data from system.
- Reconcile data discrepancies.
- Maintain master databases.
- Establish reporting SOPs and controls.
- Data cleansing
- Error correction
- System validation
- Business data integrity management
- Create automated dashboards using Power BI, Excel, SQL, or other BI tools.
- Improve reporting efficiency through automation.
- Develop interactive KPI dashboards.
- Reduce manual reporting efforts.
- Power BI
- SQL
- SAP / ERP Systems
- Power Query
- Power Pivot
- VBA (Preferred)
- Business Review Support
- Support Zonal Head during:
- Weekly reviews
- Monthly business reviews
- Quarterly business reviews
- Annual operating plan discussions
- Prepare review decks.
- Generate insights and commentary.
- Highlight risks and opportunities.
- Recommend corrective actions based on data.
Responsibilities
- Branch Performance Management
- Reports
- Key KPIs
- Inventory & Supply Chain Tracking
- Deliverables
- Data Validation & Governance
Responsibilities
- Management Dashboard Development
- Tools
- Advanced Excel
Qualifications
- Graduate in Commerce/Statistics/Mathematics/Economics
- MBA (Preferred)
- Specialization in Analytics, Finance, or Operations preferred
- MIS Executive
- 5-8 years of Sales MIS experience
- MIS Manager
- 5-8 years of experience in Sales Analytics, Business Planning, or Commercial Analytics
- Consumer Durables
- Luggage Industry
- FMCG
- Retail
- Distribution-based businesses
- Advanced Excel
- Pivot Tables
- Power Query
- Power Pivot
- Advanced Formulas
- Dashboards
- Analytics Tools
- Power BI
- SQL
- SAP
- Oracle
- Microsoft Dynamics
- Tally (Basic awareness)
- Behavioural Competencies
- Strong analytical mindset
- High attention to detail
- Business acumen
- Result orientation
- Problem-solving ability
- Presentation skills
- Stakeholder management
- Data storytelling capability
- Ability to work under pressure
- Strong ownership and accountability
- Success Criteria for the Role
- Provide management with actionable business insights rather than only reports.
- Identify emerging risks before they impact achievement.
- Improve forecast and outlook accuracy.
- Drive data-based decision making across branches and channels.
- Create visibility on opportunities, gaps, and recovery actions.
- Continuously automate and enhance reporting processes.
- Become the single source of truth for zonal business performance and analytics.
Experience
- Preferred Industry Experience
Technical Skills
- Advanced Excel
- Pivot Tables
- Power Query
- Power Pivot
- Advanced Formulas
- Dashboards
- Analytics Tools
- Power BI
- Tableau (Preferred)
- SQL
- ERP Knowledge (Preferred)
- SAP
- Oracle
- Microsoft Dynamics
- Tally (Basic awareness)
- Behavioural Competencies
- Strong analytical mindset
- High attention to detail
- Business acumen
- Result orientation
- Problem-solving ability
- Presentation skills
- Stakeholder management
- Data storytelling capability
- Ability to work under pressure
- Strong ownership and accountability
- Success Criteria for the Role
- A successful Zonal MIS professional should:
- Provide management with actionable business insights rather than only reports.
- Identify emerging risks before they impact achievement.
- Improve forecast and outlook accuracy.
- Drive data-based decision making across branches and channels.
- Create visibility on opportunities, gaps, and recovery actions.
- Continuously automate and enhance reporting processes.
- Become the single source of truth for zonal business performance and analytics.
Preferred Qualifications
- MBA (Preferred)
- Specialization in Analytics, Finance, or Operations preferred
- Preferred Industry Experience
- Tableau (Preferred)
- ERP Knowledge (Preferred)
About Samsonite
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Samsonite
Holiday Sales Associate PT 20-29 hours
Sunrise, USA
Discovered YesterdayPart-time
Territory Manager - B2B
Indore, IND
Discovered 2 days agoFull-time
Holiday Sales Associate PT 20-29 hours
Riverhead, USA
Discovered 3 days agoPart-time
Holiday Sales Associate PT under 20 hours
Leesburg, USA
Discovered 3 days agoPart-time
Associate Manager PT 20-29 hours
Garden City, USA
Discovered 3 days agoPart-time
Holiday Sales Associate PT 20-29 hours
Orlando, USA
Discovered 3 days agoPart-time
Holiday Sales Associate PT 20-29 hours
Garden City, USA
Discovered 3 days agoPart-time
Holiday Sales Associate PT 20-29 hours
Boston, USA
Discovered 3 days agoPart-time