Financial Services

SQL Server

Trailblazing Pilot Project Launches Multinational Asset Manager’s Digital Transformation

The Company 

For money management firms, making the most of every dollar is critical to maintaining a good reputation with customers. 

For one global finance leader, this was especially true; from wealth management to life insurance, this firm was directing trillions of dollars in customer assets. To earn — and keep — their customer's trust, this company needed help finding a solution to streamline reporting process and cut costs.

That’s one of the reasons it turned to BlueGranite to rework a reporting solution that fell short of delivering on its original goals – cutting costs and streamlining reporting.

AdobeStock_203084352

The Challenge

In an effort to eliminate wasteful reporting against the company’s mainframe, the company’s IT branch designed a solution to prove use internally. The original design utilized expensive software created to perform sophisticated visual analysis. 

Unfortunately, once deployed, the software was not meeting the business users’ requirements, and users continued to extract Excel data that they didn’t need to visualize. These hundreds of users pulled datasets onto their personal machines and massaged it in Excel before forwarding it on to either a financial advisor or another department.

In addition to the initial solution’s unnecessary expense, its challenging architecture meant it didn’t work as intended. The system resulted in misaligned  architecture that was hindering company performance. 

The Pilot Solution

As part of the initial engagement, the financial giant asked BlueGranite to design a new front end on top of their existing solution to help users access the necessary data. 

Once the new front was designed, it was clear  a complete overhaul would better serve users. To that end, BlueGranite also put together a new, complimentary back-end proof of concept for the company to test out.

The Engagement Grows

The company’s original design used a distributed architecture — the wrong technology for the task it needed to perform. BlueGranite’s experience with various Modern architectures, across different technology stacks, allowed them to remove bias and provide the best technology for this particular use case. 

BlueGranite  was able to implement Microsoft SQL Server – a relational database management system— and SQL Server Integration Services to ease data migration and integration. The addition of Power Query allows users to seamlessly access data and transform it in Excel.

The Results

BlueGranite created a secure, affordable, and easy data access solution for this company, as well as an effortless pathway to transition to the cloud — a move that could reduce operational costs and increase scalability. 

Additionally, BlueGranite was  able to implement a near real-time systems process that ingests, stores, and optimizes new reports, and creates additional metadata surrounding them, allowing fluid user interaction.

Wondering how we can help harness the potential of your data? Contact BlueGranite today. We’d love to help you explore the possibilities.

TECHNICAL OVERVIEW


  • BlueGranite implemented Microsoft SQL Server – a relational database management system to store and retrieve data – for an arm of a financial giant struggling to access its statistics.
  • We used SQL Server Integration Services to ease enterprise-level data integration.
  • We designed the solution to be easily transferable to the cloud

A CLOUD-SCALE APPROACH TO DATA WAREHOUSING, DATA LAKES, AND ANALYTICS

Modern Data Platform Solutions

LEARN MORE