Ran Chanel Zhu

• Perform month-end closings for all North American entities (IFRS and US GAAP) • Review ledgers and perform variance analysis over staff cost accounts (under the responisibility of HR Finance Department), including reconciliations of balance sheet items for respective expenses accounts • Collect necessary raw data from Payroll, Benefits and International Mobility teams in order to exercise control, process the data into insightful analysis and financial reporting • Bridge the gap between HR and business teams by resolving financial queries and providing guidance & training to both sides • Work with auditors to ensure compliance and control are adequately functioning as intended • Play a key role in the forecast and budget process of relevant staff costs for all NA entities

The position under Risk Assurance Services leverages the power of technology and the volume of data to assist the auditing process and to provide solution to clients. • Develop and execute CAATS (Computer Assisted Audit Tests) using ACL Analytics • Analyze audit results to ensure proper coverage of auditing principles and practices • Control the quality (i.e. completeness and correctness) of data received from clients • Automate the production of reports with Excel and create visualizations using Qlik and Tableau • Optimize the structure of database to facilitate error detection and processing • Manage multiple simultaneous audit projects within assigned time

Factory Design Labs is a full service advertising/marketing agency headquartered in Denver, with offices in Zurich and Shanghai. Key accounts include The North Face, Oakley, Air New Zealand. This role of Financial Controller reports directly to global CFO with a dotted line to Managing Director, China. • Responsible for full cycle accounting (incl. month-end closing) and monthly financial reporting • Oversee payroll (both locals and expatriates), HR, Admin and IT management of China office • Perform treasury management (incl. currency hedging) and intercompany reconciliation • Complete monthly tax filing and ensure tax compliance for VAT, income taxes, and local levies • Train the local team on company policies/procedures to ensure consistency with global offices • Review and update client contracts to ensure company profitability and successful delivery • Provide monthly / quarterly / annual client financial reporting as per clients’ requirements • Control the agency's resource planning, project and accounting management ERP platform Workamajig

Tourism Australia is an Australian Federal Government’s agency. This role reports directly to Global CFO with a dotted line to Regional Director, Greater China. The team includes one Corporate Services Officer and three admin assistants based in different TA offices. ERP used: Oracle, inc. finance, HR and project management modules. • Prepare monthly financial statements and management reports • Co-lead with the Regional GM the Annual Operation Plan and budget process (CAPEX +OPEX) • Carry out variance analysis, comment on the gaps and work closely with the BUs on better execution of the project plans approved by the Minister for Resources, Energy and Tourism • Provide guidance and instructions to Corporate Service Officer on regular accounting tasks (i.e. submit/approve invoices in the invoice system Basware, process payroll for the 4 offices, reconcile corporate credit cards, verify expense reports, perform transactions via HSBCNet) • Identify potential risks related to fraud or non-compliance in tax, procurement, use of company’s promotional items, staff T&E spend, expats’ allowance structure • Work with CFO and legal & governance team based in Sydney, and external auditors to revise or establish policies and standard operating procedures to enhance internal control • Prepare financial analysis and Board Paper for HK office relocation, SHA office lease renewal • Review the performance of non-marketing suppliers and ensure only most appropriate suppliers with best Value for Money are selected as business partners • Establish strong relationship with China National Tourism Administration (CNTA) and local government organizations • Work with People & Culture team in Sydney for staffing, HR budgets, performance appraisal

SAGA Transport (known as Bolloré Logistics, now part of CEVA) was a wholly owned subsidiary of Groupe Bolloré. It offers services in international transport, project cargo, customs brokerage, and supply chain management. This role reports directly to Regional Director, Asia and manages one staff (Financial Assistant). • Generate monthly financial analysis and reporting, prepare budget for Shanghai and HK offices • Optimize the financial reporting package to improve the visibility of business per activity as well as bridge IFRS and PRC GAAP so as to meet both group standards and local tax requirements • Improve Greater China branches' profit and cash flow through effective sales administration (e.g. client portfolio analysis, sales performance analysis, market trends spotting) • Closely work with group CFO to set up a new entity in Shanghai from the preliminary investment analysis (incl. NPV, IRR) to the asset transfer to the new entity • Enhance AR management by involving credit insurers and improving AR collection policies • Work with Regional Director, Asia and global offices to build a database with the purpose of leveraging regional resources to enhance client prospection and increase revenue • Lead an IT infrastructure reorganization project and ERP deployment (SunSystems, Pegasus)

Produced a study on the U.S. Department of Homeland Security's market for tactical comm hardware in collaboration with four other MBA students. The mandate included an analysis of agency requirements, emerging technologies and particularly financial analysis of some small-to-medium sized market players as potential Merge & Acquisition target, in order to come up with recommendations on market penetration strategy. (One of our highest ranked M&A targets, an Ontario-based company was acquired by Siemens Canada 5 months later.) The team earned an A+ for the excellence of the work.

Full-time postgrad program taken from Sep 2015 to Jun 2016 for the purpose of pursuing my passion for map making, and gaining skills in data management. Following the course, I completed an internship with AIEQ, an organization affiliated to and funded by Quebec’s Ministry of International Relations. The tasks include: • Prepare statistics package for 2015/2016 annual report • Automate reports and dashboards with Excel pivot table • Optimize data structure for a database of 3,500+ Quebec specialists and 200+ partner institutions • Develop a tutorial on visualization of spatial data and provide training to team members • Visualize key findings in the form of interactive maps and embed the maps into the revamped website