Benjamin Lord, Ca Email & Phone Number

Hong Kong Sar

Hong Kong Sar

Hong Kong Sar

Finance partner for Hong Kong, Japan, and Apac cont. improvement

Finance partner for Hong Kong, Japan, and Apac cont. improvement

Hong Kong

• Prepare and communicate financial results • Analysis of actuals, Budgets and Forecasts • Prepare monthly reporting pack with analysis• Review and support the development of Monthly Reporting Pack for local offices• Work with local offices to ensure reporting deadlines are met• Assist local offices with financial reporting issues, processes, procedures and internal controls• Review existing reporting templates and recommend changes• Review Actuals/budgets/forecasts and investigate anomalies at local level• Provide monthly report analysis with commentary • Balance sheet reviews• Cash flow management and forecasts

Hong Kong

Consulting to SpeedCast to provide Financial Modelling and Finance System Project Management services - included the following:• Developed and implemented global entity level monthly reporting process as part of implementation of Microsoft NAV ERP system• Leader of master data migration validation from legacy systems to Navision for Asia and Europe rollouts • Lead negotiations and participated in requirements gathering for CPM tool – achieved all negotiation goals• Consulting CFO, Group Finance Director and FP&A manager to develop a new set of monthly group management reports• Optimise and automate monthly group consolidation reporting processes• Tracked staff utilisation on ERP project for capitalisation through time recording• Ad-hoc analysis requests• Developing Excel maturity in Group Finance team

London, United Kingdom

Contracted to provide provide Financial Modelling, Finance System Project Management and VBA development services to M&S - included the following:• Managed successful delivery of Vena Solutions application for International Forecast and 3 Year Plan processes – leading a team of 6 to revitalise and deliver the project• Analysed and rebuilt ‘International Weekly Sales’ reporting models utilising VBA• Managed project delivery of external finance reporting tool (IBM CDM) tool to Group Finance• Delivered SharePoint site for weekly Group Finance reporting (10+ reports, 300+ internal users)• Development of Excel maturity in Finance System teams

London, United Kingdom

Contracted to provide Financial Modelling and VBA development services to M&S - included the following:• Review and structural improvement of over 50 Excel models for various teams used in Annual, Half Year, Quarterly, Monthly and Weekly reporting. Activities included: o Process modelling best practice review o Agreeing desired improvements with report owners o Undertaking improvements o Execution of reports followed by comprehensive handover back to owners• Presenting on modelling best practice to the Group Finance - Accounting and Reporting Team• Technical lead for delivery of IBM FSR (Clarity) for external reporting• Supporting the successful delivery of Store Income Statements, by owning and producing the financial model and VBA used for report publication• Delivery of SharePoint site for weekly Group Finance reporting to all levels (10+ reports)

New Zealand

• Lead a team to implement IT Total Cost of Ownership Activity-Based-Costing using a model developed in Excel with VBA• Lead implementation of time recording to IS, (approx. 120 staff). This subsequently led to requests for roll out to further two departments• Consulted project managers and sponsors regarding project budgeting, funding, and associated business cases for over 15 projects.• Implemented internal cost recoveries for selected services. This included the negotiation of pricing and service levels with internal customers, focusing on their needs• Delivery of Service Catalogue for IS department• Improved asset management from technical and budgeting perspectives• Overhauled IS budgeting/forecasting• Delivered creative solutions to solve significant project and IS budgeting issues• Participated in Request for Proposal (RfP) evaluation for three major initiatives

New Zealand

• Partnered with an internal macro-economic expert to develop an Excel/visual basic solution to determine the position of each NZ industry in its business life cycle (i.e. growth, mature, sunset). This supported a further analysis piece, forecasting future freight volume• Updated Vehicle Operating Cost (VOC) tables in EEMs. This included:o research into cost of vehicle consumables (ie petrol, oil, tires), for multiple vehicle classeso interpreting and feeding data into model software (high complexity, low documentation)o multiple regression analysis of model outputs• Developed and published smart Excel templates for EEM procedures on external website (included BCR/DCF models)• Tested EEM software developed by consultancy against EEM procedures. Tracked issue resolution and worked directly with consultants to remedy bugs/errors identified

Chartered Accountant, Accounting, First Time Pass

Bachelor Of Commerce And Administration, Accounting And Commercial Law