Overview
We are looking for an experienced MIS Executive with strong expertise in Advanced Excel, VBA, and Macro Automation. The candidate will be responsible for handling and analyzing Sales, Service, Inventory, and Management data, preparing MIS reports, and automating reporting processes to improve efficiency and accuracy.
Required Skills
Advanced Excel, Excel Macros (VBA), MIS Reporting, Data Analysis, Pivot Tables, VLOOKUP/XLOOKUP, Dashboard Creation, Data Validation, CRM Tools, Attention to Detail, Time Management, Problem-Solving Skills, Process Automation, Coordination Skills
Detailed Description
Role & responsibilities :
- Prepare and maintain daily, weekly, and monthly MIS reports for Sales, Service, Inventory, Logistics, and Management.
- Develop automated reports, trackers, dashboards, and templates using VBA and Macros.
- Handle large volumes of data and ensure accuracy, consistency, and timely reporting.
- Perform data analysis using Advanced Excel, Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, and Conditional Formatting.
- Consolidate data from multiple departments and prepare management reports.
- Track and monitor sales performance, service data, inventory, stock movement, logistics, pending reports, and targets/achievements.
- Coordinate with Sales, Service, Warehouse, Logistics, and other teams to collect and validate data.
- Identify data discrepancies and ensure timely correction.
- Automate repetitive MIS processes and improve reporting efficiency.
- Prepare customized reports and dashboards as required by management.
Preferred candidate profile :
- 2 - 5 years of relevant experience in MIS, Reporting, Business Operations, Sales MIS, or Service MIS
- VBA & Macro Automation experience is mandatory.
- Hindi, Tamil, and English language proficiency is mandatory.
