Results with Xertica

- Gradual integration of 13 systems from approximately 120 different systems to build a centralized data repository.
- Significant reduction in data processing times, from hours or days to seconds.
- Democratization of data, allowing information to be shared with more users and improving data quality.
- Social and economic impact: improvement in the efficiency of services, faster attention to members and beneficiaries.

Comfenalco Antioquia, a Colombian entity belonging to the family subsidy system, is dedicated to providing social welfare and recreation services to workers and their families.

It offers recreation, education, housing, social credit, cultural activities, among others, in order to promote the well-being of its affiliated and non-affiliated users. The entity has a long history and commitment to improving the quality of life of the community through comprehensive and technologically advanced solutions.

In a constant environment of technological innovation, the entity prioritizes updates to boost its data management processes and promote efficient service to members and beneficiaries.

Moving towards more Effective Operations and Information Management

To improve the provision of its services to users and facilitate their access to information, Comfenalco Antioquia faced the challenge of identifying and prioritizing intake based on 120 different sources of information with which they work to provide a better service. Likewise, democratize this information so that different areas have access. A challenge that involved not only improving the coordination between its areas, but also the management of projects that developed the capabilities of using technology by the internal team.

To do this, they adopted emerging technologies, such as the integration and centralization of data in a Data Lake and the initial definition of a Data Government to lay the foundations for effective information management.

In search of optimized management, key to having more timely and reliable information, Comfenalco Antioquia needed to activate some prioritized areas of data management throughout the organization, including Quality, Storage, Exploitation and Democratization of data.

“Initially, the entire cognitive project was contemplated, with the sole purpose of being able to consolidate and democratize information, ideally on a cloud platform. Precisely because of the need to have a centralized site for Comfenalco data and to be able to develop data analytics” - Adriana Montoya Valencia, Data and Analytics Unit Leader

A Cloud Infrastructure that optimizes the Democratization and Accessibility of Data

The collaboration between Xertica and Comfenalco Antioquia has resulted in successful implementation and training that has strengthened Comfenalco's data management capacity.

The Xertica team's comprehensive approach included a thorough diagnosis of the organization's state and the definition of solid Data Governance. This process ranged from the formulation of policies and processes to the internal structuring of the company.

From a technological point of view, an evaluation of the available data assets was carried out, which allowed the most relevant assets to be identified and prioritized for subsequent storage in the cloud. In addition, a culture of quality and truthful data was initially promoted through procedures that include approximately 21,000 companies, more than 400,000 workers and with more than 800,000 beneficiaries. Which finally led to an improvement in processes for both collaborators and clients of the organization.  

Optimizing the Work Environment for Employees

The adoption of Google Cloud services had great advantages for Comfenalco Antioquia, and one of the main ones has undoubtedly been the reduction in time in building dashboards and the quality of the data provided by the data lake.  

In other words, a robust Data Solution Architecture has been implemented that encompasses a variety of products, including Data Lake, Data Warehouse and Dashboards, designed specifically to manage and improve the data quality process, as well as facilitate democratization. thereof.

With the implementation of the new architecture, data processing time has been significantly reduced, making it faster and more efficient. Additionally, this approach has improved data quality by eliminating human errors and ensuring data integrity.

Another important benefit is the improvement in data accessibility. Previously, information was limited to a few people who had access and knowledge of how to manipulate the files. With the new architecture, the democratization of data has been facilitated, meaning that more users have the ability to access and use information effectively.

Additionally, the implementation of advanced visualization tools has improved the user experience by providing an intuitive and easy way to interpret data. This has allowed users to explore and analyze data more efficiently, leading to more informed and strategic decision making across the organization.

That is, with this new capacity in Comfenalco, a high-quality data culture is promoted, leveraging a data ecosystem that will provide access in the first instance to the information of affiliated and non-affiliated clients. With more precise and timely data, information analysis and decision-making will be facilitated internally, which improves the processes and services offered to members and non-members around the different dimensions of well-being.

"Xertica has a highly experienced team in the field of data, dedicated to implementing the best practices to guarantee the quality and veracity of the information" - Carlos Gómez, Comfenalco Data Architect.

Social Impact and Continuous Commitment

The collaboration with Xertica had a significant impact on the efficiency and quality of Comfenalco Antioquia's services. Beyond tangible results, this partnership reflects both parties' continued commitment to innovation and excellence in data and technology management.

Today, Comfenalco Antioquia plans to continue innovating and implementing predictive analysis, a tool that promises to revolutionize the way they understand and serve the needs of their members and beneficiaries. With the introduction of tools like MLOps, they will be opening new doors towards the industrialization of predictive models.

This initiative is leading them to redefine their data quality standards, promoting a culture of continuous improvement and awareness of the importance of information veracity at all levels of the organization.