Portfolio

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
Claims dashboard mock-up in Tableau 10

  claims-search-tool

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.

data-dictionary-img

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:

Assyst_Queue                        

        

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.

jira-screenshot2


Certificates

Copies of certificates I have attained can be found here.