Claims Data Mart
At CNA / Hardy I developed a claims data mart, conforming Companies Market data with Lloyd’s syndicate data. Working in an agile fashion I delivered some reports in Excel & Tableau early on in the project to inspire some ideas and get prompt feedback.
Data Dictionary w/ Search Functionality
Also at CNA Hardy, I put together a data dictionary for a premium rate monitoring system I looked after. It was created in Excel and had a search facility built in. With around 250 calculations and attributes it made understanding and troubleshooting a lot easier.
The tool can be seen here
Service Desk & Jira Data Marts
Whilst at Catlin I developed some data-marts, cubes and reports for our helpdesk (assyst) and issue management (jira) applications. The solution involved summary reports with drill-down functionality. Below is a sample of the reports:
Data Warehouse security audit
Again at Catlin I produced this whitepaper to get security under control and implemented in a predicatable and consistent way.
It should be noted that the supporting documents are not available and there is no sensitive information contained within this document.
Implementing Jira to replace spreadsheet issue tracking
At Aerion, I setup a cloud-hosted Jira instance for recording both BAU and project work.
Copies of certificates I have attained can be found here.