Management Financial Analyst

Rowena Miranda

**** * ***** ** ********* C

Oceanside, California 92054

**************@*******.***

310-***-****

Experience:

Sony Computer Entertainment America Sorrento Valley, California

Senior Financial Analyst September 2008 - May 2010

Global Technology

. Consolidate and manage the annual operating plan and forecasts on a

monthly/quarterly/half-year/annual basis, covering North America,

Europe, and Asia

. Provide support and insight to senior management guidance for the

budget and forecasts

. Build custom reports to show "what if" P&L impact

. Research and present opportunities and risks at a divisional level

Product Development Services Group

. Deliver financial reporting monthly/quarterly/half-year/annual,

prepare annual operating plan and manage operating forecasts including

capital expense reports

. Coordinate departmental budgets, monitor the financial activity and

analyze the costs against the budget, identifying areas that may

require corrective checks

. Highlight current and past trends analyzing causes of unexpected

variances on a monthly basis

. Improve performance by evaluating processes to drive efficiencies and

project management

. Make recommendations regarding cost savings and productivity through

working knowledge of system operations across all departments

. Provide financial strategic support to senior management including ad-

hoc reporting, extensive analyses, and presentations

. Data mine and research financial activity, interacting with

intercompany departments, all levels of staff and management

. Manage day-to-day activities, provide external estimates for revenue

generating projects, income generation tracking, maintenance of

headcount database

Electronic Arts, Mobile (formerly JAMDAT mobile) Playa Vista, California

Senior Financial Analyst May 2005 - September 2008

. Prepare company-wide annual operating plan and financial forecasts

globally, providing guidelines and interacting with international

counterparts & domestic department heads for consolidation, review,

and analysis

. Model ad-hoc reports such as break-even, trend, budget-actual,

statistical, market investment, profit & loss

. Create power point presentations for quarterly business review and

special projects for senior management

. Gather and record departmental activity within operating budget and

generate financial supporting schedules

. Generate weekly sales reports and graphs by carrier, by title, by

handset and monthly reports to show trends

. Implement Oracle based forecasting tool at home office as part of EA

integration, currently handling all global office updates

. Conduct Merger & Acquisition analysis, trend future requirements and

operating forecasts

. Manage forecasted headcount of over 800 employees worldwide

. Train international counterparts and domestic staff on the

implementation of the Hyperion financial database and Essbase

functionality in excel

Alliant Capital Asset Management Woodland Hills, California

Financial Analyst, November 2003 - May 2005

. Review potential low-income housing deals for acquisition with

originators and senior management

. Work with underwriters and lawyers to development costs, investor rate

of return, debt coverage ratio, and debt structure for sensitivitiy

models

. Update financial performance of properties for investor reports

. Work with Asset Managers in maintenance of P&Ls to monitor and

forecast property performance, including budgets, annualized numbers,

tax returns, and audits for over 80 properties

. Create ad-hoc analyses for senior management

Activision Blizzard Santa Monica, California

Senior Financial Analyst, Corporate Development & Planning February 00 -

October 02

. Create and consolidate domestic and global p&ls, identifiying risks

and opportunities

. Interact with domestic and international counterparts to meet budget

and forecast deadlines, working on several departmental cost centers

. Review and implement company budget guidelines

. Create analyses for Senior Management such as: product-line, brand,

impact, variance, budget-to-actual, and trend

. Assist in Financial Reporting for published annual reports and

quarterly conference calls for Investor Relations

. Compile financial data and generate reports for monthly bank report

requirements

. Assist in the implementation of Oracle Financial Analyzer for company

wide use

Countrywide Simi Valley, California

Financial Analyst, Corporate Finance January 99 - February 00

Auditor, Internal Audit September 97 - December 98

. Develop financial product and market modeling, flowcharting

. Prepare monthly board package reports and calculate monthly sales'

bonus

. Prepare production reports by branch, product line, carrier, agent and

source of entire product line

. Interview auditees, develop work papers and documentation of audit

findings, identify causes or contributing factors relating to problems

or control weaknesses

. Observe and evaluate actual operating procedures, identify preliminary

existing or potential problem areas

. Draft audit reports, develop appropriate recommendations for the

solution or improvement of any problem or control deficiency and

review with Audit management

Education:

University of California, Riverside

BA Business Sociology Administrative Studies, Emphasis: Accounting &

Taxation June 1997 GPA 3.5

Omicron Delta Kappa - Honors' Society 1996-1997

Accounting Club 1996 - 1997

Dean's List 1997

Software:

Cognos

Hyperion Analyzer, Hyperion Planning, Hyperion Essbase, Hyperion Smartview

Oracle Financial Analyzer, DSS Microstrategy

ComScore, Nielsen, M:Metrics

Microsoft Excel, Powerpoint, Access, Word

Manugistics, Retail Link, AS 400

Interests:

Travel abroad, hikes, detective novels, scuba dives

Contact this candidate