Job highlights

- 1-2 years as MIS Executive in manufacturing with advanced Excel, Google Sheets, Tally integration, AI tools, and FMS proficiency
- Integrate and analyze financial data, automate reporting, design Google Forms, manage Flow Management Systems, and prepare MIS reports

Location: Factory Site (Candidate must reside within a 45-minute travel radius) Industry: Transformer Manufacturing / Electrical Equipment Manufacturing

Experience: 1 to 2 Years

Employment Type: Full-Time

Job Overview

We are seeking an analytical, detail-oriented MIS Executive with 12 years of experience in a manufacturing environment. The ideal candidate will be proficient in Advanced Excel, Google Sheets, AI tools, and data automation, with hands-on experience integrating Tally data into spreadsheets to perform financial, production, and profitability calculations. You will also design Google Forms and set up Flow Management Systems (FMS) to streamline cross-departmental operations.

Key Responsibilities & Essential Functions

1. Data Integration & Financial/Profitability Analysis

- Import, clean, and consolidate financial and transactional data from Tally Prime / ERP into Advanced Excel and Google Sheets.
- Calculate product-wise and batch-wise profit margins, contribution margins, and cost variances for transformer production.
- Analyze Raw Material vs. Finished Goods consumption (e.g., copper, core material, transformer oil, steel) to track material yield and wastage.
- Maintain monthly P&L; trackers, cost-sheet analysis, and overhead distribution reports for management decision-making.

2. Advanced Excel, Google Sheets & AI Automation

- Build and manage dynamic dashboards using complex formulas (XLOOKUP, INDEX-MATCH, SUMIFS, nested logic statements, Array Formulas, and Query functions).
- Automate data workflows using Google Apps Script, Excel VBA/Macros, and AI tools (ChatGPT, Gemini,



Power Automate) to reduce manual reporting time.
- Standardize reporting formats across departments (Sales, Procurement, Production, Quality, and Stores).

3. Form Creation, Workflow Management & FMS

- Design and deploy Google Forms to capture shop-floor data, inspection reports, raw material receipts, and daily shift output.
- Set up and maintain Flow Management Systems (FMS) to track process pipelines, pending tasks, lead times, and dispatch schedules.
- Trigger automated email/WhatsApp alerts or status notifications using linked Google Apps Script triggers.

4. Daily, Weekly & Monthly Reporting (MIS)

- Prepare Daily Production Reports (DPR), Inventory Valuation Reports, and Reorder Level (ROL) trackers.
- Monitor Accounts Receivable/Payable aging reports and maintain cash flow monitoring spreadsheets.
- Generate variance analysis reports comparing budgeted metrics against actual shop-floor performance.

Candidate Requirements & Qualifications

- Experience: 1 to 2 years of hands-on experience as an MIS Executive or Data Analyst, preferably in a manufacturing unit.
- Proximity Constraint: Must reside within a 45-minute commute radius of the factory location.

- Technical Skills:
- Spreadsheets: Advanced Excel (Pivot Tables, Power Query, Macros/VBA) & Google Sheets (QUERY, IMPORTRANGE, Apps Script).
- Accounting System: Working knowledge of extracting/exporting reports and raw data from Tally.
- AI & Up-to-date Tools: Familiarity with AI tools for formula creation, script writing, and process automation.
- Process Tools: Proficiency in Google Forms, Google Drive structure, and FMS methodology.
- Educational Background: Bachelors degree in Commerce (B.Com), Business Administration (BBA), Statistics, Computer Applications (BCA), or related field.
- Soft Skills: Strong logical reasoning, numerical accuracy, and effective cross-departmental communication skills.

📌 MIS Executive (Bhopal)
🏢 Western Electrical Unit No 2
📍 Bhopal