Experience

• 

  NGK Spark Plugs Australia

  • Melbourne, Australia

  • Business Analyst

    • Oct 2015 - Present
    • Melbourne, Australia

• 

  Mettler Toledo

  • Melbourne, Australia

  • Systems Analyst

    • Jun 2012 - Sep 2015
    • Melbourne, Australia

    Mettler Toledo is a global provider of precision instruments having an annual turnover of AUD 2.3 billion. Its Australian business has over AUD 70 million annual sales.Main responsibilities:• Drive the end-to-end management report process: Design and implement over 100 live and regular reports including sales, customer service, budget and forecasting etc. by using Microsoft SQL Reporting Service (SSRS)• Design and implement systems and process improvements for all six business units an typical example is implementing the dashboard report suite by using Visual Basic Application (VBA) and spreadsheet modelling • Streamline the month end process and eliminate the unnecessary down time in the ERP system, which saved 3 business days each month• Maintain and fine tune production database: automate data upload and download, email distribution and systems integration, etc.

• 

  Chandler Macleod

  • Melbourne, Australia

  • Reporting Analyst

    • Jun 2009 - Jun 2012
    • Melbourne, Australia

    Chandler Macleod is a leading recruitment agency, ASX listed, with annual turnover of $1.4 billion.Main responsibilities:• Maintain & compile 13 key business critical reports with 100% non error rates and by the required weekly/monthly deadline• Integrate financial data (40,000 records weekly) with a newly developed Microsoft Access Database to made trends and comparative analysis• Improve reporting processes and data quality by implementing faster methods (Visual Basic Application (VBA), SQL queries) to extract data• Provide timely and accurate reports weekly/monthly to the Branch sales managers and document financial / sales reporting into simple step by step processes• Streamline the major accounts’ reconciliation process (Accenture, ANZ, BHP, etc.) by using system flow charts; reduce time taken from working day 5 to working day 2

• 

  RSPCA Victoria

  • Melbourne, Australia

  • Assistant Analyst

    • Jun 2008 - May 2009
    • Melbourne, Australia

    RSPCA is a non-government community based animal welfare charity.Main responsibilities:• Process 1,000 donation transactions (cash, cheque, credit card, EFT payments) weekly • Extract raw information from the internal finance database and process it into management reports by building VBA data models • Perform P&L analysis and re-code the template for 120 cost centres in Sage Line 500; improve the reporting accuracy and reduced the processing time by 5 days• Assist with the month-end process, budget and forecasting

• 

  China Guangdong Nuclear Power Holding Co., Ltd.

  • Shenzhen, Guangdong, China

  • System Accountant

    • Nov 2000 - Feb 2006
    • Shenzhen, Guangdong, China

    China Guangdong Nuclear Power Holding Co., Ltd. is a major clean energy corporation in China, which operates four nuclear plants and has five new ones under construction.Main responsibilities:• Perform month-end process; prepare half yearly and yearly set of accounts and financial reports, including P & L, Balance Sheet and Cash Flow Statement • Perform financial systems supports including reports designs and writing, and system training for 6 staff • Implement improvements in financial reporting procedures • Assist with cash follow forecasting by establishing a complex electricity pricing model