Background
A leading global property and casualty insurer recognized the need to modernize its data management processes to stay competitive and ensure operational efficiency. With over 6,000 employees, the company relied on diverse data, including HR, sales, MDM, finance, reporting, and unstructured files. Efficiently managing and analyzing these datasets was crucial for supporting extensive operations and maintaining its reputation for excellence.
Use Case
Before implementing Astera Data Pipeline Builder, the insurer faced significant challenges with its existing ETL systems. The company used Informatica and legacy SSIS code for data management, which proved to be inefficient and inflexible for scaling operations.
They sought a solution to establish consistent ETL and data management standards across the enterprise, streamlining development processes and significantly improving the company’s ability to manage data challenges efficiently.
Enter Astera Data Pipeline Builder
“Previously, our ETL team required 16 to 20 weeks for this process. With the introduction of Astera, we have successfully condensed this timeline to just 2 weeks, with the involvement of a single development resource.” – AVP, Information Technology
The transition to Astera modernized their data processes, achieving greater efficiency and flexibility. They chose Astera Data Pipeline Builder for its robust capabilities in handling diverse datasets. The tool’s flexibility allowed efficient management and analysis of data, from small datasets with under 100 records to large datasets exceeding 200+ million records per job. This adaptability was essential for managing a wide range of data types, including HR, sales, MDM, finance, and reporting data, as well as unstructured files.
Astera Data Pipeline Builder addressed several critical business needs. It excelled in processing unstructured data and facilitating ETL processes for both financial and non-financial systems. This ensured that data from various sources could be seamlessly integrated and transformed into a usable format for analysis. Additionally, Astera’s robust data analysis features allowed for in-depth insights into operational performance, identifying trends, patterns, and anomalies that could impact the business. This level of analysis empowered the company to make data-driven decisions.
Profile
A global property and casualty insurer with over 6,000 employees.
Industry
Insurance
Product
Astera Data Pipeline Builder
Use Case
Using Astera Data Pipeline Builder, the company standardizes ETL and data management, streamlining development and improving their ability to handle data challenges efficiently.
Results
The company cut new client implementation time from 16-20 weeks to two weeks with one developer. They also created a unified SFTP process, reducing costs and time by 95% while improving data transfer efficiency.
The tool’s auditability features were also crucial, providing comprehensive tracking and logging of data processes. This transparency ensured that all data transformations and transactions could be reviewed and verified, supporting compliance with regulatory requirements and internal policies. By maintaining a clear audit trail, the company could confidently rely on the integrity and accuracy of its data.
The implementation of Astera Data Pipeline Builder had a significant impact on their operations, particularly in reducing costs for ETL development and maintenance. Astera accelerated the new client implementation cycle.
Furthermore, Astera enabled the insurer to establish a unified enterprise-wide SFTP process. The streamlined SFTP process improved data transfer efficiency, reduced manual intervention, and minimized errors, thereby enhancing overall data management practices.
“Thanks to Astera, we’ve successfully established a unified enterprise-wide SFTP process. This implementation has led to an impressive 95% reduction in both time requirements and associated management cost.” – AVP, Information Technology
