Success Story

GRIO employees have access to a benefits application where they can view relevant information about their corporate benefits and working conditions, such as health plans and insurance types. For some time, users faced difficulties using this tool because their profiles did not meet the necessary requirements, even though this was not actually the case. This issue arose because each company within Grupo Romero manages its own health plans with different codes. Additionally, some of these companies have their own systems and codes, which were not integrated. This caused data quality discrepancies, preventing the benefits application from providing reliable, up-to-date, and real-time information.

While an attempt was made to solve the problem by manually transferring information, this led to excessive reliance on office tools, such as Excel. However, this did not address the root issue. For GRIO, continuing with this situation meant a negative impact on employee engagement strategies, potentially leading to talent loss and a poor work environment.

Once the business objectives and critical needs were identified, Protecso proposed a solution to fully automate information management with flexibility. This solution ensures that data from more than 25,000 employees and their respective health plans is available daily and on time in the benefits application.

A scalable and robust architecture was implemented, leveraging AWS native cloud components while ensuring security through Cognito.

The architecture includes the following components:

1. Automated Data Loading from SAP: The automation of data loads was implemented for various HR information domains of employees across more than 10 companies within the corporation that GRIO serves. AWS cloud components were used to periodically and programmatically retrieve structured data interfaces, which are automatically stored in S3 and communicated through AWS Lambda functions.

2. Middleware Development and Deployment: A native Middleware was built to integrate SAP’s automated data loads with the benefits application. Additionally, an administration module for the Middleware was developed, providing flexibility for both the Support and Administration teams. This module allows them to visually monitor information loads, edit and update relevant data via a data entry system, and make it available to different employee-facing consumption channels, such as the benefits application. The solution utilized SPA services for the frontend and AWS Lambda for communication with the DynamoDB NoSQL database.