Sales Accounting

Alan Fung

*** **** ****** ********, ** 646-***-**** **********@*****.***

[pic]

Summary of Qualifications

Active candidate pursuing the CFA charter with comprehensive accounting

knowledge and understanding of financial analysis through professional work

experience and continued studies. Highly detail oriented, organized team

player and technologically advanced with proficiency in MS Access, Excel,

Outlook, PowerPoint and Word. Dedicated to learning about the financial

markets through experience as an analyst.

Experience & Accomplishments

Fund Accountant

SunAmerica Asset Management - Jersey City, NJ

Jul 08 - Present

Brought on board to prepare and analyze quarterly financial statements and

portfolio of investments for various SEC filings, perform monthly expense

analysis, and reconcile daily NAVs. Coordinate with StateStreet Bank to

resolve discrepancies and errors.

* Design a macro using Excel VBA which transmutes a report presented in

Excel format into a table directly used in financial reporting,

dynamically improving efficiency in the process

* Develop a template in FundSuite Comfiler for use in N-SAR filings to

extract and calculate information from the financial statements,

eliminating the need for manual input

* Optimize various worksheets through the incorporation of advanced

Excel formulas, greatly improving consistency of the data

* Introduce innovative changes in utilizing Bloomberg and Excel to

research security holdings in portfolios

* Participate in training for new filing software, FundSuite Arc, in

response to changes to Rule 2a-7 regarding Money Market Funds

Accounting/Finance Intern

Capital Systems - New York City, NY Jun 07

- Jul 08

Hired to assist in the preparation of financial statements and maintenance

of billing database; reporting directly to the Chief Financial Officer.

Reconciled bank statements, processed aged receivables and populated

billing information into Navision.

* Successfully completed a systems conversion project by transferring

and reconciling historical data from Peachtree 2000 to Navision 4.0

* Identified errors in sales reconciliation and reconstructed the sales

analysis schedule used in recording of sales data and calculation of

ratios to correctly reflect sales figures

* Created instruction manuals for Navision 4.0 to assist in navigation

through the system and provided solutions to common problems

* Assisted in determining the validity of corporate expense claims from

the sales team, preventing payment of non-business related expenses

Education & Professional Development

CFA Charter

Active Level II candidate in the CFA program. Exam - June 2011

Bernard baruch College (CUNY) - New York City, NY

Bachelors of Business Administration in Accounting - 2008

Cumulative GPA 3.35/4.00

Contact this candidate