verified ACCA Qualified Member (Fully CCAB-Qualified)
Institutional Impact Registry 3 Flagship Deployments
Financial Engineering & Fiduciary Governance

Key Achievements & Financial Case Studies

Deep-dive into structural ERP migrations, cost centre coding review architecture, balance sheet governance, and institutional grant management methodologies.

Total Scope Managed
3 Entities ERP Cutover
100% zero downtime throughout year-end close cycles
ERP Operational Target database
3 Units

Migrated independently to Sage X3 with COA unification

check_circle Zero Reporting Disruption
Variance Reduction trending_down
-60%

Post-close adjusting journal entries across all cost centres

terminal Automated Excel/VBA SOP
Statutory Audits balance
100%

Unqualified clean audit opinion on nominal control accounts

verified_user Full IFRS 16 Compliance
Public Grant Readiness account_balance
Tier 1

Fiduciary frameworks aligned with NHS / NIHR funding rules

policy Public Sector Governance
Case Study 01 Bunzl UK & Ireland Portfolio • Operating Divisions Integration

Multi-Entity Sage X3 ERP Migration & Consolidation

Core Deliverables

3 Legal Entities Integrated

hub
warning The Strategic Challenge

Bunzl UK & Ireland operated three distinct trading subsidiaries utilizing fragmented, legacy accounting software. This siloed infrastructure generated disparate Charts of Accounts (COAs), manual data extracts, delayed monthly close cycles, and non-standardized invoice approval chains that impeded accurate group consolidation into Oracle HFM.

Methodology & Execution Architecture
1 COA Harmonization

Designed a 1:1 nominal coding crosswalk mapping 800+ legacy account lines into a consolidated 4-tier Sage X3 chart of accounts.

2 Data Cleansing & Trial

Led extract, transform, and load (ETL) data hygiene drills; eliminated dormant supplier balances and validated open purchase orders.

3 UAT & Cutover Rigor

Authored comprehensive UAT scripts covering AP three-way matching, bank interfaces, AR allocations, and intercompany settlements.

4 Internal Control Matrix

Drafted multi-tier approval authority matrices, segregation of duties (SoD), and standardized SOP documentation for operations.

Realized Business Impact
  • check_circle Zero Interruption: Seamless cutover achieved over scheduled weekend closures with 100% data fidelity.
  • check_circle Automated HFM Sync: Direct synchronization into Group Oracle HFM, shortening divisional close from 7 days to 4.
  • check_circle Audit Transparency: Eradicated manual spreadsheet bridge files, enabling instant audit trail retrieval.
Consolidation Flow Architecture Map
Entity A (Legacy) Entity B (Legacy) Entity C (Legacy) Sage X3 ERP Unified COA Engine Oracle HFM Group
security
Internal Controls SoD & Authorization Matrix Approved
100% Passed
Deployment Lifecycle Matrix
1. Pre-Migration Data Cleansing 100% Cleansed
2. Multi-tier UAT Scenarios 48/48 Passed
3. Parallel Run Verification Variance £0.00
4. User Training & Handover Manual Formalized
Case Study 02 Financial Automation Framework • Excel & VBA Engineering

Automated GL Cost Centre Coding Review Model

Close Efficiency

>60% Fewer Journal Reversals

table_view
error_outline The Problem Space

Operating expenses across divisional departments frequently experienced misallocation into improper GL codes and conflicting cost centres. Finance business partners spent numerous hours identifying anomalies manually after the provisional close, triggering retroactive journal entries and undermining executive trust in interim reporting.

Analytical Architecture & Formula Engines
functions Dynamic XLOOKUP & Logic

Configured dual-key cross-validation rules comparing nominal code prefixes against departmental cost centre hierarchies automatically.

rule Threshold Variance Flags

Built conditional triggers detecting expenditure spikes >15% against rolling 3-month run-rates and highlighting unbudgeted purchase tags.

code VBA Macro Pre-Close Script

Engineered single-click macro compiling raw transactional journals from Sage into clean exception reports within 4 seconds.

verified Corporate SOP Standard

Mandated as mandatory gatekeeper review step by Head of Finance prior to issuing divisional flash results.

Quantified Business Outcomes
60%+ Fewer Late Adjustments
1.5 Days Accelerated Close
100% Close SOP Adoption
Automated Exception Inspector VBA RUN-RATE 0.04s
Cost Centre GL Code Variance Status
CC-401 (Logistics) 7200-Opex +£12,450 VERIFIED
CC-205 (Marketing) 6410-Capex? +£44,200 MISCODED
CC-102 (Executive) 8100-Travel -£1,200 BENCHMARK
CC-308 (Engineering) 7910-Recharge +£18,750 ORPHAN TAG
Post-Close Adjusting Entries (Pre vs Post Model)
Legacy:
~54 JRN
Automated:
~18 JRN
Technical Stack & Capabilities
Excel VBA Scripting Dynamic XLOOKUP Arrays Automated Variance Parsing Multi-Entity Mapping Error-Tolerant ETL Logic
Case Study 03 Fiduciary Governance & Balance Sheet Integrity • Statutory Compliance

Nominal Reconciliation Overhaul & Control Framework

Audit Performance

Clean External Opinion

fact_check
account_balance_wallet The Governance Imperative

High-volume, volatile control accounts—specifically Goods Received Not Invoiced (GRNI), foreign exchange translation reserve, customer rebate margins, and intercompany clearing accounts—exhibited lingering unreconciled balances. A rigorous institutional overhaul was required to safeguard balance sheet truth and facilitate fast FD sign-off.

Core Redesign Pillars
receipt_long GRNI Aging Schedules

Created an automated 30/60/90+ day aging tracking schedule, enforcing supplier invoice clearance against matched delivery dockets.

currency_exchange FX Revaluation Rigor

Standardized unrealized vs. realized FX translation protocols in alignment with IAS 21, mitigating foreign currency exposure creep.

apartment Intercompany Matching

Instituted bi-weekly intercompany balance confirmations, eradicating month-end reconciliation bottlenecks between legal entities.

home_work IFRS 16 Lease Governance

Maintained Right-of-Use (ROU) asset registers, depreciation amortization schedules, and liability interest recomputations.

Institutional Sign-Off & Audit Outcome

"The redesigned reconciliation binder introduced an unprecedented standard of documentation. External audit review queries on balance sheet accounts decreased by more than 70%, with the Finance Director achieving zero-variance sign-offs continuously."

Nominal Control Summary Audit Certified
inventory
GRNI Control Account 3-Way PO / Inv Cleared
£0.00 Unmatched
payments
Bank & Wages Clearing PAYE, NI & Direct Debits
Balanced Daily
swap_horiz
Intercompany Current Acc Bi-lateral Netting Confirmed
Matched Bi-Weekly
real_estate_agent
IFRS 16 Lease Liabilities ROU Amortization Validated
Strict Standard
approval External Audit Review Speed
3X FASTER
Standard Frameworks Applied
UK GAAP (FRS 102) IFRS 16 Leases IAS 21 FX Accounting HMRC VAT MTD CCAB Best Practices
health_and_safety
Strategic Horizon & Public Sector Alignment

NHS, NIHR & Grant Funding Governance Capabilities

Leveraging rigorous institutional financial control, ACCA qualification, and multi-currency reporting to deliver audit-proof financial management for high-stakes public sector research and healthcare initiatives.

Grant Advisory Ready
receipt

NIHR & Research Grant Accounting

Full lifecycle tracking of restricted vs. unrestricted funding pots, indirect overhead cost allocations (fEC), and time-allocation verification adhering to strict UKRI and NIHR governance mandates.

account_tree

Public Partner Recharges

Transparent cross-entity recharge agreements between academic medical centers, university partners, and NHS Trusts with complete audit reconciliations and variance reporting.

shield_with_heart

Value-For-Money & Audit Trails

Establishment of defensive pre-audit files, ensuring all grant drawdowns match strictly against milestone deliverables, procurement thresholds, and clinical trial timelines.

verified Comprehensive knowledge of public funding compliance, VAT partial exemptions, and statutory NHS reporting frameworks.
Discuss Grant Stewardship
Enterprise Tooling & Systems Acumen

Verified Platform Competencies

PRODUCTION DEPLOYED
dns Sage X3 Core ERP & Migration
grid_on Oracle HFM Group Consolidation
terminal Excel & VBA Macros & Modeling
receipt_long Sage 50 Statutory Ledger
cloud_sync Xero & QBO SME & Multi-Entity
monitoring Power BI Executive Dashboards
school
Rigorous Professional Pedigree

ACCA Member (CCAB Qualified) • MSc Accounting and Finance (2:1, BPP University London) • Advanced Diploma in Accounting and Finance