Astera Case Studies Centerprise Helps RBFCU Accelerate Legacy Data Migration by 80 percent

Edit This Case Study Record

	Centerprise Helps RBFCU Accelerate Legacy Data Migration by 80 percent Astera

Centerprise Helps RBFCU Accelerate Legacy Data Migration by 80 percent

Astera

Technology Category	Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation
Services	Data Science Services
Challenge	RBFCU had previously implemented an internally-developed core banking system to store and maintain member account information. As the credit union’s membership and product offerings expanded, the back end soon grew to hundreds of tables storing hundreds of gigabytes of data. Because of the legacy design of the system, RBFCU’s ability to develop modern, member-centric applications was hindered and fitting new products and services into the system often took an excessive amount of time. Additionally, RBFCU’s team was tasked with completing many regulatory changes to keep the core system compliant, which further hindered them from focusing on developing productive software applications. Ultimately, a decision was made to convert to a third-party core banking platform from Fiserv. The decision was a logical one; however, credit union leadership soon realized that converting to the new platform would be a daunting task. The sheer enormity of the data to be converted would require dedicated resources to get the job done. This spurred the creation of a core conversion team, which was charged with converting legacy data into the new core banking system, developing conversion logic/business rules, identifying opportunities for data cleanup, and integrating newly selected ancillary software with the core system. Read More
About Customer	Randolph-Brooks Federal Credit Union (RBFCU) is a major bank and financial services enterprises operating in 55 locations across Texas, USA. With its strong commitment to customer service, RBFCU has expanded its banking solutions portfolio to cater to a fast-growing customer base. Overtime, RBFCU has shifted its banking and financial solutions data to become more customer-focused, whilst ensuring compliance of regulatory and industry best practices. RBFCU is one of the top credit unions in the country with over 400,000 members and assets exceeding $5 billion. Read More
Solution	The possible solutions boiled down to the classic “build vs. buy.” Building the system in-house was initially considered but was quickly determined not to be a viable option. The development effort would have been too extensive, and the run-time performance would not likely scale to the amount of data to be migrated. The second option involved third-party ETL tools. Most of the major players were considered, but the race was short-listed to IBM, Talend, SSIS, and Centerprise. After thoroughly investigating each option, the RBFCU team found Centerprise to have the right combination of capability, performance, and intuitiveness. RBFCU selected Centerprise because it met and exceeded all objectives. The learning curve was not too high as the team discovered the interface to be straight-forward; developers were able to drop and come back to the tool without having to relearn it. And, with the Centerprise SQL Source and Lookup components, they were able to leverage and translate their SQL skills right away. Additionally, the Name Parser component was an unexpected bonus, which saved them additional development time. What would have taken at least a week with an in-house solution was now getting done in half a day. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Services

Data Science Services

Challenge

RBFCU had previously implemented an internally-developed core banking system to store and maintain member account information. As the credit union’s membership and product offerings expanded, the back end soon grew to hundreds of tables storing hundreds of gigabytes of data. Because of the legacy design of the system, RBFCU’s ability to develop modern, member-centric applications was hindered and fitting new products and services into the system often took an excessive amount of time. Additionally, RBFCU’s team was tasked with completing many regulatory changes to keep the core system compliant, which further hindered them from focusing on developing productive software applications. Ultimately, a decision was made to convert to a third-party core banking platform from Fiserv. The decision was a logical one; however, credit union leadership soon realized that converting to the new platform would be a daunting task. The sheer enormity of the data to be converted would require dedicated resources to get the job done. This spurred the creation of a core conversion team, which was charged with converting legacy data into the new core banking system, developing conversion logic/business rules, identifying opportunities for data cleanup, and integrating newly selected ancillary software with the core system.

About Customer

Randolph-Brooks Federal Credit Union (RBFCU) is a major bank and financial services enterprises operating in 55 locations across Texas, USA. With its strong commitment to customer service, RBFCU has expanded its banking solutions portfolio to cater to a fast-growing customer base. Overtime, RBFCU has shifted its banking and financial solutions data to become more customer-focused, whilst ensuring compliance of regulatory and industry best practices. RBFCU is one of the top credit unions in the country with over 400,000 members and assets exceeding $5 billion.

Solution

The possible solutions boiled down to the classic “build vs. buy.” Building the system in-house was initially considered but was quickly determined not to be a viable option. The development effort would have been too extensive, and the run-time performance would not likely scale to the amount of data to be migrated. The second option involved third-party ETL tools. Most of the major players were considered, but the race was short-listed to IBM, Talend, SSIS, and Centerprise. After thoroughly investigating each option, the RBFCU team found Centerprise to have the right combination of capability, performance, and intuitiveness. RBFCU selected Centerprise because it met and exceeded all objectives. The learning curve was not too high as the team discovered the interface to be straight-forward; developers were able to drop and come back to the tool without having to relearn it. And, with the Centerprise SQL Source and Lookup components, they were able to leverage and translate their SQL skills right away. Additionally, the Name Parser component was an unexpected bonus, which saved them additional development time. What would have taken at least a week with an in-house solution was now getting done in half a day.

Impact #1	Simplified SQL development time through short product learning curve
Impact #2	Developers were able to drop and come back to the tool without having to relearn it
Impact #3	Leveraged and translated their SQL skills right away with the Centerprise SQL Source and Lookup components

Impact #1

Simplified SQL development time through short product learning curve

Impact #2

Developers were able to drop and come back to the tool without having to relearn it

Impact #3

Leveraged and translated their SQL skills right away with the Centerprise SQL Source and Lookup components

Benefit #1	Accelerated project completion time by more than 80 percent.

Benefit #1

Accelerated project completion time by more than 80 percent.

Download PDF Version

Overview

Centerprise Helps RBFCU Accelerate Legacy Data Migration by 80 percent

Operational Impact

Quantitative Benefit