Hyundai Autoever — Lead Capturing & SQL Query Optimization
Lead attribute capturing system and SQL query optimization reducing latencies from 3000ms to 50ms at Hyundai Autoever.
60x reduction in database response latency.
Higher data collection for 7,000+ daily enquiries.
Encrypted tables & vehicle service history access.
High database latencies (3000ms) slowed application response times, and key enquiry lead data wasn't captured effectively.
Achieved 60x speedup in query response times (3000ms → 50ms), increased lead data capture by 60% for 7K+ daily enquiries, and supported encryption across 200+ DB tables.
Project description
Refactored enterprise Java backend services to capture detailed lead attributes across 7,000+ daily enquiries, increasing data collection by 60%.
Analyzed database execution plans and optimized complex SQL queries to slash response times from 3000ms to 50ms.
Assisted database encryption migration across 200+ production tables and delivered Kia used car service history lookups for 100,000+ registered vehicles.
Why I built this
Heavy query latencies impacted core application responsiveness and sales teams lacked key enquiry lead attributes.
Delivered high-performance enterprise Java backend infrastructure for major automotive platforms.
Process and execution
How the work moved
- Optimized complex SQL queries and indexing execution plans, dropping response times from 3000ms to 50ms
- Implemented and deployed lead attribute capturing system handling 7,000+ daily customer enquiries
- Assisted in major backend refactoring to support database encryption impacting 200+ production tables
- Delivered service history lookup feature for used car buyers across 100,000+ registered Kia vehicles
What I owned
- Led the work as Associate Consultant - Java Backend Developer.
- Turned messy context into a clearer operating model, interaction direction, and rollout shape.
- Worked across stakeholders to move the project from framing into execution.
Notable decisions
Query plan restructuring & indexing
Redesigned heavy SQL queries and added strategic indexes to slash latency from 3 seconds down to 50 milliseconds.
Attribute capture workflow
Expanded lead telemetry pipelines to boost captured lead data by 60% without adding write overhead.
What I learned from this
Targeted index creation and SQL execution plan analysis can yield 60x performance gains.
Database encryption migrations require careful refactoring across core application layers.