Fanyu (David) Pan

Fanyu (david) pan

bookmark on deepenrich
Followers of Fanyu (David) Pan666 followers
  • Timeline

  • About me

    Staff Accountant at True Light CPA Professional Corporation | Intern at RBC, CHS Business Solution

  • Education

    • Milton district high school

      2010 - 2014
      84%-92% overall average

      Activities and Societies: Senior Concert Band and the Fitness Club - Active Member of the Senior Concert Band and the Fitness Club- Participated in many mathematics contest and won the School champions Medal twice and ranked in the top 25% contestant three times- Honour Student (80%+) in all four years of high school

    • Wilfrid laurier university

      2017 - 2021
      Bachelor of arts - ba economics and accounting year 3

      Activities and Societies: Active Member of the Laurier Accounting Association and Chinese International Student Association • Relevant courses: Advanced Financial Accounting and Reporting (A-), Accounting Systems, Income Tax for Corporations, Cost/Managerial Accounting (B+), Microeconomics (A+), Macroeconomics (A+), Statistics (A-)• Distinguished member of university’s Accountant Society Club• Projects: Financial Ratio Analysis - Led a team of five to perform financial ratio analysis using Advanced Excel to assess company’s financial health on financial statements. - Calculated ratios for company’s… Show more • Relevant courses: Advanced Financial Accounting and Reporting (A-), Accounting Systems, Income Tax for Corporations, Cost/Managerial Accounting (B+), Microeconomics (A+), Macroeconomics (A+), Statistics (A-)• Distinguished member of university’s Accountant Society Club• Projects: Financial Ratio Analysis - Led a team of five to perform financial ratio analysis using Advanced Excel to assess company’s financial health on financial statements. - Calculated ratios for company’s profitability and activity for years of 2016 and 2017 and measured the percentage of growth of the ratios. - Performed a presentation to include comparative analysis on key ratios and provided recommendation for the company generates more income from assets and sales. Show less

    • Western university

      2014 - 2017
      Science

      Activities and Societies: Peer Mentor and Team leader for first year student in the Leadership and Academic Mentorship Program (LAMP) • Received Western Entrance Scholarship of Distinction for 88%+ admission average• Worked as a mentor to provide academic and social support to first year student in the Leadership and Academic Mentorship Program (LAMP)

  • Experience

    • Western university

      Sept 2015 - Apr 2016

      -Worked with a group of 10 first year students and provided academic support to help them achieve their first year academic goals-Stay connected with the 10 first year students via cell phone, emails and meetings with other peer mentors to ensure that these first year student are on the right track because they are new to the university environment • Assisted Dr. Qingping Feng with fetal heart sample preparation for histological and gene expression analysis• Recorded research data and observed experimental equipment for journal publication purposes• Implemented quantitative techniques to analyze experiment observations with sample and control studies

      • Peer Mentor in the Leadership and Academic Mentorship Program (LAMP)

        Sept 2015 - Apr 2016
      • Research Assissant in the Department of Physiology at Western University

        Sept 2015 - Jan 2016
    • Ey

      Jan 2019 - Mar 2019
      Research assistant internship

      • Performed in-depth research on the industry and labour-force evolution of China over the past 10 years• Utilized official statistics and published papers to identify potential industries facing labour shortage threat by 2025• Performed econometric analysis on time series of labour demand/supplies to identify risk drivers and opportunities• Implemented an Excel model to project and report trends and qualitative measures of future labour market • Complied decks and delivered presentations to senior management on talent gaps across various dimensions• Excellent research and analytical skills evidenced by completing the independent research to receive positive feedbacks from the management team Show less

    • Wealth intelligence alliance

      May 2019 - Jun 2019
      Summer internship

      • Optimized office expenditures by identifying efficiencies in vendor contract terms and pushing for more favorable contract terms over the previous arrangement; realized 15% of general and administrative cost savings over the previous quarter• Advised on new financial service product launch by building training presentation deck for the Sales and Marketing teams and delivering trainer note package to ensure smooth execution of training day

    • Rbc dominion securities

      Jun 2019 - Aug 2019
      Summer internship

      • Revamped layout of the daily market insights memo sent to Investment Advisors and received 100% satisfaction in feedback gathered from all the Investment Advisory teams • Liaised with Investment Advisory and Client Success teams during client onboarding to ensure completeness in documentation of all submitted applications• Performed quantitative and qualitative research on labour market statistics over the past 10 years and constructed an excel model to forecast future key metrics• Analyzed financial statements of companies in the insurance and asset management industry and proactively constructed master ratio analysis excel to facilitate knowledge-share across different Investment Advisory teams Show less

    • Chs business solutions

      Jul 2020 - Nov 2021
      Accounting intern

      • Learned various accounting software (e.g. QuickBooks, Sage 50, Tax Prep, Caseware) within one week of onboarding and performed the following tasks with 100% accuracy• Prepared financial statements and adjusted entries for accrual accounts and fixed asset maintenance• Prepared daily banking transaction and account reconciliation for 15 entities • Processed payroll data and created pay cheques for 50 employees in 2 entities• Filed government returns (HST, Payroll), T1 and T2 returns and liaised with the CRA Show less

    • Hagarliao cpa professional corporation

      Dec 2021 - Mar 2022
      Junior staff accountant
    • Mac llp

      Jul 2022 - Feb 2023
      Staff accountant

      • Accurately and efficiently prepared tax returns and year ends for customers using attention to detail • Accomplished team objectives using planning and delegation skills with other team members• Met required deadlines by performing time management skills while preparing various engagements for clients• Adapted to different challenges presented by different corporate tax returns

    • Kanish and partners

      Mar 2023 - Apr 2023
      Staff tax accountant

      • Prepared, filed, and maintained effectively and efficiently annual T1 personal tax returns for 300+ individual clients in a fast-paced tax department• Generated and updated tax project tracking reports and transferred updates to software• Participated in weekly tax meetings and collaborated with tax team on streamlining processes• Provided excellent customer services by answering inbound & outbound calls with client’s tax questions and maintained the integrity and security of personal information obtained from clients Show less

    • Aic global holdings inc.

      Jul 2023 - Jan 2024
      Accountant

      • Monthly account reconciliations for multiple companies-fixed assets, prepaids, AP sub-ledger, gain loss on mark-tomarket• Journal entries – multicurrency, including but not limited to petty cash, monthly foreign currency revaluation of loan balances and related parties• Aided with audit requests, analyzed and audited financial statements by pulling required documentation, also downloading and saving information from GP for audit queries

    • True light cpa professional corporation

      Jan 2024 - now
      Staff accountant

      • Prepared spreadsheets, reports and monthly account reconciliations for multiple clients• Assisted in the preparation of year end financial statement, T4 and payroll remittance filing on a monthly basis• Completed subsidy application forms both in Excel and online to determine the eligibility of both wage and rent subsidies for clients by reviewing and verifying all relevant data and information

  • Licenses & Certifications

    • Canadian securities course (csc®)

      Canadian securities institute
      Nov 2021
      View certificate certificate
    • Sas certified base programmer for sas 9 (cbp)

      Sas
      Jun 2019
    • Sas certified advanced programmer for sas 9

      Sas
      Aug 2019
  • Honors & Awards

    • Awarded to Fanyu (David) Pan
      Western Scholarship of Distinction Western University Jul 2014 -Achieved a Final Admission Average of 88%+ -Values $1000
    • Awarded to Fanyu (David) Pan
      Ontario Scholar Ontario Ministry of Education Jun 2014 - Achieved the overall average of 80%+ in all four academic years of High school
    • Awarded to Fanyu (David) Pan
      Medal of School Champion in the Canadian Senior Mathematics Contest The Centre for Education in Mathemetics and Computing at University of Waterloo Feb 2013 -Ranked first place in the school among all the contestant in the Canadian Senior Mathematics Contest
    • Awarded to Fanyu (David) Pan
      Certificate of Distinction - Ranked in the top 25% in the Cayley Mathematics Contest The Centre for Education in Mathemetics and Computing at University of Waterloo Mar 2012 -Ranked in the top 25% of all the contestants in the Cayley Mathematics Contest-Ranked second place in the school
    • Awarded to Fanyu (David) Pan
      Certificate of Distinction - Ranked in the top 25% in the Canadian Intermediate Mathematics Contest The Centre for Education in Mathemetics and Computing at University of Waterloo Nov 2011 -Ranked in the top 25% of the Contestant in the Canadian Intermediate Mathematics Contest-Won a School Champion Medal for achieving the highest score in school
    • Awarded to Fanyu (David) Pan
      Certificate of Distinction - Gold Standard in the Fryer Mathematics Contest The Centre for Education in Mathemetics and Computing at University of Waterloo Jun 2011 -Scored 32/40 points (80%) in the Fryer full solution mathematics contest-Achieved Gold standard and top 25% of all the contestants
  • Volunteer Experience

    • Volunteer, Touring student and School Builder in Ghana

      Issued by WE.org on Mar 2014
      WE.orgAssociated with Fanyu (David) Pan
    • Hospital Volunteer in the Medical Surgical Unit at Milton District Hospital

      Issued by Halton Healthcare on Oct 2012
      Halton HealthcareAssociated with Fanyu (David) Pan
    • Academic Mentor

      Issued by Halton Multicultural Council Inc on Mar 2012
      Halton Multicultural Council IncAssociated with Fanyu (David) Pan