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.