Enterprise Analytics / Vision Quality Control
Customer Quality Claim, Warranty & Complaint Analytics System
Client Name
Iljin Automotives
Problem Statement
Customer complaint analysis, audits, and production vision quality data needed connected digital workflows across multiple PLC platforms.
SOLUTION PROVIDED BY NAPEANS TECHNOLOGIES
- Built a centralized Windows On-Premise and SQL Server (SSMS) role-based web platform for Super Admin, QC Admin, and QC User accounts.
- Managed Customer Complaints, Repair/Warranty Claims (QS), and Design-Related Entries (DRE Live Cases and Weekly Reports).
- Developed an automated Customer Excel Column-Mapping & Harmonization Engine to convert proprietary OEM columns into a standardized Master Repair Schema.
- Added 10-day draft SLA email alerts and interactive OEM PPM and Warranty trend dashboards for Hyundai, Kia, Tata Motors, M&M, and MG.
- Enabled PNG/JPEG chart exports and full-page PDF reports.
- Integrated shop-floor Basler/Cognex vision QC and traceability with Mitsubishi, Siemens, and Omron PLCs.