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.