Accounting Analyst

Dong S. Yu

**** ******* ****, ***** ******, NY **365 • Cell: 917-***-**** • Email: ******@*****.***

EXPERIENCE

Abraham Innovation Systems Inc. w ww.abrahaminnovations.com 06/12 – PRESENT

SENIOR ACCOUNTANT Long Island, NY

• Provide both actual and estimated budgeting /forecasting analyses for the General Motor & Chrysler innovation projects

• Perform Gap Analyses explaining variances between budget, latest forecast and actual expenditures (OPEX/CAPEX) on Production

• Manage general ledger processing, including: posting journal entries, account and bank reconciliations in SAP FI

• Prepare balance sheet, P&L reports, month-end close, and reports related to the firms’ current and projected financial position

• Utilize advance Excel functions to create financial models, prepare PowerPoint presentation and generate Ad-Hoc reports per request

Morgan Stanley Smith Barney LLC. 02/09 – 01/12

02/09 01

FINANCIAL ANALYST – FINANCIAL REPORTING/OPERATIONS – Stock Option planning Services New York, NY

• Generated reconciliation reports (using SQL, Ad-hoc, BO) to the accounting group and custodian banks for products control

purpose

• Identified root-causes of any Exceptions on the Security Reconciliation report and provided proper solution in a timely manner

• Participated in preparing Month-End/Quarter-End closes by generate various Financial/Accounting Analyses and Ad-Hoc reports

• Advised clients on handling multiple tax collection methods; including Dividend Reinvestment Plans and Cost Basis Reporting

• Verified portfolio cash activities into the accounting system on a daily basis; reconciled currency balances between bank and

custodian

• Provided comprehensive solution for stock options plans, restricted stocks, restricted stock units, and performance plans

• Performed and documented User Acceptance Testing (UAT) on plan setup and system remediation

BUSINESS ANALYST – FINANCIAL DATA MIGRATION – Stock Option planning Services New York, NY

• Managed the data migration project for all stock options plans to be migrated from the Legacy-Morgan system to the Smith Barney

Sapphire system (for the joint venture of Morgan Stanley and Smith Barney)

• Worked directly with Client Services, Operations and Technology to elicit Business/Functional Requirements

• Developed key quality standards, metrics, and related reports to provide transparency around quality of execution

• Performed system testing on reconciliation of account holdings/activities; including check portfolio holdings, trading activities, and

cash balances with the custodian bank’s statements, researched and resolved any outstanding exceptions.

• Import large set of data to Excel from Access Database / SQL servers; generate various Excel reports by using VLookup, Pivot

Table, Advanced filtering, and Charts; Created/edited Macros for various Excel Templates that will be used in routine basis

BUSINESS ANALYST – ACCOUNTING INFORMATION AUDIT – Retirement Plan Solutions Purchase, NY

• Participated on establishing an effective Client Relationship Management system by transferring financial/non-financial data from

several Morgan Stanley systems into a unified database (for the joint venture of Morgan Stanley and Smith Barney).

• Performed Retirement Accounts Audit to ensure the accuracy of client data as well as the compliance with the SEC regulations.

• Audited account entries and reported doubtful plans/accounts to Client Managers and provided comprehensive solutions

• Performed system testing to ensure accounting data is accurate and reconciled for monthly/quarterly statements

• Obtained relevant reporting data by utilizing Oracle SQL Developer/Business Objects and performed Ad-Hoc reporting services

Ernst & Young LLP. New York, NY 01/07 – 09/08

FINANCIAL ANALYST - Business Advisory Services

IAL

• Assisted in reviewing the financial statements and supporting schedules provided by client’s subsidiaries; ensured compliance with

SOX 404 Control Standards

• Reviewed and advised clients on performing GAAP adjusting entries, elimination entries, and detailed reconciliations in the

consolidation process

• Advised clients in consolidating financial statements, footnotes, other financial disclosures and necessary support for 10Q and 10K.

• Analyzed the client’s recording and reporting processes to simplify the path to reduce the overall timing of financial close process

• Searched for root cause problems in sub-ledgers that feed General Ledger to simplify process activities to reduce the complexity of

data mapping and report generation

• Developed Excel Models to conduct cost/benefit analysis, scenarios comparison, periods of payback, and return on investments

Deutsche Bank Securities Inc. New York, NY SUMMER 2006

OPERATIONS ANALYST INTERN – Risk & Analysis Control Group

• Generated independent aged risk reports for No-Name accounts on a daily basis

• Notified potential fails to managers of different operation groups before the risks become an audit issue

• Prepared weekly report on all Client Fails, Broker Fails, Account Receivable and Payable

EDUCATION Institution of Technology SUNY, MS in Accounting Information Systems, expected graduation date: June 2013

Bernard M. Baruch College CUNY, BBA in Finance, January 2007

PROFESSIONAL SKILLS:

Proficient in Excel/Access/Word/PowerPoint/Visio/Project, Great Plains, Business Objects, SQL, Oracle SQL Developer, SAP

Business Consulting: Strong knowledge on Project Management, General Accounting/Finance, Regulatory Finance

Certification: Microsoft Excel Specialist, Microsoft.com

LANGUAGES: Fluent in Chinese (Cantonese and Mandarin)

Contact this candidate