MS SQL – Financial Services – Custom Development – Success Story

Client Overview

The client is a US based emerging markets private equity firm, focused on investing in small and medium-sized businesses, transforming them into significant and enduring regional operations, which deliver strong and consistent returns for both themselves and the investors.

Business Challenge

  • The client wanted to improve its business operations and be able to react to market trends quickly

  • For this, the client needed new business intelligence tools that could access information faster and provide more detailed reports to managers. Its previous reporting system did not provide the detailed level of reporting or analytical capability that the users needed to make business decisions.

Technical Requirements

  • Microsoft SQL Server Analysis Services and Reporting Services

Solution Strategy

  • The client partnered with Eternus Solutions to implement a new system

  • Eternus Solutions team worked with the client’s Subject Matter Experts (SMEs) and finalized the design and plan for the system implementation

  • Being a standard development project, standard project lifecycle was carried out

  • Eternus Solutions reviewed the client’s business objectives and worked with the client to implement a new analytical system based on SQL Server 2000 Analysis Services with SQL Server Reporting Services as the Reporting tool

  • Daily transactional information was loaded at each branch, which was consolidated at the head office on a weekly basis. Reports were then available to managers for more insightful business decisions.

  • The users could easily identify trends and target areas of improvement. Furthermore, users can slice, dice and view multidimensional information relevant to them using Online Analytical Processing (OLAP) cubes.

Implementation Details

  • Import data from multiple formats into MS SQL server using SQL jobs

  • Implemented SQL Server Reporting Services as the reporting tool

  • Push the data to reporting tables

  • Prepare cubes of data

  • Implemented new analytical system based on SQL Server 2000 Analysis Services

Share This Case Study