SUMMARY

• Over 9+ years of IT experience. Hyperion consultant with hands - on Essbase, Planning, Financial Management, Interactive and Financial Reporting.
• Strong experience in Application Architecture, design, analysis, development and Administration of various financial applications in Client/Server environment using Hyperion Essbase, Planning, Work space, MaxL, Essbase Spreadsheet Services. Hyperion Smart View Reports, Hyperion Financial Management, Financial Reporting, Interactive Reporting and FDQM
• Knowledge of business and requirements analysis, business process modeling, Project planning and creation of user’s cases.
• Involved in writing custom Essbase calculations scripts, Report Scripts automated the Essbase Cubes using MaxL, Esscmds, MDX and Batch Scripts.
• Expertise in development of web forms/Data Forms and Hyperion business rules.
• Using Essbase Data Load Rules file to Load the Data in to Planning Database.
• Knowledge of Budgeting and Forecasting Process by using Hyperion Planning
• Upgrading EPM System 9.2 to version 11.1.2.3.
• Experienced in all stages of SDLC that includes duties like providing documentation on design, testing and migration from development to production.
• Coordinated Installation, Configuration and Overall Maintenance ofOracle EPM 11.1.2.4, Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis and Smart View.
• Support forHyperion Essbase, Hyperion Planning and Hyperion Reports.
• Resolving complex issues of Hyperion Essbase, Hyperion Planning and Hyperion reports.
• Set up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation
• Imported security profiles from Hyperion planning to Hyperion Essbase.
• Improved the Performance (Optimized the Planning, Essbase system) by changing the dimension order and working on configuration file including Cache design techniques.
• Migrated reportsfrom development to Preproduction and then to production.
• Extensively worked onDatabase optimizationandperformance tuningof Essbase cubes for fast retrieval and calculation performance.
• Involved in Trouble shooting the Production issues in support to the EssbaseApplications, Planning, Interactive Reportsand all Reporting objects (Production Support).
• Configure the Application server software to each individual application’s requirements Performance Tuning with the Application server software for optimization of use.
• Coordinated in End-user training and developed appropriate Training
• Good Knowledge in maintaining Mapping using Informatica.

TECHNICAL SKILLS

OLAP: Hyperion Financial Management 11.1.2.x, Planning 11.1.2.x/9.3, Hyperion Essbase 11.1.x/9/7, FDM 11.1.x

Reporting Tools: OBIEE, Financial Reporting 11.1.2.x, Web Analysis11.1.2.x Smart View, Interactive Reporting 11.1.2.X

Databases: MS Access, MS SQL Server, Oracle, Netezza

Web Server: Apache Web server, Microsoft IIS

Languages: Java Script, XML, HTML, C++, PL/SQL

Testing Tools: Win Runner 8.x, Q.T.P 9.x

OS/Environment: Windows 98, 2000, 2003/2008 Server, UNIX / LINUX

PROFESSIONAL EXPERIENCE

Hyperion Consultant

Confidential, CA

Responsibilities:

• Installation, Configuration and maintenance of System 11.1.2.3, 11.1.2.4 and EPM Products like Shared Services, HFM, Essbase, BI+ Products (Workspace, Financial Reporting and Web Analysis),FDMEE, Calculation Manager, Extended Analytics.
• Played an active role in all phases of the development lifecycle including requirements gathering, analysis, application design, development, and implementation.
• Manage Administration related activity for Hyperion System 11 and troubleshooting of issues that arises in the application
• Administered security, created users and groups and provisioned them with specific roles and assigned HFM security classes in user management console.
• Applying the patches whenever needed to resolve the issue.
• Configuration of FDM, Initial setup of creating an application and integrating with HFM.
• Import target system adapter and register it, Configuring Application settings and Integration settings, Copying FDM application across environments
• Preparing Reports as per user requirement using Hyperion Reports.
• Performed environmental checks/ Hardware requirements for various products to be upgraded.
• Migrated data from older versions to system 9.3.1 for various products.
• Running the Extended Analytics weekly and monthly.
• Performing daily Health check on HFM, Essbase, FDMEE, FR, WA, SS applications.
• Highly involved in the Hyperion system upgrade from version 9 to version 11
• Co-ordination with Site Services, DBA’s and other teams as required in resolving Hardware and application issues.
• Scheduled & Developed batch scripts for weekly and month end process.
• Supporting monthly, quarterly and yearly closing activities.
• Work closely with Oracle support to resolve any bugs with System9 & 11 Products
• Prepared documentations for the install and configuration of products and shared to the business and team.
• Trouble shooting of Smart View, Hyperion Services issues
• Responsible for preparing HFM for each month end close
• Responsible for monitoring the loading, promotion, and consolidation of data in HFM
• Responsible for monitoring the data outputs (outbound interfaces and extracts)
• Must adhere to tight close and reporting schedules
• Responsible for processing and tracking metadata changes in FDM and HP
• Maintenance of rules logic, forms, and scripts in HP
• Maintain controlled processes for loading and validation of data
• Provision users via groups and promoting apps from Dev to QA to Production
• Responsible for maintaining the mapping logic in Financial Data Management Enterprise Edition (FDMEE)
• Responsible for new user set-up and periodic review of existing users security rights
• Liaison with the IT group to support system, servers, upgrades and patches
• Responsible for assisting with training users on Hyperion (this is a supplement to existing training delivered through an on-line self-study tool)
• Creation and maintenance of Hyperion Financial Reporting Studio reports, Smartview reports, and ad-hoc reporting
• Develop and maintain an understanding of data sources and data outputs
• Creation and implementation of process improvements which includes testing, validating and documenting change process
• Assist with system configuration / modification to support acquisitions, divestitures, or retrospective accounting changes
• Collaborate with business teams to develop or clarify requirements for improving and expanding the capability of HP, FDM, and reporting

Confidential, CA

Hyperion Administrator

Responsibilities:

• Workforce and Expense planning applications were developed for budget and 18 month rolling forecast periods.
• Data was retrieved from different sources like PeopleSoft and Oracle.
• Implemented security on Department dimension for all the three applications.
• Configured Essbase objects like Rules File, Calc Scripts, Caches, etc to improve application performance.
• Created Menus, Smart lists in Planning and added them to web forms based on user requirements.
• Complex Business rules were developed for enable the users to manage assets, contingent workers and employees.
• Automated the rollup, load and backup process using MaxL.
• Scheduling of jobs in Windows network.
• Created multiple financial reports based on security privileges.
• Designed and developed Hyperion Web forms & reports
• Developed the load rules (Hierarchies), member functions to perform dynamic calculations for the Essbase cube build.
• Developed calculation scripts and tuning of calculation scripts was performed.
• Optimized the Essbase cubes and calculation scripts.

Environment: Enterprise Performance Management System 11.1.2.1, Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Financial Reporting, Smart View, Excel Add-in, Oracle 11g, Windows 2008.

Confidential

Hyperion Administrator

Responsibilities:

• Hyperion Interactive reporting tools used for reporting.
• Workforce and Expense planning applications were developed for budget and 18 month rolling forecast periods.
• Prepared business requirement and functional requirement documents.
• Involved in gathering requirements and developed prototype model.
• Developed report script to export the part of data from Actual BSO cube.
• Strong experience in implementing Hyperion Essbase security features, dimension level securities and creating user and group profiles.
• Validated the reports against Excel retrieval using Excel Add-Ins
• Developed load rules, calc scripts and reports and maintenance of cubes.
• Migrated the applications from Dev to QA, UAT and Prod.
• Automated the rollup, load and backup process using MaxL.
• Scheduling of jobs in Windows network.
• Developed calculation scripts and tuning of calculation scripts was performed.
• Optimized the Essbase cubes and calculation scripts.

Environment: Enterprise Performance Management System 11.1.2.1, Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Financial Reporting, Smart View, Excel Add-in, Oracle 11g, Windows 2008.

Confidential, CA

Hyperion Consultant

Responsibilities:

• Configured Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Designed and developed Dashboards, Queries, Tables, Pivots, Charts and Report sections in Interactive Reporting Studio 11.1.2.
• Developed various reports using Hyperion Interactive Reporting to provide executives, business users and analysts with the most intuitive user-directed relational query and capabilities.
• Created views, functions and stored procedures in SQL Server for creating reports in Hyperion Interactive Reporting Studio.
• Designed and developed various types of reports (Pivot, Tabular, and Chart reports) to be used by different user groups using Hyperion Interactive reporting.
• Used various conditional, date, data, numeric functions to add computed columns in query, result, pivot and report sections.
• Deployed dashboard for easier end user interaction and report generation.
• Java Scripts to customize the Dashboards in Interactive reporting.
• Worked extensively on Answers to create the reports & Intelligence Dashboards as per the detailed design requirements in OBIEE.
• Designed various reports using Column Selector, View Selector, Charts, Pivot table in Oracle BI Answers in OBIEE.

Environment: Hyperion Essbase 9.3, Hyperion financial Reporting 9.3, Planning 9.3, Hyperion Interactive Reporting 11.1.2.1, Hyperion Work Space, Oracle, Netezza, UNIX and Informatica.

Confidential, CA

Hyperion Consultant

Responsibilities:

• Building dimensions, Loading data using Rules files, two pass calculations, defining UDA’s, specifying dimensions like Account dimension, Time dimension, Attribute Dimension as per the requirements.
• Worked extensively on shared services for User Management.
• Monitoring application performance, availability and utilization.
• Worked with internal customers to consistently improve and refine process and procedures as it relates to Planning and Operational Analysis
• Creating users and user groups in the planning application and assigned security to web forms.
• Developed and modified calculation scripts, business rules and Planning forms
• Created analysis, ad hoc reports and submissions for annual budgets and YTD expenses.
• Analyzed all dimension and members in the Essbase outline.
• Maintaining Accounting structure for reporting.
• Designing and Development of reports and dashboards using Hyperion Interactive Reporting.
• Creating reports using Hyperion Financial Reporting, Spreadsheet Services
• Involved in creating new reports, modifying existing according to the User requirement, Problem solving and Query Tuning on Errors while report generation.
• Schedule jobs for existing reports and sending email notification, and also exported to html, excel PDF and text files and published to Hyperion Portal.
• Production ongoing Support with Incident Management Tool Peregrine.
• Managed changes, user-access requests, and security configuration Through Security administration using Shared Services.
• Resolve incidents, and perform root-cause problem analysis.
• Involved regularly with developers, end users, and infrastructure support specialists located onsite.
• Create, modify, and maintain Hyperion reports and ad hoc reporting for analysis
• Resolution of system errors, performance tuning, object administration, and application maintenance of Hyperion in an MS Windows Server environment
• Managed the Change Management tool.
• Troubleshooting all the Hyperion related issues and bugs that may come up in the production.
• Application migration to Dev/QA/Prod whenever necessary.
• Monitoring and maintaining Hyperion Financial Reports folder structures and reports within the BI+ Workspace.

Environment: Hyperion Essbase 11.1.2.1, Hyperion financial Reporting 11.1.2.1, Planning 11.1.2.1, Hyperion Interactive Reporting 11.1.2.1, Essbase Spreadsheet Services, Hyperion Work Space, Microsoft SQL Server 2005/2000, Oracle 9, and Redwood, UNIX.

Confidential, CA

Hyperion Consultant

Responsibilities:

• Prepared business requirement and functional requirement documents.
• Involved in gathering requirements and developed prototype model.
• Expertise in providing the access and configuring the external authentication using the shared services.
• Developed Database Outlines and involved in enhancement of the cubes.
• Developed report script to export the part of data from Actual BSO cube.
• Involved in regular Client interaction/Calls to identify the issues, change requests and provided best of technical solutions
• Strong experience in implementing Hyperion Essbase security features, dimension level securities and creating user and group profiles.
• Validated the reports against Excel retrieval using Excel Add-Ins
• Developed load rules, calc scripts and reports and maintenance of cubes.
• Managed to provide excellent support to customers in a quick turnaround time.
• Troubleshooting and Writing Maxl/Esscmd scripts for the data load/dimension build process for both SO databases
• Provide the maintenance, backup and recovery strategies documentation to the client.
• Enhanced the Calc scripts as well as developed new calc scripts.
• Handled performance tuning, weekly back-ups and monthly consolidations of data
• Setting up security to respective user workspaces and various reports within Planning.
• Gather business requirements from users for new report development and changes to current reports and dashboards. Translated that into BR document and Technical Requirements document for developers to build reports/dashboards
• Supported the Application Support Team for HIR report/dashboard development and user security
• Studied current processes and systems and recommended process improvements and efficiencies
• Trained users on how to create reports using Hyperion Interactive Reporting
• Developed Reports using Hyperion Interactive Reporting Tool, migrated from Dev-QA-Prod.
• Developed Interactive Dashboards and Web Dashboards according to the user requirements.
• Involved in creating new reports, modifying existing according to the User requirement, Problem solving and Query Tuning on Errors while report generation.
• As Hyperion Admin managed reports security by creating different folders and assigning security to these folders in Hyperion Workspace.
• Provided ongoingProduction supportto the existing applications and ensure that processing schedules and deliverables are met.

Environment: Hyperion Essbase 9.3.1, Hyperion financial Reporting 9.3.1, Planning 9.3.1, Hyperion Work Space 9.3.1, Hyperion Essbase Spreadsheet Services, Microsoft SQL Server 2005/2000, Windows, Microsoft Excel 2007

Confidential, GA

Hyperion Consultant

Responsibilities:

• Streamlined reporting processes in HFM Build and modify reporting systems and create reports for global users.
• Worked Involved in requirement gathering and created reports using Financial Reports from HFM applications.
• Created Project, Application in Hyperion Shared Services and provision users and groups for (HFM) Hyperion Financial Management.
• Validated the source data against mapping table to optimize the design, to increase the performance and troubleshooting with workflow process.
• Troubleshoot and resolve HFM and FDM user questions and issues where possible.
• Installed the EPMA applications Hyperion Financial Management 11.x, FDQM 11.x, Hyperion Financial Reporting 11.1.x, Essbase 11.1.x/9.x, Smart view in Windows Server 2003
• Monitoring and maintaining Essbase security settings during different cycles.
• Performed the installations and configurations of Hyperion products
• Created Users and Groups and assigned privileges to them. Applied security on the application by creating filters on its dimension members
• Responsible for running periodical backups
• Consolidation and reporting experience using HFM Experience with data transformation tools such as FDM Experience with scripting in an Essbase environment
• Monitoring and maintaining Hyperion Financial Reports folder structures and reports within the BI+ Workspace.
• Ability to write, modify and maintain Hyperion Financial Reports, Hyperion Smart View Reports.
• Experience with Hyperion Reporting tools (Hyperion reports, Smart View, Web Analytics).
• Developed batch scripts for automating and scheduling month end backup process
• Ensure HFM is available and accessible to all financial users domestically.

Environment: Hyperion Financial Management11.1.1.3, Financial Data Quality Management 11.1.1.3, Hyperion financial Reporting 11.1.1.3, Planning 11.1.x, Hyperion Analyzer, Hyperion Essbase Spreadsheet Services, Smart View, Oracle 11, Windows and UNIX Shell Scripting, Microsoft Excel 2007 iQm Soft Pvt LTD

Confidential

Hyperion Consultant

Responsibilities:

• Designed and Developed OLAP cubes
• Experience in metadata and data validation process
• Optimizing Aggregate Storage Option and Block Storage Option outline.
• Assist in developing the Hyperion planning dimensions by using the functional specifications document for the forecasting applications.
• Involved in gathering user requirements, Identifying Dimensions and identifying data sources.
• Writing Rule file for Dimension building and Data loading in to outline.
• Writing Calc script and Report scripts
• Checking Err File for Dimension build as well as data load, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Creating reports using Hyperion Financial Reporting, Spreadsheet Services
• Designing and developing web forms for data inputs as per the business requirements using Hyperion Planning.
• Creating users and user groups in the planning application and assigned security to web forms.
• Worked with Hyperion workspace 9.3.1 to schedule the certain task flow in HFM applications.
• Extensively involved in the financial Hyperion Planning model calculations by writing Business Rules i.e. (Actuals, forecasts, Profit, Elimination and Consolidation )
• Setting up users and groups according business department and Assigning security to users and groups.
• Importing security profiles from Hyperion planning to Hyperion Essbase.
• Worked on Hyperion Essbase Spreadsheet Services templates.

Environment: Hyperion Essbase 9.3.1, EAS, Hyperion Planning v 9.3.1, Hyperion financial Reporting 9.3.1, Smart View, Hyperion Analyzer, UNIX Shell Scripting and Hyperion Essbase Spreadsheet Services.

Confidential

Hyperion Developer

Responsibilities:

• Designed and developed Hyperion Web forms & reports
• Developed OLAP Models and Meta outlines in EIS for all the Essbase cubes in requirements of the business logic.
• Developed the load rules (Hierarchies), member functions to perform dynamic calculations for the Essbase cube build.
• Developed calculation scripts and tuning of calculation scripts was performed.
• Optimized the Essbase cubes and calculation scripts.
• Designed and developed Hyperion Analyzer Reports for the purpose of accessing the on line reports by the users.
• Monitored the system to check the performance issues and do necessary modifications in the Essbase functions.
• Raised, documented, and helped resolve any project issues
• Trained and helped the users to access the online Hyperion Analyzer Reports.
• Involved and designed user manuals and documented the entire cube specifications.

Environment: Essbase Administration Services 9.3, Hyperion Analyzer 9.2, Essbase Integration Services 9.1.2, Essbase Excel Add-in, Tomcat 4.1.3, Teradata 6.5, Abinitio Windows Pro and Unix.