Developed Power BI solutions for Investments, Marketing and Data Quality functions. This involved ingesting, transforming, loading, modelling and visualising data using premium features. For example, using Power Automate to trigger Dataflow and Dataset refreshes.Prepared Lloyd’s Cyber Certainty Return. Created data quality reports to help underwriters and underwriting assistants monitor missing and invalid codes.Provided trouble-shooting support to various Power BI solutions to overcome performance, modelling and size issues using Dax Studio and Tabular Editor tools.Participated in key business change programs, including IFRS17 implementation and the accounts receivable target operating model.

Responsible for the strategic development, maintenance, control and reporting from the finance infrastructure, including Finance MI (a data warehouse) and Great Plains (the general ledger).Worked closely with IT and across the Finance department to integrate required systems into finance processes, identifying system requirements and contributing to design specifications.Recommended systems and process changes to minimise manual, time-consuming processes in the Finance department including automation.Provided training and technical advice on using Power Query, Power Pivot and Power BI to automate complex accounting and reporting processes.Participated in vendor request for proposal and proof of concepts for Coupa, a procurement to pay system, and Alteryx, a data wrangling tool.

Played a significant part in defining the strategy and creating the business case for the Finance Transformation Programme, which would allow the Syndicate and LSM US to use SAP S/4 Hana as an operational general ledger and lead to the introduction of Concur expense management tool and Swift banking integration.Contributed and influenced the vision and aspirations for the LSM Finance function by working closely with the senior leadership team and other finance team managers.Participated in Global Specialty’s Self-Service BI initiative, which lead to the formation of a Financial Reporting Centre of Excellence and the creation of training programmes for various Microsoft reporting tools, including Power Query, Power Pivot, and Report Builder.Designed and implemented the integration of summary financial data from Syndicate and LSM US general ledger systems into SAP, BPC & BI to facilitate group reporting, and to also uplift the data in Hyperion for corporate reporting purposes.Engaged in the preparation of Business Requirements Documentation for the enhancement of various system processes, participated in the documentation of system design & architecture and completed the user acceptance testing.Developed and maintained the monthly expense inter-company recharging & line of business allocations model.Supported the monthly financial close process by automating various journal calculation and reporting processes. Developed Excel Add-in for the Finance Team to support the distribution of Reference Data & Standard Reports, and to automate common tasks.

Managed the production of the quarterly management reporting information for the Insurance Global Risk and London Markets syndicate operations and its associated legal entities to provide quantitative and qualitative analysis to Insurance Segment Management and Corporate Finance team.Managed the development and production of the financial reports from the PeopleSoft and of the databases maintained within the US GAAP Reporting team to ensure the reports and variance analysis are complete and accurate.Standardised Currency revaluation and translation process within PeopleSoft for all XL legal entities as a part of the Financial Reporting & Control project. This included a formal presentation of the new processes and rules at the Global Controller conference.Worked closely with the Actuaries to stream-line the production journals from Actuarial Reserving recommendations to improve the reconciliations and reporting process.Managed the interface process between the GENIUS underwriting systems and PeopleSoft Financials, and provided support in the development of the interface process.Oversaw the preparation of our inter-company reports, and continue the on-going development of the inter-company matching tools.

My primary roles and responsibilities at Deloitte included testing internal controls and auditing the financial information for various clients. My specialisation was the audit of finance and accounting systems for financial institutions and retail electricity providers.