01/24/2024 updated
SM
100 % available
Financial Planning & Analysis Manager, Financial Planning & Analysis Consultant
United Kingdom
Worldwide
Accounting and financeManagement and Business ConsultingSpreadsheetsDatabasesFinancial PlanningOperational Data StorePower BIAnaplanSAP ApplicationsData StreamingData ProcessingVba Programming LanguageQlikviewMultiplatform
FP&A Anaplan, data manipulation, data flows, data flow, database, Excel, multi-platform, operational data, Microsoft Power BI, Power BI, Qlikview, SAP, spreadsheets, spread sheet, VBA
Languages
EnglishNative speaker
Project history
* Continued FP&A support as lead business partner for Marine, Energy, Aviation and Financial Political Risk
* Selected to lead the transition of the Bermuda underwriters into the London FP&A team from the US team
* Integrated and implemented the London FP&A blueprints and structure into the Bermuda underwriting team
* Built relationships with underwriters to explain underlying operational & financial performance
* Business partnered and upskilled Bermuda Underwriters on knowledge gaps of financial performance
* Partnered with the US Operations and FP&A team to understand the complex MI landscape
* Identified differences between US and London FP&A reporting and communicated to the underwriters
* Articulated the complex MI landscape to underwriters to explain how data flows end to end in a financial close
* Built MI capabilities in Power BI, excel models and dashboards to bridge operational and financial data to
understand underlying drivers of profitability and key performance metrics
* Upskilled and trained the Bermuda underwriters to use the London FP&A Anaplan planning tool
* Populated and data mined historical operational and financial performance of Bermuda underwriting activities to
understand trends and business performance
* Performed deep dive class analysis to understand key drivers of suboptimal financial performance and
communicated concerns to the London management team
* Selected to lead the transition of the Bermuda underwriters into the London FP&A team from the US team
* Integrated and implemented the London FP&A blueprints and structure into the Bermuda underwriting team
* Built relationships with underwriters to explain underlying operational & financial performance
* Business partnered and upskilled Bermuda Underwriters on knowledge gaps of financial performance
* Partnered with the US Operations and FP&A team to understand the complex MI landscape
* Identified differences between US and London FP&A reporting and communicated to the underwriters
* Articulated the complex MI landscape to underwriters to explain how data flows end to end in a financial close
* Built MI capabilities in Power BI, excel models and dashboards to bridge operational and financial data to
understand underlying drivers of profitability and key performance metrics
* Upskilled and trained the Bermuda underwriters to use the London FP&A Anaplan planning tool
* Populated and data mined historical operational and financial performance of Bermuda underwriting activities to
understand trends and business performance
* Performed deep dive class analysis to understand key drivers of suboptimal financial performance and
communicated concerns to the London management team
* Led the development of transforming monthly reporting, planning and analysis activities
* Delivered a platform for monthly FP&A activities utilising Power BI technology which was recently installed
* Encouraged the utilisation of TM1 as single point version of the truth and avoid databasing via spreadsheets
* Designed cube structure/workflows and liaised with external TM1 consultants to help build the environment
* Supported the development of automatic data feeds from TM1 into Power BI
* Led the development and process enhancement of planning and forecasting activities
* Performed a detailed process review and eliminated redundancy and duplication in the BAU activities
* Harmonised processes combined with standardisation across all activities to allow for automation via VBA
* Reengineered processes provided an opportunity to understand underlying performance in a highly complex MI
landscape
* Delivered a platform for monthly FP&A activities utilising Power BI technology which was recently installed
* Encouraged the utilisation of TM1 as single point version of the truth and avoid databasing via spreadsheets
* Designed cube structure/workflows and liaised with external TM1 consultants to help build the environment
* Supported the development of automatic data feeds from TM1 into Power BI
* Led the development and process enhancement of planning and forecasting activities
* Performed a detailed process review and eliminated redundancy and duplication in the BAU activities
* Harmonised processes combined with standardisation across all activities to allow for automation via VBA
* Reengineered processes provided an opportunity to understand underlying performance in a highly complex MI
landscape
* Lead Business Partner for Marine, Energy, Aviation and Financial Political Risk
* Maintained & built relationships with underwriters to explain underlying operational & financial performance
* Took lead on the validation of commercial reality reflected in the financial result
* Provided forensic accounting services to understand data flow, processes & controls in a complex MI landscape
* Alleviated transparency restrictions on the financial close process in a highly complex MI environment
* Produced a walk from operational to financial data, articulating issues within the financial close process
* Quantified the amount of underlying underwriting contribution over/under stated in the financial result
* Partnered with Underwriters to build MI capabilities in Power BI to bridge operational and financial data
* Delivered monthly Underwriting Production Packs explaining premium and variances to plan
* Delivered monthly Premium Bridge explaining pricing metrics, rate, linesize & new business
* Delivered the Annual Planning, Quarterly Re-forecasts and reports to meet the needs of internal stakeholders
* Delivered the Quarterly Packs explaining the financial results and variances to plan and presented to the C suite
* Redesigned & implemented a reporting platform using VBA to automate monthly FP&A deliverables
* Designed & implemented a suite of analysis tools in Power BI to unlock key commercial insights and
understand underlying drivers of operational and financial performance
* Adhoc project work to understand the financial impact of changes in class earnings patterns
* Maintained & built relationships with underwriters to explain underlying operational & financial performance
* Took lead on the validation of commercial reality reflected in the financial result
* Provided forensic accounting services to understand data flow, processes & controls in a complex MI landscape
* Alleviated transparency restrictions on the financial close process in a highly complex MI environment
* Produced a walk from operational to financial data, articulating issues within the financial close process
* Quantified the amount of underlying underwriting contribution over/under stated in the financial result
* Partnered with Underwriters to build MI capabilities in Power BI to bridge operational and financial data
* Delivered monthly Underwriting Production Packs explaining premium and variances to plan
* Delivered monthly Premium Bridge explaining pricing metrics, rate, linesize & new business
* Delivered the Annual Planning, Quarterly Re-forecasts and reports to meet the needs of internal stakeholders
* Delivered the Quarterly Packs explaining the financial results and variances to plan and presented to the C suite
* Redesigned & implemented a reporting platform using VBA to automate monthly FP&A deliverables
* Designed & implemented a suite of analysis tools in Power BI to unlock key commercial insights and
understand underlying drivers of operational and financial performance
* Adhoc project work to understand the financial impact of changes in class earnings patterns
Certificates
Anaplan
Anaplan2022