Case Study

Data collection platform

Project scope

Our client

The Company is operated in North America and has been the leading provider of strategic data and analytical solutions for the agriculture, crop protection and animal health industry for almost 30 years.

The challenge

They were using and maintaining multiple legacy systems and custom applications to collect, cleanse and analyse sales, product, and customer data from thousands of sources across the US and Canada.

These systems consisted of hundreds of databases, over 20 web portals and countless SSIS packages, stored procedures and custom workflows which were maintained and operated by multiple teams in 3 different geographic locations.
Those systems were storing and processing redundant data and contained duplicated inefficient manual processes for transforming and cleansing incoming data resulting in costly data quality issues.

An enormous amount of time had to be spent to integrate, modify and support those systems.
Onboarding new customers required creation of new databases, configuration changes in multiple systems and applications and the process was taking weeks. Initial historical data loads could take days.

What was the problem?

Identified challenges

Multiple legacy
systems

Custom manual
workflows

Data quality
issues

Slow customeron boarding
process

Our solution

Our solution begins with clarifying business requirements, advising in software architecture and day to day development, on both, backend and frontend technologies. The key objective is keeping consistent agile processes. The solution consists of a single data integration platform replacing all existing tools, websites and processes.

The solution consists of a single data integration platform replacing all existing tools, websites and processes. It is based on 10+ scalable Microservices hosted on Azure Service Fabric cluster which allows asynchronous processing with multiple service instances making processes faster and efficient.

Results

The implemented solution improved file processing time, which decreased from days to minutes.The geo independent tool aided the expansion of the business to multiple locations and industries much faster and improved the organization’s ability to make more accurate and efficient decisions. Onboarding of new customers was reduced from weeks to days.

It reduced costs of maintenance and support, resources required for data extraction and the trouble of tying multiple systems together. The vastly improved data quality allows our customers clients to make sound business decisions and gives an opportunity to find new markets and distribution channels.

Leave your contact info and we’ll be in touch soon.

Let’s accelerate your business!