Introduction
El-Cheapo is a comprehensive Customer Relationship Management (CRM) and service management platform designed to streamline locksmith and automotive key services, vehicle lookup, and airport/car parking solutions. The platform manages dynamic workflows, complex quote calculations, and client operations to deliver fast, reliable, and automated services.
About the Client
The client operates in the automotive and locksmith service industry, providing key services, lock replacements, car unlocking, and parking services.
- Key Offerings: Locksmith services, vehicle key duplication and replacement, car unlocking, and parking service management.
- Operational Scope: Dynamic state/location-based service rules (e.g., specific workflows for areas like New Jersey), dynamic vehicle key identification, model/make queries, and pre-configured pricing structures.
Business Impact
- Rapid Delivery: Delivered and launched the full platform in a lean 3-month timeline through decoupled micro-services and serverless infrastructure.
- Revenue & Growth: Supported scale expansion from 10 million to 24 million operations/records effortlessly while maintaining system stability and low maintenance costs.
- Improved Accuracy: Reduced pricing and calculation errors on dynamic fields, ensuring accurate automated quotes for locksmith and key configurations.
- Operational Efficiency: Enabled real-time driver license scanning and multi-user data synchronization, drastically reducing manual data entry for operators.
Challenges
- Database Architecture & Schema Optimization The existing database architecture suffered from bottlenecks, structural limitations, and performance degradation at scale. Data collections needed restructuring and indexing to reduce redundancy and handle millions of records efficiently.
- Dynamic Form Handling & Calculation Accuracy Customer and internal CRM forms required complex, multi-layered dependencies based on vehicle make, model, key types, and pre-configured pricing logic. Restructuring field-level dependencies and dynamic workflows was critical to maintaining accuracy across dynamic web interactions.
- Asynchronous Execution & Event Loop Bug Resolution Addressing complex race conditions and asynchronous execution timing was crucial. Resolving JavaScript event loop issues was necessary to prevent execution-order conflicts during fast user interactions.
- Third-Party US Driving License Scanner Integration Integrating an external US Driving License Scanner involved handling complex API requests, managing vendor workflows, and processing intricate payload structures reliably in real time.
- Real-Time Form Synchronization & Conflict Resolution Maintaining real-time synchronization of form data across multiple internal operators caused concurrent update conflicts. A responsive conflict-resolution strategy was required to maintain data integrity.
Metrics
| Phase / Metric | Implementation / Solution | After Solution |
| Development Timeline | Optimized architecture & agile delivery | Completed in 3 months |
| Data / Record Capacity | Restructured schema & optimized indexing | Scalable up to 24 Million+ records (up from 10 million) |
| Database Architecture | Divided main connection into smaller modular parts | Reduced maintenance workload & higher throughput |
| Verification Speed | Third-party US Driving License Scanner API integration | Instant automated scanning & form population |
| Calculation Integrity | Dynamic lookup engine with pre-configured pricing | 100% calculation accuracy across dynamic web forms |
Tech Stack
- Frontend: Vue.js
- Backend: Node.js
- Serverless Infrastructure: Firebase (Authentication, Realtime DB / Firestore, Serverless Functions)
- Integrations: US Driving License Scanner API
- Team Structure:
- 1 Business Analyst (BA)
- 1 Quality Assurance (QA)
- 1 Developer (Vue.js + Node.js)
Our Approach
- Modularizing Database & Indexing: We resolved main database connection bottlenecks by indexing collections and dividing broad data structures into smaller, modular components. This reduced maintenance complexity while boosting throughput.
- Dynamic Logic & Dynamic Form Engine: We built a rule-based calculation engine in Vue.js and Node.js that checks vehicle make, model, key type, and state-specific logic (e.g., New Jersey dynamic workflows) against pre-configured pricing matrices instantly.
- Event-Loop & Async Optimization: We refactored asynchronous code pathways in Node.js, resolving event loop timing issues to guarantee predictable data updates under concurrent access.
- Seamless Third-Party API Integration: We abstracted the third-party US Driving License Scanner workflow behind clean micro-services, ensuring robust parsing of license payloads and error handling.
- Real-Time Firebase Synchronization: Leveraging serverless Firebase capabilities, we implemented optimistic UI updates paired with server-side conflict resolution, ensuring real-time multi-user synchronization.
Conclusion
By restructuring the underlying architecture and adopting a serverless model with Firebase, Vue.js, and Node.js, the team successfully delivered a high-performing, scalable CRM platform within 3 months. The solution smoothly expanded capacity from 10 million to 24 million records, eliminated dynamic calculation errors, and provided seamless automated driver license verification for daily operations.
