Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Case Study

Web Based Application Solution for a Leading Financial Firm

Whom we worked with

Our customer offers competitively-priced financing, community development grants, and other banking services to help member financial institutions make affordable home mortgages and provide economic development credit to neighborhoods and communities.

Our Solution

  • Created separate physical Essbase databases for each product while having a commonly maintained outlined, calculations scripts, and Excel utilities
  • Included functionality-Index/ Match in the product’s database to allow calculations for any product revenue
  • With this functionality, the investment firm was allowed to decide how each account is calculated
  • Created product reports via data mining from Hyperion Essbase
  • Build a separate corporate database with a replicated partition to the individual product databases
  • Trained Investment Managers to create reports as per the needs

Challenges

  • To reduce the different reporting requirements in each of the product
  • In-sync of primary business hierarchy of all the products
  • To reduce the Application development time and support for creating separate applications for each product
  • To reduce the cost on the training and planning administration to monitor each product’s success

Impact

  • Reporting requirements of each product was reduced by 49%
  • With the in-sync functionality, primary businesses were in hierarchy format with clean UI
  • Cost on the training and planning was reduced by almost 70%

How we helped

  • Sun Technologies executed assessment, estimation and Proof-of-Concept (POC) to work on the Forecasting and Solution
  • Impact Analysis carried out and Planning objects to forecast were identified
  • Planned to create SSIS packages to generate flat files to re-map old data and load the actuals