Andrew Hicks Email & Phone Number

Exeter, GB

London, England, United Kingdom

• Work with the FP&A team to develop group reporting and key performance metrics. Actively make improvements to support BAU process and focus on scenario modelling within Anaplan (Test Model Owner).Key Achievements
• Make Anaplan model ‘fit for purpose’, by implementing Anaplan best practises DISCO (e.g. Write data into Anaplan, simplify group calculations, focus output to user).
• Automated transfer of data and built process from HFM accounting system to Anaplan. Saved 7 hours per month, refreshed daily / on request, built in checks.
• Automated transfer of data from Anaplan to Power BI. Developed Power BI dashboards for reporting and analysis for team and CFO, e.g. Budget with flexed scenarios.
• Built new Management Accounts and supporting monthly process for CFO. Worked with business and finance technology team to explain difference between local reporting and contribution to group.

London, England, United Kingdom

Build salesforce and financial dashboards with a focus on (1) Business metrics and key performance indicators (e.g. Average Order Values, Life Time Value of Contracts, Renewals, Churn, Product / Industry / Salesperson analysis(2) Building forecasts / budgets (including scenarios) to model revenues and cashflows.(Included forecasting new business, renewals.

United Kingdom

Walked from Lands End, Cornwall to John O'Groats, Scotland.89 days, 1200 miles or 2.7million steps

London, United Kingdom

Reporting to the CFO, I was responsible for financial reporting, planning and analysis, whilst also creating an internal financial dashboard with business metrics for the XTX Global Operating Committee (GOC). Financial Reporting, Planning & Analysis1. Reports – Produced individual entity and multiple consolidated financial reports. All income statement.

London, United Kingdom

London, United Kingdom

Develop Qlik Sense dashboards for the finance team.Income Statement and Balance Sheet data - Actual, Plan and Forecast.Functionality includes set Analysis to allow user to select prior month and storing data on daily basis to track movement of financials. Train the team on how to use Qlik Sense.

London, United Kingdom

Role – I supported the FX COO to improve quality of data, management information and reports. Data – Worked on Revenue, Trade Volumes, Brokerage, Sales Revenue, VaR and Headcount data.Stakeholders – positioned on trading floor, communicating with desk heads and traders across all HR levels. Ability to translate front office requirements to middle and back.

London, United Kingdom

Role – Supported the front office Fixed Income COO team, by producing accurate, up to date, relevant management information on daily, weekly, monthly and ad-hoc basis. Product exposure included Swaps, Options, Governments & Treasuries, Short Rates, Exotics and FX.Legal Entity Migration – Supported transfer of derivatives business from Irish unit (ML.

London

Working with EMEA Fixed Income COOs to review and analyse revenue, headcount and trade level data. Provide general IT support, training and creating best practises in time critical environment.

London, United Kingdom

• Three month contract, supporting changes to the internal structure of the business.
• Review and assess the implementation of the new cost centre structure for 2008. Ensure all 2008 expenses (including reversal of 2007 accruals) are allocated to the correct 2008 cost centres.
• Create spreadsheets to design and manage the 2008 Forecast by Cost Centre. Write Commentary on variance between the 2008 Forecast and 2008 Budget.
• Provide detailed monthly cost analysis on direct and in-direct cost charges to the business

Bristol, United Kingdom

• Provide focused management information and support covering CB central suite of cost centres.
• Built and maintained relationships with CB Central Support Functions (MD, HR, Marketing, Risk & CIO)
• Process all CB Central Monthly Accruals, Journals and Prepayments to SARBOX requirements.
• Provide commentary variance analysis of CB Central costs to budget, forecast and prior periods.
• Assist with creation of quarterly cost and FTE forecast – including CB Recruitment analysis.
• Efficient use of SAP R3 and COBRA. Experience of FPB&F and SAP BW.

Bristol, United Kingdom

• Generate weekly and monthly reports of CCS non-financial management information (MI)
• Continuous proactive development of MI, in fast changing environment, supporting business decisions.
• Develop key relationships with centres to ensure time efficient collection of MI.
• Analysis of MI Reports, understanding of trend data, and centre productivity.
• Updated unit costing models to support calculation of indirect costs to the business.

Cima, Management Accounting, Acma

Self funded qualification

Introduction To Securities And Investments

Self funded qualification

Management Science, Business Management, 2:2

Activities and Societies: University Football 5th Team Captain University Football Club Treasurer