Executive - MIS

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)

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.

• 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

• 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

• 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

• 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

SAP / ERP Systems

VBA (Preferred)

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