Experience

RTX RouteTrader

• United Kingdom
• Telecommunications
• 1 - 100 Employee

• Management Accountant

  • Jan 2022 - Present

• Finance Operations Analyst

  • Mar 2014 - Dec 2021


Ellen Hau Photography
• Freelance Photographer

  • Jul 2013 - Present


Voice X Ltd

• Australia
• Retail Office Equipment
• 1 - 100 Employee

• Finance operations analyst

  • Mar 2013 - Dec 2013

  Reported to Head of carrier sales and commercial manager Assisted in portfolio management of suppliers, KYC, due diligence, NDA forms. Responsible for daily billing to wholesale telecom carriers up to $500,000. Submitted new pricing rate card to other wholesale carriers and recorded rate cards from other suppliers. Reconciled supplier purchases invoices to usage minutes against VOS3000 Telecom database Created and updated invoice and purchase data to sales and purchase ledger. Created new supplier/customer accounts. Allocated payments against invoices and reconciling these accounts Prepared information to assist VAT returns and to assist external accountant. Collated information from new suppliers and customers for new Interconnections in order to close contracts. Monitored telecom quality statistics, # of concurrent calls, ASR,ACD Created, automated and reported sales, costs and profit margin report. No. of minutes terminated daily by customer and by destination using Vlookup, Sum if, Index and Match formulae functions and data tables. Show less



Johnson Electric PLC

• Finance Analyst

  • Feb 2008 - Mar 2009

  Global manufacturing company based headquartered in HK with multi-US billion dollar annual turnover Reported to group financial systems team (subteam of Corporate decision and support). Project 1: Responsible for the development of Cognos Dashboard BI tool for all management users to view historical sales and cost reporting data (MTD, YTD, Variances). Distributed and collated UATs, prepared training documents, uploaded historical data via ETL interface. Project 2: Support person for all Cognos Controller budget and cost data for all users globally Opening and closing periods, upload of intercompany and cross charges to Hyperion, run translation and consolidation of forecast and budget data. Show less



Bank West, Halifax Bank of Scotland Australia (HBOSA)

• Sales reporting analyst

  • Jul 2007 - Sep 2007

  Daily, weekly, monthly and quarterly reporting sales performance of BDM and ARM to management across Business Banking, Commercial, Private Banking, Property and Rural and regional banking areas. Distributed Leaderboard by rank each week. Running and editing queries using Access database, BI tools, Excel named ranges, Vlookups, editing multiple macros, VBA, using multiple worksheet and workbook linking to create reports. Acted as systems administrator to grant new bank business managers to access SMART reporting tool to record deals in terms of new leads, in the pipeline, and closed deals. Created/updated regional/team structure changes in the reporting tool. Show less



Simply Energy, Retail arm of International Power PLC

• Finance analyst

  • Mar 2007 - Jun 2007

  Reported to financial controller. Assisted finance manger to update actuals and update forecast model for electricity and gas. Update new price assumptions and assist accountant to prepare revaluations, and update cash flow forecast models. Reported to financial controller. Assisted finance manger to update actuals and update forecast model for electricity and gas. Update new price assumptions and assist accountant to prepare revaluations, and update cash flow forecast models.



Sainsbury's

• United Kingdom
• Retail
• 700 & Above Employee

• Asset Controller

  • Mar 2006 - Feb 2007

  Job role: Asset controller: Working from the Head Office. Reported to Asset Manager of IT department Monitored and accounted physical IT assets across all Sainsbury Stores across the country\ Oracle Inventory Job role: Asset controller: Working from the Head Office. Reported to Asset Manager of IT department Monitored and accounted physical IT assets across all Sainsbury Stores across the country\ Oracle Inventory



Accenture

• Ireland
• Business Consulting and Services
• 700 & Above Employee

• Asset Controller

  • Apr 2004 - Mar 2006

  Worked within Accenture's customer site at Sainsbury's Monitored IT fixed assets at multiple stores Reconciliations of IT assets Worked within Accenture's customer site at Sainsbury's Monitored IT fixed assets at multiple stores Reconciliations of IT assets



Reader's Digest LTD

• Product Analyst

  • Apr 2002 - Dec 2003

  Reported to financial controllers for RD Magazine, Moneywise, CD, Series Books and Telemarketing business groups for the reporting of Actuals, budget, rolling forecasts, Quarterly forecasts, LE for upload to Hyperion(Essbase) system. Updated assumptions to update bespoke forecast models for each business group. Liaised with Marketing teams regularly to review expenditure, variances, changes to assumptions and revision of performance data. Produced and updated Profit and loss reports by business group. Collected assumptions from marketing teams and production to feed forecast changes. Updated daily one hundred excel forecast models by each campaign for each business group to monitor daily performance and distributed reports to management. Extraction of actuals data to Excel and import to excel for reporting. Use of Oracle financials to query expenditure of marketing teams. Show less



Panduit Europe LTD

• Finance Analyst / Oracle Specialist

  • Dec 1999 - Jul 2001

  Reported to Financial Planning and Analysis Manager for US manufacturing firm for EMEA region.Sales reporting of all actual sales on ad hoc and periodic basis using IBM Mainframe, writing queries using DQL and query tool Infomaker to export data to Excel to populate pivot tables and reports.Financial analyst role:Periodic reporting of circa 100 cost centres using Oracle discoverer, Monarch, multiple macros, to update cost centre reports in local and group USD currency. Distributed reports to all users.Periodic use of BI tool Oracle financial analyser to obtain full sales/cost report and to change cost centre structures.Oracle support role:Provide single help desk in European headquarters to 25-30 finance users in Oracle (GL,AP,AR, FAR, Oracle ADI) for 15 sets of books. Resolved periodic issues such as batch payment errors, AP to GL interface errors, fault reporting to resolution with IT team. ADI templates upload errors.Supported 8 financial accountants to run the monthly translation and consolidation process. Dealing with multiple currencies. Editing Oracle reports and editing batch report runs. Activated/Deactivated GL reporting accounts.Oracle 8i/11i upgrade: Assisted US HQ and local IT to coordinate upgrade. Assisted IT to prepare desktop ready for new software client. Distributed, checked UATs and follow up. Attend Oracle User groups. Show less

• Oracle Financials Implementation Project Coordinator

  • Apr 1999 - Nov 1999

  Reported to EMEA Finance DirectorIdentified, documented, tested all tasks required to implement new Oracle financial applications to 15 sets of books for EMEA region. Modules included: General ledger, Accounts Payable, Accounts Receivable, Fixed asset register, translation and consolidation support to US books. Oracle Discoverer, Oracle ADI upload process. Resolve any issues such as login, error and timing.Liaised with local IT team and financial users daily and HQ financial systems team in US critical paths required and status updates until completion.User acceptance test distribution, collation, problem record, monitor through to resolution for all financial users in EMEA region. Recorded and monitor any Oracle bugs, response time issues, ping/time out issues with IT team.Attended Oracle user events and forums as super user in the European HQ. Show less

• Accounts Assistant

  • Mar 1999 - Mar 1999

  Reported to EMEA accounts receivable manager. Preparation of ad hoc Excel reports and assistance of receipts to AR system