Experience

Titles Queensland
• Australia
• Legal Services
• 1 - 100 Employee
• Data Reporting Analyst

  • Aug 2022 - Present


Equiniti

• United Kingdom
• Financial Services
• 700 & Above Employee

• Pensions Data Analyst

  • Aug 2020 - Jul 2022

  • Producing and maintaining workflows and letters for Compendia Touch pension schemes • Updating Member Self Service websites for pension schemes using Umbraco • Creating tools to inspect and maintain SQL database tables using MS SQL Server Management Studio • Producing and maintaining workflows and letters for Compendia Touch pension schemes • Updating Member Self Service websites for pension schemes using Umbraco • Creating tools to inspect and maintain SQL database tables using MS SQL Server Management Studio



ITM - Independent Data Consultants

• United Kingdom
• IT Services and IT Consulting
• 100 - 200 Employee

• Data Analyst

  • Nov 2018 - Aug 2020

  • Reconciling GMP data using scripts designed in MS SQL Server Management Studio • Creating stored procedures and functions for use in processing HMRC responses • GMP rectification of pension amounts rolling forwards and rolling back reconciled figures • Reconciling GMP data using scripts designed in MS SQL Server Management Studio • Creating stored procedures and functions for use in processing HMRC responses • GMP rectification of pension amounts rolling forwards and rolling back reconciled figures

• Pensions Data Analyst

  • May 2010 - Nov 2018

  • Building MS Access and MS Excel tools used to produce benefit statements, pension saving statements, valuations and ad hoc reports, across a range of DB and DC pension schemes. Updating existing tools to improve accuracy and efficiency • Responsible for annual pension increases for various schemes, reconciling old elements and ensuring new elements are loaded correctly • Responsible for one off projects, such as bulk record data cleanse, data migration, pension calculation changes • Building MS Access and MS Excel tools used to produce benefit statements, pension saving statements, valuations and ad hoc reports, across a range of DB and DC pension schemes. Updating existing tools to improve accuracy and efficiency • Responsible for annual pension increases for various schemes, reconciling old elements and ensuring new elements are loaded correctly • Responsible for one off projects, such as bulk record data cleanse, data migration, pension calculation changes