Bonus Settlement System

Who the Client Is

Moto-Profil sp. z o.o. specializes in the import and distribution of automotive spare parts and accessories, as well as in equipping automotive workshops. Through a network of over 1,400 Business Partners, the company reaches more than 15,000 workshops across Poland and Central Europe, where in recent years it has grown into a solid market leader.

Project Goal

The goal of the project was to design and implement a system that would allow Moto-Profil to define bonus programs (both those received from manufacturers and those granted to business partners) and manage their full settlement process.

Result

The project resulted in the launch of a web portal with an advanced permissions system, enabling:

• Defining bonus programs

• Settling bonuses (calculating due amounts based on sales data)

• Forecasting future bonus amounts for upcoming settlement periods based on trends

• Reporting

Additionally, a distributed, non-monolithic group of microservices was developed to integrate with various client systems and aggregate sales data required for bonus calculation.

Technologies

• ASP.NET Core

• .NET Core

• JavaScript

• MS SQL

• Docker

• Cloud

• Azure

• Service Bus

• Azure Blobs

• Redis

• AI

• ML

• Deep Learning

• Keras

• Darts

Challenges

• Building a universal rule editor that allows non-technical users to define complex bonus rules using simple building blocks

• Creating a universal engine for evaluating bonus rules

• Processing data for over 3 million products

• Handling bonus calculations for several hundred suppliers

• Processing hundreds of gigabytes of sales data

• Developing a trend prediction module to forecast future turnover across product groups in order to predict upcoming bonus amounts