xin wen

* Processed the school store and all fund-raising activities’ revenue and expenses, and conducted general ledger daily * Reconciled bank statements and generate financial reports monthly * Prepared annual financial budget and tax return * Researched, analyzed, and resolved accounting issues and discrepancies * Coordinated and communicated with the school’s accounting department, administrative staff, and PACA executive leaders * As a member of PACA leadership team, provided financial updates and recommendations for PACA Executive Committee

* Performed annual / quarterly / monthly budget plans and forecasts, and analyst actual vs. budget variance for 16 cost centers * Conducted Technology Production Volume Tracking, Expense Monitoring and Expense Corrections. * Managed capital budgets, reviewed Capital Tracking Report and other budgeting tools to streamline control process * Performed and automated the control reports * Designed, created, updated, tested and maintained Funding Database and multiple Financial Models and Forecasting Models by utilizing Microsoft Access and Excel * Performed research and analyses on complex projects by utilizing Oracle 11i, Technology Sector cost recovery methodology, and Microsoft Excel and Access Macros * Created model and software' User Guides for internal education purpose

As a DBO (Database Owner), managed OFA (Oracle Financial Analyzer), created and maintained financial models and reports to support Accounting Controllers and Finance departments

* Performed timely investment accounting on an automated accounting system and determine NAV (net asset value) daily * Provided daily investable cash balances to portfolio manager and reconcile cash to custodian * Prepared trial balance, financial statements, audit analysis schedules and annual adjustments

Activities and Societies: Dean's List 1997-1998