Office Financial Analyst

Billion Chow

***********@*****.*** Bill's Mobile #: 626-***-****

EDUCATION: Bachelors in Economics, Business

University of California - San Diego (UCSD) - La Jolla, California

GPA: 3.47

SOFTWARE: . Bloomberg Terminal, MS Excel (Vlookup-Hlookup-Pivotables-Sort-

Filter-Macro), FX MetaTrader, SQL, Mathlab, SAS, AS400, Capital IQ,

PowerPoint, SAP, Outlook, Access, Oracle, Argus, RiskMetrics, Moody's,

Advent, Morningstar, SharePoint, QuickBooks, Risk-Metrics, FTP, Stata,

Tableau, Peoplesoft, HTML, PhotoShop Paint, Google Picasa, Java, Lender

Processing Srvs, Word, Financial Modeling

EXPERIENCE:

Bank of America

Financial Analyst, July 2012-present

. Analyze numerous transactions and income data on numerous

investment loans within the bank's BAC asset portfolio : NAV: $10-$50+

billion

. Utilize SQL, AS400 software to research, select client fee data and

account information, addresses, trancodes, transaction keys

. Research and classify backups in the early stages of the accounting

cycle prior to trial balance

. Create an Access database sample to better track and display loan

fee income in loan investment financing data

. Post service release and prepare invoice bills as part of cash

disbursements to accelerate fund liquidity & cash flow as part of BAC's

business transaction within its cash conversion cycle to third party

investors, mid-market servicers

. Post service release and deliver numerous documentation backups to

various banks, mortgage service companies (ie GNMA, HUD, FHA)

. Generate a sample Pivot Table graph to better visualize fee costs

on specific transactions including attorney legal fees, utility properties

. Develop a new technique to better streamline and file search a

numerous loan records in any folder in a few seconds.

. Re-train two other analysts to fully execute and take advantage of

this due diligence approach which resulted in 1,000 more loan records

saved and reimbursed

. Real estate property pricing appraisals throughout the United

States served mostly in California, New York, Texas, Florida, Washington,

Nevada

Prudential Financial

Financial Investment Analyst, 2011-2012

. Examine Fortune 1000 corporations' executive investment plans

utilizing Bloomberg software with historical performance investment pricing

. Coordinate with numerous investment analysts, portfolio managers to

provide investment plans performance and reporting information

. Pull dividend information from Bloomberg, Oracle software on

approximately mutual funds, stocks from historical performance data

. Research corporation actions on mergers & acquisitions with special

funds based on fixed rates followed by Money Markets and Moody's

. Prepare calculation workbook from Vanguard Prime Money market with

daily rate, annual yield percentage with account balances

. Review investment pricing on the following trade batches: PIMCO

Total Return Bond Portfolio, BNY Mellon, BlackRock Equity Dividend,

New York Life, Oppenheimer, Barclays Bank, Morgan Stanley Instl Cap Growth,

Fidelity, Charles Schwab, and TCW Collective Fund Prices

. Implement for critical data support on ongoing pricing for a

variety of investment service options in platform, including COLI, Split

Dollar, Executive Life, mutual funds, corporate stocks, proprietary funds,

dividend administration related to executives, high net worth corporation.

Daily Policy administrative tasks include premium billings, preparation, re-

balancing, reconciling policy allocations, & delivery of Net Asset Value

reports

WEDBUSH Morgan Investment Bank & Securities

Accounting Analyst, 2010-2011

. Analyze ibanking trades with corporate securities reports in high

volume market activity

. Calculate investment bankers & executive's net earnings, draw

payouts with corporate headquarters accounts for 90 offices

. Monitor accounting liabilities of employee wages, salaries, bonuses,

401(k), and 1099 in charts of accounts aligned with W2's

LEADERSHIP EXPERIENCE:

UCSD Business & Financial Services - Budget Office, Financial Analysis

Office, General Accounting Office

Financial Analyst II/Accounting Assistant, Sept 2009-March 2010

. Reconciliations of lease rates and term agreements for UCSD's Medical

School office properties - assets

. Revise tax financing questionnaire paperwork for bond approval from UC

Regents - Office of President for capital planning purposes

. Summarize campus financial policies involving authorized expenditure

recharges

. Attende meetings on university's funds, expenditures cost discussions on

various campus business activities

International Financial Services

Associate - Finance & Investments, Jan 2008-Jun 2008

. Assist back/middle office personnel with clients on 3yr insurance

policy plans - $300,000 & premium financing payments for planning targets

. Contact clients on application info with Access database to

streamline data processes along with ad-hoc requests on insurance policies

. Help brokers contact policyholders to explain policy programs with

provided suggestions regarding any additions/changes with beneficiaries

COURSEWORK & INTERESTS:

. Organizational Leadership . Entrepreneurship: Innovations to Technology

. Corporate Finance & Investment

. Econometrics Business Statistics . Project Management

. Financial Accounting

. Microeconomics/Macroeconomics . Cost Accounting

. Product Marketing

Contact this candidate