It has been correctly said, “Anything worth doing is worth doing right.” Business Intelligence (BI) solutions enable organizations to make the best possible decisions to improve business practices and profitability. While implementing BI solutions is a concrete step to success, it is not enough. Organizations need to ensure that their BI solutions are of the highest quality.

As one of the largest insurance companies in the U.S. with over USD 4 million in revenue, Nuvento’s client had implemented endto-end BI solutions for managing its extensive business. The company offers insurance and financial services products across 41 states with a client base of more than 15 million customers and close to 20,000 employees. However, to gain significant competitive advantage, the client needed to ensure the quality of its data and operations matched the best in the business.

Nuvento partnered with the insurance company to deliver its Quality Assurance solutions, ensuring that the BI solutions deployed met the business organization’s requirements.

  • There were over 35 lines of business that needed quality data for accurate reporting.
  • High volumes of data amounted to more than 6 terabytes covering claims, payment, audits, surveys, third party integrations etc.
  • The client did not have any QA infrastructure or tools available, even though heavy investments had been incurred for implementing the BI solutions.
  • There were high levels of data change impacting the company with the new BI applications. This led to a high demand of testing requirement at every stage of the project.
  • There was a need for high amounts of regression testing with more than 2500 test cases per release. It was essential to ensure that no additional errors were being created while fixing the existing once.
  • While the organizational business was undergoing complex transformation, compliance and regulatory obligations had to be met.
  • The increase in the number of users using organizational information, could lead to potential performance bottlenecks in the system.

During the last three years Nuvento has successfully built a strong QA structure for the insurance client. Nuvento’s approach was to first provide agile and cost –efficient solutions, enhancing this with advanced technologies and frameworks over a period of time. Nuvento adopted the combination of the offshore and onsite delivery model.

2008

  • Jump started QA operations by using existing Nuvento solutions that were cost efficient and easily replicable, in the client’s technology environment
  • Started working with the business team to enable risk-based testing
  • Managed data for more than 16,000 users covering 35 lines of business
  • Nuvento implemented unit testing, integration, system and regression testing activities

2009

  • Enhanced data quality analysis and testing, using SQL Server 2005. This provides a comprehensive data-management platform:
    • Integrating the development, management, and operations of relational data
    • Extraction, transformation, and loading (ETL)
    • Online analytical processing (OLAP)
  • Implemented Nuvento’s flagship product BI Report Center to analyze data in cubes using SQL Server Analysis Services (SSAS)
  • Successfully implemented analyzers and cube based reports. This provided the client with easy to use and self-service BI   solutions

2010

  • Nuvento implemented its proprietary TaskBolt methodology for Project Management using Project Open. 
  • Implemented Oracle Business Intelligence Enterprise Edition (OBIEE) Scorecards for 35 lines of business across the organization.
  • Business users could now create interactive dashboards, ad-hoc queries, scorecard and strategy management and much more.
  • Transitioned existing scorecards into new generation reporting platform.
  • Built the prototype for future customizations including executive dashboards

Process:

  • The client now has an end-to-end QA system using Open Source products. 
  • The use of risk based testing concepts reduced the overall effort by 40%.
  • There was 100% auditing of results and complete adherence to any quality guidelines.
  • All projects were implemented with a 97% or higher quality rate. 
  • Nuvento was able to quick provide QA solutions with cost-efficient frameworks and replicable components. 

 Cost:

  • The client had an estimated cost benefits of USD 750,000 per year over a period of 3 years.
  • Zero cost was incurred on licenses while implementing testing solutions. The insurance company saved more that USD 100,000 per year. 
  • Offshore and onsite delivery model achieved cost savings of more than 50% from the current model, amounting to more than USD 500,000 in savings.
Insurance-BI