GREGORY SILVA
(***)
Mission Viejo, CA
acp0wu@r.postjobfree.com
OBJECTIVE:
I am seeking an accounting/finance position with a growth oriented company
which will allow me to fully utilize my financial background, education and
skills.
PROFESSIONAL EXPERIENCE
Alda Financial Group - Orange County, CA,
Financial Accountant/Analyst - September 2010 to Present
Analyze G/L, Balance Sheet & Income Statement accounts to research
business performance.
Prepare summary reports and supplementary materials used in presentations
to management
outlining business performance and financing projects.
Advanced Excel spreadsheet design using Pivot Tables, Formulas; VLookup,
Macros, Access Building Tables & Running Queries, Microsoft Office.
URS Corp.- Santa Ana, CA
Senior Accountant/Analyst - June 2004 to July 2010
Run daily, weekly monthly G/L, expense & revenue reports in Oracle &
Hyperion
Create and maintain Excel reports requested by management for variance
analysis & evaluation of business performance. Reports are distributed to
offices on a daily, weekly, monthly and quarterly basis.
Assist with budgeting, report preparation and presentation preparation in
business development and financing projects.
Advanced Excel spreadsheet work using macros, pivot tables & formulas.
Continuous maintenance of existing Excel spreadsheets.
Create custom Excel analysis reports for project manager requests.
Troubleshooting.
Write up and process journal entries.30 to 60 per month to maintain general
ledger accounts.
Extensive customer service by telephone, in person and e-mail researching
accounting queries and answering software questions from URS employees.
Review & process electronic transfer requests. Electronic labor requests
are individually processed in time sheet software. 200 to 400 requests per
month.
Maintain petty cash and imprest accounts and insurance file.
CGS Real Estate Company, Inc.- Irvine, CA
Financial Analyst - March 1999 to June 2004 Company Relocated to Texas
Reports directly to the Director of Financial Reporting.
Responsibilities include preparation of monthly, quarterly and year ending
financial packets presented to external auditors for final audit and SEC
filings.
Preparation of cash flow statements, income statements, balance sheets,
supporting depreciation, amortization accruals, prepaid, and CAM schedules.
Prepared variance analysis actual to budgeted in order to project future
rent increases and revenue streams.
Responsible for researching and providing additional support schedules for
external auditor inquiries as well as legal, cash and loan confirmations.
Assisted with the development of new reporting and analysis systems
necessary for move from a private to publicly traded REIT.
Created advanced Excel templates, Pivot Tables and schedules.
Successfully assisted in conversion of diverse accounting bases in national
divisions to one GAAP system.
Bank of America - San Clemente, CA
Personal Banker II - March 1997 to February 1999
Responsible for analysis and maintenance of customer accounts including
researching and auditing discrepancies and variances, opening new accounts,
account collections and maintaining balances.
Extensive customer service throughout the day.
EDUCATION
University of California Riverside-Riverside, CA
Bachelor of Science - Business Economics- Graduated with Honors
Dean's List 3.4 GPA
Accounting Courses - Financial Accounting, Intermediate Accounting I
& II, Cost Accounting.
COMPUTERS
Oracle 11.i ERP, MRI Accounting System, Lotus, Excel Advanced,
Microsoft Word, Access Building Tables & Running Queries, Skyline,
PeopleSoft, SQL, JD Edwards One World, On Base, Extra, Hyperion,
QuickBooks & Peachtree.