Aftermarket Solution Development

Dedicated Development team focused on four pillars: high-scale migration to cloud, comprehensive data processing, customer portal enhancement, and streamlined returns automation

Customer:

Leading expert for data management and processes in the IAM

Business need:
As a part of a Digital Transformation initiative, TecAlliance wanted to reengineer the existing digital platform featuring spare parts from 900+ brands for more efficiency and reliability. They were looking for a reliable supplier to bring in Big Data & Cloud expertise and extend the in-house team.
Result:
TecAlliance launched the new, cost-efficient, easy to scale and maintain solution developed by in-house and Sigma Software experts according to the best BigData & Cloud practices. We further support the Client in product development and enhancement, extending the solution with new modules.

“Sigma Software supports us in our digital transformation journey. With the first results we were able to achieve major milestones and set the base for further progress. They provide us on all levels with highly professional support and expertise!”

Tobias Roth

Vice President Information Management

TecAlliance

Collaboration Overview

Key Facts

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.

Strategic Migration to AWS

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.

Big Data & Cloud

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.

Testimonials

Our long-term cooperation with Sigma Software is a win-win situation. Both parties profit from the close collaboration, the experiences and knowledge within our digital transformation!

Tobias Roth

Vice President Information Management

TecAlliance

The project is by no means simple, and our team takes part in almost every aspect of it. But the fact that we help TecAlliance in the end-to-end transformation of the data that comes in nearly DVDs into a comprehensive catalog to be used in almost every country in the world makes every effort worth it.

Darya Gruntovskaya

Account Manager

Sigma Software

Aftermarket Solution Development

Business need:

Result: