SUMMARY:

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

PROFESSIONAL EXPERIENCE:

Confidential - New Jersey

Sr. Cloud Suite Financial Hyperion Planning Consultant

Responsibilities:

• Palos Community Hospital: 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 Documentation for budgeting and forecasting. Successfully supported of Hyperion Planning, Essbase, Financial Studio, Smart-view, BSO, ASO, MaxL, Bat, and Calc / Rule Scripts

Confidential - Frankfort, IL

Principal Consultant Hyperion Planning

Responsibilities:

• Pikeville Medical Center: Developed and implemented Hyperion System 11 calculation scripts, business rules, Internal and SEC Financial Reports, Smart-View Reports, and Planning Forms in Oracle budgeting and forecasting.
• London Medical Hospital: 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 Contractor Consultant

Responsibilities:

• Sheridan Healthcare: 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

Manager Hyperion Planning Architect Consultant

Responsibilities:

• Williams Energy: 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 UNIX for budgeting and forecasting.

Confidential - Tampa, FL

Lead Hyperion Planning Analyst/Developer Consultant

Responsibilities:

• Universal Healthcare: Hyperion Analyst / Developer: Lead current budget, stabilized the system, restored forms and internal and SEC financial reports, wrote scripts and rules within 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. Presented objective business reporting and analysis for a multi-billion dollar international financial conglomerate with operations in consumer, corporate, and investment banking and insurance.

Confidential - Tampa, FL

Manager Hyperion Planning Consultant

Responsibilities:

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

Confidential - Tampa, FL

Sr. Hyperion Planning Administrator / Sr. Financial Analyst

Responsibilities:

• Gathered requirements: Via facilitated sessions, group interviews, one-on-one interviews, questionnaires, management support: developed and implemented Hyperion OLAP applications/databases (Essbase cubes, business rules, calc scripts, outline calculations, data load rules, UDA's
• Implementation: achieved implementation of budgeting and forecasting applications using Hyperion Planning and Essbase
• Administrator: Managed the Hyperion System 9 BI+ environment which involved overseeing and providing 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 with team members, stakeholders, and management to anticipate and manage technical requirements, business requirements, and deadlines for these requirements
• Financial Analyst: Comparative and reporting analyst of actual/budget variances at all departments, Ad Hoc analysis for decision making

Confidential - Mulberry, FL

Manager Business Project / BI Developer

Responsibilities:

• Business intelligence tool development & companywide rollout:
• Consulted with senior management to identify business requirements; led collaboration with 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
• , coaching & consultation for managers at all levels:
• Instrumental in driving gross margin percent & increasing sales

Confidential

Business/Financial Analyst

Responsibilities:

• 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

Confidential - Tampa, FL

Contract Accountant

Responsibilities:

• Unisite Communications: Financial Analysis: Analyzed accounts receivable, billings and cash receipts. Budget review: Ensured accuracy, feasibility, and presentation of budget line items on income statement, balance sheet and statement of cash flows

Confidential - Clearwater, FL

Contract Financial Accountant

Responsibilities:

• Expense forecasting (ten regions): Developed expense projections for annual corporate budget
• Feasibility studies: Used discounted cash flow models to determine new locations, relocations, and consolidations
• Discounted cash flow analysis for newly acquired grocery chain: Created financial models and graphs; prepared and analyzed operating and market change budgets and forecasts for 40+ stores