Aftermarket Solution Development

TecAlliance is the leading expert for data management and processes in the automotive aftermarket. In addition to up-to-date vehicle and spare parts data in the globally renowned TecDoc Catalogue, the portfolio includes comprehensive repair and maintenance information as well as solutions and consulting services for e-commerce and fleet management.

As a part of the digital transformation inside TecAlliance, they decided to replace the existing data warehouse software with a new solution based on modern technologies. Sigma Software’s specialists were engaged to reinforce the TecAlliance’s development team and support the company with consulting in Cloud and Big Data. Our experts worked hand-in-hand with the Client’s team across various product lines:

• Data Processing team delivers solutions for data lake building, including those to combine / aggregate large data amounts from various source files into company’s standard, transform raw data into a predefined object schema with providing the unified format for data consumption
• TecWeb team develops additional modules for the B2B marketplace automating the bad batch return processes and generating the vendor rating for end clients (with detailed information regarding shipment, pricing, quality, etc.)
• Data Distribution team provides development and integration of the brand data storage for internal TecAlliance products
• Migration team covers full-scale migration of all services from on-premises to AWS Cloud, including initial discovery phase, implementation, staging environment testing, final migration, cutover, and post-migration support.

Following the TecAlliance’s vision for an agile, future-ready ecosystem, we took over dual data center migration covering 240 servers & DBs, 100 apps, and 10M+ files. We have already migrated the first data center from on-premises to AWS Cloud, tailoring each app’s migration plan to their architecture and business priorities.

The prior monolithic setup had limited scalability and relied on manual resource allocation. We split key workloads into containerized services on Amazon ECS and used Terraform for IaC, ensuring better scalability & governance. The new platform rapidly adapts to shifting workloads and leaves room for innovation:

• 90% process automation across the system, reducing bus factor risk to zero and improving performance, maintainability, and scalability
• Horizontal auto-scaling for containerized workloads ensuring stable performance during peak demand
• Lower Data Center services maintenance and support costs due to retirement of 25% outdated components
• Automated backups and defined recovery processes for Amazon ECS workloads.

The Client wanted to create a robust data platform that would eliminate manual refills, easily process significant data volumes, and safeguard data consistency & accuracy. They also wanted to achieve full cloud adoption to ensure higher performance and lower efforts for aftermarket platform maintenance.

We helped the Client to design and develop a solution that addresses TecAlliance business needs in full, support both vertical & horizontal scaling, and is capable of handling 200+ requests a second (e.g. a complex selection within a database requiring about 35 massive data dictionaries to be processed) from different end-customers.

• Safeguarded easy and cost-efficient maintenance with true serverless architecture taking the most out of the services AWS provides out-of-the-box (e.g. AWS Lambda for data collection, preparation & insertion; AWS Glue managed service for data clusterization)
• Built a robust data lake based on Apache Hudi open-source framework that allows bypassing data immutability limitations and enables smooth data management (e.g. versioning, replacement, field discovery)
• Provided for increased system scaling & extension capacity with Data Mesh architectural approach that ensures distribution of a monolithic data lake into microservices.