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.

Claims dashboard mock-up in Tableau 10


Policy / Claim search tool built using Excel 2010

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:



Jira - Sun Diagram

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.