Project Sales
Resume:
Raghav Pathania
******.********@*****.***
E XPERIENCE
EMC, Pleasanton, CA (01/16 – present)
Business Analyst (Contract)
●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
ProQuest, Mountain View, CA (07/15 - 11/15)
Senior Financial Analyst (Contract)
● 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
Chevron Corp, Concord, CA (04/08 – 06/15)
Financial Reporting Analyst
Financial Analysis Duties:
● 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
Capital Expense Duties:
● 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
Technical Duties:
● 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
Accounting/Other Duties:
● Conducted P&L reviews and detailed variance analysis for IT teams
● Analyzed sub ledger accounts and performed reclassifications with journals
● Enforced Chevron 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
PricewaterhouseCoopers LLP, San Jose, CA (04/06 – 12/07)
Financial Analyst
● Performed billing analysis for clients including LSI Logic, Nvidia and JuniperNetworks.
● 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
Deloitte Consulting LLP, San Francisco, CA (03/05 – 03/06)
Project Controller (Contract)
● 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 Deloitte consulting 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.
EDUCATION
California State University, East Bay, Hayward, CA
M.B.A. Finance & Accounting
University of California, Davis, D avis, CA
B.A. Economics Minor: Managerial Economics
Dean’s List
Coresoft Corporation, Sunnyvale, CA Certificate, SAP R3 FI/CO
Contact this candidate