US Based Large Investment Firm

Our US based large finance domain client having more than 1000 of customers was using Oracle Hyperion as an enterprise wide reporting system, As oracle decided to retire Hyperion and its services, we worked as technology partner with a large client and successfully migrated entire Oracle based reporting system to enterprise wide microsoft self service data analytics solution.

There were significant challenges and limitations which we overcome effectively and build robust solution -

Customer listed under stock exchange so data sensitivity was a big concern, we delivered on premises solution using SQL Server and designed a perfectly modeled Data warehouse with fine grain measure which allows the customer to get any data information and can be sliced and diced to get any data view.

There were more than 150 complex reports which we developed on PowerBI. We have designed pre-calculated measures and facts which users can use on their own to build or enhance reporting without IT intervention.

We have successfully deployed detailed and PDF based reports to PowerBI services which developed using SQL Server Reporting Services.