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 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!”

Mark Ross | Assistant Vice President of Information Technology

Download the Case Study PDF here

Let's Talk Today!

No obligation, no pressure. We're easy to talk with and you might be surprised at how much you can learn about your project by speaking with our experts.

XTIVIA CORPORATE OFFICE
304 South 8th Street, Suite 201
Colorado Springs, CO 80905 USA

Additional offices in New York, New Jersey,
Missouri, Texas, Virginia, and Hyderabad, India.

USA toll free: 888-685-3101, ext. 2
International: +1 719-685-3100, ext. 2
Fax: +1 719-685-3400