Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Vivian Yang | Elance
 
176985602337900
Last Sign-in: Jul 9, 2015

Vivian Yang

Certified General Accountant of Canada
   Canada
  |   Toronto, Ontario

Overview

Certified General Accountant of Canada, with over 16 years experience in full cycle accounting, financial reporting and analysis, reconciliation, costing and accounting system, over 10 years in ERP conversion, database & business intelligence management (Excel, SQL server,Crystal report design).

Currently managing 3 divisons' financials and BI structure (over 30 customerized views, over 150 crystal reports, over 50 scheduled reports) for a big organization.

Read More »
Aug 20, 2013|Event Planning|$0|Working
Jul 8, 2009|Accounting|$100|Working
|
5.0
Jun 19, 2009|Accounting|$100|Completed
|
5.0
May 2, 2009|Accounting|$120|Working
|
5.0

View All »

Skills (10)

Tested
Financial Reporting
SAP Crystal Reports
Financial Forecasting
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Data Warehousing
Microsoft Access Administration
Accounting
Enterprise Resource Planning (ERP)
Microsoft SQL Server Programming
Peachtree Accounting

Service Description

BI AND DATABASE MANAGEMENT:
-SQL server view creation
-Cyrstal report designing and scheduling (or convert excel reports into Crystal)
-Microsoft access database
-Excel report designing

FULL CYCLE BOOKKEEPING & ACCOUNTING:
-Journal entries (Current & historical data)
-Month end accruals
-Bank reconciliaions
-Subledger maintenance and reconciliations (e.g. Inventory, fixed assets, CIP, WIP)
-Accounts receivable
-Accounts payable

COSTING:
-Standard cost simulation within or ouside of accounting software
-Overhead absorption calculation
-Inventory turnover or obsolesence analysis
-Royalties or commissions calculation
-PPV analysis for purchase, WIP, "in transits"
-Margin analysis
-Demand and supply analysis

FINANCIAL REPORTING:
-Financial statements
-Budgeting or forecasting
-Variance analysis: budgetary or different periods
-Bank borrowing base analysis

TAXATION:
-Personal tax return
-Strategies & preparation

Read More »

Education

Queen's University
Master of Science in Management
2000 - 2001
Remin University
Bachelor of Accounting
1992 - 1996

Keywords

CGA
crystal report
SQL server
bookkeeping & reconciliation
analysis & reporting.
My Snapshot
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
1
2
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
viviany
Type
Individual
Member Since
February 2009
Elance URL
Verifications
0
Groups
Vivian Yang | Elance

Vivian Yang