Job Overview
Responsible for managing project data, preparing MIS reports, monitoring project KPIs, developing dashboards, and providing actionable insights to management. The role involves coordinating with cross-functional teams, maintaining data accuracy, tracking project progress, and identifying risks and operational bottlenecks.
Key Roles and Responsibilities
1. MIS Reporting and Data Management
- Prepare and maintain daily, weekly, monthly, and quarterly MIS reports for management reviews.
- Collect, consolidate, validate, and analyze data from multiple departments to ensure accuracy and consistency.
- Maintain project trackers, operational reports, and centralized databases for effective monitoring and decision-making.
- Track key performance indicators (KPIs), identify performance gaps, and highlight deviations from planned targets.
- Ensure timely submission of reports in accordance with business requirements and reporting deadlines.
2. Dashboard Creation and Data Analysis
- Develop and maintain interactive dashboards using Microsoft Excel, Power BI.
- Use advanced Excel functions, including Pivot Tables, VLOOKUP, XLOOKUP, conditional formatting, and data validation.
- Analyze operational and project data to identify trends, delays, bottlenecks, and improvement opportunities.
- Present key business insights and performance metrics through visual reports and dashboards.
- Automate repetitive reporting activities wherever possible to improve efficiency and reduce manual errors.
- Specified processes for maintaining project documentation, managing scopes and adjusting work schedules for on-time delivery of tasks and milestones.