CGI's Enhanced Client Experience through Efficient Data Migration to Digital Wealth Platform
Technology Category
- Application Infrastructure & Middleware - Data Exchange & Integration
- Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
- Buildings
- Finance & Insurance
Applicable Functions
- Product Research & Development
Use Cases
- Inventory Management
- Time Sensitive Networking
Services
- System Integration
About The Customer
CGI is a global business and technology consulting company with 77,000 consultants and other professionals across the globe. The company delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services, and intellectual property solutions. The Global Wealth & Capital Markets team sells proprietary software to large financial services clients. CGI’s Wealth360 solutions are designed to simplify and automate portfolio management, fund accounting, and fund allocation.
The Challenge
CGI, a global business and technology consulting company, faced a significant challenge in simplifying data migration when onboarding clients to their proprietary wealth management platform, Wealth360. The platform was designed to automate and simplify portfolio management, fund accounting, and fund allocation. However, the Data Migration and Conversion team had to develop new code for every data source, which could include up to 200-plus data files in various formats. This made the process time-consuming and complex. The team envisioned creating an automated ETL (extract, transform, load) data migration process that was based on a single, flexible, and reusable script.
The Solution
CGI deployed Pentaho Data Integration to automatically migrate data with a single, reusable script. They had been using Pentaho Data Integration to support its Wealth360 solution since 2016, initially using the Community Edition and then migrating to the Enterprise Edition as data volumes increased. In 2020, CGI enhanced its ETL capabilities with the solution’s MetaData Injection (MDI). The Data Conversion and Migration team uses the Pentaho MDI feature around once a week, either to onboard new clients or to update existing clients to the latest version of its wealth management platform. The solution provides reports so the team can reconcile source and target systems at a glance. CGI is also planning to improve its data migration capabilities with additional Pentaho Data Integration features, including using its reporting capabilities to create real-time dashboards that deliver continuous status updates.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Real-time In-vehicle Monitoring
The telematic solution provides this vital premium-adjusting information. The solution also helps detect and deter vehicle or trailer theft – as soon as a theft occurs, monitoring personnel can alert the appropriate authorities, providing an exact location.“With more and more insurance companies and major fleet operators interested in monitoring driver behaviour on the grounds of road safety, efficient logistics and costs, the market for this type of device and associated e-business services is growing rapidly within Italy and the rest of Europe,” says Franco.“The insurance companies are especially interested in the pay-per-use and pay-as-you-drive applications while other organisations employ the technology for road user charging.”“One million vehicles in Italy currently carry such devices and forecasts indicate that the European market will increase tenfold by 2014.However, for our technology to work effectively, we needed a highly reliable wireless data network to carry the information between the vehicles and monitoring stations.”
Case Study
Protecting a Stadium from Hazardous Materials Using IoT2cell's Mobility Platform
There was a need for higher security at the AT&T Stadium during the NFL draft. There was a need to ensure that nuclear radiation material was not smuggled inside the stadium. Hazmat materials could often be missed in a standard checkpoint when gaining entry into a stadium.
