Tuong Dao

Motivated and dedicated Staff Accountant with over three years of experience in month-end closings, bank reconciliations, and balance sheet account reconciliations; A proven ability to create Microsoft Excel macros through Visual Basic for Applications (VBA) to automate routine tasks, and a strong background in property management accounting and wholesale petroleum distribution accounting

Experience

Staff Accountant

Oct 2018 – Present Western National Property Management

Managing a portfolio of around thirty apartment communities and being responsible for cash management, review of vacancy loss, delinquencies and prepaid rent applications, resident refund and bank reconciliation, and monthly financial statement preparation (trend operating reports, budget variance reports, and balance sheets) for these sites

Accounts Payable Associate

Jun 2018 – Oct 2018 International Education Corporation

Processed an average of 800 invoices to ensure that the accounts payable aging balance stayed at around $3 – $4 million every month, performed weekly check runs, and reviewed monthly vendor statements to investigate and resolve unknown invoices

General Ledger Associate

Mar 2017 – Jun 2018 IPC (USA), Inc.

Prepared month-end closing journal entries (accrual, reclassification, payroll, depreciation, amortization, and other adjusting entries), reconciled key balance sheet accounts to their supporting schedules, and recorded miscellaneous cash receipts

Education

Doctor of Business Administration

Mar 2018 – Apr 2021 (Anticipated) Westcliff University

Master of Science in Accountancy

January 14 – Dec 2016 California State University, Fullerton

Bachelor’s Degree in Business Administration

Sep 2009 – Jun 2013 University of Economics, Ho Chi Minh City

Achievements

Western National Property Management

Streamlined month-end closing processes by making Excel macro-enabled workbooks to post miscellaneous cash receipts and disbursements to Yardi Voyager

IPC (USA), Inc.

Reduced the amount of manual data entry substantially by building a standard procedure for integrating data from Excel worksheets to Microsoft Dynamics GP (Great Plains)

Enhanced the company’s bonus plan for regional managers by creating Excel workbooks with macros to allocate overhead costs among profit centers and adding tabs to the Excel Ribbon with buttons and menus to execute the macros

Redesigned the employee expense reimbursement form to secure a 30% reduction in accounts payable processing and payment times and facilitate the audit process

Language Skills

Vietnamese

English

Computer Skills

Microsoft Excel

Visual Basic for Applications (VBA) for Office

Web Design