Mis Executive

MIS Executive (App Script Expert)

Key Responsibilities:

• Develop, manage, and automate Google Sheets-based systems for tracking production, sales, inventory, and performance metrics.
• Write, debug, and maintain Google Apps Script to automate reports, alerts, and dashboards.
• Build custom forms, validation workflows, and data sync processes between multiple Google Sheets.
• Prepare daily, weekly, and monthly MIS reports for management with clear visualizations and KPIs.
• Maintain data accuracy, perform error checks, and ensure real-time updates across systems.
• Coordinate with departments to gather requirements and deliver automation solutions.
• Train internal teams on usage and upkeep of Google Sheets-based systems.
• Design, develop, and maintain reports and dashboards using tools like Advanced Excel and google sheets.
• Collect, validate, and process large volumes of data from various departments and systems.
• Analyse trends and prepare business reports (daily, weekly, monthly) for senior management.
• Ensure data integrity, accuracy, and security within the MIS.
• Automate routine reporting processes to enhance efficiency.
• Troubleshoot and resolve data/reporting issues in a timely manner.

Key Skills & Qualifications:

• Bachelors degree in Computer Science, Information Systems, Business Administration, or a related field.
• 0.52 years of experience in MIS, data analysis, sheet automation or reporting roles.
• Proficiency in

  MS Excel (VLOOKUP, Pivot Tables, Macros)

  and other MS Office tools.
• Experience with

  Javascript and Appscript

• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Attention to detail and ability to work under tight deadlines.