Brendan Colgan

• Leading the transition of Insurance financial reporting to a strategic solution using Qlik Sense & Tableau
• Using BigQuery to transform and load various data sets
• Leader in design and development of 4 major dashboards hosted on Google Cloud Platform
• Detailed ETL used to ensure data pipelines had structured, populated data

Key Achievements

• Actuarial and financial teams now have a single source of truth for financial reporting
• Users now have the time to comment on their analysis rather than spending hours creating throw away monthly reports through availing of user story functionality in Qlik Sense

• Leading the transition of Insurance financial reporting to a strategic solution using Qlik Sense and Power BI
• Using BigQuery to transform and load various data sets
• Leader in design and development of 4 major dashboards hosted on Google Cloud Platform
• Applied three-tiered loading approach using extraction, transformation, and presentation layers
• Key Achievements
• In-house systems had tangible relationships between them through creation of data models
• KPI reporting could be measured at the most granular level instantly, rather than spending hours trying to mesh a myriad of spreadsheets
• Nominated for “making a difference award”, in cross-functional regulatory reporting team for a high-profile remediation project, analysing commodity delta risk
• Extracted large amount of data sets from Oracle and MS SQL databases
• Use to assess high-potential anomalous commodity delta risk
• Application analysed external historical indices and compared commodity deltas to historical NWM reporting
• Strengthened communication base with CFTC for ensuring timely delivery of back-reporting
• Key Achievements:
• Reduced commodity delta risk analysis time by 50% through introducing dynamic dashboard thresholds for daily risk movements
• Outcome meant the team could automatically filter out any minor which was a key driver in ensuring submission of reports to the CFTC deadline and fine imposed was minimal.

• Counterparty Risk, Investment Banking, Utilized highly effective financial models in accordance with new Basel framework for creating BI solutions to present capital requirements for Quantitative Impact Study (QIS)
• Implemented best industry practices for remodeling of an existing Tableau application to produce counterparty risk metrics

Key Achievements

• Dashboard enabled QIS study reports to be produced 30% quicker than previous submission
• Results were submitted to regulatory body – the analytics played key role in helping ExCo members get understanding of submission data through drill down capabilities.

• Lead BI analyst in cross-functional regulatory reporting team for a high-profile remediation project, analyzing commodity delta risk.
• Extracted large amount of data sets from Oracle and MS SQL databases.
• Used to assess high-potential anomalous commodity delta risk
  Strengthened communication base with CFTC for ensuring timely delivery of back-reporting
  Key Achievements
• Reduced commodity delta risk analysis time by 50% through introducing dynamic dashboard thresholds for daily risk movements
• Reporting meant that remediation figure was substantially smaller than it could have been due to timely reporting with CFTC

• Development of reporting tool for Equities markets, providing daily trade information to traders using Qlikview
• Documenting and implementing requirements from front office trading team to produce dashboards with meaningful metrics
• Implemented automated reporting, delivering over 1,000 one-pager scheduled client reports using NPrinting
• Key Achievements:
• Designed an innovative application used by over 500 Natwest Market employees
• Introduced and deployed an automated reporting system for delivering more than 1,000 one-pager scheduled client reports while using NPrinting
• Sales team had instant data on clients.