Gareth Trotter Email & Phone Number

Milton Keynes, England, United Kingdom

London, England, United Kingdom

• Integral part of the Making Finance Brilliant Project transformation group which implemented Phase II system changes, specifically in the (Ariba) Purchasing space.
• Delivered; data analytics to identify user groups for engagement, creation and completion of UAT, and successful rollout of training/communication packages to help onboard user base of 5,000+.
• Designed reporting suite to guide senior leadership on cash flow management, encompassing activities across critical suppliers and key inventory. Produced daily slide deck (using large data set cross referenced to 1m.
• Streamlined post go-live reporting to focus on KPIs and tighter controls in supplier payment timing and PO control. Positive reception and improvement in on-time payments led to engagement in knowledge sharing and best.
• Key point of contact for UK Finance and Operational teams to improve onboarding journey. Resolved a huge volume (10k+) of queries across a wide user base (1k+) in 9mths post go-live to ensure experience was as positive.

London, England, United Kingdom

• Fully owned all local standard reports, supported production of multiple areas of senior slideware, and responsible for Hyperion systems; modelling templates, budget submissions, multi-cube reconciliations, year-end.
• Completely rebuilt reporting used across the business; standardising disparate reporting into a single suite with fully systemised (Hyperion, then later SAP) data quality. Led and implemented all changes, and automated.
• Led the design and build of a new KPI suite, by co-ordinating inputs across Finance and Operations. Resulting weekly metrics were shared with the CEO to help aid strategic decisions within the business.
• Overhauled budget journal adjustment process. Rebuilt templates; adding in reconciliation checkpoints and user friendly input methods. Reviewed system methodology around data posting, with outcome of system process.
• Built Product Profitability excel model from scratch using wide ranging source data (both manual and systemised) across the business to deliver a full functioning solution to help drive business decisions.
• Key point of contact for Hyperion within the UK. Implemented best practice in reporting, data loading, system design, reorgs, reference data management and year-end procedures.

Leavesden, England, United Kingdom

• Responsible for maintenance and production of BPM Insight reporting packs, and multiple areas of the Hyperion suite.
• Evolved entire suite of Management Reporting by working with units to generate custom built reporting. Previously generated via manual and disconnected process; consolidated into one set of documents that leveraged.
• Directly involved with multiple HFM upgrades (9.2->9.3->11), working as the key bridge between finance and system teams.
• Assisted in all system aspects of every re-org; including re-mapping the entire HFM data cube via extraction and Excel manipulation
• Automated T&S reporting process (via Excel & VB), reducing production time from a week to a day.
• Travelled to APAC with a specialist team to provide a week’s intensive Hyperion training to both Hong Kong and Singapore offices.

Leavesden, England, United Kingdom

• Prepared monthly financial and management accounts for assigned contracts, and business partnered senior Contract managers by providing analysis of performance, and collaborated to review and generate regular lifetime.
• Successfully implemented standard build of working papers across both the Lloyds and A&L contracts.
• Improved detail available on the Lloyds contract to a position where Control Sheet was fully interlocked with Business Manager forecast. Allowed a release of £2m of Revenue to Gross Margin.

Leavesden, England, United Kingdom

• Owned accounting of multiple general ledger lines for the business, ensuring the reconciliation and correct allocation of costs to customers/products.
• Reduced unassigned overhead balance created due to incorrect coding of invoices from £10m+ to < £500k.
• Reconciled multiple years of eCashier data, resolving unallocated transactions in excess of £1m.
• Overhauled reconciliation and data reporting files turning them from tabular spreadsheets into live pivots.
• Drove efficiency within PO Accruals by completing quarterly closure exercises. Within 6mths 1,300 PO’s had been closed, totalling a value of >£14m.

Hayes, England, United Kingdom

Worked with Finance teams to help derive Budgets and then completed monthly analysis of variance bridging across the (UK) Grocery division.

Stockley Park, England, United Kingdom

Highly analytical role which involved working with multiple sales teams and navigating 3rd party systems to derive appropriate spend controls when leveraging major marketing campaigns.

London, England, United Kingdom

Recruited out of University into graduate trainee position, quickly transitioning from factory floor to head office in to analyst role.