SUMMARY:

• Over & 8+ years of IT a Hyperion Consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.Experience in Hyperion System 11.1.2 modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards)
• Strong development, functional and technical expertise in Oracle Hyperion EPM products from version 6.5 until recent …
• Extensive experience in end to end implementation of development, design and analysis of Hyperion Essbase ASO/BSO, Hyperion Planning, Hyperion Business Rules, Hyperion Calc Manager, Data Relationship management (DRM), Hyperion Financial Reports (FR), Hyperion Financial Management (HFM), Hyperion Financial Data Quality Management (FDM), Hyperion Smart view, Oracle data integrator
• Extensive knowledge in building Applications, Hierarchy, Attributes & UDA and load data through Essbase Studio.
• Experienced in installation/configuration/upgrade of Hyperion EPM products - Essbase, Planning, FCM, ARM, ERPi, ODI, HFM, FDM and other BI+ products.
• Experienced in Hyperion Essbase Administration (EAS), Essbase Studio, Essbase Integration Services (EIS), EPMA, FDM workbench, FR Studio, DRM
• Strong scripting experience in developing batch scripts, Calc Scripts, MaxL Scripts, Batch Scripts, reporting using Excel Add-in/Smartview/Financial reporting studio.
• Designed, developed and customized data forms for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Extensive knowledge in integrating MSAD and other LDAP technologies, LCM.
• Skilled in performance tuning, upgrading, testing, server maintenance, back-up planning, security administration and migration
• Extensive experience in building a Multi-Dimensional Database (MDDB) and in defining hierarchy, dimensions and formulas in Hyperion Essbase

TECHNICAL SKILLS:

OLAP Tools: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase … Hyperion Financial Management Suite (HFM), Excel Add-In, ESSCMD, MaxL, MDX and Hyperion Planning, ODI, FDQM, DRM, Essbase Studio. Databases Essbase … Oracle 8i/9i/11i, SQL Server 2000, DB2, Toad 8.0, MS Access

Reporting Tools: BI+, Financial Reporting, Web Analysis, Hyperion Reports, Hyperion Interactive Reporting, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Smart View, Cognos series 8, OBIEE.

Internet Tools: HTML, DHTML, XML, VB Script, Java Script, JSP, ASP

Languages: SQL, PL/SQL, C/C++, Shell Scripting

Operating Systems: MS-DOS, UNIX, WINDOWS … 4.0/XP/Vista/, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux Testing Tools Win runner, Load Runner, Quick Test Professional QTP.

PROFESSIONAL EXPERIENCE:

Hyperion planning & EssBase Consultant

Confidential, Houston, TX

Responsibilities:

• Install and configure Hyperion 11.2.3 On Oracle Ex alytics Box.
• Strong understanding of the Hyperion System 11.1.2.3 EPMA relational repositories which support front end applications.
• Design architect and global foot print for various client.
• Tune web server for OBIee and Hyperion workspace.
• Extensive knowledge of Hyperion planning module like workforce, apex and PSPB.
• Implement the account and cost center hierarchy in DRM for Center repository tool for Company
• Write Different property In DRM to support HFM, Planning Essabse and other relation system.
• Developed over 50 reports using HFR and OBIEE dash boards.
• Design transparent partition to support Complex Forecast and budget process.
• Design security for Hyperion Planning application using Hyperion Shared Services.
• Optimized the Essbase BSO and ASO cube by changing the outline.
• Design incremental load in ASO Cube to minimize the data load process.
• Implement the account and cost center hierarchy in DRM for Center repository tool for Company
• Automate Financial close process in Hyperion though MAXL scripts, batch script and schedule in autosys, odi and control m And unix.
• Created projects and interfaces to load metadata and data into the Hyperion Planning applications using both Planning and Essbase Knowledge Modules (KMs) in Oracle Data Integrator (ODI)
• Automate Data loading and Dimension build Process, Email notification Via ODI
• Implement FDM for various client and provide support for month end process.
• Design disaster recovery process for Hyperion environment
• Worked very closely with application tuning to enhance performance.
• ESSBASE DBA Activities (Performance tuning, optimization, EssCmd, MaxL API, Backup, Outline, Load rules)
• Providing support to the Hyperion user community.
• Used JAVA API for developing the member names vs alias and UDA reports and to extract members from outline.
• Involved in migrating planning applications, HFM apps, Business rules, Reports.
• Generated various reports based on the requirements
• Created and loaded the Dynamic member list and maintained the Security through Shared Services
• Developed rules for Eliminations and Member lists.
• Created Mappings while loading metadata and data loads.
• Used Consolidation process for calculating Intercompany transactions and Journals.
• Create ASO Cube for actual data load and reporting.
• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO option. Also, created BSO application to support Financial Budgeting and Forecasting Application.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO)
• Developed and maintained applications through Essbase Studio.
• Load data, create drill through reports, maintain hierarchy through Essbase Studio.
• Create partition between ASO and BSO application for Budget and Plan data movement.
• Hyperion Planning was used in testing of the new calculation scripts.
• Optimized the ASO Cube by changing hierarchy and MDX formulas
• Hyperion Planning 11.0 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion EPMA 11.0.

Environment: Hyperion Financial Management 4.x/9.x/11.1.1.2, Hyperion FDM, HAL, Hyperion Essbase 11.1.1.3./11.1.1.2, EAS 9.3.1, EIS, Excel Spreadsheet Add-In, Hyperion Financial Reports 9.3.1/11.1.1.2, Hyperion Planning 4.x/ 9.3.1/11.1.1.2, Hyperion Web Analysis, Smart View, Windows 2000, UNIX, LINUX, ESSCMD, Maxi, Microsoft Excel 2007, Microsoft Access, Oracle 10g, Hyperion Enterprise.

Hyperion Administrator

Confidential, Houston, TX

Responsibilities:

• Developed a financial data models to support their Data Warehousing and Financial Reporting needs.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Hyperion Planning 9.3.1 was used in testing of the new calculation scripts.
• Hyperion Planning 9.3.1 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.
• Created applications and reports in FDM.
• Created the Financial Consolidation Application to maintain Actual and Budget data
• Loaded Metadata for Accounts, Entities and Custom dimensions
• Loaded Security manually using a text editor and Loaded using Shared Services
• Configured the Application Settings and Currencies
• Loaded the Actual Data on monthly basis into Consolidation Application
• Created Data Grids and Data Forms to view and enter the Data
• Created and Posted Journals to modify data if there is any posting errors, Data entry errors, Management Initiative and to Eliminate Inter Company Transactions
• Created financial reports and Web analysis reports.
• Created and loaded the Dynamic member list and maintained the Security through Shared Services
• Developed rules for Eliminations and Member lists.
• Created Mappings while loading metadata and data loads
• Installed and configured Web analysis studio and created user/groups in it.
• Involved in migration of entire Development environment to Production environment
• Involved in migrating planning applications, HFM apps, Business rules, Reports.
• Generated various reports based on the requirements.
• Installed and configured Web analysis studio and created user/groups in it.
• Generated various reports based on the requirements.
• Defined queries with cube navigators formatted spread sheet add-in and saved the reports as web page.
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users
• Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperion upgrade project.
• Provided technical leadership and mentoring, helping those on the team less familiar with Hyperion System 9 to come up to speed.
• Intervened in production support issues as necessary to improve issue turnaround time as well as the customer's perception of the team's customer service.

Environment: Hyperion Essbase Integration Services 9.3.1, Essbase Administration Services 9.3.1Hyperion Shared Services9.3.1, Hyperion Financial Management9.3.1, Hyperion Workspace 9.3.1, Hyperion Planning 9.3.1, Hyperion Interactive Reporting 9.3.1, Hyperion Web analysis studio 9.3.1, Hyperion SmartView 9.3.1, Oracle 10i, Windows Server 2003.

Oracle Essbase Administrator

Confidential, Dallas, TX

Responsibilities:

• Migration and Update 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).
• 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 the Oracle Essbase cubes.
• Performed tuning of the BSO cubes by arranging and dimensions according to the hourglass model, using Sparse/Dense setting, and various other techniques.
• Implemented monthly, quarterly and annual reports which accounting teams use for budgeting and forecasting managers.
• Used substitution variables to implement budgeting and forecasting reports as per client requirement with no constraint period.
• Created complex calculation scripts to implement various business calculations as required.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension Builds.