Client Description

The two credit unions, Bellco Credit Union and Bethpage™ Federal Credit Union, formed Open Technology Solutions, LLC (OTS), a Credit Union Service Organization (CUSO), focused on providing collaborative, technology-related services to a few large credit unions on the Fiserv platform. Together, they have achieved the kind of scale none could have achieved on their own – more than 889,000 members and over $14 billion in assets – ranking them together as one of the largest credit unions in the country.

Challenge

OTS was in need of a comprehensive needs analysis of the three credit unions, S3 (a consolidated back-office and call center serving the three credit unions), and Open Technology Solutions. The needs analysis encompassed a thorough evaluation of the current uses of data, the processes surrounding the use of data, and the desired uses of data to arrive at a consortium-level data strategy. OTS was seeking an experienced partner that could assist in defining a consortium-level data repository solution and the optimal approach to data modeling to support the expansive data needs of the consortium.

Solution

iOLAP completed a thorough assessment of the data requirements of the three credit unions, OTS, and S3, as well as anticipated future needs. iOLAP worked with the credit unions to gather requirements for the outputs required for a data warehouse & analytics solution. We appropriately documented results, conclusions, and recommendations. iOLAP assessed data readiness of all three credit unions and S3 and identified gaps in organizational alignment and identify opportunities for synergy. Infrastructure was assessed to support a fully-functioning data warehouse and with distributed data analytics.

Benefit

iOLAP defined a data strategy that addressed the needs of end users, determining the correct balance between centralized and decentralized data. The strategy included the database schema, data collection techniques, data retention, report generation, data distribution, security, etc. The strategy clearly defined the future steps necessary to achieve the goals set forth in the strategy.