MIS Executive

B.Com / BBA / MBA / BCA with 1–4 years in MIS, analytics, or reportingAdvanced Excel mandatory: VLOOKUP, HLOOKUP, Pivot Tables, IF conditions, Charts, Power QueryExperience with Tally, SAP, or ERP data extraction

Data Management: Collect data from ERP, Tally, SAP, CRM, and other sources. Ensure data accuracy and consistencyReport Generation: Prepare daily, weekly, and monthly MIS reports on sales, production, inventory, debtors, creditors, and expensesDashboards: Build and maintain Excel dashboards, pivot tables, and charts for management reviewKPI Tracking: Monitor business KPIs like revenue, margins, TAT, rejection %, and order fulfillment. Highlight variances and trendsAutomation: Automate recurring reports using advanced Excel, macros, or Power Query to reduce manual workAnalysis: Analyze data to identify patterns, bottlenecks, and opportunities. Provide insights, not just numbersCoordination: Liaise with sales, accounts, production, and logistics teams for timely data and clarificationPresentations: Create PPTs for monthly review meetings with graphs and key takeawaysAd-hoc Reporting: Handle urgent data requests from HODs and management within TATDatabase Maintenance: Maintain master data, price lists, and customer/vendor databases.