PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Business Analyst

Responsibilities:

• Managed project financials totaling $70MM in revenue
• Calculated SOP 98 capitalization requirements for project costs
• Met with project and resource managers to review financials and provide support
• Processed monthly SOW accruals and reversals and updated active contracts
• Presented financial forecasting data and reconciled in Essbase
• Utilized VBA programming to automate Essbase financial reporting for cost center hierarchy
• Reviewed and approved invoices in Oracle system for payment
• Provided recommendations on allocation of resources to various projects
• Participated in decision making process during PRB meetings
• Reviewed sales commission reports with controller and other finance leads

Confidential, Mountain View, CA

Senior Financial Analyst

Responsibilities:

• Prepared monthly sales commission reporting for VP of Finance
• Analyzed financial data and trends for Ebooks business
• Compared sales and royalty rate trends on year to year basis
• Prepared accruals, reclasses, and P&L report for financial dashboard review
• Maintained large sets of data using Global Sales Reporting tool and Hyperion
• Budgeting and forecasting duties in Hyperion performed on monthly basis
• Participated in budget and forecasting reiteration meetings

Confidential, Concord, CA

Financial Reporting Analyst

Responsibilities:

• Reduced overall operating expenses by 30% for entire IT organization through furloughs, travel expense reductions, offshoring resources and key project efficiency initiatives
• Engaged in planning and budgeting decisions for annual business cycles; performed reforecasting iterations as needed
• Provided ongoing feedback and performance recommendations to management
• Analyzed headcount and operating expenses at cost center group level
• Budgeting, forecasting duties and variance analysis for all IT teams
• Met annual budget targets within 5% of operating expense goals
• Managed and led capital finance committee meetings with product services
• Worked closely with project managers to manage capital expense funding; reallocated project funds as needed based on quarterly expenditures
• Reviewed capital spend for various projects with leadership committee
• Developed forecasting tool for capital expenditure tracking
• Strong knowledge and understanding of Business Planning and Consolidation tool
• Converted existing spreadsheet reports into BPC application using Visual Basic
• Tested newly upgraded version of BPC for reporting functionality
• Trained new hires on using financial reporting tools and analytics
• Downloaded complex data sets from SAP system and formatted into Excel using macros
• Conducted P&L reviews and detailed variance analysis for IT teams
• Analyzed sub ledger accounts and performed reclassifications with journals
• Enforced Confidential accounting methods on projects; calculated depreciation and amortizations, direct billings, and project labor cost allocations
• Consolidated cost center roll - up of financials for managerial review
• Engaged in budgeting and forecasting duties to manage cost center expenses within ITC and PAD finance.
• Reported financials and provided recommendations to management for reducing IT headcount costs.
• Developed and maintained monthly headcount rosters and project expenditure reports for ITC teams using VBA programming.
• Provided financial reporting support for the Ariba upgrade project, and managed the overall forecast for review by the project management team
• Assisted planning committee with reduction of ITC expenses for team budgets
• Performed accounting month-end and year-end close duties
• Utilized Hyperion Essbase to generate financial forecasts and budgets

Confidential, San Jose, CA

Financial Analyst

Responsibilities:

• Performed billing analysis.
• Created value added tax (vat) revenue report for managers,directors and partners.
• Used pivot tables to categorize vat report regionally, and presented analysis.
• Provided monthly revenue analysis on engagement portfolios for partners.
• Administered invoices to clients and ensured timely cash collections.
• Analyzed engagement revenue gains for assigned clients.
• Obtained 95% of monthly billing and cash collection goals.
• Tracked invoices in payables database, and approved payments
• Met with all levels of client services and provided exceptional support
• Received recognition for high performance within finance team

Confidential, San Francisco, CA

Project Controller

Responsibilities:

• Responsible for SAP implementation project with $50M budget
• Managed financials for key SAP ERP implementation projects
• Provided recommendations based on monthly engagement results to partners
• Performed tracking of time and expense reports for consultants.
• Utilized the Deloitte Pricing Model to track the profitability of engagements
• Enforced Confidential policies and practices
• Monitored and updated project engagements with actuals/forecasts
• Used pricing model to calculate profit margins, and pivot tables to organize expense reports.