Astera Case Studies Intuitive Data Integration Platform Enables Vanderbilt University to Leverage Endowment Data

Edit This Case Study Record

	Intuitive Data Integration Platform Enables Vanderbilt University to Leverage Endowment Data Astera

Intuitive Data Integration Platform Enables Vanderbilt University to Leverage Endowment Data

Astera

Technology Category	Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Education
Applicable Functions	Business Operation
Services	Data Science Services
Challenge	Vanderbilt University Office of Investments (OOI) manages the university's $3.2 billion endowment. The funds are typically invested through multiple external money managers who have little or no communication among each other. In the uncertain economy, the OOI wanted to determine consolidated risk exposures of the endowment to better understand the impact of different macroeconomic and market shocks. This was a difficult task that often required manual entry because the investment data was scattered across multiple systems. The risk management team needed an application that could integrate and map data from multiple internal and external sources in a timely and repeatable manner and give accurate reports of the endowment's factor risk exposures. Read More
About Customer	Vanderbilt University, located in Nashville, TN, is a private research university with approximately 12,000 students from all 50 U.S. states and over 90 foreign countries. The University required a system for accurate and timely reporting of endowment investments. A key part of the solution was gathering and mapping data from a variety of sources, including outside money managers. The Office of Investments at the university manages the university's $3.2 billion endowment. The funds are typically invested through multiple external money managers who have little or no communication among each other. Read More
Solution	After a build-or-buy analysis, the decision was made to acquire a data integration platform and a team was formed to evaluate various integration tools. Vanderbilt conducted a detailed evaluation of several data integration platforms, including SSIS, which was already deployed at Vanderbilt. The team discovered SSIS was difficult to learn and use and therefore entailed a significantly high total cost of ownership. Other platforms either did not meet the evaluation criteria or were too expensive. Vanderbilt ultimately selected Centerprise Data Integrator. By leveraging Centerprise's dataflow, workflow, and scheduling capabilities, Vanderbilt was able to quickly develop integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Education

Applicable Functions

Business Operation

Services

Data Science Services

Challenge

Vanderbilt University Office of Investments (OOI) manages the university's $3.2 billion endowment. The funds are typically invested through multiple external money managers who have little or no communication among each other. In the uncertain economy, the OOI wanted to determine consolidated risk exposures of the endowment to better understand the impact of different macroeconomic and market shocks. This was a difficult task that often required manual entry because the investment data was scattered across multiple systems. The risk management team needed an application that could integrate and map data from multiple internal and external sources in a timely and repeatable manner and give accurate reports of the endowment's factor risk exposures.

About Customer

Vanderbilt University, located in Nashville, TN, is a private research university with approximately 12,000 students from all 50 U.S. states and over 90 foreign countries. The University required a system for accurate and timely reporting of endowment investments. A key part of the solution was gathering and mapping data from a variety of sources, including outside money managers. The Office of Investments at the university manages the university's $3.2 billion endowment. The funds are typically invested through multiple external money managers who have little or no communication among each other.

Solution

After a build-or-buy analysis, the decision was made to acquire a data integration platform and a team was formed to evaluate various integration tools. Vanderbilt conducted a detailed evaluation of several data integration platforms, including SSIS, which was already deployed at Vanderbilt. The team discovered SSIS was difficult to learn and use and therefore entailed a significantly high total cost of ownership. Other platforms either did not meet the evaluation criteria or were too expensive. Vanderbilt ultimately selected Centerprise Data Integrator. By leveraging Centerprise's dataflow, workflow, and scheduling capabilities, Vanderbilt was able to quickly develop integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software.

Impact #1	Developed integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software.
Impact #2	Quick turnaround times and a short learning curve for executing data integration, migration, and mapping tasks.
Impact #3	The project has been so successful that Vanderbilt is now deploying Centerprise in other areas to enhance existing processes.

Impact #1

Developed integration jobs to automatically retrieve and map data from external money managers and internal systems into the endowment tracking software.

Impact #2

Quick turnaround times and a short learning curve for executing data integration, migration, and mapping tasks.

Impact #3

The project has been so successful that Vanderbilt is now deploying Centerprise in other areas to enhance existing processes.

Download PDF Version

Overview

Intuitive Data Integration Platform Enables Vanderbilt University to Leverage Endowment Data

Operational Impact