Enhanced DW Ecosystem with Cloud Migration for a leading European Insurance Company


About the Brand

The customer is a leading European insurance group, which provides different insurance products to over 30 countries, with key focus on Europe & Asia.

Business Overview

Majority of data intake was through delimited files coming from varied sources.

DW Integration to data sources was partially automated as in majority of cases data extracts were manually placed in folders, from where it’s picked up and processed through SSIS Packages.

Business Challenges

  • Managing data growth and performance was challenge
  • Lack of end-to-end integration was prone to human error 
  • Required a technology partner to carry out cloud migration 

Solutioning proposed by Espire

Espire assessed the business bottlenecks and suggested a two-step phase-wise approach to ensure incremental evolution of the DW ecosystem in cloud 

  • All existing data warehouse ecosystem was shifted from SQL Server to Azure Synapse
  • Network share on-premises was migrated to Azure Storage 
  • Data source file ingestion was automated to provide an efficient and secure way for source owners to send data to the customer
  • A front-end application was developed on .NET to enable internal/ external users to easily upload files. 

The following activities were carried out on Azure synapse: 

  • Setup Azure Storage as network share
  • Create Schema in Azure Synapse 
  • Migrate Database to Azure Synapse 
  • Move data from existing DB to Azure Synapse 
  • 22 SSIS packages to point Azure Storage Network share & Azure Synapse 
  • Deploy SSIS packages using cloud server

Business Benefits

  • Improved collaboration between departments & enhanced staff experience
  • The migration improved the automation of key business processes
  • Reduced the dependence on manual efforts 
  • Increased data backup & performance
  • Enhanced security of business data and assets 
  • Lowered the cost of operations 

Tools & Technologies

  • MSBI Stack – SQL Server, SSIS, SSAS
  • Azure

Download Case Study

RELATED CASE STUDIES

Creating an automated online voting platform for seamless onboarding and improved Voter Experience

One of the major challenges faced by the customer was - conducting the cooperative elections amidst the nationwide lockdowns in the US as casting votes on a piece of paper was neither safe nor feasible. Espire built an online voting application to integrate all the three existing ways of voting in one place including: Online voting (through a website), SmartHub voting (through single sign-on), Paper ballot voting (which includes data entry and verification)

Enhanced user query resolution with Microsoft Azure-based Chatbot for a Leading Australian University

A leading Public University with campuses across Australia and Internationally.This Australian University is ranked in the top two percent of universities worldwide by the Times Higher Education World University Rankings required a strategic technology partner to develop a self-service chatbot for streamlining systems and processes for optimal utilization

Successfully Carried out Cloud Migration for a Leading US-based Healthcare Organization

The customer specializes in creating and delivering patient obligation communications for healthcare revenue cycle management they were managing critical business data on-premises, which increased their capital and operating expenditure on physical infrastructure, that needed a technology solution to support application scalability and disaster recovery also required a strategic technology partner to carry out dataset movement from on-premises to AWS

Designed a scalable Analytics and BI Platform for a leading UK-based Mutual Insurance Company

The client is a leading UK-based mutual insurance company, which provides general insurance products to the members of the trade union and other not-for-profit organizations. Due to the constraints of their existing legacy architecture, they were looking a modern web-based architecture which could seamlessly integrate with multiple in-house applications being used by their different departments.

Top 5 benefits of digital insurance fast track your digital journey and bolster growth in 2022

Digital Insurance has empowered the insurance and reinsurance industry streamline key business operations like premium calculations, claims management, customer communications and customer data storage etc, thereby enabling leading companies to deliver unmatched customer experience, business experience, employee experience, multiexperience and user experience at scale

Delivering total experience in the insurance sector with scalable legacy transformation

Overhauling the legacy core IT infrastructure and adopting cloud-based solutions has become a must for insurance companies to reap the benefits of true digital transformation. Businesses in the insurance sector should adopt Total Experience solutions to craft impeccable customer experience, business experience and employee experience to bolster growth in the new normal.

7 strategic technology trends for business to unlock growth in 2022

Gartner's Strategic Technology Trends for 2022 provide businesses a deep insight and understanding of futuristic technologies that are necessary for building resiliency and achieving sustainable business growth. Espire is helping businesses across industries achieve total experience at scale and attain true digital transformation to bolster business growth.

Fast track your cx transformation with cloud migration

To accelerate CX transformation, businesses need to eradicate disparate legacy systems and deploy agile cloud or hybrid cloud solutions. Cloud migration can help brands accelerate their Customer Experience transformation and deliver Total Experience solutions at scale.