Previous Work
Effective Consulting
Data Warehouse for Insurance & Assistance
Feb 2018
Collinson I&A historically merged multiple businesses and this bring lot of challenge in terms of heterogeneous claim and policy system and reporting. This project consist of two major phases, one is to migrate all the data from heterogeneous systems (Oracle, SQL, Automated data feed) into single place called repository (data lake) and another is to build data warehouse on top of it.
GC&C Data Integration
May 2015
This is an integration project which aims to bring the data (premium, Claim, and Movements) from multiple branches of Generali into data mart and Master data systems. Data is scheduled to be received via FTP every month in fixed-width flat files and transformed into downstream fact and dimension structures. Also, Business Partner repository has been created to uniquely identify business partners (customers, brokers and reinsurers) based on Dun and Bradstreet (D&B) data
GSO Report Migration (Travelers UK Insurance)
Sep 2011
This project focuses on integrating business reports which are maintained in Excel and MS Access and Business Objects. Migrating data into a single system involves challenges like format, redundancies, and different business terms for same metrics and so on.