Swiss Insurance company

Creating automatic reporting tools through data centralisation, eliminating tedious and repetitive tasks anc increasing quality of reports

Challenge

• An insurance company creates quarterly financial reports. They were manually extracting data, exchanging it via emails back and forth for aggregation in Excel and further validation

Solution

• Ingestion of the source data to the data lake and implementation of the pipeline to validate and clean the data.
• UI application was built to streamline the process reporting process by giving access to all parties and allowing modifications if necessary

Impact

• Eliminated the repetitive and tedious manual process, reducing the amount of time needed to create reports
• Improved the quality of reports by reducing the margin of human error