Mis Executive

Job Description

Job Title: - MIS Executive Location:- Ahmedabad Workdays:- 6 Days Experience:- 3+ years Primary Purpose: We are looking for the MIS Executive To ensure accurate, timely, and insightful reporting across all sales channels and trade operations, supporting decision-making, forecasting, compliance, and performance monitoring in the dairy business. KRAs, Brief Descriptions, and Responsibilities: 1: Sales Reporting & Analysis Brief: Generate and analyze sales reports by product, geography, team, and customer segment to support daily decision-making and performance tracking. Roles & Responsibilities: Extract and compile daily, weekly, and monthly sales data from the sales app or CRM tools. Generate reports by SKU, zone, ASM, SO, SS, distributor, retailer, etc. Analyze achievement vs. target across segments. Identify sales trends, gaps, and provide actionable summaries. Support senior management in sales review dashboards. 2: Modern Trade, HoReCa, B2B, ECom Sales MIS Brief: Maintain accurate and periodic sales reports for alternate channels like Modern Trade, HoReCa, B2B, and E-commerce. Roles & Responsibilities: Track primary and secondary sales by format/channel. Consolidate outlet-wise performance data for modern trade chains. Maintain HoReCa, B2B key customer performance summary. Coordinate with the respective teams for data accuracy. Present weekly summaries for each vertical to management. 3: Outstanding & Receivables Reporting Brief: Provide daily updates on distributor and customer outstanding to aid credit management and sales collections. Roles & Responsibilities: Generate and share daily outstanding and receivables reports. Match sales ledger with finance records to ensure accuracy. Highlight overdue accounts and alert the sales team. Coordinate with accounts/finance for reconciliation queries. Maintain region- and partner-wise AR aging summary. 4: Sales Promotion, POS & Social Media Reports Brief: Track deployment and effectiveness of sales promotions, POS materials, and digital campaigns. Roles & Responsibilities: Maintain POS material inventory and usage report. Track scheme-wise sales impact and consumption. Prepare zone-wise promotion activity summaries. Coordinate with marketing for digital/social post data. Maintain campaign-wise lead or sales conversion reports. 5: Stock Reporting (SS, Distributors, Retailers) Brief: Maintain weekly inventory levels at trade partner locations to aid demand planning and replenishment. Roles & Responsibilities: Collect and compile stock data from SS, Distributors, and key retailers. Validate inventory levels against secondary sales. Identify slow-moving or overstocked SKUs. Prepare channel-wise inventory heatmaps. Share reports with supply chain and sales managers. 6: Credit Note & Scheme Management Brief: Ensure accurate credit note reporting and timely circulation of trade schemes. Roles & Responsibilities: Track issued credit notes and maintain summary reports. Validate scheme-wise distributor eligibility and claims. Prepare monthly credit note usage dashboards. Circulate scheme circulars to all stakeholders. Archive scheme approvals, claim records, and usage audit data. 7: Demand Forecasting Support Brief: Provide accurate and forward-looking sales data to support plant-level production and dispatch planning. Roles & Responsibilities: Collect market forecast from sales team by 5th of each month. Prepare consolidated demand sheet SKU-wise and zone-wise. Share the sheet with the plant 10 days before month end. Analyze past sales and trends to guide demand planning. Coordinate with plant if revisions are required. 8: Order & Rate List Management Brief: Ensure accuracy in sales order entries, product rates, and timely circulation of rate changes. Roles & Responsibilities: Enter orders into ERP with 100% SKU accuracy. Maintain latest rate cards and update in system and circulation. Communicate pricing changes to sales, accounts, and plant. Assist in margin structure preparation. Verify invoice values against order and rate list. 9: TA/DA & Expense Reports Brief: Maintain accurate travel/expense records of sales team and flag discrepancies. Roles & Responsibilities: Collect TA/DA claims of sales team. Prepare summary and validate entries as per policies. Highlight anomalies to HR/accounts. Maintain monthly expense trend summaries. Ensure timely reporting for reimbursement processing. 10: Trade Partner Documentation (KYC/Legal) Brief: Maintain legal and KYC documentation for all SS and Distributors as per compliance norms. Roles & Responsibilities: Maintain KYC records (GST, PAN, bank, Aadhar) for all partners.