As one of the largest manufacturing companies in Latin America and the biggest exporter in Argentina, Molinos needed to evolve it’s data extraction process with Cloud based solutions.
Molinos Rio de la Plata S.A. is a company owned by the Grupo Pérez Companc, a leader in the Food & Beverage industry in Latin America.
Currently, it employs more than 2,800 workers and has 14 production plants. It counts with more than 20 brands that exports to 50 countries all over the world.
Our working relationship began with a local billing project, another of DinoCloud’s areas of expertise. Due to the good interpersonal and professional
relationships sprung from this project, Molinos Río de la Plata contacted the commercial area of DinoCloud to address another need: the automation of
the data extraction processes of the Precios Claros program.
This program seeks to achieve competitive equity through the exhibition of the retail price of products by competitors in the food market.
Before starting this project, Molinos Rio de la Plata used a PowerShell script to manually extract data from the program and then load it into a SQL
Server database. This manual process was a major operational disadvantage as it hindered achieving high availability data for strategic decision-making
and increased the possibility of errors in data reading and extraction.
To address this need, DinoCloud presented Molinos Río de la Plata, a
project whose main objective was the implementation of an Automatic
Data Lake to extract and transform data from the Precios Claros program.
This project was intended to last one month in three milestones.
Discovery, infrastructure, and migration
The project to automate the data extraction processes of the Precios Claros program was carried out in three different milestones:
1. Discovery
This stage consisted of understanding the processes being carried out by the client. Also, two meetings were held with the client to understand which needs needed to be addressed by DinoCloud.
2. Setting up the infrastructure for data processing
The main task of this milestone was to put together the workflow in AWS Glue to automate data processing.
To execute this, DinoCloud set up roles and keys with the AWS IAM service, created and configured AWS S3 buckets, and created jobs in AWS Glue. In addition, DinoCloud developed ETL pipelines on AWS Glue and assembled the data architecture in Amazon Redshift to support the queries needed for reports in PowerBI. This stage culminated in the completion of the workflow.
3. Migration of scraping processes to AWS
Once the architecture was created, it was necessary to perform the migration of the scraping process, which was completed.
At DinoCloud, we take care of turning a
company’s current infrastructure into a modern, scalable, high-performance, and low-cost
infrastructure capable of meeting your business
objectives.
If you want more information, optimize how
your company organizes and analyzes data, and reduce costs, you can contact us here.
Both efforts provided MODO with valuable insights into the security of their AWS environment. The comprehensive security assessment reports helped
MODO identify potential weaknesses and compliance issues, allowing them to proactively address and improve security procedures.
With a clear understanding of their security status, MODO is ready to offer their growing customer base secure, reliable, and PCI-compliant financial services,
reinforcing their position as a leader in the financial services industry.
Focus on your core business while DinoCloud provides the
technology outcomes you need by leveraging its expertise in
the cloud.
(*) Required fields
