Alsea Revolutionizes its Reconciliation Process with AWS Technology and XalDigital's Expertise

In the dynamic world of restaurants, Alsea stands out as a giant, managing a broad portfolio of internationally recognized brands. However, it faced a critical challenge that slowed its ability to make strategic decisions: a cumbersome, manual and error-prone financial reconciliation process. The need for an innovative solution was clear, and the collaboration with AWS and XalDigital marked the beginning of an unprecedented digital transformation.

The Challenge: A Manual Process in a Digital World

Alsea was stuck in a reconciliation process that relied on multiple data sources, from databases to flat files and APIs. The manual task of cross-referencing this information in Excel not only consumed a significant amount of time, but was also subject to human error, delaying the delivery of crucial information and extending the reconciliation process to a full week.

The Solution: Automation and Efficiency through Innovation

Alsea, in collaboration with XalDigital, undertook an ambitious work plan divided into 6 sprints, with the objective of automating the reconciliation process. This strategic plan allowed for a meticulous and organized approach, which helped the implementation of a robust solution.

The first sprint focused on thoroughly understanding Alsea’s specific data sources and business rules. Intensive sessions with IT staff and end users allowed us to precisely define the connection methods, extraction periods and operations required for the dashboards. This initial analysis was fundamental to establish a solid foundation for the project.

Subsequent sprints were dedicated to building the technological foundations of the solution: from the creation of code repositories with CI/CD pipelines to the implementation of a web portal for catalog uploading. The engineering behind the data ingestion mechanism and reconciliation logic was gradually developed and refined, ensuring a smooth transition to automation.

Achieving Major Goals with AWS and XalDigital

All this was possible thanks to the AWS services and expertise of XalDigital. We took advantage of the power of technologies such as:

Amazon VPC

Amazon S3

Amazon API Gateway

AWS Lambda

AWS Glue

AWS Secrets Manager

Amazon Cognito

Amazon Dynamo DB

Amazon CloudWatch

Amazon CloudFront

Amazon Athena

These services came together like pieces of a puzzle to achieve the desired transformation.

Transformational Results: Agile and Accurate Decision Making

The collaboration between Alsea, AWS and XalDigital culminated in spectacular results:

  • Reduction of reconciliation time from one week to as little as 1.5 hours.
  • Reduction of errors in the productive code by 80% thanks to the implementation of unit and integral tests.
  • Configuration of reconciliation rules without the need to modify the code, allowing unprecedented adaptability and flexibility.
  • Delivery of 9 strategic reports and operational dashboards for informed and timely decision making.

This success story not only reflects Alsea’s ability to redefine its internal operations through technology, but also its commitment to innovation and continuous improvement.

Contact us and receive advice from our team of experts.

+52 (55) 5205 2003

contacto@xaldigital.com