(888) 685-3101 ext. 2

CONCORDIA PLAN SERVICES:
BI/DW ASSESSMENT MAPPING

SUMMARY

BENEFITS PROVIDER FOR 6,000+ LUTHERAN ORGANIZATIONS WORLDWIDE

Concordia Plan Services (CPS) is the benefits provider for Lutheran Church – Missouri Synod employers of over 6,000 Lutheran organi- zations, including schools, universities, congregations and other ministries worldwide. These benefits include health, disability and survivor plans, retirement and retirement savings plans. https://www.concordiaplans.org/

CHALLENGE

They required a Business Intelligence / Data Warehouse solution.

THE XTIVIA SOLUTION

With XTIVIA’s experienced track record of working with top data analytics and data warehouse providers, CPS and XTIVIA developed a comprehensive RFP matrix to help select the best solution aligned with CPS’ vision and needs. CPS selected long-time XTIVIA partner Information Builders, Inc (IBI) as their provider and XTIVIA as their outsourced data architects and developers. The IBI tools used in this project were WebFOCUS for analytics and iWay Data Migrator for ETL.


XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.

XTIVIA developed an Executive Analytics dashboard, optimized CPS’ dated Enrollment Eligibility process and began outlining a data governance model that will provide improved security and increased operating efficiencies. Specific phases of the project included: 1) FPE and Plan Participation dashboard, 2) Enrollment Eligibility, 3) Rosters and Statistics dashboards, 4) Compensation Phase II data extracts and 5) Initial Vendor dashboard.

BY THE NUMBERS:
6,000+ organizations
31,000 Workers Covered
53,000 Dependents Covered
22,000 Retirees Covered
5 Phases in 10 Months
3 Systems to Integrate
1 Senior Architect
2 Senior Developers

BUSINESS VALUE

This project helped CPS improve security and increase operating efficiencies. The quality of solution delivery was supported by XTIVIA’s Business Intelligence expertise, especially given the familiarity with third-party tools (WebFOCUS and iWay Data).

“XTIVIA’s resource and depth of business intelligence knowledge has been an asset to the CPS organization!”
Bill Hofrichter, Chief Operating Officer

Download the Case Study PDF here