Electronic Data Processing Executive

Position

EDP Executive

Department

EDP

Location

Ranchi

Industry - Automobile Industry

Reporting To

EDP Incharge

Experience

1–3 years preferred in Automobile Dealership \& Maruti Suzuki environment

Qualification

Graduate; preferably BCA, B.Com, BBA, or equivalent

Computer Skills: MS Excel (Vlookup, Hlookup, Pivot Table, strong command in using formulas), MS Word, Internet, Email, knowledge of dealership DMS preferred

Job Purpose

To manage the dealership's Electronic Data Processing, MIS, system entries, data accuracy and reporting, ensuring that all departmental data is updated correctly and reports are generated and submitted within the required timelines.

Key Responsibilities

A. Data Entry \& System Management

• Enter and update daily dealership data in the relevant DMS/ERP/software systems.
• Ensure accurate and timely entry of Sales, Service, Parts, Customer and other operational data.
• Verify system entries against physical documents and departmental records.
• Maintain data accuracy and avoid duplicate or incorrect entries.
• Update customer and vehicle-related information in the system.
• Ensure proper documentation and filing of system-generated reports.

B. MIS \& Reporting

• Prepare daily, weekly and monthly MIS reports.
• Prepare department-wise performance reports as required by management.
• Generate reports relating to
• Vehicle Sales
• Retail \& Wholesale
• Enquiries \& Leads
• Test Drives
• Bookings
• Deliveries
• Insurance
• Service RO
• Customer visits
• Workshop performance
• Parts
• Pending cases
• Stock and inventory
• Consolidate data received from different departments and present it in the required format.
• Submit reports within defined timelines.

C. Sales Department Support

• Maintain and update Sales-related data in the system.
• Track enquiry, booking, retail and delivery data.
• Reconcile Sales data between DMS and physical records.
• Prepare pending delivery and booking reports.
• Assist the Sales Team with required system reports and data.

D. Service Department Support

• Maintain Service-related system data.
• Generate reports relating to
• Repair Orders
• Paid/Free Services
• Repeat Repairs
• Customer Retention
• Service Follow-up
• Pending ROs
• Coordinate with Service Advisors and CRM for data corrections and updates.

E. CRM \& Customer Data

• Ensure customer information is correctly captured and updated.
• Support CRM team in generating customer databases and follow-up reports.
• Provide data for customer retention and campaign activities.
• Maintain confidentiality of customer information.

F. Data Accuracy \& Reconciliation

• Cross-check system data with invoices, job cards, delivery documents and other source documents.
• Identify discrepancies and coordinate with the concerned department for correction.
• Maintain proper records of corrections and amendments.
• Ensure that management reports are based on accurate data.

G. Excel \& Analytical Work

• Prepare Excel-based MIS and dashboards.
• Use formulas such as SUM, COUNTIF, SUMIF, VLOOKUP/XLOOKUP, IF, Pivot Tables etc.
• Analyse departmental data and highlight major variations.
• Maintain monthly comparison reports.
• Assist management in extracting relevant information from large datasets.

H. Management Support

• Provide data and reports to GM/management as required.
• Handle urgent data requirements from management.
• Maintain confidentiality of business and employee information.
• Assist in audits and management reviews by providing required records.

Daily Responsibilities

• Check system status and pending entries.
• Collect daily data from Sales, Service, Parts and other departments.
• Complete required system entries.
• Verify data accuracy.
• Prepare daily MIS.
• Highlight pending/incorrect entries to concerned department.
• Share required reports with management.
• Maintain proper backup and filing of important reports.

Key Performance Indicators – KPI

KPI

Measurement

Data Accuracy

% accuracy of system entries

Timeliness

Reports submitted within defined timelines

MIS Accuracy

Error-free reports

Data Reconciliation

Timely closure of discrepancies

System Compliance

Completion of required system entries

Report Quality

Correct and useful MIS

Pending Data

Minimum pending entries

Support

Response time to departmental data requirements

Skills Required

• Strong knowledge of MS Excel
• Good numerical and analytical ability
• Data management skills
• Attention to detail
• Good communication skills
• Ability to work under deadlines
• Ability to maintain confidentiality
• Knowledge of automobile dealership operations
• Knowledge of DMS/ERP systems preferred
• Good coordination with Sales, Service, Parts, Accounts and CRM teams

Pay

₹25,000.00 - ₹32,000.00 per month

Benefits

• Cell phone reimbursement
• Provident Fund

Work Location

In person