PAT Data Warehouse

Consistent, reliable, and vetted data are paramount to the successful implementation of any investment system, i.e. accounting, portfolio management, transaction, risk and performance systems, at Asset Management firms and Funds of Funds.

The PAT Data Warehouse (PAT DW) is a centralized repository for enterprise wide portfolio analysis and reporting needs of hedge funds, fund of hedge funds and asset management firms. It supports the connectivity and integration of all investment systems thus helps achieve straight through processing (STP) for the investment management process.

PAT DW has built-in processes to integrate, normalize, and reconcile investment data from numerous and disparate internal and external sources. Additional processes allow users to model and proxy complex asset classes, integrate with third-party analytics applications and feed quality data to all investment systems. The Data Warehouse contains customized time-series data of portfolio, benchmark, and securities statistics to support research and analysis needs.

PAT DW provides extensive, consistent, and reliable data sets and multidimensional data views to investment and reporting systems, including: multiple hierarchies, counter-party, portfolio and benchmark holdings, transactions, security reference, prices and sensitivities, market and credit risk and performance metrics.

PAT DW key features include:

Comprehensive schema for terms & conditions, position, transaction, analytics, risk and performance data.
Powerful metadata region for application configuration for increased application flexibility.
Extensive drill-down capabilities to perform detailed analysis.
Built-in graphic capability.
Export feature that allow data set exports to other applications or packages.
Multi-level permissions for managing/restricting data access.
Automated batch reporting and scheduling.
Time-stamped input and output data for history and auditing purposes.