EXPERIENCE SUMMARY:

• Hyperion EPM Technical Architect with over 13+ years of IT experience.
• Main area of expertise has been design, development, maintenance and support of various Hyperion applications and servers.
• My technological forte is Hyperion v7 / v9.x, EPM 11.1.2.x, ODI 11g and also proficient in Shell Script, PERL, PowerShell, VBScript and SQL
• Over 13+ years of experience in design, analysis, development and implementation of EPM applications in Hyperion Essbase, Hyperion Planning, Hyperion DRM, FDMEE, Hyperion Financial Reports, ODI & IBM Cognos Command Centre
• Worked closely with client from onsite and helped in building EPM roadmap
• Involved in initiation & planning phases of various projects
• Gathered Hyperion application requirements from business users
• Provided solutions with best practices and ensuring easier maintenance
• Development:
• Involved in end to end full development life cycle of Hyperion planning & Essbase ASO applications
• 4 planning applications
• 3 ASO reporting applications
• Worked in enhancements of existing Hyperion applications
• Extensive knowledge of
• Essbase calculation script, Data Load Rules, MaxL scripts, MDX
• Hyperion planning data forms, calculation manager rules
• HFM metadata updates, rules, data grids, data forms, journals
• FDM import/custom scripts
• Integration of Hyperion with source systems: MS SQL, PeopleSoft, DW, Mainframe
• Strong database development and business intelligence modelling capabilities
• Infrastructure:
• Extensive experience on the installation, configuration, server settings, DR setup, backups, client and server installations of Hyperion products such as Essbase, Essbase Integration Services, Essbase Analyzer and Hyperion Reports on both Windows and UNIX environments
• Installed Hyperion on roughly 40 Hyperion servers during various upgrade projects
• Implemented disaster recovery mechanism with near real time recovery of Hyperion application
• Tuned Hyperion servers for performance and stability
• Support & Maintenance:
• Worked in SLA based support for Hyperion applications
• Worked as Hyperion application administrator and involved in activities that are required for day to day maintenance of the applications and user coordination such as updates to COA, calc script or HBR, data forms, report scripts etc.
• Experience in Maintenance and Administration of Hyperion Essbase Cubes
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Versatile team player with excellent analytical, presentation and interpersonal skills

SKILL:

Domain: Manufacturing, Media & Entertainment

Programming Languages: MDX, SQL, PowerShell, VB Script, Perl, Shell Script

Operating System: Microsoft Windows, UNIX, Linux

Tools: /DB/Packages: EPM 11.1.2.x, Hyperion System 9.x, Hyperion v7.xMS SQL, ODI 11g

WORK EXPERIENCE:

Confidential, New York

Responsibilities:

• Design and build 1 BSO applications and 1 ASO Application.
• Design and build metadata and data integration and load process.
• Create complex allocation scripts to allocate revenue and costs as per the channel segmentation logic.
• Performance tuning of the Allocation scripts and other essbase calculation scripts.
• Build Actual, budget and Mid - Month data process.
• Unit, Integration and assist users UAT testing.

Technology: Hyperion 11.1.2, Essbase, Planning.

Confidential

Responsibilities:

• Design application changes to accommodate for Universal users for Planning and forecasting.
• Build the Outline changes, Integration changes, Report and Business rule changes.
• Build FDM changes, create mappings, change scripts.
• Populate Actual data for Universal view from Paramount View.
• Create Security Matrix and build /test application security.
• Create Unit/Integration/UAT test scripts.
• Assist Universal International users with Application Access, Provide Application training and UAT.

Technology: Hyperion Financial Reports, MSSQL, Essbase, Planning, FDM

Confidential

Responsibilities:

• Redesign of the integrations in SQL.
• Financial Reports development over consolidated PPI Flow data.
• Development of 10 PPI Data Flow reports
• Unit/Integration testing of all the artefacts with changes.

Technology: Hyperion Financial Reports, MSSQL, Essbase, Planning, FDM

Confidential

Responsibilities:

• Design around 18 reports in Hyperion Financial reports.
• Create new alternate Hierarchy members in ASO cube- MRC to meet report requirement .
• Design and develop automation for reports with user interface to create and publish books (excel and pdf) and email to users.

Technology: Essbase, Planning, Hyperion Financial Reports, MSSQL, IBM CCC. PowerShell

Confidential

Responsibilities:

• Create/update SQL Integrations for Market and Product dimension update
• Creation of QED/user managed table to manage for exceptions in Market and Product Update/retrofit impacted calc scripts, reports, web forms
• Design and develop automation for reports with user interface to create and publish books (excel and pdf) and email to users.
• Creating VB script to auto populate the FR xml (command line file) file with the parameters extracted from planning web forms

Technology: Hyperion Essbase 11.1.2, Cognos command Center, MS-SQL, QED, VB

Confidential

Responsibilities:

• setup 4 Environments - Dev, QA, Prod, DR each distributed along 10 servers
• Install Hyperion Shared services, Hyperion planning, Essbase, HFM, FDQM, ODI, CCC, QED in each environment.
• Migrate all application from Old to new environment.
• Extensively Test the new environments.

Technology: Hyperion 11.1.2.3 Suite, ODI, MSSQL

Confidential

Responsibilities:

• Staging area design and development, Redesign of the integrations in SQL. Retrofit all the artefacts of Hyperion (Planning applications, Web forms, reports in FR, business rules)
• Redesign excel templates, Redesign of ASO - MRC Cube Metadata and Data Load Automation using batch /maxl scripting.
• Unit/Integration/Regression testing of all the artifact with changes

Technology: Hyperion Planning, Essbase, Financial Reports, MSSQL, ODI.

Hyperion Application Support

Confidential, Hoboken, NJ

Responsibilities:

• Monitoring the daily jobs, Debug and fix job failures.
• Providing access to new users, Modifying filters, Calculation scripts Report scripts, Essbase outline, Maxl .
• Debug and Fix data issues
• Creating automation for Metadata and data build for planning using Perl
• Providing support to DRM and FDM applications, debug and fix issues.

Technology: Hyperion Suite of Components, PERL Scripting. Hyperion Essbase 9.3.1,11.1.1, Hyperion Planning 9.3.1

Hyperion Application Support

Confidential, LosAngeles

Responsibilities:

• Support and Enhancement process includes Metadata changes, modification of web-forms for user entry, modification of retrieval sheet for the end-users, calculation scripts and business rules etc., and perform other routine activities
• Providing access to users, modifying filters, Calculation scripts Report scripts, Essbase outline, Maxl. Involved in resolving tickets
• Maintain Hyperion Financial Reports, modify reports. Debug and Fix data issues

Technology: Hyperion Essbase 9.3.1,11.1.2, Hyperion Planning 9.3.1, HAL

Confidential, Phoenix

Responsibilities:

• Involved in Initial Study of Cost of Production Process. Design and Build of ASO - COP Cube which involved in Outline design, Load Process design, MDX calculations.
• Staging area design and development. Data Load Automation.
• Report Design and development (Excel Templates). Optimization, Tuning of the COP cube and Testing

Technology: Teradata, Data stage 8.0, Hyperion Essbase, UNIX, Shell Scripting

Confidential

Responsibilities:

• Design & Build new Confidential application outline/hierarchy with dimension (members & their properties) considering the changes to Account, Product & Cost center
• Design data interfaces to load data into Hyperion application from data files using shell script for G/L, COPA & Stat accounts
• Re-design existing 210 Confidential FR reports to accommodate the changes per new cube

Technology:Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Oracle Data Integrator