Sales Financial Analyst

Skills and Experience

. Financial Analysis

. Consolidation

. Mass Allocation

. Variance Analysis

. Forecasting

. General Ledger

. A/C Reconciliation

. Month-end Close

. FSG Reports

. Ad-Hoc Reports

. Internal Audit (SOX)

. External Audit(E&Y)

. Account Analysis

. Report Writing

. Creating CSV files

. SQL

Computer Applications

. Oracle E-Business Suite R12 (& R11i)

. Oracle Financial Analyzer

. Hyperion Essbase

. Quick Books

. Brio

. MS Excel (advanced)

. MS Word

. Power Point

Professional Skills

. Cross Functional team work

. Detail Oriented

. Time Management

. Experienced in New Method Development - Process Optimization

. Strong evaluation and problem solving skills

. Excellent at building strong relationships at all levels

. Proven ability to lead by example, to find optimal solutions

Education/Qualification

. MBA, Finance, Maharishi University, (India) 2003-2005

. Bachelor's, Accounting, Osmania University (India) 2000-2003

Industry Lines

. Software

. Hardware

. Manufacturing

Principal Areas of Practice

Strong analyst and an Individual contributor with a unique combination of

finance and systems in a software industry. Passionate about process

improvement, analysis and learning new skills. Excel at meeting business

requirements where accountability, productivity and results are required.

Professional Work Experience

McKesson Corporation, San Francisco, CA March-2014 - till date

Financial Analyst, (Contractor)

> Works within VMO Technology Procurement Group supporting financial

functions.

> Analyzes 3rd party vendor agreements, spend, and other related

financials

> Maintains analysis on Excel models used within the group

> Performs analysis of the financial data to roll up to VPs and SVPs

within the group

> Act as a liaison to business partners to follow up on outstanding

action items

RAININ Instruments LLC, Oakland, CA Sept-2013 - March 2014

Financial Analyst III, (Contractor)

> Managing budget process and quarter forecasts updates.

> Supporting Sales and Marketing departments with financial planning and

Budget versus Actual (BVA) analysis.

> Managing monthly internal reporting package (Analyzing department

expenses and explaining the variance for the brides MTD Actuals vs PY/

Budget & YTD Actuals vs PY/ Budget. And dash board reporting for

senior management.

> Managing corporate monthly reporting package requirements.

> Supporting Controller in system integration projects.

> Responsible for monthly financial close.

> Various ad hoc analysis and special projects as needed.

> Daily sales reporting (DSR) and sales analysis.

> Analyzing department expenses and book JE for reclass entries.

> Booking of accruals and reconciling major accounts.

JDS Uniphase Corporation, Milpitas, CA April 2013 - July 2013

Financial Analyst III, (Contractor)

> Recent experience in manufacturing inventory, logistics and

distribution.

> Providing financial support and analysis to the corporate for the

overseas plants and contract manufacturers.

> Prepare financial reporting bridges to track actuals vs. forecast,

prior forecast and provide to higher management for commentaries.

> Calculation of MOH (Material Overhead Cost), Freight, PPV, Cost

reduction, Absorption and Spending and Manufacturing Spend details.

> Assisted in developing sales forecasts and comparative financial

reports, tracked inventory

> Established and implemented accounting procedures for preparing

financial statements

> Forecast and ordered production and shipment units per month,

analyzing sales data to accurately meet demand and emergency orders.

> Ordered, tracked, and monitored inventory of supplies and finished

goods system-wide

> Prepared and analyzed statistical and productivity reports, and

coordinated information management between two data-tracking

applications.

Oracle Corporation, Redwood Shores, CA April 2008 - Jan 2012

Financial Analyst

> Provided financial support and analysis of the corporate expenses per

Line of Business, by allocating it to the local, divisional, regional

and global subsidiaries based on tax allocation methodologies,

including shared service centers

> Assisted in Consolidation, Mass Allocations, Reconciliations, Month-

end Close process.

> Worked closely with TAX department managers on determining allocation

methodologies for expenses to benefiting subsidiaries based on LOB

with forecast estimates every quarter.

> Acquisition experience: when Oracle acquired Sun Microsystems in the

year Jan 2010 (and various other acquisitions) successfully merged the

new company in the GL and closed the books for the year end on time

without any issues.

> Project the lead on creating Variance Analysis of all International

Subsidiaries quarterly on excel which required working with the

different years, quarters of data considering the LOB and SCOA changes

ranging every quarter and overall management process.

> Supported SOX team with internal audit and E&Y with external audit of

the GL quarterly.

> Maintaining General Ledger per SCOA (Standard Chart of Accounts), LOB

(Line of Business) and Account changes/updates every quarter including

testing of the process on the test database before migrating it to

production.

> Worked closely with TAX department managers on forecast and budget

estimates, completing the forecasts in Hyperion Essbase and presenting

to executives.

> Research, design, develop and implement a model to forecast/plan

expenses for a software company with numerous lines of business. Model

projects multiple expense components, by months, accounts and

subsidiaries.

> Acted as functional lead in implementation of financial systems or

product upgrades; Serve as liaison between IT and Finance/Accounting

functions; Design and map chart of accounts; Develop and execute test

scripts; Design financial reports using csv files; Identify and

implement "quick hit" process improvements; Perform post-

implementation troubleshooting.

> Collaborated work with department staff to resolve outstanding

reconciliation issues.

Major Projects

Hyperion Essbase: Developed, Implemented and Executed - Tax Forecasting and

Budgeting Model.

> Worked closely with TAX department managers on forecast and budget

estimates, completing the forecasts in Hyperion Essbase and

presenting to executives. The result was a 1st pass acceptance

which made 1 week process a 4 hrs work.

> Forecast Model Development: Research, design, develop and implement

a model to forecast/plan expenses for a software company with

numerous lines of business. Model projects multiple expense

components, by months, accounts and subsidiaries.

5000 Hyde Park Drive

Fremont, CA-94538

Phone: 650-***-****

Home: 510-***-****

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

Contact this candidate