Δ
Insurance
Business Automation Solution
Tableau, MS SQL Server, SSIS
The client is a full-service insurance and reinsurance company that offers different types of coverage to choose for third-party insurance agencies and platforms.
The company operates in several countries, and its enterprise data warehouse (EDW) stores historical data and reports from all of an organization’s business operations in a single, centralized platform acting as a backbone for data-driven decisions and operational efficiency. As more data was processed, the workload of the data hub infrastructure increased, and the need for scaling and optimization became a pressing matter.
The client approached NIX to join a distributed engineering team from different countries and redesign the architecture, making a difference using our proven experience with enterprise-level data solutions.
Due to an outdated technology stack, the client’s EDW was barely scalable and sustainable, necessitating a large team, enormous funds, and computing power effort to maintain and support the large data flow coming from all operational servers. The engineering team spent almost all of their time maintaining the EDW rather than optimizing and developing new functionality.
The daily EDW ETL processes exceeded the available load window, and the processing of new data took more than 48 hours, thus operating with obsolete information. Furthermore, data governance was limited—the lack of foundational capabilities such as an enterprise data dictionary and data lineage hampered both delivery and consumption.
Our solution architect started by conducting an in-depth audit of the existing EDW architecture to develop the roadmap for enhancements. To help the client increase the reliability of data and build a single source of truth, the NIX project scope included the following activities:
Optimize and enhance the on-premise enterprise data warehouse (EDW) operating with up-to-date data
Reduce report generation time and set up regular automated report submission to streamline the department’s operations process
The NIX team managed to reduce the load of the EDW and stabilize system operations by reinforcing the data management and optimizing ETL process. To improve the overall efficiency of an ETL process, we loaded data incrementally, broke down large tables into small ones, and used parallel processing.
We used an online analytical processing (OLAP) cube—a data structure that is geared to handle multidimensional data coming from the data warehouse and derive insights.
We set up the process of automatic report generation by making necessary changes in OLAP cubes—subsets of the data warehouse in multi-dimensional cubes provide a source of fast ad-hoc analysis for self-service users via drag and drop functionality.
For analytics, we updated the existing Microsoft SQL Server’s Analysis Services to SSIS SSAS—an online analytical processing (OLAP) and data mining and reporting tool used in business intelligence.
The NIX team also pioneered improved report management with custom calculations, automation capabilities, and more, for various departments within the client’s company:
As a result, the client received the ability to obtain all necessary reports without delay, thereby allowing business stakeholders to make data-driven decisions using up-to-date data.
The EDW was optimized to handle high loads and can now process new data in less than four hours, which is 12 times faster than before the system optimization. Moreover, enhanced capabilities of the reporting system streamlined operations between departments and allocated more time for higher-value activities.
11 experts (Project Manager, Solution Architect, Business Analyst, 6 .NET Developers, 2 Business Data Analysts)
MS SQL Server, PostgreSQL, Tableau, SQL, OLAP, SSIS, Pyramid
Multitask app that offers insurants to pay for sports products in installments and ensure their advanced customer experience abroad with helpful info
Microservice-based SaaS platform with a perfectly scalable architecture to provide services for over 50,000 insurance tenants and allows end-users to enroll, manage, and share benefit information more efficiently.
See more success stories
Our representative gets in touch with you within 24 hours.
We delve into your business needs and our expert team drafts the optimal solution for your project.
You receive a proposal with estimated effort, project timeline and recommended team structure.
Learn what Web 3.0 is and understand how this new concept of the internet is related to blockchain and cryptocurrency.
A product roadmap, also known as a product plan, is a great way to optimize your development process. Learn more about it right now!
Looking for a trusted MLaaS vendor? Choose the best one with our Amazon vs Microsoft Azure vs Google Cloud AI vs IBM Watson in-depth overview.
Software technical documentation is indispensable for every development project. The article introduces the benefits of tech documentation, its types, and the ways to create them successfully.
Find out more about top mobile development technologies, their pros and cons, and which ones will help you meet your business goals.
Learn how your organization can benefit from the ServiceNow virtual agent and learn the best practices to build a suitable chatbot for your business.
A business intelligence strategy is a roadmap that defines a company’s performance and improves it through data-driven solutions.
GCP offers services any business can benefit from, like AI, machine learning, data storage, and management.
To compete successfully, businesses must be able to extract value from data. Find out what business opportunities real-time analytics provides.
See more insights
Schedule Meeting