Mis And Sales Coordinator

Key Responsibilities

• Prepare and maintain the Dispatchable Pending Report and monitor pending orders from both plants.
• Prepare the Monthly Plan Report HO CBM Wise and track monthly business plans.
• Generate and analyze Commitment vs. Achievement Reports.
• Prepare daily Daywise Order Summary Reports.
• Develop Target vs. Achievement Reports, including summary and detailed analysis.
• Prepare and monitor Monthly Targets for Each Branch.
• Prepare audited budget meeting reports for both plants and share them with the concerned management, including Keyur Sir, every month.
• Prepare and analyze OEM / SCP Reports.
• Generate Realization Reports to monitor sales realization and business performance.
• Prepare One-Pager Management Reports highlighting key business performance indicators.
• Support Yearly Budget Planning, target setting, forecasting, and budget monitoring.
• Coordinate with sales teams, plant teams, and other departments to collect, validate, and consolidate data.
• Ensure data accuracy, timely report submission, and consistency across all MIS reports.
• Analyze deviations between targets, commitments, achievements, and budgets, and highlight key observations to management.
• Develop and improve reporting formats, dashboards, and automated MIS processes.

Required Skills & Qualifications

• Graduate in Commerce, Business Administration, Statistics, Mathematics, or a related field.
• 5–8 years of relevant experience in MIS reporting, preferably in a manufacturing or sales-driven organization.
• Advanced proficiency in MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, data validation, and advanced formulas.
• Strong knowledge of sales MIS, target vs. achievement analysis, budgeting, forecasting, and management reporting.
• Experience in preparing plant-wise, branch-wise, and month-wise reports.
• Knowledge of ERP systems such as SAP will be an added advantage.
• Experience in Power BI or dashboard automation will be an advantage.
• Strong analytical, numerical, and problem-solving skills.
• Good coordination, communication, and time-management skills.
• Ability to handle multiple reports and meet strict reporting deadlines.

Key Competencies

• MIS Reporting and Data Analysis
• Sales Performance Tracking
• Budget Planning and Monitoring
• Target vs. Achievement Analysis
• Order and Dispatch Monitoring
• Advanced Excel and Reporting Automation
• Management Dashboard Preparation
• Data Accuracy and Timely Reporting