Management Project

Summary

Solution-focused, analytical and team oriented Hyperion consultant with

proven experience creating cost effective budget and forecasting strategies

and developing and implementing Hyperion Planning/Essbase applications.

Professional Experience

2010 ADR Analytics

Owner/Consultant

. Providing Hyperion System 11 Planning and Essbase consulting services to

a global digital media provider. Examples of experience with current

and past projects include:

o Requirements gathering

o Database/ cube design and development

o Calculation creation, testing and optimization

o End-user and administrator documentation

o Metadata management

o Performance optimization

2010 Resources Global Professionals

Consultant

. Provided consulting services to a major wireless broadband provider

o Normalized source system data and created MS Access databases for

use during complete warehouse physical inventory counts

o Led database administration team with the creation of MS Access

databases to capture, manage and report national inventory results

within 12 hours of inventory completion.

o Conducted transaction reconciliation to ensure inventory integrity

o Assisted with Oracle integration testing

o Performed program management for national deployment of 3PL partner

. Created and managed team project plans in MS Project

. Acted as liaison between warehouse and central executive

teams

. Coordinated and tracked warehouse security assessments and

approvals

. Created C-level executive recaps for weekly status meetings

2006-2009 Univar Inc.

Manager Planning Administration, Corporate Finance Group

. Developed and implemented global, multicurrency Hyperion System 9

Planning applications:

o Translated data from 13 local currencies to 3 reporting currencies,

including CTA

o Utilized Workforce Planning to forecast & budget employee expenses

and HC

o Optimized performance

o Created multiple P&L and BS views including tax, reporting and

currency neutral

o Assessed risks/opportunities, developed functional requirements and

implemented appropriate enhancements based on best practices

o Coordinated Hyperion upgrades with user groups, consultants and

technical partners

. Created specialty-purpose Hyperion System 9 Essbase cubes:

o Inter-country loan interest, payment and balance planning cube

o Capital asset and liability planning and analysis cube

. Performed testing and data reconciliation of corporate Hyperion System 9

Financial Management (HFM) application and served as the back-up

administrator

. Created and maintained Hyperion Financial Reports sourced from HFM,

Hyperion Planning, and Hyperion Essbase applications

2006 Berntson Porter & Company PLLC

Project Analyst, Litigation and Forensic Accounting Group

. Evaluated internal controls and provided recommendations for improvement

. Performed construction project cost analysis

. Created financial models (ROI and Loan analysis)

2005 Getty Images

Senior Financial Analyst (contract), Finance Group

. Prepared the company headcount and related salary expense budget for 2006

2005. Washington Mutual Bank

Senior Financial Analyst, Specialty Finance Group

. Designed a Financial Planning & Analysis application in Hyperion System 7

Planning

. Provided Hyperion Essbase and Hyperion Planning training

. Participated in the development of a company-wide Product Profitability

System in SQL

. Coordinated the development of annual and long -term financial and

strategic plans

. Designed and maintained rolling financial forecasts

. Designed management financial reports

. Conducted process improvement analyses

1997-2002 Arthur Andersen LLP

Senior Financial Consultant, Business Consulting Group

Senior Financial Consultant providing services to internal and external

clients in the areas of project management, data mining, forensic

accounting, financial modeling and quantitative analysis. Specific

projects include:

. Contract management

. Construction contract audits and claim evaluations

. Mergers and acquisitions

. Wealth and portfolio management

. Patent infringement

. Process improvement

Education and Certifications

1997 University of Washington, BA in Accounting and Human Resource

Management

1999 Passed CPA Exam

2007 Hyperion Certified Administrator for Hyperion System 9 Planning

Hyperion Training:

. Hyperion System 9 Planning: Create and Manage Applications

. Hyperion System 9 Financial Management: Create and Manage Applications

. Hyperion Essbase 9.3 for System Administrators

. Hyperion Essbase Analytics 9.3 Bootcamp

. Hyperion Planning 9.3 Installation and Configuration

AMY L. DEL ROSARIO

+1-206-***-**** ~ ****@************.***

Contact this candidate