Location: Matunga
Company: Studio5 Design
Employment Type: Full-Time
The MIS Executive will be responsible for maintaining and managing data, preparing reports, and ensuring smooth functioning of various management information systems. The role requires strong Excel expertise, data handling skills, and experience working with operational systems like FMS, IMS, and PMS.
Collect data from various departments and systems
Clean, verify, and organize data for accuracy
Interpret data to support operations and management decisions
Analyze data to generate meaningful insights and summaries
Prepare daily/weekly/monthly MIS reports
Create and maintain dashboards, trackers, and performance sheets
Work on checklists and task delegation sheets for management
Ensure timely and accurate updates of all MIS-related documents
SUM, SUMIF, COUNTIF, COUNTIFS
MAX, MIN
VLOOKUP, HLOOKUP, XLOOKUP
DATE & TIME formulas
Pivot Tables
Charts (Bar, Line, Pie, etc.)
Advanced Excel functions
Macros & VBA
Conditional Formatting
Data Validation
Power Query
Power Pivot
Excel Dashboard development
Google Sheets & Google Docs
FMS (Fleet Management Systems)
IMS (Inventory Management Systems)
PMS (Project Management Systems)
Checklists & report formats
Delegation and task distribution management
Strong analytical and MIS reporting skills
High proficiency in Excel and Google Workspace
Knowledge of operational systems (FMS / IMS / PMS)
Detail-oriented, organized, and efficient
Good communication and coordination abilities