Greg Heath Email & Phone Number

Sydney, NSW, AU

Sydney

• Deliver an ETL solution for producing AASB17 accounting standard model point files.
• Developed ETL processes for six insurance books, transforming data in the BIRDI data warehouse to the model point file format, meeting all deadlines.
• Introduced and implemented unit testing for complex calculation for Reinsurance Proportion and Reinsurance Factor as well as other key risk areas.
• Developed system testing for the net reinsurance premium report, validating over 20 fields against a known gold dataset. This proactive measure enhanced quality and saved finance time on reconciliation.
• Performed data issue resolution working closely with Finance to explain and resolve data issues.
• Conducted data quality checks using a Data Quality Tool, escalating issues to actuaries. This improved data quality, saving the business time and money by preventing errors in data provided to KPMG.Upgrade Data.

Sydney, New South Wales, Australia

• Database Development – Develop Data warehouse and reporting systems.
• Designed and implemented denormalized OLAP models for the data warehouse resulting in fast consistent data sources and a reduction in query load on the OLTP database.
• Enhanced the data warehouse design including star data models using SSIS and SQL.
• Introducing exception reporting for monitoring data quality resulting in data being fixed quickly improving both process and data quality.Database Administration – Manage database systems ensuring availability.
• Managed Microsoft SQL servers by implementing monitoring, alerting and robust maintenance procedures resulting in improved system performance and uptime.
• Installed and upgraded SQL Server 2014 database servers migrating databases, SSIS jobs and SSRS reports from SQL Server 2005 to SQL Server 2014 servers.

• Key Responsibilities
• Design technical solutions to meet the operation demands of the business.
• Analyse and implement database performance improvements to psychological call management software.
• Design and implement reporting solutions to reporting improve performance in a rapidly growing environment.
• Manage SQL Server database servers and systems ensuring system availability, performance, recovery, system upgrades and patching.Achievements.
• Enhanced application database performance of SQL Server 2000 and 2005 in a demanding 24/7 environment improving all interface requests to below 1 second.