Jack Li Email & Phone Number

Melbourne, Australia

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… Show more 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. Show less

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… Show more 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 Show less

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… Show more 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 Show less

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… Show more 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 Show less

Master, Business It

Bachelor, Accounting