Executive - MIS

Key Responsibilities

1. 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

2. 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)

Responsibilities

• 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.

3. Branch Performance Management

• 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.

Reports

• Branch Ranking Report
• Branch Outlook Accuracy Report
• Recovery Tracking Dashboard
• Branch Productivity Analysis

Key KPIs

• Forecast Accuracy
• Outlook Reliability
• Target Coverage Ratio

4. Inventory & Supply Chain Tracking

• 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.

Deliverables

• Inventory Ageing Report
• Stock Health Dashboard
• Liquidation Tracker
• Fill Rate Analysis

5. Data Validation & Governance

• Ensure accuracy of all business reports.
• Validate sales and inventory data from system.
• Reconcile data discrepancies.
• Maintain master databases.
• Establish reporting SOPs and controls.

Responsibilities

• Data cleansing
• Error correction
• System validation
• Business data integrity management

6. Management Dashboard Development

• 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.

Tools

• Advanced Excel
• Power BI
• SQL
• SAP / ERP Systems
• Power Query
• Power Pivot
• VBA (Preferred)

7. Business Review Support

Support Zonal Head during:

• Weekly reviews
• Monthly business reviews
• Quarterly business reviews
• Annual operating plan discussions

Responsibilities

• Prepare review decks.
• Generate insights and commentary.
• Highlight risks and opportunities.
• Recommend corrective actions based on data.

• Graduate in Commerce/Statistics/Mathematics/Economics
• MBA (Preferred)
• Specialization in Analytics, Finance, or Operations preferred

Experience

MIS Executive

• 5-8 years of Sales MIS experience

MIS Manager

• 5-8 years of experience in Sales Analytics, Business Planning, or Commercial Analytics

Preferred Industry Experience

• Consumer Durables
• Luggage Industry
• FMCG
• Retail
• Distribution-based businesses

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.