|   Engage Our Services   |   Apply for Job

VIVAPastPerformance

List of Specializations

BI / DW

DW / BI - Healthcare Company

VIVA has provided end-end services for Data Warehousing and Business Intelligence applications. VIVA's team was responsible for designing a data warehouse prototype in SQL server for a large hospital in Illinois.

Responsibilities

DW / BI - Healthcare Company VIVA has provided end-end services for Data Warehousing and Business Intelligence applications. VIVA's team was responsible for designing a data warehouse prototype in SQL server for a large hospital in Illinois. Our team studied their existing data stores and developed a logical data model of a data warehouse. Responsibilities Analysis of functional requirements of the data warehouse for the hospital environment Study of disparate data stores of the client Design of Extraction, Transformation, and Loading (ETL) mechanisms using MS SQL Server DTS packages Design of data warehouse logical and physical models Loading of data into the data warehouse Design of cubes using PowerPlay, and reports using Impromptu Design of data modeling, and prototyping of BI environment using COGNOS and Business Objects