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.
- Positive 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

📌 Mis And Sales Coordinator (Ahmedabad)
🏢 RUSHIL DECOR
📍 Ahmedabad