PROFESSIONAL OBJECTIVE
Analyst/Finance position utilizing analytical skills and computer knowledge to contribute to the growth of a progressive company in a dynamic Industry.
SUMMARY OF QUALIFICATIONS
· Fundamental accounting knowledge of financial statements, evaluation of company ratios and forecasting through studies at the University of Phoenix.
· Proficient in using technology to enhance data and information management.
· Strong Analytical and Problem solving abilities.
· Motivated self-started with an aptitude for learning new tasks quickly.
SUMMARY OF SKILLS
Financial System Reporting Reconciliation, Statistical Modeling, Price Modeling, Forecasting/Trend Projections,
Market & Competitive Analysis, Variance Analysis and Performance Reporting.
Information/ Microsoft: (Word, Excel, Access, PowerPoint, and Outlook) Business Objects, SQL, Crystal Reports,
Technology Oracle, J.D. Edwards, A.S. 400,G/L System, Oracle Discoverer, Steelwedge, PeopleSoft and ACL
EDUCATION University of California at Santa Barbara (Santa Barbara, California)
B.A. in Business Economics, August, 1994
University of Phoenix (La Mirada, California Campus)
M.B.A., October, 1998
RELATED EXPERIENCE:
DaVita Inc.- Irvine, CA
Sr. Financial Analyst: October 2008 to October 2009
· Analyzed Dialysis trends by tracking treatments, costs, products and services used in the clinics
· Created various reports to monitor contract compliance through analysis of our purchasing data and cost data
· Prepared various monthly reports that tracked current Real Estate leases and transactions.
· Analyzed existing contracts and spend categories and identified cost savings to management.
· Maintained Lease Models and updated templates and revised as necessary.
QLogic Corporation- Aliso Viejo, CA
Sr. Business Analyst: July 2006 to October 2008
· Responsible for preparing sales revenue reports by analyzing data to help determine strategic business development opportunities using various sales scenarios.
· Forecast the sales budget for Channel POS, a $220 million dollar a year division of QLogic
· Prepare various accrual entries at month end which are based on product channel sales.
· Run and process monthly volume rebate programs for all NA POS Channels.
· Act as liaison between sales reps and management to provide support on the various sales programs at QLogic.
SYBRON DENTAL SPECIALTIES- Orange, CA
Revenue Analyst: November 2002 to July 2006
· Responsible for preparing sales revenue reports and forecasts by collecting information from other departments in order to project and compare sales impact of various scenarios.
· Forecast the sales budget for Metrex, a $60 million dollar a year division of SDS
· Prepare various accrual entries at month end which are based on product sales.
· Prepare and submit the sales by country package of the financials for Kerr Worldwide.
· Process management reports, analyze results to identify product lines/geographical areas and other areas that have exceptional or poor sales performance. Present finding to management.
· Streamline the sales commission process, by linking to other excel spreadsheets and databases, designed to eliminate the re-keying of data.
· Compile sales data for sales commission, royalty payments, and rebate payments.
· Analyze sales data to identify deviations from contract compliance
· Administration of sales contracts, to include financial analysis and reporting along with improving plans and contract enforcement.
CCC GLOBALCOM (FORMALLY INCOMNET COMMUNICATIONS CORPORATION), Irvine, CA
Financial Analyst/Billing Analyst: May 2000 to October 2002
· Monthly Analysis, reporting package with various graphs, charts, tables and reports which tracks various types of call detail; such as customer usage per minute, per product, per state and per international country called. The reports are given to management for competitive analysis.
· Responsible for the accurate and timely billing of Incomnet’s Direct and Lec Billed Products.
· Revenue Insurance reporting which tracked Paging and I.S.P. customer accounts.
· Analysis, tracking and trending of traffic to insure 100% effieciency of all calls to Globalcom’s revenue stream.
· Review and audit all call records, looking for any discrepancies received and research as needed.
MANAGEMENT SOLUTIONS/ ACCOUNTANTS ON CALL - Contract Santa Ana, CA
Systems Analyst /Staff Accountant: September 1999 to May 2000
· Research using Mas 90 accounting software to determine the Accounts Payable and Receivables.
· Account Reconciliation of daily cash reports and bank statements
· Month-end General Ledger entries and account balance review.
· Input bank invoices using Peachtree Accounting Software.
· Exported winning sales bids from Internet, credited accounts as needed
WASHINGTON MUTUAL, Irvine, CA
Sales Reporting Analyst/Financial Analyst: June 1998 to August 1999
· Assisted in the integration of the Home Savings Employees into the Washington Mutual pay structure; assisted in all commission related issues.
· Ran compensation programs for all Home Savings employees until integrated.
· Gave monthly presentations about compensation to all new sales managers.
· Analyzed compensation tiers for all Sales Reps.
· Created and distributed Bi-Monthly loan sales tracking reports to sales field.
· Ran ad-hoc queries and programs as necessary.
· Assisted in the design and implementation of the 1999/2000 Compensation Plans.
· Administrator of the incentive programs and specialized pay for all of the Sales Rep’s
AT&T WIRELESS (FORMALLY L. A. CELLULAR TELEPHONE COMPANY) Cerritos, CA December 1994 to May 1998
Commission Accounting Specialist: August 1996 to May 1998
· Process/ Analyze/ Verify over $1,000,000.00 in Cellular sales commission on a monthly basis. Such as Cellular sales from Circuit City, The Good Guys Stores and the Inside and Outside Sales Reps.
· Involved in the implementation of a download system that saved over 50% of processing time per month. This freed up my time, to spend more time analyzing sales commission.
· Answer any questions related to Sales Commissions, following the guidelines as stated in the Commission (compensation plans) Contracts.
· Post Commission Expense Payable to the General Ledger.
· Prepare management ad-hoc reports as needed on a monthly basis.
· Assist in month-end closing, with various charts and graphs that analyze sales commission.
Cellular Fraud Account Investigator: December 1994 to July 1996
· Process and Analyzed the amount of Fraud credits issued.
· Worked on special Fraud accounts as given from the Presidents Office.
· Identified a tax saving, in, out of state roaming Credits.