Carol Liu

Experience

• 

  Jiangxi University of Finance and Economics

  Sept 2004 - Jan 2005

  Associate Lecturer

  - Teaching Intensive English Reading and Speaking units

• 

  Computershare

  Sept 2006 - Jan 2007

  Investor Services Representative

  - Shareholder registry during AGMs

• 

  New Zealand Natural

  Jul 2007 - Mar 2008

  Store Manager

  - Processing accounts payable- Preparation of staff roster, time sheet and PAYG summaries- Employee recruitment and training- Products management and cost control- Customer services

• 

  Quinlan Consulting Team Pty Ltd

  Oct 2007 - Jan 2008

  Consultant

  - MYOB bookkeeping and procedure writing- General office administration for client

• 

  Coles

  Apr 2008 - Oct 2017

  Achievements - Delivered ongoing technical training to the team improving work efficiency and accuracy- Simplified and built Liquor monthly model for grocery and converted two day process to 2 hour process, incl. engaging IT to automate output- Built financial model to analyse overhang after meat promotion and put forward recommendations to the business and senior management around forecast review, missed sales opportunities and in-store meat cut (circa $10m loss reduction annually)- Improved perishable stocktake matrix to have the flexibility to report stock to stock- Automated stocktake timetable update process from manual change of one store at a time to upload with multiple stores and improved communicate to all stakeholdersResponsibilities- Analyse Supermarkets stocktake result to investigate the drivers for loss and present the findings to the business- Conduct analysis to support business initiatives / projects, e.g. slice ready meat- Manage Supermarket Perishable stocktake and communicate the result Show less I was approached by the Transport Commercial team for this role because of what I delivered in my previous role and recommendation from my ex-managerAchievements- Automated and streamlined various reporting processes, e.g. create macros and first one in Finance to employ IT software (QTP) for automation, saving considerable hours- Set up supplier annual rise & fall mechanism which brought in millions of revenue when contacts were lacking of details- Worked cross-functionally and built model to analyse reporting gap between Logistics and Replenishment regarding supplier performanceResponsibilities - Partner with Coles Collect key business stakeholders to help decision making and to influence commercial outcome. Maintain productive relationship with all stakeholders- Present Coles Collect results (P & L) and net profit bridge in waterfall to senior business managers, including commentary to reflect the impact of operational drivers- Understand business operations via getting first-hand information and use it for analyses and process improvement- Prepare Coles Collect budget and forecast including managing discussion with stakeholders and obtain business sign-off. Provide information for Board reporting- Transport KPI reporting (DODD & DOT) – validate calculation in TM1, identify areas for improvement, and created carrier performance report and supplier report linked to TM1 - Prepare and analyse Secondary Transport results to reflect the impact of various drivers- Maintain productive relationship with 3rd party logistics supply partner- Validate and challenge carrier rate review submission and volume rebate. Prepare TMS rate card and update fuel surcharge. Manage trailer cost allocation and depreciation- Conduct analysis and provide information to support business initiatives / projects- Build financial models to track performance of projects and translate operational drivers Show less Achievements- Successfully supported Easy Ordering project from putting together Business Requirement Document to acquire roll cages to developing / managing processes to capture and maintain returnable asset information from procurement to disposal, i.e. raise purchase orders for capital items and review Fixed Assets Register- Key contact for system performance and review business enhancement documents and document training material for distribution centres (DCs)- Initiated and engaged Fresh Produce to review returnable plastic crates (RPC) rate strategy as well as put forward recommendationsResponsibilities- Put together Business Requirement Documents, e.g. applying for funding to purchase additional RPCs to support operation- Set up supplier cost models via direct engagement with suppliers and review supplier contracts- Budget preparation and submission - CAPEX & OPEX (incl. light & power, lease cost etc.)- Prepare EOP financial pack for the purpose of monthly reporting- Review 3PL monthly financial pack, GL and KPI report as per open book arrangement- Monthly commentaries to Logistics Finance based on variance analysis- Monitor and control RPC operating costs & conduct EOP accruals- Develop and maintain returnable asset reconciliation processes to minimise pallet loss;- MHE Stocktake – stocktake action plan, store communication, stocktake result analysis, post implementation reviews (PIRs), etc. Show less

  • Business Analyst, Operations Finance – Planning and Analysis

    Sept 2016 - Oct 2017

  • Business Analyst, Stock Analysis (Stock Accounting)

    May 2015 - Sept 2016

  • Commercial Analyst, Logistics Finance

    Mar 2011 - May 2015

  • Returnable Assets Analyst

    Apr 2008 - Mar 2011
• 

  Monde Nissin Corporation

  Oct 2017 - Apr 2018

  Financial Analyst, Supply Chain, Operations & Commercial

  - Manufacture, Supply Chain and Logistics performance reporting including automation and analysis, supporting internal and external audit requirements - Partner with stakeholders across Supply Chain, Operations, Sales and Marketing to drive discussion and decision making- Product costings and COGS analysis including supporting margin improvement initiatives- Coordinate with NPD, category and marketing team to put together new product P&L and get involved in gate meeting- Prepare financials and commentary for demand planning deck (incl. customer and product profitability and trade spent) and present performance and forecast in monthly Sales & Marketing demand planning meeting Show less

• 

  QSR International

  May 2018 - Jul 2019

  Senior Commercial Analyst

  - Coordinates the setting of financial performance metrics for Marketing and Sales and build reports and dashboards to provide business with meaningful information, including trend analysis, geographic trends etc.- Perform analysis for a wide range of requests and commercialise Marketing initiatives- Support the development of business cases for new products, e.g. competitor analysis, new product P&L- Organise and prepare deck for monthly Integrated Business Planning (IBP) Forum – Portfolio Management Review (PMR)- Build various financial models to assist and improve AOP/budgeting process Show less

• 

  Mt Scopus Memorial College

  Jul 2019 - now

  System Manager and Senior Business / Data Analyst