Accounting Microsoft Office

Joanna Zhou

**** ******** ****, ***********, ** L5L 5K4

905-***-****; *********@****.**

QUALIFICATION HIGHLIGHTS

• Proficiency in Microsoft Office Suites, Word, PowerPoint, Access and Excel

• Advanced Excel Skill- V-Look up, Pivot Table, Data Validation, Macro (VBA), What-if Function

• Sufficient knowledge in Simply Accounting System, QuickBooks, Microsoft Dynamic GP, Slack system, SPSS data analysis tool

• Financial Modeling- Using Excel to conduct Financial Statement Modeling and Discounted Cash Flow Modeling

• Financial Statement Analysis- Able to use ratio analysis such as liquidity ratio, risk analysis ratio and value ratio to identify problems and causes in the financial statement

• Budgeting- Able to use variance analysis to identify over/under budget in the financial performance, and make adjustment and recommendations accordingly

WORK EXPEREINCE

Financial Project Assistant April 2012- April 2015 Century 21 Today’s Real Estate, Niagara Falls, Ontario

• Successfully forecasted future three years business expense patterns for small business owner by using Excel functions to analyze past five years accounting data

• Minimized 20% potential business losses by recommending buy- and- sell decision based on scenario analysis on break-even sale

• Controlled and reduced cash flow risk by monitoring expense activities to make sure that available fund is sufficient to meet our financial obligations

• Successfully recommended revenue generation options and pricing strategies based on accounting records and economic factors

• Accurately tracked business performance by conducting daily bookkeeping process using Simply Accounting system, such as entering date entries, reconciling bank &credit card statements, tracking accounts payable/receivables Bookkeeper October 2014- April 2015

Coinoutlet, Burlington NC, United States

• Set up Chart of Accounts in an accurate accounting sequence in the online QuickBook system for company’s initial started up, make sure that assets, liability and expense accounts reflected company’s activities

• Maintained accuracy and productivity of day-to-day activities of accounts payable, cash disbursements, and payrolls in an efficient and timely manner using QuickBook system

• Closely monitoring and issuing financial records for CEO to ensure an accurate and understandable accounting reports are recorded

• Demonstrated problem solving skills by researching and resolving collections and billing disputes Finance Intern (CO-OP) May 2014- August 2014

Rugby Canada, Richmond Hill, Ontario

• Achieved 100% accuracy in financial reports by reconciling corporate operating account, Diners account, and managers’ Visa card

• Successfully increased the efficiency and productivity of finance team by effective communicating problems and clarifying tasks with supervisor and team members

• Successfully ensured corporate bills are paid in a timely basis by keeping track on accounts payables in Dynamic GP system, and by communicating with vendors through emails & phones to investigate missing invoices

• Ensured corporate taxes are in “ready to go” status by preparing HST tax rebate on expenses and services in accordance with provincial tax rebate rules

EXCEL PROJECT ACCHEIVEMENT

Income statement Modeling(2015)- Applied ratio analysis (COGS Margin, Operating expense ratio) on past income statements and using those ratios as reasonable assumption to create forecasting template for future five years by using Excel tools such as Pivot table, Conditional Formatting, Freezing panes and 3D References.

Efficient Portfolio Analysis (2014) - Led team of three to construct efficient portfolio and to evaluate systematic risks by using ten selected risky stocks in TSX; Used Excel Matrix (MMULT, Transpose) to calculate returns and standard deviations on individual stocks, and Presented results on Pie charts and Bar charts.

Goodman Career Funding Model(2013)- Led team of five to establish benchmark funding models and template for Goodman Career Office by using Excel Macro, Sort& Filter, and Text to Column functions to reclassify large data set, and using Excel Pivot table to present results. EDUCATION

Master of Business Administration (Finance Stream) September 2013- March 2015 Goodman School of Business- Brock University, St. Catharines, ON Finance (MBA, Exchange Study Program) September 2014- March 2015 Katholieke Universiteit Leuven, Leuven, Belgium

Honors Bachelor of Accounting January 2010- April 2013 Goodman School of Business- Brock University, St. Catharines, ON

Contact this candidate