Legacy
soft­ware
moder­nization

for а market research company

Our customer is a global measurement and data analytics company that provides the most complete and trusted view of consumers and markets worldwide.

For more than 90 years, it has provided data and analytics based on scientific rigor and innovation, continually developing new ways to answer the most important questions facing the media, advertising, retail, and fast-moving consumer goods industries.

It operates in more than 100 countries and is ranked number 1 among top Market Research companies in the USA.

Domain:

Market Research

Budget:

$11.000/month

Duration:

since 2017

Challenge

Succeeding in today’s market is tough. Innovation is where breakthrough opportunities reside. But an innovative approach cannot be implemented without using up-to-date technologies.

Our customer embraces innovation just as we do. They needed to jump on the new technology bandwagon to operate optimally. That’s why they decided to migrate from legacy technologies to modern cloud infrastructure.

Tasks

  • Migration to Spark. Spark is used in a wide range of organizations for large-scale data processing. It allows running workloads faster, writing applications quickly in Java, Scala, Python, R, and SQL, combining SQL, streaming and complex analytics. Spark runs on Hadoop, Apache Mesos, Kubernetes, standalone, or in the cloud. It can access diverse data sources.

  • Validation of business logic, which is critical to keep things running smoothly. Publishing data is actually pretty easy. There are a lot of ways to do that. But securing and organizing your data is an important task that requires some thought.

  • Data correctness verification. Accurate data is the backbone of any database. Rigorous, objective and transparent verification processes are vital to establishing and maintaining high-quality data.

  • Performance improvement in general and reducing data processing time in particular.

Solution

The solution involved taking the data prepared by the company’s different teams from the cloud storage (S3) and executing the project code to message, consolidate and filter data to perform further calculations. Code execution results are recorded in a file that can be used either for the company’s other projects or for making reports.

The solution includes:

  • orchestration of all jobs (tasks);
  • migration to AWS cloud services;
  • refactoring of the code to handle increased data volume;
  • the possibility of sharing the transformed data with different teams and using it within various company projects.

Key features

Data verification 

(data qualitatively and clearly coincides with what is expected)

Each job (task) gives the expected result

Runtime reduction

Maintenance cost reduction

Modifiability improvement

Value

Thanks to the solution implemented by *instinctools, the users got an opportunity to manage the revisions of documents and correlate them with all the necessary regulations in a more efficient way. It allowed our customer to attract more clients, which increased the revenue.

Technologies

Scala
HDFS
AWS EMR
AWS Lambda
AWS RDS
AWS SQS
Spark
Grafana
S3
Kubernetes
Airflow

Legacy software modernization

Software modernization is the key to adapt, grow and remain competitive for any organization. In close cooperation with your company, we will work out the best strategy for this process!

Do you have a similar project idea?

Contact us — and get a project cost estimate for free!