Select Page

Case Study

SOM Accelerator reduced the manual efforts by 60-75% as compared to traditional methods.

Client Background

The client is a diversified, multi-national FORTUNE® 50 health insurance provider in the US which offers various health insurance plans under Medicaid, Medicare and commercial lines of business.

Client Need

  • Define the scope of the program after analyzing the existing legacy system, without causing any hindrances to operations.
  • To support the growth and scalability projections and to better align with future state enterprise architecture, needed to migrate the following to Oracle Exadata:
    • Legacy data with iterative loads in different phases of the project for 2000+ tables.
    • Application .NET code and active services including ETL, Reporting related objects for more than 200+ applications.
    • Database objects with 1800+ artefacts.

Our Solution

  • Analyzed the list of applications active in Sybase, identified dependencies, and performed impact analysis.
  • Utilized SOM Accelerator For DB objects and schema conversion which reduced the manual effort by about 60-75%.
  • Analyzed the .NET and VB applications and converted so ensure compatibility with Oracle.
  • Performed integration testing and automated the validation using custom applications and ETL jobs.
  • Utilized SOM accelerator for extraction, transformation, and loading of data from Sybase to Oracle with the added functionalities of notifications, failover and auditing mechanism.
  • Automated validation of data through SSIS Packages. Migrated ~11 TB in 45 hours for 2000+ tables.
  • Migrated DataStage Jobs and WebFOCUS reports from Sybase to Oracle
  • Implemented CI/CD for deployments across various environments and validating the applications.

Key Benefits

  • Successfully completed the migration before the open-enrollment period.
  • Post-completion of Sybase to Oracle migration, improved the performance of the applications by 20%.
  • Automated code conversion to successfully reduce manual effort by 60-75%.
  • The SOM accelerator creates developer-friendly manual intervention runs to identify the exact changes and code block for further changes.
  • Enabled developers to easily inspect areas that need manual intervention and modify the code accordingly.
  • Increased the scalability to the core platform to easily integrate with future state architecture changes.

Tools & Technologies

Sybase
Oracle
IBM DataStage
Python
.NET
VB.NET
WebFOCUS

Services

Digital Product Engineering

Cloud Services

Data & Analytics

AI and Automation
Cybersecurity
Modern Managed Services

Build Operate Transfer

Innova Orion GCC Services

Talent Solutions

Industries

Communications & Media

Government Solutions

Healthcare, Life Sciences,
and Insurance

Banking & Financial Services

Energy, Oil & Gas and Utilities

Hi-Tech

Retail & CPG
Manufacturing

Travel & Transportation and Hospitality

Partnerships

AWS

Automation Anywhere

Databricks

Google

IBM

Microsoft

Pega

Salesforce

SAP
ServiceNow

Snowflake

Uipath

Innovation @ Work

Blogs and Insights

Research and Whitepapers

Case Studies

Podcasts

Webinars & Tech Talks
US Employment Reports

Company

About Us

Leadership Team

Strategic Partnerships

Office Locations

Newsroom

Events

ESG

The Innova Foundation

Careers

Explore Open Positions

Life @ Innova Solutions

Candidate Resource Library

Let's Connect