Professional Summary:

• 7 years of experience of Designing utilizing complex multidimensional and relational database systems for a diverse set of clients.
• Experience in development of Hyperion Systems, Hyperion planning applications, Essbase Cubes.
• Experience of working with various ETL tool like ODI, ERP-I and FDM.
• Worked on Hyperion Modules Planning 11.1.2.1/9.3.1, Essbase 11.1.2.1/9.3.1 versions, Shared service.
• Experience on reporting tools multidimensional-based Hyperion Financial Reporting and analytical application projects including requirements gathering, design, implementation, testing, production roll-out, documentation, and maintenance.
• Involved in Hyperion product suite development and support experience with Hyperion 11x installations and configuration.
• Extensive knowledge of client/server applications working in Essbase OLAP environment using Hyperion Essbase tools such as Essbase Administration Services, Hyperion System Planning 9x and 11x, Smart View 9x and 11x, Web Analysis, and Financial Reporting
• Experience of designing of Essbase Cubes using Block storage BSO and Aggregate storage ASO .
• Provided technical consultation and expertise in the development of Hyperion Essbase forecasting and reporting applications.
• Involved in writing Essbase calculations scripts, automation of Essbase Cubes using MaxL, ESSCMD.
• Developed Batch Scripts and Rules files for dynamically uploading data to Essbase Cubes.
• Experience in optimization and performance tuning of Planning and Essbase application.
• Worked on various implementations in Hyperion Projects with involvement of application upgrade and migrations.
• Responsible for security groups and access for the users in Hyperion Reports and Hyperion System 9x/11x

TECHNICAL SKILLS

• ETL, OLAP and Reporting Tools: Oracle Hyperion 9.x and 11.x products Essbase, Planning, Smart view, Hyperion Financial Report HFR , Web Analysis, Shared services, Enterprise Performance Management Architect
• Databases: SQL Server 2005/2008, Oracle
• Operating Systems Platform: Windows 2003/ 2008/XP,Unix
• Scripting: MAXL, UNIX Shell, Calc Script

professional EXPERIENCE:

Confidential

Hyperion Planning Consultant

Responsibilities:

• ODI implementation, Physical, logical architecture, Interface creation
• Installation and Configuration of Hyperion Components
• Form and task list security setup and workflow design
• Security setup, Groups creation and assign users in to the groups
• Coordinating regular meetings with the client for status update
• Develop Hyperion financial reports and maintenance
• Creating data forms like headcount forms, hiring by entity, salary by job
• Creating task lists, menus, business rules
• Dimension design based on the client requirement, adding new accounts as per client requirement
• Develop planning workforce management applications
• Data loading and monitor backup process
• Worked closely with implementing partners to document the requirement from SME.
• Solely responsible for managing shared service roles and syncing MSAD group to native Hyperion group.
• Troubleshooting application related issues and provide daily application support.
• Responsible for creating ODI interfaces from scratch to integrate data load from various data sources. Integrated Hyperion planning with ODI and ERPI for data integration.
• Coordinating call with off shore team to delegate the projects new requirements and developments.
• Automated daily actual load via ODI using MAXL. Perform ad-hoc data load to planning application and troubleshoot ODI load issues.
• Automated daily database backup and Essbase file back up using MAXL and window task scheduler.
• Monitoring the jobs and troubleshoot on any event of job failure.
• Maintaining Hyperion servers and monitoring disk space and consumption in servers.

Environment: Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Shared Service 11.1.2.1, Hyperion Workspace 11.1.2.1, Smart View 11.1.2.1, ERP-I 11.1.2.1.501, Oracle Data Integrator ODI 11.1.1.1.5g, Hyperion Workforce Planning, SQL 2008SP2, Windows 2008R2, PeopleSoft version 9.1

Confidential

Hyperion Consultant

Responsibilities:

• Support existing applications and built new web forms for data entry, and read only forms for data retrieval as per new requirement.
• Provision new users and maintained security in shared services and Planning.
• Created Business Rules with run time prompts for planning web forms consolidation and currency conversion for newly created web form.
• Created task lists to provide guidance to the budget preparers through the planning process.
• Added Smart lists to provide pre-populated drop-downs.
• Updated the Planning application Metadata through Oracle data Integrator aka ODI
• Used ODI to load the data files received from various sources.
• Created rules files to load data to Essbase.
• Provided Planning/Essbase application support during outage.
• Install and prepare Hyperion Essbase spreadsheet add-in document for users.
• Manage workflow process and support workflow process access during forecasting months.
• Update prompts in financial reports during school's year change.

Environment: Windows NT, OLAP Tools using Hyperion System 9 BI Essbase Analytics,BI Financial Reporting, Hyperion System 9 Planning, Hyperion System 9 Workspace, Hyperion Essbase Spreadsheet add-In, Hyperion scripting languages MaxL, Esscmd, MDX , MS Office, ODI 10g.

Confidential

Hyperion EPM Developer Support

Responsibilities:

• Involved in Migration from 9.1.3.to 11.1.2.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Involved in production support and maintenance of existing ASO BSO cubes. Worked as a team member in Hyperion Essbase Planning migration activity.
• Responsible for end to end build and testing of all the applications.
• Involved in improving performance of the applications by adding new dimensions and optimized data retrieval by creating materialized views
• Maintained application security and added/deleted users per management requests.
• Was responsible for all the scripts migrations and their validations in all the environments.
• Assist Financial Analysts to load and validate their budget, and prepare Actual, forecasts, budget, ad-hoc reporting and management reporting by working with the departments' managers.
• Provide support to users on access related issue and to some users, installing essbase add ins and smart view.
• Involved in testing the performance of the scripts in UAT and preparing test cases and results.
• Involved in Knowledge transfer and development transition to the other team members and to production team onshore and offshore .
• Analyzed financial results and prepared web based financial budgeting and forecasting with Hyperion Planning tool to support business managers make profitable decisions.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Expertise in development and performance tuning and optimizations for data/dimension loads, database restructuring BSO/ASO , calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision

Environment: Oracle EPM suite 11.1.2, Hyperion planning, Essbase, EAS, Shared Services, Workspace, Smart View, Excel Add-ins, Oracle 10g, 6.1,Windows 2008 R2 server.

Confidential

Hyperion Developer

Responsibilities:

• Backups for all application of production, pre-production and development servers including database backup.
• Designed and developed the Essbase outlines for the applications based on the functional requirement
• Designed and created cubes for OLAP in Hyperion Essbase using rule files.
• Created cubes and automated data loads using batch scripts.
• Called the batch processes, stored procedures and script commands.
• Responsible for Performance Monitoring.
• Involved in Application Migrations, test environment to production and automated backup jobs for daily maintenance.
• Actively worked in creating web forms, data loading, calc scripts and dimension building and export data all data and level 0 data .
• Developed reports using excel add-in.
• Tickets resolution as per client and end user requirement and provision of users/groups for the application access as per requests.
• Managing shared service security set up.
• Troubleshooting and analysis of the Hyperion issues in both development and production environments
• Worked with users to troubleshoot issue faces while submitting budget.

Environment: Hyperion Essbase 7x, Oracle 8i, Windows XP/2000, Hyperion Share Service, Excel Add Ins.

Confidential

Hyperion Business Analyst

Responsibilities:

• Worked with technical team to build the logic for scripts
• Analyzed Business Requirements, developing, tracking and enhancing them into functional requirements.
• Actively interacted with the client and the sales team to gather client requirements regarding the patient Electronic Medical Reports.
• Creation of the Hyperion Planning applications using planning desktop and Creating and Maintaining Hyperion Essbase applications using Console.
• Refresh planning applications using Hyperion Planning Desktop
• Issues resolution based on priority of the tickets.
• Involved in the deployment of the applications using Hyperion Planning.
• Involved in the creation of web forms in the planning applications and Data loading through the interfaces using HAL.
• Coordinated closely with the diagnostic lab and sales team for approvals.
• Developed Use Cases for the main modules and describe the requirements to the developers.
• Worked closely with the development team to communicate client requirements
• Worked closely with the Project Manager in handling the scope creep and analyzing its effects
• Provided key input in working with users in defining project and system requirements.
• Communicate any final adjustments required based on user feedback.
• Held regular status meetings on behalf of the Project Manager to keep track of the status.
• Created and maintained the Requirements Traceability Matrix to keep track of each requirement.

Environment: Hyperion System 7, Microsoft Office Excel Word, PowerPoint, Project , Rational Requisite Pro, MS Visio.