Skip to content

Transform Technology Landscape For An Asia's Largest Insurance Giant

Industry:

  • BFSI

Service:

  • Sybase Migration

Client’s Location:

  • Hong Kong

About Client

A subsidiary belonging to one of the largest life insurance groups in Asia-Pacific, providing a comprehensive range of products and services, including medical, travel, and general insurance with over a century of operational experience in the insurance industry. They have presence in 18 markets in Asia-Pacific – wholly-owned branches and subsidiaries in Hong Kong, Thailand, Singapore, Malaysia, China, Korea, the Philippines, Australia, Indonesia, Taiwan, Vietnam, New Zealand, Macau, Brunei, Cambodia.

In the ever-evolving landscape of financial services, they have consistently strived to provide their customers with cutting-edge solutions for life and health insurance, continuously adapting to meet the evolving needs of their policyholders.

As technology continued to reshape the insurance industry, the Client - a true beacon of innovation and customer-centricity, recognized the imperative to stay ahead of the curve. The company was facing several pressing business pain points that required a dynamic and forward-thinking technology partner to address.

aia about client

The Requirements

Sybase Migration - To support Migration of Sybase to Azure SQL

Recognizing the need for scalability, performance optimization, and cost efficiency, Client made this decision to harness the power of Azure's cloud infrastructure. By migrating their critical data to Azure SQL, they aimed to ensure seamless access to data on a global scale, enhance application performance, and leverage advanced analytics capabilities. This migration not only aligns with their commitment to providing superior customer service but also positions them at the forefront of technological innovation within the insurance industry.

reas about client

The Solution

  • NTQ Solution employed Linux Shell scripting to parse thousands of SQL query plans, facilitating the migration process.

  • Conducted in-depth analysis of performance and runtime statistics, offering valuable insights into stored procedures/functions.

  • Provided troubleshooting and optimization solutions for Azure SQL and Linux/UNIX batch jobs.

  • Addressed resource consumption challenges on Azure SQL Virtual Machine.

Tech Stack

sql azure
bash
aws batch

The Results

We achieved substantial enhancements in application performance, query execution, CPU efficiency, and resource utilization. The Client's Project Team commended our effective technical solutions and deep expertise in SQL optimization, fostering trust and collaboration. We were also appointed to review solutions and support other client team members, demonstrating our commitment to knowledge sharing and teamwork.

aia the results

Open Gateway to Technology Excellence with NTQ Solution