SUMMARY:

• Hyperion EPM Technical Architect with over 15+ 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 14+ years of experience in design, analysis, development and implementation of EPM applications in Hyperion Essbase, Hyperion Planning(workforce,Capex), 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
• 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
• 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
• 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
• 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

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

IPF Application Support/Development

Confidential, San Antonio, Texas

Responsibilities:

• Preparatory activities for monthly forecast cycles
• Provide Application support for workforce/Market
• Do Monthly Meta data/Actual Data refresh for planning applications, archiving the database. Monitoring the daily /Monthly forecast 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.

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.

Confidential, Los Angels

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 and UAT.

Confidential, Los Angeles

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.

Confidential, LosAngeles

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.

Confidential, LosAngeles

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

Confidential, LosAngeles

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.

Confidential, LosAngeles

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

Hyperion Application Support

Confidential, Hoboken, NJ

Responsibilities:

• Do Bi-Monthly Meta data refresh for planning applications, archiving the database. 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 (for CRAMER, CRAPAC).
• Providing support to DRM and FDM applications, debug and fix issues.

Hyperion Application Support

Confidential, Los Angeles

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

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

Confidential, Phoenix

Responsibilities:

• Design & Build new FINPBU 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 FINPBU FR reports to accommodate the changes per new cube

Confidential

Responsibilities:

• Design & Build FINFPA application outline/hierarchy with dimension (members & their properties) Design data interfaces from CORP Plan, FINPBU & FINRPT applications to FINFPA application. Design ODI interfaces & its corresponding mapping for FINFPA dimension building.
• Create report scripts, calc scripts, and rule files for data interfaces to & from FINFPA Application. Use of ODI for Essbase metadata updating

Confidential

Responsibilities:

• Estimation and Proposal Initial Study of Power, Road and Infrastructure projects. Development of Power, Road and Infrastructure financial model. Identify the Production environment set up for the project.
• Installation & Administration of HSF server. Installation of Hyperion system 9 suite on Development and Test servers. Changes per new cube

Confidential

Responsibilities:

• Involved in understanding Bunge business process model. Identify the development/Production/Test environment set up for the project.
• Designed and Created the Hyperion Cubes (BSO). Build Outline, Rule files, Calculation scripts, Maxl scripts and Load rule files.
• Automation of data loading Creating Calculation Scripts (necessary for the dashboards) Creating Static Reports for Bunge using Financial Reporting Optimization, Tuning and testing of the cubes Developed Dashboards using Web Analysis Studio.

Confidential

Responsibilities:

• Requirement Specification Design
• Installation of System 9.0 environment, Database Administration
• Essbase & Interface Development
• Optimization Tuning and Testing
• Application Support and enhancements

Confidential

Responsibilities:

• Involved in Initial Study and URS (User Requirement Specification).
• Involved in Interface design.