1996 to 1998 ~ SAS Contractor
- As part of the Management Information Team, designed and developed insurance data warehouses and delivery systems, following client standards on production change control and implementation.
- Designed a multi-dimensional data model as the basis for implementing a claims data warehouse.
- Investigation of legacy systems for extraction to existing data warehouses.
- Design and development of key components (including reconciliation to source systems) on both claims and policy data warehouses.
- Production data fixes applied to DB2 systems using SAS and SQL.
- Design, implementation and provision of production data files for analysis and reporting for the purpose of product pricing.