15 Nov
|
GreenPack India
|
Varanasi
15 Nov
GreenPack India
Varanasi
Position Summary
Designation
MIS Executive
Company
GreenPack (paper packaging manufacturing)
Department
MIS / Operations
Reports to
Plant Head
Location
Rajatalab factory, Varanasi; travel to other branch (Ahmedabad) offices and factories if required
Working hours
09:30 AM – 07:00 PM
Working days
6 days (Mon - Sat)
Experience
2–4 years in MIS, data reporting or ERP support, preferably in manufacturing
Qualification
Graduate (B.Com / BCA / B.Sc IT or equivalent); PGDCA / MBA (Systems or Operations) preferred
CTC range
2,00,000/- lpa to 2,60,000/- lpa
Role Purpose The MIS Executive owns the company's operational data and reporting. He/she will produce accurate, on-time reports from the ERP and the in-house CRM / Follow-up Management System, act as the single point of contact between internal users and software vendors, and make sure every new system requirement is properly documented, tested and adopted.
Key Responsibilities****1. MIS Reporting and Analysis
- Generate daily, weekly and monthly reports from ERP data and the CRM / Follow-up Management System (sales, production, dispatch, inventory, purchase, debtors, follow-up status, etc.).
- Build and maintain reports and trackers in Google Sheets and Excel using formulas, Pivot Tables, lookups (VLOOKUP / XLOOKUP / INDEX-MATCH), QUERY, conditional formatting and data validation.
- Maintain a fixed MIS calendar: which report goes to whom, by what time, on which day.
- Cross-check report figures against source data and flag mismatches, missing entries or unusual trends to the concerned department head.
- Prepare summaries and presentations for management reviews.
2. ERP and Follow-up Management System Handling
- Handle day-to-day operation of the customised ERP and the Follow-up Management software.
- Maintain master data (customers, items, vendors, users) and ensure entries are complete and consistent.
- Manage user IDs, roles and access rights as approved by management.
- Monitor whether teams are entering data on time and follow up on pending or incorrect entries.
3. Vendor Coordination and Issue Resolution
- Act as the single point of contact with the ERP and Follow-up Management software vendors.
- Log every issue in an issue tracker (date raised, description, priority, vendor response, date resolved) and follow up until closure.
- Escalate issues that are delayed or repeated to management with the facts.
- Track vendor turnaround time and service quality.
4. Requirement Documentation and SOPs
- Collect and understand new requirements or changes from internal departments.
- Write clear requirement documents and SOPs for vendors for any new development, module, report or change in the ERP / Follow-up Management System.
- Test recent developments before they go live (user acceptance testing) and confirm they work as specified.
- Prepare user SOPs and short guides for internal teams after each change, and keep all documentation version-controlled.
5. IT Coordination and User Support
- Coordinate with the IT department on issues faced by ERP vendors (server, network, remote access, etc.).
- Coordinate with IT on issues faced by team members in accessing the ERP / Follow-up Management Systems.
- Provide first-level support and training to users at all locations, including new joiners.
6. Automation (Google Apps Script)
- Write and maintain basic Google Apps Script code to automate repetitive work in Google Sheets: auto-reports, scheduled emails, data imports, reminders and simple form-based workflows.
- Document every script (what it does, which sheet it uses, who owns it) so it can be maintained by others.
7. Data Security and Control
- Keep company data confidential; share reports only with authorised persons.
- Ensure regular backups of key Google Sheets, Excel files and reports, and verify that ERP backups are taken as agreed with the vendor / IT.
- Maintain access logs and remove access promptly when employees leave or change roles.
8. Travel and Multi-location Support
- Travel to other branch offices and factories as and when required for system rollout, training, audits of data entry, and issue resolution.
9. AI-enabled Productivity
- Identify repetitive reporting, data-entry checks and follow-up tasks that can be automated with AI tools, and implement them after management approval.
- Maintain a library of tested prompts and templates for recurring reports, summaries and SOP drafts.
- Set up and maintain simple internal AI assistants (e.g., ChatGPT Custom GPTs, Gemini Gems or Claude Projects) loaded with company SOPs and ERP user guides, so team members can get answers to routine “how do I…” questions.
- Follow the company's AI usage policy and make sure no confidential data is shared with unapproved AI tools.
Required Skills****Must Have
- Advanced Google Sheets and MS Excel:
formulas, Pivot Tables, lookups, QUERY / IMPORTRANGE, charts, data validation.
- MS Word for SOPs, requirement documents and reports.
- Experience handling customised ERP software and generating reports from it.
- Basic Google Apps Script coding.
- Ability to write clear SOPs and requirement documents for software vendors.
- Good written and spoken communication in English and Hindi.
Preferred
- Basic working knowledge of Tally (Tally Prime).
- Dashboard tools such as Looker Studio or Power BI.
- Experience in a manufacturing or packaging company.
- Basic understanding of sales, production, inventory and accounts processes.
AI Skills (Beyond Chatting with AI)
- AI inside spreadsheets: uses Gemini in Google Sheets and Copilot in Excel to build formulas, clean data, categorise entries and summarise large datasets.
- AI-assisted coding: uses AI to write, explain and debug Google Apps Script and complex formulas, and tests the output before using it on live data.
- Structured prompting: writes prompts that return output in a fixed format (tables, CSV, JSON) so results can go straight into sheets or reports.
- Document processing with AI: extracts data from PDFs, invoices, purchase orders and scanned documents using AI / OCR tools, and summarises meeting recordings and transcripts into action points.
- No-code automation: basic working knowledge of workflow tools (Google Workspace automations, Zapier, Make or Power Automate) to connect forms, sheets, email and AI steps.
- AI via API (basic): understands how to call an AI model from Google Apps Script using an API key, for tasks such as auto-categorising follow-up remarks or drafting reminder emails.
- AI-assisted analysis: uses AI to spot trends, outliers and mismatches in MIS data and to draft short commentary for management reports.
- Verification and data safety: checks every AI output against source data, knows that AI can be confidently wrong, and keeps customer, pricing and financial data out of public AI tools.
Personal Attributes
- High attention to detail and accuracy with numbers.
- Process-oriented and disciplined about deadlines.
- Persistent in follow-up with vendors and internal teams.
- Able to explain technical issues in simple language to non-technical users.
- Maintains confidentiality.
- Willing to travel.
Additional Information
- Candidates must have a laptop-friendly setup and be comfortable working across Google Workspace and Microsoft Office.
- Own two-wheeler
- Probation period 06 months and notice period 01 month
📌 MIS Executive (Varanasi)
🏢 GreenPack India
📍 Varanasi