SUMMARY:

• Over 11 years of experience in Hyperion Essbase, Hyperion Planning, PBCS, Hyperion Financial Reporting(HFR), DRM, ODI, FDMEE, OBIEE, SmartView for Office, Hyperion Web Analysis, MaxL, ESSCMD and Excel Add - in.
• Accomplished Oracle Certified Essbase and PBCS Specialist with extensive hands-on experience in business intelligence design and implementation
• Extensive knowledge in Hyperion version like 6.5.1, 9.3.1, 11.1.2.1 and 11.1.2.4
• Expertise in Administrative Tasks of Essbase: Managing Applications and Databases, Data and Dimension loading, Calc Scripts, Business Rules, MaxL, MDX Querying, Report Scripting, User security and Performance tuning.
• Extensive Implementation and Support project experiences of Hyperion Suites in all technical and functional aspects of solution design, development and deployment along with handling complex IT environments and familiarity with Software Development Life Cycle
• Excellent knowledge in Automation, Optimization, and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments
• StrongSQL and PL/SQLknowledge. Familiar with creating queries, tables, and relational references, and maintaining the referential and data integrity.
• Substantial experience in Financial, Banking, Manufacturing and Distribution business.
• Proven team player who keeps multiple tasks in motion while maintaining the overarching project vision

TECHNICAL EXPERTISE:

Hyperion: Hyperion Essbase, Hyperion Planning, PBCS, DRM, ODI, Hyperion Financial Reporting(HFR), Hyperion Web Analysis, FDMEE, OBIEE, Smart View for Office, MaxL, ESSCMD and Excel Add-in

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, MS Access, DB2

Desktop Tools: MS Office Suite 2007/2003/2000.

Operating systems: Windows NT/2000/XP/Server2003, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion/DRM/ODI Tech Lead

Responsibilities:

• Served as a subject matter expert for the Support/development/implementation team for the Hyperion Essbase and Planning, Oracle Data Integrator (ODI) and DRM.
• Develop and re-design the Essbase Outline, Dimension build rule, Data load rules, Calculation Scripts and Report Scripts in Hyperion Essbase Analytics
• Troubleshooting critical issues in timely manner to- ensure the SLAs (Service level agreement) are met. On time completion of all assigned tasks and meeting the business expectations and timelines.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Essbase and Planning
• Create automated batch file to refresh the Essbase cubes.
• Tuning the Hyperion Essbase Analytics Application to improve query and data retrieval performance and data processing speeds
• Created the hierarchies using Oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Installation, configuration, troubleshooting on Windows and Linux versions to end users.
• Provide accurate time and effort estimates for the completion of milestones for data loads and extracts. Prepare metrics, status reports, reviews to identify the defects and risks
• Enforced database standards, best practices, methodologies, processes and procedures
• Application level security set-ups using the User Management Console. Security for Webforms and reports.
• Provided training and technical support to Essbase End Users

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, DRM 11.1.2.1, ODI 11.1.1.5, HFR and SmartView for Office, Oracle 11g and OBIEE 11g project name: - Hungry Jack’s PBCS Implementation project

Confidential

PBCS Technical Lead

Responsibilities:

• Design and developed the outline containing Chart of Accounts hierarchies, Cost Centers hierarchies, Entity Hierarchies for Hungry Jack’s Planning and Budgeting Process in PBCS.
• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Mapped the Old Chart of Accounts, Cost Center Codes and Entity structure to the new System in PBCS.
• Develop and re-design the Excel based Planning and Budgeting process to adapt the PBCS based Planning and budgeting process.
• Build Prototypes in PBCS to demonstrate to the client to educate and enhance the Planner knowledge in using PBCS.
• Developed Business rule to calculate Food and Paper Cost, Labor Cost, Fixed Cost, Advertising expenses, Allocation etc
• Building interface using the PBCS FDMEE to pull actual data from ERP and push the budget data to ERP
• Migrate the history data of the Previous year actuals and the current year YTD data load
• Configure and test the PBCS mobile application only on IOS devices as a part of standard delivery offering.
• Build Application Reports, Webforms and Automation of Integration Scripts
• Application level security set-ups using the User Management Console. Security for Webforms and reports.
• Build the Hyperion Financial reports for the Planning and Budgeting Analysis like EBITDA monthly and YTD by Stores, Profit After Tax Monthly and YTD by Stores, Balance Sheets Monthly and YTD by Districts and Stores.
• Provided Training to all Planner of HJ and created the PBCS Admin User Guide and FDMEE SIT User Guide

Environment: Planning and Budgeting Cloud Services (PBCS) R16.11.48, FDMEE, ERP 11.x and SmartView for Office project name: - Confidential Hyperion Application Maintenance Support

Confidential

Senior Associate

Responsibilities:

• Installations and Support of Hyperion HFM, FDMEE, Hyperion Enterprise, DRM, Smart-View, Shared Services, Essbase, ODI Applications and Servers.
• Maintain documentation on server related details around Hyperion implementation.
• Server Management/ Monitoring of Hyperion applications on Virtual server - Monitoring tools maintained at Confidential are Accelatis.
• Refresh/restart Hyperion servers as and when required.
• Periodic wellness check of all Hyperion Servers listed in the scope.
• Perform Disaster Recovery and participate in DR dry runs as needed.
• Upgrading/applying patches to Hyperion modules.
• Assist application support/development team in performance tuning/performance monitoring of Hyperion implementation (Application and Database).
• Assist/Be on Call when Application support/development team is working on troubleshooting Hyperion application/batch issues. Support monthly closing from an infrastructure viewpoint cycles/budgeting cycles

Environment: Hyperion Essbase 11.x, Hyperion Planning, Hyperion Financial Reporting(HFR), Hyperion Data Relationship Management(DRM), Oracle 11g, Unix, Windows 2003 server and Windows 7.

Confidential

Assistant Project Manager

Responsibilities:

• Involved in discussions with business users to derive requirements. Held design sessions and created functional and technical design documents using Microsoft Visio and Power Point.
• Worked on Design Documentation for various applications.
• Created, Enhanced, Maintained and Supported the Essbase BSO&ASO, IR, FR, Web Analysis, EIS, EAS, MaxL Scripts etc
• Performed metadata building using outline load utility for different dimensions.
• Created various rule files for loading Data into Planning cubes and ASO Cubes.
• Developed Dynamic Web forms and composite web forms for various applications with POVs, menus, run time prompts, Smart Lists, Validation rules and Pages.
• Designed Task lists and workflow process for all the Planning applications.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of Calc scripts and tuning of Calc cache.
• Automating of cube refresh through MaxL and UNIX scripts.
• Worked extensively on Hyperion Shared Services and created users, groups and provided privileges

Environment: Hyperion Essbase 9.x/11.x, Hyperion Planning, OBIEE 11.1.1.7, Hyperion Financial Reporting(HFR), Hyperion Data Relationship Management(DRM), Hyperion Studio, Oracle 11g, Unix, Windows 2003 server and Windows 7. project name: - Hyperion Application Development and Maintenance Support

Confidential

Assistant Project Manager

Responsibilities:

• Worked during the Full life cycle Implementation of the project from requirements gathering to deployment.
• Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders
• Optimized the applications to bring down the runtime considerably.
• Loaded the metadata and data into Planning application using interface tables and refreshed into Essbase database.
• Designed and developed web forms for the data input as per the business requirements using Hyperion Planning.
• Developed Dynamic Web forms for various users with POVs and Pages
• Used Business rules for allocation and budgeting in Hyperion Planning.
• Routine maintenance of the OLAP application and took regular backups.

Environment: Hyperion Planning and Essbase 11.1.2.3, Hyperion Financial Reporting, Oracle 11g, Unix, Windows 2003 server and Windows XP. project name: - Confidential pmt essbase Application Development and Maintenance Support

Confidential

Team Lead-Hyperion Technical Consultant

Responsibilities:

• Created, Enhanced, Maintained and Supported 12 sales feeds, 3 Cost feeds and 1 Inventory feeds
• Design, Develop and maintained multidimensional Essbase cubes using Analytic Administration Services
• Develop and re-design the Essbase Outline, Dimension build rule, Data load rules, Calculation Scripts and Report Scripts in Hyperion Essbase Analytics
• Troubles shooting critical issues in timely manner to- ensure the SLAs (Service level agreement) are met. On time completion of all assigned tasks and meeting the business expectations and timelines.
• Create automated batch file to refresh the Essbase cubes.
• Tuning the Hyperion Essbase Analytics Application to improve query and data retrieval performance and data processing speeds
• Create Spreadsheet Add-in reports based on customer requirement.
• Installation, configuration, troubleshooting on Windows and Linux versions to end users.
• Prepare metrics, status reports, reviews to identify the defects and risks
• Enforced database standards, best practices, methodologies, processes and procedures
• Managing a team of 4 developers for a handling the Services Request from the client
• Provided training and technical support to Essbase End Users

Environment: Hyperion Essbase 7.x, Essbase add-n, Oracle 11g, UNIX and PL/SQL.

Confidential

BI Consultant

Responsibilities:

• Responsible analyzing and reviewing the existing business model and customer requirements
• Collaborated with end-users and stakeholders to bring form and clarity to a multitude of data sources which enabled data to be displayed in a meaningful analytic way
• Design, Develop and Test multidimensional database using Analytic Administration Services
• Loaded data from flat files to Hyperion Essbase Analytics to generate reports for analyzing and decision making
• Imported the Database into OBIEE Administration tool.
• Identified the members for the required analysis in the physical and business layer.
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompts, and Oracle Delivers iBots
• Different styles of reports are been generated such as Charts, Gauge, Pivot, and Tabular.
• Iterative development of OBIEE dashboards, Answers requests, charts, pivot table layouts, dashboard prompts
• Analyzed end-user query performance when implementing and tuning OBIEE

Environment: Hyperion Essbase Analytics 7.1.3 and 9.3.1, OBIEE 10.1.3.4.2 , Oracle 9i, Windows 2003 server, Windows XP and Unix project name: - Customer information management system