Case Study – Accelerate data processing 2017-08-03T20:47:26+00:00

Accelerate data processing, provide timely and accurate information to executives: From 3 hours to 20 minutes

Download this Client Success Story!

Download Now

Industry

Financial Services

Client

Financial Services Company

Business Geographical Coverage

North America 

 

Business need

Our client was experiencing delays in processing the daily data transfer from their financial systems to the corporate data warehouse, and this caused most of the reports used by the executives to be delayed and incorrect due to data corruption. The old processes developed more than a decade ago were never updated or optimized to handle the current volume of data processed.

 

Solution

CXO analyzed alternatives to fix these issues, redesigned the data load process using modern functions available in Microsoft SQL server, and optimized several queries that provided faster data processing and accurate numbers. The original data transfer process was taking between three and five hours to execute; after the new process was implemented, the same volume of data ran in less than twenty minutes.

 

Benefits

These back office improvements were translated in multiple benefits for our client; not only is the data now processed in less time, but the numbers are accurate and balanced by the redesigned processed. By reducing the processing time, the executives are receiving reports early, and the business intelligence server is available to process additional queries and more complex drill-through reports developed to utilize the server’s available processing capacity. Our client is using the same hardware and software infrastructure, but is obtaining more reports and data analysis in less time.

 

Technology

SQL Server Integration Services, SQL Server, IBM Cognos Business Intelligence (Report Studio, Analysis Studio), IBM Cognos Framework Manager, and IBM Cognos Packages.

Revolutionize the way you conduct business.

CONTACT US