Extract, Transform, and Load (ETL) involves extracting data from often a number of different systems, transforming it to fit business needs (which can include quality levels), and loading it into the data warehouse. ETL can also be used for the integration with legacy systems.
Moore Stephens has experience of extracting data from a number of insurance systems including:
- Intech solutions
- Xchanging
- SICS/nt
- CGIRoom
- Sirius
- SUN Systems.
Project examples
Leading insurance intermediary
We built two data warehouses to support the broking and underwriting divisions of the business. Due to extensive acquisition the group comprised over 100 companies running on around 30 different systems. We extracted the information from all these systems and loaded it into a centralised data warehouse. This solution enabled the client to have standard, consistent reports and one view of the business.
Specialist insurance company
We implemented three solutions for the insurers finance department - a budget and forecasting model, cash flow model, and one for expenses. Data warehouses were created using SQL Server 2000 to extract, load and transform data stored in excel spreadsheets and tables held in Agresso. Analysis Services 2000 was used to build cubes with IntelligentApps as the front end reporting tool.
Speciality insurance and reinsurance company
We developed a solution to extract and transform data from their own catastrophe risk management tool (CATMan system) for their actuarial department. This involved building a data warehouse solution, using SQL Server 2005 and SQL Server Integration Services (SSIS). A Microsoft .NET desktop application was also developed to view and update the transformed data.