SUMMARY:

• Lead Business/Financial Budgeting, Forecasting, Reporting and Analyst wif Expertise in Applying Hyperion Planning and Data Warehouse Business Intelligence to Corporate Strategic Planning for Improved Profitability
• Broad Background as Financial Accountant and Sr. Reporting for Diverse Organizations

PROFESSIONAL EXPERIENCE:

Confidential

Consultant - Hyperion Planning / Essbase / FRS

Responsibilities:

• Successfully led supported budget & forecast plan in BSO applications, built hierarchies, financial reports, reworked scripting, presented issues and solutions.

Confidential

Principal Consultant Hyperion Planning - Remote

Responsibilities:

• Successfully administered Premise Hyperion Planning and Essbase BSO, ASO applications. Work wif new implementation PBCS. FRS, Smart-view, MaxL & batch files, load & bus rules, calc scripts.

Confidential, New Jersey

Sr. Cloud Suite Financial Hyperion Planning Consultant -

Responsibilities:

• Developed and delivered management reports via dynamic Infor BI Enterprise Performance Management Application Studio. Delivered hierarchical chart of accounts for dynamic reporting and analysis.
• Delivered d/EPM application training documentation, including installation, repository & OLAP administration, designer setup dimensions & upload metadata, cube development, data load, create reports, & dashboard setup.

Confidential - Frankfort , IL

Principal Consultant Hyperion Planning - Remote

Responsibilities:

• Led cube developed and implemented Hyperion System 11 calculation scripts, business rules, Metadata load, load rules, MaxL, Bat Scripting, Internal and SEC Financial Reports, Smart-View Reports, and Planning Forms in Oracle budgeting and forecasting.
• Cube developed and implemented Hyperion System 11 calculation scripts Internal and SEC Financial Reports Public Sector Planning and Budgeting (PSPB)

Confidential - Sunrise, FL

Sr. Hyperion Planning Essbase Consultant

Responsibilities:

• Lead developed and supported Hyperion System 11 including Essbase, Planning, Shared Services, Smart View, and Internal and SEC Financial Reports. Successfully developed dBase backups, ASO - MDX formulas, Bat, MaxL, and PS for budgeting and forecasting.

Confidential - Tulsa, OK

Lead Hyperion Planning Architect Consultant

Responsibilities:

• Led a team of six via Hyperion System 11, Essbase, Hyperion Planning, EPM, Workspace, Shared Services, Internal and SEC Financial Reports, Web Analysis, SmartView, Excel Add-in. Successfully develop and maintain Hyperion System 11 Business Intelligence applications including Essbase, Hyperion Planning, EPM, Workspace, Shared Services, internal and SEC Financial Reports, Web Analysis, Smart View, Excel Add-in, and budgeting and forecasting.

Confidential / Spherion - Tampa, FL

Lead Hyperion Planning Consultant

Responsibilities:

• Universal Healthcare: Led team of four via development, budget, stabilized the system, restored forms and me nternal and SEC financial reports, wrote scripts and rules wifin Essbase and Planning, communicated issues and procedures for a large privately held insurance company for budgeting and forecasting.
• Citi Group: Hyperion data miner: Gather business requirements, retrieve, and identified correlations across multiple dimensions via Interactive Reporting.

Confidential - Tampa, FL

Manager Hyperion Planning Consultant

Contract Consultant

• Hyperion Consultant: Successfully implemented Hyperion v9.3, including Planning and Essbase cube development, internal and SEC Financial Reports, Web Analysis and Smart View for educational management company wif revenue of $2.1 billion for budgeting and forecasting.
• Hyperion Consultant: Successfully implemented as managing liaison Hyperion v11, including Planning, Essbase, Reporting Studio, Web Analysis and Smart View HFM, and FDM for Energy Company wif revenue of $1.1 billion for budgeting and forecasting.
• Created a 680-page website for a multimillion-dollar Craft Equipment Service Company, which receives 600,000 hits annually. Dreamweaver, HTML, Java

Confidential, Tampa, FL

Sr. Hyperion Planning Administrator / Sr. Financial Analyst

Responsibilities:

• Gatheird requirements: Via facilitated sessions, group interviews, one-on-one interviews, questionnaires, management support: developed cubes and implemented Hyperion OLAP applications/databases (Essbase cubes, business rules, calc scripts, outline calculations, data load rules, UDA's
• Administrator: Managed the Hyperion System 9 BI+ environment which involved overseeing and providing cube development efforts when needed in the areas Hyperion Planning application development. Hyperion business rule development and modification, Hyperion Planning web form development and change, Hyperion Essbase application development, calculation script development and modification, Hyperion reports development and modification
• Liaison: Interfaced wif team members, stakeholders, and management to anticipate and manage technical requirements, business requirements, and deadlines for these requirements

Confidential, Mulberry, FL

Manager Business Project / BI Developer

Responsibilities:

• Business intelligence tool cube development & companywide rollout:
• Consulted wif senior management to identify business requirements; led collaboration wif programmers to design, develop and deploy a multi-dimensional model tool for monitoring, analyzing, and reporting information
• Dimensional data analysis & management reporting (all stores/warehouses):
• Generated and analyzed key performance indicators and scorecards (across multiple dimensions), such as GMROI, gross margin, AR aging and delinquencies, inventory turnover, service level and days-on-hand
• Training, coaching & consultation for managers at all levels:Instrumental in driving gross margin percent & increasing sales
• Financial analysis (320 stores): Designed and conducted analyses of multiple drivers contributing to margin, including (but not limited to) product profitability, payroll, special costs, store promotions and competition
• Financial modeling & benchmarking: Developed sensitivity analyses for forecasting sales, costs, margin, cash flow, etc.
• Presentations to senior management & Board of Directors: Reported on strategic and operational analyses