Data Warehouse

 In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating analytical reports for knowledge workers throughout the enterprise. Examples of reports could range from annual and quarterly comparisons and trends to detailed daily sales analysis.

Our expertise working for Northern America largest financial services group provided business intelligence solution to

• Consolidate the middle office end of day and intraday data
• Provide start of day portfolio management
• Handling of all tasks related to the monitoring of collateral posted by a borrower (collateral reporting, processing of margin calls and returns, monitoring of collateral substitution, notification of corporate events, processing of securities transfers on behalf of the client, etc.) and is an established mechanism for mitigating credit risk.

Our technical experts designed and developed a DataWarehouse solution that resulted in a highly scalable solution that met the following requirements

Transaction volume : 73 Million per year; annual growth rate of 110%
Size : 180 GB at the end of Year 1; annual growth rate of 45%