Financial/Data Analyst Resume Los Gatos, CA - Hire IT People

SUMMARY:

Dynamic and competent professional with Masters Degree in Business Administration (MBA) and 10+ years of professional experience in Data Analysis, Financial Analysis, Business Intelligence Reporting, Managing Promotion Programs in High Tech Industries.
Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels
Expert in MS Excel & Google Sheets; Pivot Table, Vlookup, Sumifs, Countifs, Index, Slicer, Filter
Strong data reconciliation skills; Can find out difference between two data sets quickly
Financial Modeling
Data validation during data migration
Oracle Financial ERP Systems: Payment processing and report generating
Other Cisco tools: Finance Business Intelligence (FinBI), SIRE, Status tool, Service Contract (CSCC), Invoice tool, AR Inquiry Report, COAM, PMC, PDB
SAP Business Objects, SQL, MS Access, SFDC, Tableau, Word, PowerPoint, HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Los Gatos, CA

Financial/Data Analyst

Prepare bookings forecast on a weekly basis
Prepare forecast variance report (actual vs forecast)
Prepare total revenue report
Work with Engineering team to build custom report for Finance
Revenue validation and royalty calculation for authors
Perform cost analysis and report actual monthly/quarterly/yearly cost
Analyze performance of sales team (account executives) based on opportunity vs closed deal
Manage accounts payables in Xero and reconcile Stripe revenue on monthly basis

Confidential, San Jose, CA

Reporting Analyst

Prepared Business Intelligence Package (20 pages); Analyze large data set and provide meaningful charts and presentations for executive decision making
Presented findings in team meeting and incorporated suggestions from other members
Prepared weekly WW Service and Product channel Bookings reports using SAP Business Objects and prepared dashboards for executives
Ran Pipeline report (new service deals) from Salesforce and forecast Channel service bookings based on pipeline report and trend analysis
Performed Strategic Data analysis to identify customers’ frequency
Analyzed financial impact for new service channel contracts and partner incentive programs
Managed Cisco’s MOU based Service promotion program for cloud based products
Worked with Alliance Managers to create new service contract
Managed quarterly/yearly program budget for Alliance Managers
Reviewed proof of performance and process payment to Cisco partners on timely basis

Confidential, San Jose, CA

Reporting/Financial Analyst

Prepared worldwide service booking and revenue report for alliance partners on a quarterly basis, analyze Q/Q & Y/Y growth
Forecasted booking and rebate on a monthly basis for revenue accounting accrual
Maintained forecast variance using accuracy file to study actual vs forecasted number
Validated bookings as per criteria of the financial contract then finalize payment
Investigated disputed bookings using various internal Cisco web based tools
Processed and monitored payment to ensure accuracy using Oracle Financial ERP Systems
Ran Finance Business Intelligence reports for internal Ad - hoc request, analyze and summarize reports on regular basis
Worked as a business analyst and worked as a liaison between Offshore team and Channel finance for automation process

Market Research Analyst

Confidential, Scotts Valley, CA

Delivered market forecasts to enhance executive-level decision making
Created processes to effectively gather, manage and evaluate large data sets
Conducted research on emerging markets to educate the company on expected market behaviors