Sinergija Challange 2019

Parameter Sniffing Problem with Stored Procedures
July 20, 2017

Once upon a time, more than 10 years ago, we stepped into the magical world of information technology. Working on complex projects, we are mastering new technologies and adapting to the turbulent world around us. It may sound a bit like a fairytale, but the journey into the uncharted territories of the IT world certainly is. Today we come to the random forest, neural networks, and machine learning. That’s why we decided to compete in the Sinergija 2019 public arena hosted by Microsoft. We accepted the challenge of trying to introduce ourselves to an audience made up of eminent experts and managers from the Serbian business world.

 

_DJT7674 Sinergija 2019

 

In addition to the impeccable organization, Sinergija 2019 also provided a challenge that was not easy at all. It was necessary to determine the exact value of used cars and propose a solution to automate the process of transferring ownership of them.

Our solution is not only intended for participants in the process of importing and evaluation of vehicles for customs and taxation purposes, but for all citizens of Serbia as a public service. It allows estimation at any point in the lifespan of a vehicle.

 

How did we achieve this?

 

Thanks to Microsoft Azure Services. We take data from relevant sources, both domestic and foreign, and store it in Datawarehouse, after which the brain of our solution enters the scene – our Machine learning model in Azure ML Service. Our model considers not only market trends but also the legally prescribed method of writing off the value of vehicles. By serious mathematics, we get high accuracy classes and generalizations, resistance to market deviations, while the trend is considered. It’s like creating a catalog for the value of vehicles on a daily basis.
The rest of the architecture is tasked with responding to leaps in demand, to keep things running smoothly.
We were able to achieve all that was required:

 

• Simplicity
• Flexibility
• Transparency
• Availability

 

but also to leave the door open for Customs, Tax Administration and Ministry of Internal Affairs, to join forces in automating the whole process.

 

_DJT7799 Sinergija 2019

 

The expert jury recognized our effort and awarded our idea with First Place. Of course, our success did not go unnoticed and now a lot of people know about the wonderful transformation that is happening in our small code factory. After all, we are AVS Solutions and our long-standing motto is “Bringing life to ideas”. It is up to us to continue to learn, to grow, to develop and, of course, to do our best to make our idea live and make life easier for all citizens of Serbia.