SUMMARY

• Talented and accomplished IT professional having 6 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.
• 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, 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.

Confidential, Dallas, TX

Sr. Oracle Hyperion/ODI Consultant

Responsibilities:

• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Developed interfaces to load the metadata from flat files, Oracle to Hyperion Planning.
• Developed complex interfaces, procedures, packages in order to extract data out of IBR Essbase cube to 33 APEX cubes.
• Developed and optimized ODI packages in order to extract data out of IBR Essbase cubes to file systems based upon user selected Year, Scenario,Version.
• This process has been optimized to complete the process in ~6 hours compared to 27 hours current process.
• Did SQL and PL/SQL programming for ODI and oracle.
• Created ODI packages, scenarios using interfaces, variables, procedure.
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy,odisqlunload etc.
• Optimized the knowledge modules to improve the functionality of the process.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Delivered the assignments before the tight deadlines.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, ODI 11.1.1.7, Oracle 11g, Windows server 2008

Confidential, Dallas, TX

Sr. Oracle Hyperion/ODI Consultant

Responsibilities:

• Hyperion SmartView retrieval performance has been improved from 10 mins to about 5 seconds
• Provided technical documentation Planning Applications build using ODI 11.1.1.3.0 to classic planning.
• Provided training and workshops for the Users for the new features in SmartView and Webanalysis 11.1.2.1
• Applied patches for Oracle EPM 11.1.2 Shared Services, Planning.
• Created weekly, nightly process to backup all the Hyperion systems. Both metadata+data using LCM and Essbase MAXL scripts
• Worked closely with Oracle Product Assurance and Oracle Developers to resolve bugs as they arose
• Worked to build and implement a process to automate nightly processes relating to Essbase Data loads
• Optimized Planning applications: Submitting and Retrieving data using either Webforms or Smartview has been gradually reduced from more than 4 minutes to 10 seconds
• Build complex CALC scripts, Business Rules according to business requirement

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, ODI, Hyperion Shared Services 11.1.2.1, Excel Hyperion Add-In, Smartview.