Prepare Daily, Weekly & Monthly MIS Reports.
Collect data from different departments/projects and consolidate it.
Maintain and update Excel / Google Sheets databases.
Prepare Dashboard, KPI and Performance Reports for management.
Monitor project-wise and employee-wise performance.
Maintain attendance, salary, employee and operational data.
Perform data validation, reconciliation, and error checking.
Use formulas such as VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, FILTER, QUERY etc.
Create Pivot Tables, Charts and MIS dashboards.
Track pending, completed and target-related activities.
Coordinate with HR, Accounts, Operations and Project Teams for data collection.
Identify discrepancies in data and resolve them with concerned teams.
Maintain proper documentation and records.
Provide ad-hoc reports and analysis whenever required by management.
Ensure reports are submitted accurately and within deadlines.
Maintain confidentiality of employee and company data