New York NY, US
Phone: xxx-xxx-xxxx
Email: xxx@xxxx.xxx
Looking For: accountant, financial analyst
Occupation: Business and Finance
Degree: Master's Degree
Career Level: Qualified
Languages: Mandarin Chinese, English, Spanish
Highlights:
Skills:data analysis, Excel, Access, Communication, team work, financial modeling
Tax Intern 01/2014 - 04/2014
Angel's Tax Service, Columbus, OH United States
Industry: Tax Accounting
- Tax Preparation: prepared federal and state tax returns for both individuals and small businesses, achieving average reductions in tax burden of 15%, after self-learning and mastering Drake tax prep software
--
Property Accounting Intern 07/2014 - 08/2014
Equity, Inc., Columbus, OH United States
Industry: Real Estate
- Financial Reporting: created a system that automated the process of generating 210 different financial reports for property owners and lenders, dramatically decreasing administrative systems and providing clients real-time access to all reports
- Database Management: applied knowledge of various software platforms to evolve a unified database of the company’s more than 80 properties using Access and Excel; generate financial statements using Yardi; and disseminate using SharePoint
--
Accountant 07/2014 - 09/2014
NiSource, Columbus, OH United States
Industry: Utility
- Expense Management: reconciled three years of time sheet data for over 150 employees, reducing expenses by over $600K
- Forecasting: researched and forecast over $1 million in future salary expenses for the company, applying advanced Excel skills to filter and analyze data sets
- System Implementation: collaborated with IT teams on the testing and companywide implementation of PeopleSoft 8.9
- Data Analysis: reviewed large data sets and identified patterns and variances in employee overhead costs
--
Fiscal Intern 06/2012 - 09/2012
Wingspan Care Group, Shaker Heights, OH United States
Industry: Health Care
- Data Analysis: created a space allocation database for all employees in the company HQ to track overhead expenses, improve human resource management and optimize the use of space
- Audit Preparation: examined data and searched for variances in the main database tracking all organizational funding sources (federal, state and individual contributions) to prepare for the organization’s annual audit
- Process Improvement: analyzed payment procedures and recommended bringing certain functions in-house to reduce administrative expenses by over $6K per year
--
The Ohio State Univeristy 09/2010 - 05/2013
Columbus , OH, United States
Degree: Bachelor's Degree
Major:Accounting
Minor:Economics
I have participated in Accounting Association and Fisher Cares while studying at Fisher College of Business.
CPA Candidate, Accountant Accountant