SUMMARY

• Oracle Certified Senior Hyperion Solution Developer/Administrator with broad knowledge of Oracle Hyperion business intelligence, financial reporting and software development tools.
• Proven experience with the ability to plan and support the analysis, architecture and development of Hyperion software solutions to answer business challenges.
• Talented and accomplished IT professional having 7 years of experience installing, configuring, upgrading, patching, analyzing, developing, implementing, tuning and supporting the Oracle Hyperion Suite of tools, including Hyperion Essbase, Hyperion Financial Reporting, Hyperion Web Analysis, Hyperion Planning.
• Experienced in installing, configuring, upgrading and patching of Hyperion EPM products including: Hyperion Foundation, EPMA, CALC Manager, Planning, Essbase, Profitability, ODI, Financial Reporting, Web Analysis, Oracle HTTP server and WebLogic in distributed environment. Authored comprehensive documentation for all installation and configuration steps.
• Experienced in development and implementation of Hyperion Planning/Essbase systems. Expertise in complete development, final testing and implementation.
• Proficient in Hyperion System 9/11.x BI+, Hyperion Essbase 9.x /11.x, Hyperion Planning 9.x/11.x, Hyperion Reports, ESSCMD, MAXL, Essbase Excel Add - In and Smartview.
• Expertise in Calc Scripting, and dimension build, Data Load Rules, Tuning and Optimization.
• Expertise in writing custom Essbase calculation scripts, automated the Essbase Cubes using MAXL and Batch Scripts.
• Expertise in creation and maintenance of Hyperion planning applications, business rules, web forms, task lists, security groups and users etc.
• Expertise in loading metadata and data using EPMA, ODI.
• Extensive Knowledge of LCM
• Worked exclusively on Hyperion Shared Services and Created numerous users, groups and provided them different privileges.
• Expertise with all ODI tools - Topology, Security Manager, Designer, Operator
• Demonstrated ability to work in a fast-paced, team environment

TECHNICAL SKILLS

OLAP: Hyperion Essbase & Planning(Classic & EPMA) 11.1.2/11.1/9.3 , ESSCMD, MAXL

Reporting Tools: Hyperion Financial Reports, Smart View, Hyperion spreadsheet Add In, Web Analysis

Database: Oracle 11g, 10g, 9i, 8.x & 8.1.5, 8.1.6, 8.1.7, SQL Server 2000/2005/2008/2012 , MS Access 2003

Operating System: Microsoft Windows 2000/2003/2008/2012 , AIX,Linux

ETL: Oracle Data Integrator 11.1.1,10.1.3.6

PROFESSIONAL EXPERIENCE

Confidential, Germantown,MD

Sr. Oracle Hyperion Consultant

Responsibilities:

• Extensively used calculation commands and functions to improve the performance of applications.
• Developed Calc Scripts/Business Rules for complex calculations.
• Optimized already existed Calc Scripts/Business Rules
• Directly Dealt with other teams for Data matching issues.
• Primarily responsible for Metadata Changes in the Applications.
• Developed and Managed ODI packages based upon the requirements.
• Optimized the ODI Packages.
• Migrating the Artifacts from one Environment to the other using LCM.
• Responsible for Migrations.
• Maintenance of User Security and troubleshooting user access issues as they arise.
• Worked with Hyperion Support on a number of issue resolutions.
• Developed Customized Reports.
• On time completion of all assigned tasks and meeting the business expectations and timelines

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, Hyperion Shared Services 11.1.2.4, Hyperion SmartView, Hyperion Financial Reporting Studio, Windows Server 2008 R2.

Confidential, Minneapolis,MN

Sr. Oracle Hyperion Consultant Lead

Responsibilities:

• Installed EPM 11.1.2.3 on RHEL 5.6.
• Analyzed Issues in WebLogic Admin Console 10.3.6 and applied needed Patch Sets
• Applied the latest Hyperion Products related patches
• Worked closely with Hyperion Support Development team in fixing the Issues.
• Responsible for Migrations..
• Keeping all the environments in sync.
• Supporting the End users on Client install issues. Tracking the issues with Incident management tickets.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Setting up security in planning and assigning access to Forms, Rules and Reports.
• Backup and Recovery of Hyperion applications.
• Defined and documented the steps to migrate applications in the Hyperion Planning,Essbase between PROD,DR,QA and Dev environments.
• Worked with Hyperion Support on a number of issue resolutions.
• Experience with Change/Incident/Problem Management
• Training end users

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Shared Services 11.1.2.3, Excel Addin, Hyperion SmartView, Hyperion Financial Reporting Studio, Hyperion EPMA 11.1.2.3, RHEL 5.6.

Confidential, Nashville,TN

Sr. Oracle Hyperion/ODI Consultant Lead

Responsibilities:

• Performed metadata building using outline load utility for different dimensions.
• Created various rule files for loading Data into Planning cubes
• Developed Dynamic Web forms and composite web forms for various applications with POVs, menus, run time prompts, Smart Lists, Validation rules and Pages.
• Performed Essbase Calc script tuning and debugging as well as enhancements
• Optimization of BSO cubes: Custom setting type of compression, data cache, index cache, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size
• Created various business rules according to the requirements.
• Automated and backup all the LCM artifacts on a daily basis and also documented various steps of how to restore the application when the cube is corrupted.
• Worked extensively on Hyperion shared Services and Created numerous users, groups and provided them different privileges.
• Developed and monitored MaxL Scripts and Rules files to dynamically upload dimensions and data from legacy system to Essbase cubes.
• Created ODI design documents from the existing SSIS packages. Used these design documents in development of ODI interfaces/packages.
• Resolved tickets which are coming from various business users through ticketing system.
• Subject matter expert for all queries related to Hyperion products.
• Provided external support for all Hyperion issues on as need basis.
• Mentoring and guiding business users on all Hyperion products.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, ODI 11.1.1, SSIS, Hyperion Shared Services 11.1.2.2, Excel Addin, Hyperion SmartView, Hyperion Financial Reporting Studio, Hyperion EPMA 11.1.2.2, Windows server 2008 R2.

Confidential, St. Louis, MO

Sr. Oracle Hyperion/ODI Consultant

Responsibilities:

• Setup the ODI connection with Flat Files, Oracle and Hyperion Planning.
• Setup the Topology including physical architecture, logical architecture and context.
• Created new Models for the Source - Flat Files, Staging Area - Oracle and Target - Hyperion Planning.
• Created Data Stores for Flat Files and reverse engineered for the data sources and targets.
• Developed interfaces to load the metadata from flat files, to Hyperion Planning.
• Did SQL and PL/SQL programming for ODI and oracle.
• Worked extensively with ODI navigators: Designer, operator, topology. Developed TDD for the ODI Project
• Currently redesigning Hyperion planning application in order to work more efficiently.
• Worked on the performance tuning (Cube Optimization) of the Application for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Optimized Nightly package by bringing it down from running around 12 hours to 1.5 hours.
• Optimized Essbase application to balance the calculations and retrieval performance needs.
• Documented various Essbase tuning methods and recommendations.
• Build ODI package in order to extract data out from Oracle to load into AHY Essbase cube.
• Build calc scripts in order to extract data out from Essbase and load into Oracle using ODI and based upon user selected POV.

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, ODI 10.1.3.6.0 , Hyperion Shared Services 11.1.2.1, Excel Addin, Hyperion SmartView, Hyperion Financial Reporting Studio, Hyperion WebAnalysis, Hyperion EPMA 11.1.2.1, Windows server 2008, LINUX.

Confidential, St. Louis, MO

Sr. Oracle Hyperion/ODI Consultant

Responsibilities:

• This project was a full life cycle, global implementation of Hyperion Planning, including EPMA, Calculation manager and ODI for 200+ users.
• Hyperion Planning Consultant responsible for development of Planning applications for P&L, Variance Analysis using Oracle Enterprise Performance Management System 11.1.2.2 .
• Developed calculations for variance analysis, including price\volume\cost mix, spend and FX impact.
• Developed SG&A allocations across all cost centers.
• Developed and automated data integration for loading metadata and data for various Planning cubes.
• Created weekly, nightly process to back up all the Hyperion systems both metadata and data using LCM and Essbase maxl scripts.
• Automated monitoring to detect Hyperion Web application crashes and other failures, enabling the team to immediately respond to such issues using Weblogic WLST scripts.
• Subject matter expert for all queries related to Hyperion products.
• Provided external support for all Hyperion issues on as need basis.
• Mentoring and guiding business users on all Hyperion products.
• Helping business users on the team less familiar with Hyperion System 11 to come up to speed to Oracle EPM 11.1.2 system.
• Identify project risks, issues and avenues of mitigation on Hyperion Planning & Essbase.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, ODI, Hyperion Shared Services 11.1.2.2, Excel Addin, Hyperion SmartView, Hyperion Financial Reporting Studio, Hyperion WebAnalysis, Hyperion EPMA 11.1.2.2, Windows server 2008.

Confidential, Dallas, TX

Sr. Oracle Hyperion/ODI Consultant

Responsibilities:

• Created all MS SQL Server database required for Production, Stage and Development Hyperion installations
• Installed, configured and patched Hyperion Prod/Stage/Development Environments: Foundation Services, EPMA, Calc Manager, Essbase Server, EAS, APS, Essbase Studio, Planning, and Financial Reporting.
• Configured Shared Services security integration with Microsoft Active Directory
• Created custom start/stop scripts for Hyperion Windows services
• Migrated Essbase business rules and substitution variables, converting them to Calculation Manager objects
• Migrated Hyperion EPMA, Planning, Essbase, Financial Reports.
• Produced documentation of all steps involved in infrastructure work.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, Hyperion Shared Services 11.1.2.2, MS SQL SERVER 2008,Windows server 2008, Hyperion Financial Reports Studio, Smartview, Excel Addin.