Data Analyst, accountant, bookkeeper, Excel Quickbooks. SQL

June Tan

480-***-**** *************@*******.*** 3162 W. Stephens Pl Chandler, AZ 85226

Summary of Qualifications

Proficiency in MS Office (particular in Excel, Word and PowerPoint). Intermediate skills with Oracle, Workday, HCM Cloud, ADT Payroll system, Taleo, Access, Database, ACL, SQL.

Strong problem solving skills and team work sense.

Attention to details and time management.

Excellent written and verbal communication skills.

Knowledge of HRIS and HR procedures.

Excellent time management skills and the ability to prioritize work and multi-tasking.

Fluency in multiple languages: English, Cantonese, Mandarin Chinese.

Certification

Business Data Analyst Certificate (Completed 3 courses of 5 courses)

Work Experience

On Semiconductor, Contractor, HR Shared Services Specialist. April – December 2018

Completed collection with 2000 plus employees’ information all over the world.

Transferred and corrected the data in HRIS database.

Maintained and updated employee personnel files and employee records in Oracle.

Used Excel to collected, analyzed and prepared payroll data and payroll system testing.

Audit global onboarding documents in Taleo.

Knowledge at and answered international employees visa and H-1b questions and processing.

Metro Realty Phoenix, Intern, Accountant May-December 2015

Prepared account entries for monthly reports and prepared documents for tax return.

Organized large amount of files to make sure they were in order in preparation for the audit.

Assisted accountant to created income statement, annual finical report and profit report.

Assisted and prepared documents for payroll.

Created and calculated commission account.

Monitored and in charge of business traveling and entertainment account.

Kolodin Law Group PLLC, Intern, Accountant January-May 2015

Handled administrative requests and queries from senior manager.

Evaluated bank statement for reconciliation and account entries.

Assisted the supervisor with month-end financial reports and balance sheet reconciliation.

Filed and prepared audit documents.

Tracked stocks of office supplies and place orders when necessary.

Capstones Education Phoenix, Intern, Accountant January 2013-December 2014

Updated contact list and answered phone calls with customers.

Scheduled meetings with manager and customers if necessary.

Arranged schedule with students and tutors.

Tracked stocks of office supplies and place orders when necessary.

Documented corporate credit card expenses to corporate finance.

Established, developed, maintained and updated filing system.

Prepared balance sheet, profit and loss statement, and other reports.

Assisted Account Payable/Account Receivable and Payroll.

Award 2015-2016 Dean’s List, W.P Carey Business School, Arizona State University

Activity 2015-2017 Volunteer at St. Mary’s Food Bank

Education

Aug 2014-May 2017 B.A. in Business, Arizona State University, Tempe AZ

Aug 2012-May 2014 Associate Degree in Business, Scottsdale Community College, Scottsdale AZ

Contact this candidate