MIS Executive

MIS Executive - Anurag & AmbicaLocation: IDA Uppal, Hyderabad (on-site)Experience: 3–5 years, FMCG mandatoryTimings: Monday to Saturday, 10 AM – 6 PMSalary: ₹30,000 – ₹35,000 per monthProbation: 3 months, confirmed to permanent based on performanceReports to: Sales Head / Management About us Anurag is a Hyderabad-based pooja samagri manufacturer with 25+ years in camphor, kumkum, cotton wicks and puja oil. Our products move through 400+ retailers across India and we ship to export markets. As the distribution footprint grows, we need someone who can keep the numbers clean and current. What you'll doGenerate reports using Tally, SAP/ERP software, Advanced Excel and other reporting toolsPull sales, stock, dispatch and billing data out of Tally and convert it into reports management can act onOwn the daily, weekly and monthly sales MIS — primary and secondary sales, distributor-wise, SKU-wise, region-wiseTrack distributor and retailer stock positions, flag slow-moving SKUs, ageing stock and out-of-stock risks before they cost us salesMaintain dispatch, production and inventory reports in coordination with the plant and warehouse teamsReconcile schemes, discounts, claims and credit notes with the accounts team, tallying back to entries in TallyBuild and maintain sales team performance trackers — beat coverage, target vs achievement, productivityPrepare export order tracking and documentation-linked reportsStandardise how data is entered and exported so one number means one thing across the companyPut together management review decks and month-end summaries with actual analysis, not just tablesRequired qualifications3–5 years of experience as an MIS Executive, preferably in the FMCG industryStrong hands-on Tally — exporting ledgers, stock summaries, item-wise and party-wise sales, and knowing where the data breaksStrong proficiency in SAP, ERP software and Advanced Microsoft ExcelAdvanced Excel skills: pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, charts and dashboards, data validation, conditional formatting, advanced formulas and data analysisKnowledge of sales reporting and FMCG distribution systems — secondary sales, beat plans, primary billing, scheme reconciliationStrong analytical, reporting and organizational skillsExcellent communication and coordination abilities — you'll be chasing data from ASMs, distributors and the plantAbility to work under pressure and meet reporting deadlinesTelugu, Hindi and English preferred, given the distributor and retailer networkAdded advantagePower BI or Google Looker StudioExposure to export documentation and shipment tracking Google Sheets automation / Apps ScriptPrior work in a manufacturing setup, not just a distribution office