Guoyue J. Email & Phone Number

Sydney, New South Wales, Australia

Integrity of General Ledger and Reconciliation of Balance Sheet Accounts: Ensuring accuracy and reliability of the general ledger by performing timely reconciliations of balance sheet accounts. This involves verifying and rectifying any discrepancies or errors in financial records.Assistance in Financial Control for Specific Entities: Supporting the Manager Financial Control in accounting and monthly general ledger closing activities for ING Australia Group. This includes managing financial aspects and ensuring compliance with reporting standards.Adherence to Financial Accounting Standards: Ensuring that the general ledger reflects adherence to relevant financial accounting standards, ensuring accuracy and compliance in financial reporting.Responsible for managing ING Australia Holdings monthly accounting activities, including categorise all financial transactions, reconcile accounts, analyse inter-company transactions, prepare elimination journals for consolidated financial statement and forecast monthly expenses to ensure adequate funds in bank account.Corporate Credit Card management: Administering Card access privileges, including access to premises, computer systems, etc. Ensuring employee access to the limit and proceed instant usage suspension if separate. Authorised Signatory monitoring: Managing approval process for various transactions or activities requiring signatures, including defining approval hierarchies and ensuring appropriate documentations in place. Liaison for Sarbanes Oxley Testing: Collaborating with business units to facilitate Sarbanes-Oxley Act compliance testing, which involves ensuring internal controls are effective and in place.Financial Control Projects and Ad-hoc Requests: Participating in financial control-related projects and handling ad-hoc requests related to financial reporting and control.

New South Wales, Australia

Conduct duties on monthly basis works including Monthly Business activities statement, Foreign benefit tax accrual, monthly reconciliation, contractor analysis and records, PAYG instalment and withholding tax accrual and upload which requiresaccurately generate data from oracle, prepare working files and provide numerical analysis on the result.Regularly prepare the Large Pay As You Go withhold for both Sydney branch and Australia company, prepare paymentauthorization forms to ATO if the amount meet the threshold and ask for perspectives to sign.Regularly update the study guidance on the topics of WHT, FBT and PAYG that provides assistance on other collogues works.Draft and design the process map for internal control purpose. Over 20 maps were drafted for both Sydney branch and Australiacompany and proposed to senior manager to review and upload to internal control statements.Design the Ending User Computing minimum standard check list for over 50+ working files that are critical to the business decisions to meet ATO compliance and the lists contain password protection, application statement, asset owner application,EUC decision tree, Model testing, version controls.Responsible for the mail collections and email monitoring on the daily basis, making sure attached files are correctly saved torelated folders and keep records on ATO notices.Participate in tax and finance team meeting, provide answers to other teams questions and keep meeting minutes.

China

Served as an intern in Henan GehgnJia Group IPO project, led the sorting and sorting of key data, including the flow of directors, supervisors and related parties, and verified the company's financial data to ensure the accuracy of the data.Participated in the annual inventory, checked and recorded the company's raw materials, semi-finished products, finished products, transportation, assets and other information, and completed the archiving.Participated in internal control meetings, made meeting minutes, output meeting points and implement, conveyed them to relevant departments.Handled the invoices of securities companies, made monthly reimbursement vouchers, translated and checked the overseas flow and invoice specifications of the project company.Made overseas questionnaires and documents of overseas companies, and connected with domestic financial departments.Used the due diligence software to conduct due diligence on the project company and gave early warning of potential risks.Checked the sales orders, delivery orders, logistics delivery orders, sales invoices and other businesses of foreign subsidiaries.

Shenzhen, Guangdong, China

Used Wind, Rong Da Elangshen, Robo Dataeyes, Bloomberg and other software to comprehensively investigate the company's business.Used office software to write research reports, provided financial and sector analysis for investors.Collected and analyzed industry and company data, analyzed the change trend of fundamentals, provided important data for investment decision-making.Participated in internal financing meetings, made meeting minutes, sorted out and analyzed important data.Wrote investment daily, sorted out the hot news in the new field of environmental protection and electricity, carbon price tracking, national notices and other information, and formulated a checklist.Work results: For Everwin precision & Siyuan electric company, two in-depth reports were completed independently.

Richmond, British Columbia, Canada

Counted 1500 + customer data and completed data entry and upload to ensure that the data is always up-to-date.Assisted in customer development, completed customer coordination and customer organization.Established an information user feedback system to collect user needs and use feedback information.Assisted VP to count weekly data, made analysis report and provided data support for weekly meeting.Work results: Successfully presided over the online customer development meeting and attracted many potential customers.

Vancouver, British Columbia, Canada

Analyze account information and trends for financial estimation report adjustments.Follow detailed end of month accounting procedures to verify proper balancing of all accounts and readiness for new month.Process and ensure that payable are correctly recorded in QuickBooks system.

Simon Fraser University

Provided high quality service to the indoor customers. Memorised official and off-menu preparations to serve all customer beverage desires.Protected customers by regularly cleaning and sanitising work areas and equipment.

Simon Fraser University

Organized and publicized peer mentor program activities, assisted professors in lectures and mobilized students' enthusiasm.Helped freshmen get familiar with and understand campus life, coached Freshmen's courses and helped them improve their grades.Cooperated with professors to organize new recruitment activities and attracted new volunteers.Trained new volunteers, assigned job responsibilities, tracked the service effect, and did a good job in the connection between students

Simon Fraser University

Master'S Degree, Management Finance

Bachelor'S Degree, Major In Economics And Double Minor In Business And Statistic

Activities and Societies: Volunteer and participate in Universal case competition Dean's honor roll

Business/Managerial Economics

Activities and Societies: Volunteer in peer memtorship program