SUMMARY:

Expert Oracle Hyperion Essbase (ASO/BSO) and Hyperion Planning Analyst/Developer/Administrator with 10 years of experience on the design, creation, support, testing, implementation, and administration of financial applications. Effectively simplifies complex data structures, creating organized data models. Extensive experience in all phases of software / application development life cycle. Efficient communicator and liaison with functional and technical users, transforming project requirements into technical specifications. Recognized for designing and developing reports/templates quickly mainly using Hyperion Financial Reporting (FR) Studio and Hyperion SmartView. Effectively maintain and setup metadata and dimension hierarchy structures using Hyperion Enterprise Performance Management Architect (EPMA). Create cube constructs enabling end users / analysts to acquire needed information more quickly and efficiently. Rapid analysis of financial data with the ability to determine correct Point of View (POV) and ease in doing pivoting, Proficient in Budgeting and Forecasting, mainly supporting monthly/quarterly forecasts and annual budgets.

CORE STRENGTHS IN:

• Multi - Dimensional Database Analysis / Development
• Business Intelligence Analysis / Reporting
• Troubleshooting & Problem Solving
• Dimensional Modeling
• Data Warehouse
• Business Analysis
• Cross-Function Communication
• Leading Project Teams
• Planning, Budgeting, & Forecasting
• Data Model & Database Programming

TECHNICAL SKILLS:

Oracle Hyperion Essbase (ASO/BSO) Version 11 and 9

Erwin Data Modeler

MS Project

Oracle Hyperion Planning (EPMA and Classic)

Linux/Unix

Oracle Hyperion SmartView

SQL Queries

Oracle Hyperion Financial Reporting

Oracle Hyperion Shared Services

Oracle Hyperion Web Analysis

MaxL, MDX, Calc Scripts, Report Scripts, Data Forms, Business Rules, Load Rules, Partitions

SQL Server

SSIS Packages

Microsoft Office Suite

Windows Server

RELEVANT EXPERIENCE:

Confidential, Houston, TX

Senior Consultant

Responsibilities:

• Oracle Essbase & Hyperion Planning Lead, Finance Hyperion Applications Division
• Contracted as the Lead person in maintaining and supporting Oracle Hyperion Essbase and Planning applications.
• Work closely with Accounting on doing Metadata and Data loads & validations, Hierarchy changes, and creation, deletion, & modification of Profit and Cost centers during close (Monthly, Quarterly, Annually).
• Creation and modification of Web forms, Calc scripts, and Business Rules for a 12 month Rolling Forecast.
• Responsible for assigning Security Filters per dimension.

Confidential, Sugar Land, TX

Senior Systems Analyst

Responsibilities:

• Maintains and supports Oracle Hyperion Planning, Budgeting, and Forecasting EPM application for Noble Drilling globally.
• Planning is designed with 18 months rolling forecast with 3 plan types of Main, Wkforce, and Capex. Administer both Hyperion Planning (through EPMA) and Essbase with transparent partitioning between Main and Wkforce cubes.
• Created, modified, and optimized Web Forms, Business Rules, Calc Scripts, Load Rules, Outlines, Member Formulas.
• Have also developed and maintained FR Reports using Financial Reporting Studio.
• Automations and movement of data between HFM and Planning were done thru IBM Cognos Command Center, ODI, and FDM.

Confidential, Houston, TX

Oracle Hyperion Essbase Sr Analyst/Developer, Finance and Accounting Systems Division

Responsibilities:

• Built and maintained CapEx ASO cube (Capital Management System), as backend source for analysis from five OBIEE dashboards - Capital Expenses Projection, Top 200 AFE’s (Authorization for Funds Expenditure), Forecast Accuracy, Profitability Rating, and Residual Forecast.
• Built and maintained OTC ASO cube (Order To Cash), as backend source for analysis from three OBIEE dashboards - Invoice Scorecard, Invoice Effectiveness, and 15th Invoicing.
• Maintained Results ASO cube - main financial cube that handles analysis on Actuals, Forecasts, Budget, Consolidations, with front-end users utilizing reports made in Financial Reporting Studio and SmartView.
• Maintained FinRes ASO cube - similar to financial cube Results, but with front-end OBIEE dashboards.
• Maintained CustRev BSO cube - deals mainly with Customer Revenue with Financial Reporting Studio reports and SmartView as tools for end-users.
• Managed quarterly MetaData changes for all five Essbase cubes above, with DRM (Data Relationship Manager) as source for centralized changes. Executing, testing, and moving changes from/to environments’ Development to QA, then to Production.
• Built, modified, and maintained Essbase Outlines, Calc Scripts, Report Scripts, MaxL scripts, SQL Scripts, Linux shell scripts, Windows batch files, Member properties and formulas, MDX formulas, and Build & Data Load Rules for all five cubes above.

Confidential, Houston, TX

Oracle Hyperion Essbase BI Analyst/Developer

Responsibilities:

• Consulted for Confidential on the infrastructure and software upgrade of their Oracle EPM (Enterprise Performance Management) environment.
• Created an automated ETL process that moves metadata and actual data from their transactional relational database to a multi-dimensional database.
• Maintained BSO cube and ASO cube.
• Installed and configured Oracle EPM 11.1.2.2 System (Calculation Manager, Essbase, EPMA (Enterprise Performance Management Architect), Hyperion FDM (Financial Data Quality Management), Foundation Services, Hyperion Planning, Hyperion Reporting and Analysis, and Hyperion Workspace) in a new Windows 64-bit servers environment.
• Migrated Essbase BSO and ASO Applications and Databases (Properties, Variables, Macros, Functions, Calculation Scripts, Report Scripts, Rules Files, etc.) from the old version Oracle EPM 11.1.2.0 to the latest version Oracle EPM 11.1.2.2.
• Created an automated process that moves metadata and actual data from Enertia relational database to the Essbase Financial cubes.
• Optimized and fine-tuned Financial cube by creating calculation scripts, modifying outlines, and updating Essbase settings.

Confidential, Houston, TX

Management Consultant

Responsibilities:

• Consulted for Delphi Automotive on the plan and analyze phase of the Master Data Management / Data Relationship Management project.
• Defined and helped document data quality, cleansing, error handling requirements and methodologies.
• Managed risks and issues and escalate any roadblocks appropriately.
• Created conceptual architecture diagrams.
• Collected and created a Requirements Traceability Matrix of 4 domains of customer, organization, platform and product in only 5 weeks, resulting in a clear structure of the hierarchical design for the Master Data.
• Defined governance and maintenance processes, assigned roles for governance teams, and helped document data quality, cleansing, error handling requirements and methodologies, which allowed for accurate data and knowledge of assigned roles and security permissions.
• Performed Systems Test, Functional Test, Integration Test and Performance Test of Hyperion Planning Application. All the tests were documented and saved to the HP Application Lifecycle Management tool / software.

Confidential, Houston, TX

Oracle Hyperion Essbase BI Analyst/Developer

Responsibilities:

• Created and maintained Oracle Essbase cubes and the development and maintenance of front-end BI applications for the Division of Finance for the entire Confidential.
• Built and maintained Fund Equity BSO cube and Budget vs Actuals BSO, migrating to Oracle Essbase 11 under Windows environment.
• Built Personnel Cost (Human Resources Management with emphasis on the finance particulars). ASO cube - deals with UH Employees / Personnel with measures of Headcount, FTE, Payroll (salary), and
• Migrated and updated of all Oracle Hyperion Essbase system 9 (Red Hat Linux) cubes, applications, and software (Oracle Essbase and BI tools) to Oracle Hyperion Essbase system 11 (latest version of 11.1.2.1) (Windows), improving performance and allowing latest version with access to all new features.
• Automated daily cube processes (delete, build, and swap) through the creation of MaxL scripts and load rules using PL / SQL.
• Automated daily data audit processes through the use of Report scripts and Calc scripts.
• Defined and established security by provisioning user roles through Hyperion Shared Services.
• Optimization and fine-tune of Oracle Essbase cubes, increasing efficiency and improving performance.

Confidential, The Woodlands, TX

Financial Advisor

Responsibilities:

• Prospected and established long-term relationships with clients by creating and implementing Personal Comprehensive Financial Plans through the Six Key Areas - Net Worth, Insurances, Investments, Tax Management Strategies, Retirement Planning, and Preservation of Wealth
• Hold the necessary licenses - Insurance and Securities - to offer financial solutions.

Confidential, Hollywood, FL

Senior Business Systems Analyst

Responsibilities:

• Analyzed customer and user requirements and created technical specifications, while performing maintenance on system.
• Provided technical support on multichannel (web) clients. Primary technical analyst on dealing with web clients on integration, implementation and support of Multichannel (web) modules.
• Completed multiple projects for Finance, Inventory, Groups, Sales, etc.
• Completed automation of the Group Master manual cycle from creation of new deals from clients to the automatic sending of the Group Contract by fax or email.
• Completed revision of Discounting and Repricing module of the Confidential reservation system, which resulted in an improved and accurate Discounting and Repricing module.
• Created core APIs (Application Program Interface) to extract data in the PROGRESS Database then transferred to Data Warehouse for multiple reports created from CORVU front-end system.
• Created APIs for Web partners (Travel Agents with online cruise booking) to access system in real time.

Confidential, Atlanta, GA

Consultant / Systems and Database Analyst / Developer / Trainer

Responsibilities:

• Developed new and / or major enhancements on Costa Cruise Reservation System namely:
• Standard Commission Computation.
• Group Inventory.
• Pricing Cross Reference for a Cruise.
• Deposit Value Computation.
• New Agency Browser during Booking Process.
• Agencies by Phone Browser.
• Automatic Transfer Generation.
• Automatic Insurance Booking.
• Net Tour Operator Rate (Discount linked to Commission).
• Remarks / Notes / History.
• Air Level Pricing (Gateways / Zones / Cities).
• Discounting (by Amount, Percentage, Flat-rate, Per Diem, and User-Defined).