Financial Analyst Sales

Victor Magallon

Home/Cell: 408-***-**** Campbell, CA

95008

Email:***************@*******.***

FINANCIAL ANALYST

An experienced Financial Analyst with 10 years of extensive and diverse experience across multiple

sectors & industries including networking, enterprise software, ecommerce, consumer technology,

biotechnology, security, retail and contract manufacturing. I have the ability to quickly immerse and adapt

to different work environments. I am bilingual in Spanish. I have had contract assignments extended

multiple times.

MAIN SKILLS

(1) Month/Quarter/Year-End Reconciliation (2) Budgeting and Forecasting

(3) Variance Analysis (4) Balance Sheet and P&L Analysis

(5) Business Partner Relations (6) Financial Systems

(7) Operations Analysis

Budget Analyst for CH Reynolds at Cisco, 7/10-9/10 Direct Hire.

Tracked expenses and ensured execution via Oracle iProcurement for a top 5 project at Cisco in the

hundred millions.

Sales Ops Financial Analyst for Accountants International at Websense, 4/10-5/10 Contract job.

Validated commission payments in Compel software.

Created Compensation Plan documents on a monthly basis for individuals with new plans.

Validated data for commission rates, quotas, and other measures in Salesforce.

Senior Financial Analyst for Meritus LLC at Guidewire, 1/10-2/10 Contract job.

Tied out budget variance analysis results to worldwide department templates.

Updated and ran macros on a monthly basis to populate worldwide operating expense and headcount

templates from BVA analysis.

Reconciled this spreadsheet to management reporting for company financial results disclosure.

Documented these processes including monthly GL consolidation and expense reporting as future

guidelines.

Senior Financial Analyst for Pro Unlimited & Kelly Financial at Life Technologies, 7/09-8/09 & 2/07-9/07

Contract jobs.

Constructed annual reagent forecast from research department’s manager input.

Built template to automate SAP actuals by business unit and cost center by linking multiple tabs and

inserting checks for total expense by month, quarter and year in order to tie back to financial reporting results and

ensure scalability and data integrity.

Assisted as business partner to Manufacturing and R&D cost center owners.

Created, adjusted and performed variance analysis on forecast and actual templates for direct expenses,

headcount, and other manufacturing costs.

Utilized Hyperion Planner in FY07-FY08 budget process.

Closed month and quarter-end financials using SAP.

Senior Financial Analyst for Net Polarity at Juniper Networks, 8/08-6/09 Contract job.

Forecasted, planned & assisted as a business partner for the second largest revenue-producing business

unit.

Had contract extended twice for exceptional performance and support.

Senior Financial Analyst for Accounting Network at Ebay, 9/07-12/07 Contract job.

Implemented Classified department’s FY08 budget process.

Forecasted and analyzed revenue streams, expenses, headcount and financial metrics.

Created Excel templates to submit to business partners for budget upload into Khalix.

Reconciled between budget and target summaries for multiple forecast scenarios.

Performed month and quarter-end close using SAP.

Senior Financial Analyst for Accountants Now! At Openwave, 12/06-2/07 Contract job.

Assisted in the preparation of the weekly finance report including bookings, revenue, operating

expenses, headcount, cashflow, and a/r aging.

Participated in the monthly outlook and quarter-end close process.

Analyzed data from cash, headcount requisition, and offer reports using pivot tables.

Supported VP of Finance with ad-hoc projects using variance analysis.

Senior Financial Analyst for Summit HR Worldwide at Cisco, 6/06-11/06 Contract job.

Worked with members of the Corporate Functions Finance team to support the annual plan

process for the World Wide Finance Organization.

Implemented budgeting and forecasting for two product lines using Plan-It!

Performed month-end close and reconciliation.

Assisted with year/month-end close and SOX compliance.

Performed balance sheet accounts reconciliation.

Peformed budget vs. actual variance analysis.

Booked accrual and cross-charge journal entries into Oracle 11i.

Developed Powerpoint financial metrics.

Financial Analyst for Kelly Financial at Omidyar Network, 1/06-3/06 Contract job.

Created financial analysis Powerpoint presentation for year-end board package.

Constructed various financial statement lead schedules for year-end audit.

Assisted with month-end reconciliation for four entities in the Omidyar Network umbrella.

Performed financial analysis for all department budget vs actual reports using

FRx & Great Plains packages.

Financial Analyst for Accountants Inc. at Chordiant Software, 11/05-12/05 Contract job.

Supervised and documented the upload of fixed asset data for software conversion from

proprietary database to Great Plains software

Ran variance analysis on year-to-date accumulated depreciation.

Verified fixed asset book value for life-to-date accuracy.

Financial Analyst for Photon Dynamics, 9/05-11/05 Direct Hire.

Supported all corporate functional departments in all aspects of financial planning, reporting and

analysis.

Administered the Hyperion Planning application.

Assisted with the preparation of the annual/mid-year budget and monthly forecasts.

Compiled and distributed monthly management reports, ensuring accuracy and conducted quality

control and improvements to system generated reports using the Essbase add-in to Excel.

Analyzed and documented variances between actual, forecast and budget.

Created Powerpoint presentations of operating expense variances for head of departments.

Financial Analyst for Coretechs at Verisign, 5/05-9/05 Contract job.

Supported Corporate Marketing, Legal, Strategic Development, Policy, & IA-Purchasing-Tax by

analyzing data via report generation and download into Excel.

Analyzed data from Hyperion Pillar, TM1in Excel, Oracle Discoverer, and Oracle GL & PO Inquiry.

Assisted with variance analysis, forecasting, month-end package, & operations review.

Pulled & sorted financial information for IDC including IT Marketing Departments & Interbrand for

Verisign Brand Valuation Survey.

Audited headcount, phone card expenses, and travel & entertainment expenses

Submitted reclass & accrual JV’s using Oracle ADI interface.

Utilized Oracle iProcurement to correct and view receipts/accruals.

Financial Analyst for Spherion at The Gap, 3/05-5/05 Contract job.

Compared Oracle ADI-generated monthly facilities maintenance expense reports to Essbase

generated current month actual to budget reports by departments to explain variances.

Updated project funding commitment budgets for all brands’ new and remodel stores in Excel

from Oracle Discoverer.

Updated facilities maintenance invoices and accruals for actuals and forecasted data on a

monthly basis.

Set up allocation formulas for individual projects in Oracle 11i.

Updated year-to-date actuals for PO projects and month-end accrual reports.

Financial Analyst for Volt Services at Apple Computer, 12/04-3/05 Contract job.

Utilized SAP in report creation for online store department.

Manipulated the data of SAP reports using sumif, concatenate and vlookup functions.

Ran a SOX audit of contract employee pay/commission/bonus for variance in charges.

Maintained worldwide vendor database in global information access reporting tool.

Documented all processes as future guidelines.

Accountant at Veritas Software, Symantec & Flextronics, 7/03-10/04 Contract jobs.

Lease Analyst for Adecco at Cisco, 9/01-2/03 Contract job.

Booked over 1,945 lease contracts worth over $177 million into Oracle 11i.

Rebooked, reconciled, and amended lease contracts in Sybase (LeasePak) program.

Reviewed and analyzed tax terms in E-Lese program and in Excel 2000 template.

Applied cash and utilized Oracle ADI to create Journal entries for end-of-month & end-of-quarter

procedures.

Had contract extended three times due to exceptional performance to implement E-Lese

automization.

Financial Analyst for Accountants Inc at PowerTV, 1/01-4/01 Contract job.

Rebuilt company financial model for the purpose of financial analysis. In particular,

Developed revenue section and 30 departmental sections in the model.

Expanded expense departments to meet “consistent” criteria, including consistency in account

details as well as expense allocations for cost of sales.

Created variance analysis reports for management review, including revenue, cost of sales and

spending variances against forecast and fiscal year budget.

Ensured accuracy and data integrity for the purpose of report building and analysis.

Financial Analyst for Ajilon Finance at Fatbrain.com, 9/00-12/00 Contract job.

Constructed MightyWords.com (Fatbrain subsidiary) income statement in Excel since

MightyWords.com original funding date using individual invoices, accruals, and adjustments.

Analyzed income statement down to individual departments on a monthly basis from SAP.

Junior Financial Analyst for Accountants Now! at Applied Materials, 2/00-7/00 Contract job.

Reconciled asset accounts and monthly balance sheet and income statement.

Reconciled cash payments from the monthly bank statement of accounts.

Updated headcount template for domestic & foreign operations each month.

Logged Cashflash and forecasted cash flows two months in advance.

Updated cash transactions using TeamPC.

Logged fixed assets and journal vouchers; audited expense reports.

SOFTWARE

Oracle 11i, SAP, Hyperion Planner, Essbase, and Microsoft Excel specifically with financial model development,

linking, macros with VBA modification, pivot tables, lookups, and sumifs. Great Plains, Salesforce, BAAN,

Hyperion Pillar, Oracle Discoverer, Powerpoint, Khalix, Plan-It!, ADI, TM1 and Microsoft Access.

EDUCATION

B.S. Degree in Finance – San Jose State University – 1998

Intermediate Accounting course at De Anza College January-June 2010

Contact this candidate