Project summary | Upgrade existing data warehousing and reporting solution (IBM COGNOS) with metric collection and aggregation for custom communication programs developed for specific customers (Data-marts and operational reporting). |
Customer | Leading provider of automated voice services and outbound communications for medical providers and payors |
Project geography | USA |
Project objective | As new customer communication program gets designed and implemented, it has a number of data points associated with it. These programs include complex automated voice dialogs and even a sequence of calls. The project objectives include:
Provide near-real time program outcomes and performance analytics for program customers in eth form for COGNOS reports and metrics |
Project highlights | ALG DWH expertise: With a strong background and experience in DWH, together with customer we carefully designed engineered Data-marts for flexibility, growth and reuse BI published within secure customer portal: Great advantage of our analytics was the fact that with incremental ETL and COGNOS web-based analytics we offered program customers near real-time information about program outcomes and overall performance. All this in the secure, role-based, and HIPPA-compliant environment. Real-time performance management: Care Providers and payors involved in the communication program used the portal to track their program objectives and results using flexible and intuitive COGNOS analytics near real-time |
Project description | Specific project activities:
Implemented using MS SQL Server, MS Integration Services, COGNOS 8.2 |