All Case Studies

Modernizing legacy reporting on cloud

A US-based global pure play payments company modernized its legacy BI application with a custom reporting and visualization app on cloud to serve more than 100,000 merchants.

5/5

customer rating

5/5 Customer Ratings

10x

Increased performance

5x-10x increase in query performance

1

Unified channel

An omnichannel user experience

Increased global revenue

Overall cost Reduction

Better decision making

OVERVIEW

Migrating legacy BI applications to cloud comes with its own sets of challenges that require an innovative customization approach to embed desired functionalities that can offer a seamless and engaging user experience.  

A leading pure play payments company based in the US faced similar issues during its migration of on-premise BI application to Google Cloud Platform (GCP). Bitwise helped create a customized solution on top of Looker and GCP that powered the client’s ‘cloud-first strategy’ goal with a best-in-class customer engagement platform to enable secure, self-service analysis in real-time along with other functionalities. 

CHALLENGE

As a global payment processing company, the client serves merchants across the globe with a broad range of innovative software and services which involves securely handling large volumes of data. To improve customer experience, the client made a strategic decision to migrate all its on-premise applications to GCP including its legacy BI application for merchants to reconcile payments using various tabular reports and dashboards which also helped in making business decisions. 

The client’s existing legacy BI application posed various challenges in terms of costs, performance, and user experience which required a custom reporting and visualization tool which helped its customers to better manage their accounts and deliver an omnichannel experience. 

Now, building this customized tool required solving the following challenges: 

  • Align the solution with CIO’s goal for a ‘cloud-first strategy’ and ensure it fits well in GCP strategy 
  • Meet stringent business timelines for migration 
  • Create a best-in-class engagement platform with embedded BI for customers  
  • Employ a multi-cloud strategy, but use GCP for the embedded solution
  • Select a non-batching option for disparate data sources and real-time data  
  • Create self-service for their customers 

THE CLIENT PERSPECTIVE BEHIND THE PARTNERSHIP

The client looked for a technology partner who had a rich experience in offering complex data and cloud solutions with a nuanced understanding of security practices to manage such highly confidential data.  

Bitwise with its extensive expertise in data management and data security built a custom app that successfully enhanced the client’s cloud migration goal with a custom functionality to help customers easily and quickly understand different transactions. 

Here are the core advantages that were considered: 

  • 22+ years of strong experience in Data & Cloud 
  • Expertise in legacy migration and modernization  
  • Agile methodologies 
  • Expert talent 
  • Strong customer experience insights

OUR APPROACH: ENABLING A SEAMLESS MULTI-CHANNEL EXPERIENCE

Bitwise built a custom reporting and visualization app on top of GCP and Looker that enables a superior engagement platform with embedded BI for the end-user merchants.  

The solution worked in the following manner: 

  • It streamed data from BigQuery to customers in real-time scale and used custom tokens to deliver the right data to the right user depending on company and persona 
  • It enabled different functionalities for different departments 
    – Accounts use card summary reports to address escalations as total sales are easily identified by card brand 
    – Money room managers use the merchant portal to help quickly identify transitions and improve their team’s operational efficiency 
    – IT managers find customer reports useful for identifying sales vs. refunds. It improved query performance and time with custom partitioning for BigQuery  
  • It stored and retrieved data with BigQuery nested table 

HOW THE BITWISE SOLUTION ALIGNED WITH THE CLIENT VISION

The solution designed by Bitwise met the client’s stringent business timelines, offered an evolved customer experience and powered the cloud migration goal with complex customized features. 

The key benefits that were identified: 

  • Improved scalability for all segments, from SMB to Large enterprises  
  • Secure self-service analysis in real-time 
  • Embedded BI 
  • Improved operational efficiency  
  • Omnichannel user experience through smart UI/UX 
  • Comprehensive reporting 
  • Support for highly customized APIs for everything  

TRANSFORMATION THAT FOLLOWED

The customized solution by Bitwise delivered exceptional customer experience, eliciting 5/5 customer ratings along with spontaneous appreciation from merchants. It also helped achieve the client’s vision to facilitate cultural change among end-users adapting to the new cloud-based application. 

TECHNOLOGY

Relevant Case Studies

This is a center of discovery and innovation where businesses can enable themselves with the latest insights and perspectives from technology experts to stay relevant in a competitive environment.

RELEVANT Reads

Data Governance in Insurance Sector: A key to building customer golden record

Perspective | September 9, 2020

Data Governance in Insurance Sector: A key to...

In the past decade, market penetration by Indian insurers was marked at lower single digits despite the…

Read more

Self-service BI and Dashboards

Perspective | August 7, 2020

Self-service BI and Dashboards

The rapid advancement of technology over time has propelled the evolution of Data Warehouses and…

Read more

Legacy Modernization: When is the right time for the upgrade?

Perspective | June 22, 2020

Legacy Modernization: When is the right time for...

The Covid-19 pandemic has put a sharp focus on remote-working culture, creating a highly digital and contactless…

Read more