1. MIS Reporting

. Prepare daily, weekly, and monthly MIS reports for management.

. Consolidate data from different departments, including Production, Quality,

HR, Stores, Purchase, and Accounts.

Prepare dashboards, summary reports, and performance reports.

2. Data Management

. Collect and verify data from various departments.

. Maintain accurate records in Excel and company ERP systems.

Identify data discrepancies and coordinate with concerned departments for corrections.

- Maintain proper documentation and confidentiality of company data.

3. Excel and Data Analysis

- Use MS Excel formulas, PivotTables, VLOOKUP/XLOOKUP, charts, and conditional formatting.
- Prepare automated reports and dashboards wherever possible.
- Analyse trends, deviations, and performance against targets.

4. Factory Operations Reporting

- Track daily production, rejection, rework, and machine downtime.
- Prepare quality KPI and productivity reports.
- Monitor raw material, finished goods, and inventory reports.
- Support the preparation of dispatch, purchase,



and material consumption reports.

5. Customer Invoicing

- Prepare and generate customer invoices, bills, and credit notes.
- Verify sales orders, purchase orders, and supporting documents before billing.
- Maintain accurate billing records and update data in the billing system.
- Monitor outstanding payments and follow up with customers when required.
- Prepare daily, weekly, and monthly billing reports.
- Handle customer queries related to invoices, billing corrections, and payment details.

6. Coordination and Follow-up

- Follow up with departments for timely submission of data.
- Ensure reports are submitted within defined deadlines.
- Assist management in reviewing operational performance and identifying improvement areas.

7. Process Improvement

- Develop standard reporting formats and templates.
- Reduce manual data entry and reporting errors.
- Support internal audits and management review meetings.

📌 MIS / Back Office Operations (Gurugram)
🏢 ALOK INTERNATIONAL
📍 Gurugram