Skip to main content Skip to main navigation Skip to search Skip to footer

BI Assessment study to identify TCO and road map to reduce TCO and maximize value

BI Assessment study to identify TCO and road map to reduce TCO and maximize value

Client

One of the world’s largest life insurance, pension groups and investment products Company.

Services offered

BI assessment for all the major BI systems to identify TCO and define roadmap how to reduce TCO and maximize value.

Domain

Insurance

Application environment

PL/SQL, Cognos, Informatica, VBA and Oracle

Location

US

Client background

The client was founded in 1983, headquartered in The Hague, Netherlands. The company has an international business, providing life insurance, pensions and other long-term savings and investment products to millions of customers around the world.

Business challenges

  • Not enough information on TCO and ROI
  • Lack of fact-based analysis on operational efficiency of systems
  • Difficult to move forward as every part of the client is at different stages of maturity level

HCLT solution

  • Identify cost hot spots for infrastructure and software
  • Phase out unnecessary environment
  • Reduce mainframe download costs and reduce unused databases
  • Merge databases, reduce storage costs and hosting extended hours
  • Implementations of promotions strategy and single ownership
  • Reviewed additional IM systems and unify it to a single environment
  • Addressed Metadata, data quality, master data and  retention issues
  • Architectural/ environmental consolidation
  • Creation of the business cases to move to a case-effective alternate technology stack
  • Set up of a BICC governance board and KPIs

Project challenges

  • Lack of operational data repository with strong business vocabulary, makes decommission process difficult and creates bottlenecks for faster cost optimization
  • There are more than 10 MS Access VBA-based application silos which need to be consolidated for single ownership and governance
  • All high cost elements in the resource list is due to disparate skills needed to manage the complex applications (i.e. PL/SQL, Cognos, Informatics, VBA and Oracle)
  • Informatica as a tool is not used optimally as many of the business rules lies in PL/SQL Blocks
  • Incident Management Systems data shows considerable amount of  Ad-hoc data requests with redundancy which can be automated to reduce cost

Benefits in business operations

  • Cost savings to the tune of 5-7% in the first quarter, 8-10% in the second quarter and 10-15% projected cost savings over the next 3 years

DOWNLOAD THE SUCCESS STORY

Contact Us
MAX CHARACTERS: 10,000

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.