endorsedOngoing

BI & Digital Portfolio Solutions for Health Plan Payer

Services Covered:

UI/UX Design • Software QA and Testing • Staff Augmentation

Industry

Financial Services

Duration

127 months

Budget

Confidential

Start Date

1 January 2016

Team Size

21-25 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

77/100

Good

Project Capability Score (PCS) estimates how capable Coherent Solutions is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Grand Junction, United States of America

Project Summary

Coherent Solutions provides ongoing custom development augmentation for a health plan payer, building database architecture for a BI solution and designing UX/UI for a digital platform. They helped migrate analytics to MS SQL with Pentaho and SAS, implemented a SiteCore CMS, and provided staff augmentation across Web API and DevOps roles. Their support enabled the client to bring the main public website in-house, empower marketing and sales, and reduce reliance on vendor-hosted contracts.

Key Challenges

Migrate the BI stack from Oracle to MS SQL with a star schema using Pentaho and SAS
Replace externally hosted legacy web platforms by implementing a SiteCore-based CMS
Augment teams with Web API and DevOps engineers to support ongoing development

Project Deliverables

Database architecture for Business Intelligence
ETL and data migration to MS SQL star schema
UI/UX design for the digital platform
SiteCore-based CMS implementation
Web UI and API solutions
QA testing and automated validation for production loads

Project Solution

Coherent Solutions designed the database and architecture for the client's Business Intelligence platform, implemented ETL and automated validation for production data loads, and provided quality assurance testing. For the Digital Portfolio, they supplied UI/UX design, architecture and development of Web UI and API solutions, and helped implement a SiteCore content management platform. They staffed the engagement with specialists (including .NET engineers, ETL developers, QA testers, and DevOps engineers) and delivered features on a two-week agile cadence.

Project Outcome

Brought the main public website in-house with a CMS, empowering marketing and sales and eliminating a vendor-hosted contract
On track to eliminate two more vendor-hosted website solutions and to decommission the legacy analytics platform in early 2020
Coherent staff integrate into onshore agile ceremonies and provide early-morning overlap to accelerate handovers

Platforms

Tech Stack

.NET
Azure
SQL
REST API

Client Endorsement

Overall Review Rating

4.63

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Coherent Solutions' support has allowed the in-house team to fully oversee the main website rather than relying on a vendor-hosted contract. Together, they've been able to launch a CMS that empowers the sales and marketing teams. Coherent Solutions works well with all involved parties.”
Ronald Glen McDaniel
IT Director
Date: 11/27/2019