Back Office MIS Executive

JOB DESCRIPTION – MIS EXECUTIVE (HOME CINEMA ROOM)

Company Name: AV Core
Job Title: MIS Executive
Department: Sales & Operations
Reporting To: MIS Manager / Operations Manager / Management
Job Location: Baner, Pune

1. Job Summary

We are looking for a detail-oriented and organized MIS Executive to manage company data, prepare reports, monitor sales performance, and maintain accurate records related to home cinema room projects. The candidate will coordinate with the sales, tele calling, technical, installation, and accounts teams to ensure timely reporting, data accuracy, and smooth business operations.

2. Key Responsibilities

1. Prepare daily, weekly, and monthly MIS reports related to sales, leads, customer inquiries, quotations, orders, and project status.

2. Maintain and update customer databases, lead records, sales pipelines, and project information.

3. Track leads generated by tele callers and field sales executives, including follow-ups, appointments, site visits, and conversions.

4. Monitor quotations submitted, orders received, pending approvals, and sales targets.

5. Maintain project-wise records for home cinema installations, including customer details, project value, materials, timelines, and completion status.

6. Coordinate with the sales team to collect daily sales reports and ensure timely submission of information.

7. Prepare Excel reports and dashboards to monitor team performance, sales achievements, lead conversion rates, and pending activities.

8. Maintain records of home cinema products such as projectors, screens, speakers, amplifiers, AV receivers, accessories, and other equipment, as required.

9. Track project delivery schedules, installation progress, pending site visits, and customer commitments in coordination with the concerned teams.

10. Maintain records of purchase orders, stock movement, material dispatches, and deliveries in coordination with the inventory and purchase teams.

11. Identify discrepancies in reports and follow up with the concerned departments for corrections.

12. Prepare management reports and provide accurate data to support business planning and decision-making.

13. Maintain proper documentation of customer orders, quotations, invoices, and project-related records.

14. Ensure data confidentiality, accuracy, and timely updating of company records.

15. Perform other reporting and administrative duties assigned by management.

3. Required Qualifications and Skills

• Graduate in any discipline, preferably B.Com, BBA, BCA, or a related field.

• Prior experience in MIS reporting, data management, sales coordination, or operations reporting is preferred.

• Strong knowledge of Microsoft Excel, including:

  • VLOOKUP/XLOOKUP

  • Pivot Tables

  • IF formulas and SUMIFS

  • Data sorting, filtering, and validation

  • Charts and dashboards

• Basic knowledge of MS Word, PowerPoint, email, and CRM or ERP software.

• Good analytical, numerical, and problem-solving skills.

• High attention to detail and accuracy.

• Strong coordination, communication, and time-management skills.

• Ability to handle multiple reports and meet deadlines.

4. Key Performance Indicators (KPIs)

1. Accuracy and completeness of MIS reports.

2. Timely submission of daily, weekly, and monthly reports.

3. Accuracy of lead, quotation, sales, and project data.

4. Timely updates of sales and project tracking sheets.

5. Accuracy of inventory and material movement records, where applicable.

6. Timely identification and correction of data discrepancies.

7. Quality of dashboards and management reports.

8. Compliance with company documentation and data-management procedures.

5. Daily Reporting Responsibilities

The MIS Executive should maintain and update the following reports:

• Daily Sales Report

• Lead Generation and Follow-up Report

• Tele caller Performance Report

• Field Sales Visit Report

• Customer Inquiry and Conversion Report

• Quotation and Order Tracking Report

• Home Cinema Project Status Report

• Installation and Delivery Tracking Report

• Inventory and Material Tracking Report, where applicable

• Monthly Sales Target vs. Achievement Report

6. Working Conditions

Employment Type: Full-time

Work Mode: Office-based

Working Hours: As per company policy

Salary: As per company policy and candidate experience

Department Coordination: Sales, Tele calling, Technical, Installation, Inventory, Purchase, and Accounts

7. Expected Outcome

The MIS Executive is expected to maintain reliable business data, provide timely and accurate management reports, monitor sales and project progress, improve reporting efficiency, and support the smooth operation and growth of AV Core's home cinema business.

Salary & Benefits

Salary: ₹ 15,000 – ₹ 25,000 per month
Location: Baner, Pune
Working Hours: 10 AM to 7 PM
Working Days: 6 Days (Monday to Saturday)
Employment Type: Full-Time

To Apply: Send your updated CV to hrmavcore@gmail.com or contact 9684023849

• It is a Full Time Back Office / Data Entry job for candidates with 2 - 5 years of experience.