SUMMARY

• 10+ years of hands - on Hyperion implementation experience in various industries including Financial Services, Manufacturing, Consumer Products, Utility and Retail.
• Requirements gathering, Designing, Developing and Testing of Hyperion Enterprise Performance Management Architecture EPMA and Java applications.
• Strong experience in Hyperion Planning 11.1.2, 11.1.1.3/9.3.1 , Hyperion Essbase 11.1.2/ 11.1.1.3/9.3.1 /7.x, Hyperion Financial Reporting.
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add-In, Hyperion Analyzer, Smart view and OBIEE.
• Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view, Hyperion Intelligence designer 8.3.2, MDM or DRM, ODI, OBIEE, EPMA.
• Expertise in writing Calc Scripts, Report Scripts and Load rules. Good Exposure on Hyperion Dashboard.
• Implemented/Installed the EPM applications Essbase 11.1.2/9.3.1 , Planning 11.1.2/9.3.1 in Windows Server 2003.
• Creating Macros/ CDF’s using VB scripts through Excel Spreadsheet Add-in, Smart views.
• Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulas and Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Upgradations, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Created & Used ODI routines to update the metadata changes in Planning.
• Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Involved in UAT, Performance testing and system testing of Hyperion applications before deployment to production
• Expertise knowledge in Memory analysis, cache tuning, Configuration settings tuning, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
• Experience in process automation using MaxL, ESSCMD, and Batch and UNIX scripts.
• Experience in developing OLAP models (EIS) and metadata outlines for loading dimensions and data into Essbase Cubes.
• Worked in various environments of Development, Production-Support and Maintenance projects with excellent result-oriented approach.
• Excellent technical and communication skills coupled with firm commitment to quality and team spirit.
• Excellent accounting proficiency, problem solving skills and efficient in time management.
• Experience in providing support and maintenance for Hyperion Essbase Systems including both client/server level services and consulting.
• Experience leading teams from onsite and offshore.

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 6.5, 7.1, 9.2, 9.3.1,11.1.1.3,11.1.2.3,11.1.2.4 and Hyperion Hyperion Planning 4x, 9.2, 9.3.1 and System 11.1.1.3 and 11.1.2.2,11.1.2.3 and 11.1.2.4 Hyperion Financial Management (HFM) 9.3.1 and 11.1.2.2.

Reporting Tools: Hyperion Reports, Hyperion Analyzer, OBIEE, Interactive Reporting, Financial Reporting, Web analysis Reporting, Smart view

ETL Tools: Oracle Data Integrator (ODI), Data Relation Management (DRM) Informatica, FDQM.

Languages: SQL, PL/SQL, C/C++, Shell Scripting, VB, VB Script, Java, Java Script, PL/SQL

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux

Databases: Oracle 9i, Oracle 10g and Oracle 11g8i, 9 MS SQL Server 2000/2005, DB2

Markup Languages: Core FTP, TOAD, VMWARE, SQL Developer, MS-VISIO, Tiger VNC, Putty and Amazon Elastic Cloud Computing

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Lead Hyperion Workforce Planning/HFM Consultant

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Involved in Installation and Configuration of Hyperion 11.1.2.2 system consisting of Planning, Essbase and Financial Reporting Studio, Shared services and Workspace.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library by importing GL information from ETL processed data mart.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Developed and created financial reports and creating dashboards for the end users.
• Enhanced/modified existing financial reports as per changes in reporting requirements.
• Created Applications, including the use of Workforce and Capex plan types.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage (ASO) and Block storage (BSO).
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports.
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Designed Hyperion Financial Management (HFM) Reporting Infrastructure including System Infrastructure, Metadata Layer Infrastructure, and Data Acquisition and Data Distribution Infrastructure.
• Loaded the data into HFM using Hyperion Financial Data Quality Management (FDM).
• Developed Data Forms and Data Grids using HFM.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Developed batch scripts to automate the process of taking backups of the planning application, Essbase database, shared services and reports on a nightly basis using the Life cycle management command line utility.
• Performed migrations between the Production, QA and Dev environments using the Life Cycle Management utility integrated in the shared services console provided in 11.1.1.3 version.
• Developed HBR (Hyperion Business Rules) with Run-Time Prompts for realizing various business functionalities like creating a project, enter the planned amount for the project and consolidating to the upper level of the hierarchy.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports using Smart View.
• Involved in the automation of nightly backups, extraction of data and loading data.
• Responsible for monthly maintenance of the hierarchy by loading the hierarchy using the outline load utility, maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.

Environment: Hyperion Essbase 11.1.2.X, Hyperion Planning 11.1.2.x, Financial Management (HFM), FDM, DRM, Analytic Administration Services 11.X,ODI 11.1.1.6.5 , Hyperion Financial Reporting, Essbase Excel Add-in, AIX UNIX, Exalytics server, Hyperion Web Analysis, Hyperion shared services, Smart view, and Windows 2005/2008 Server.

Confidential. Alpharetta, GA

Sr. Hyperion workforce Planning/HFM Consultant

Responsibilities:

• Responsible to analyze new user requirements, make changes and update the application.
• Analyzed user requirements and actively involved in the process of finalizing views for the existing cubes.
• Developed new web forms using Hyperion Planning for the users to input data.
• Developed additional Business rules to support the business needs and attached to the input forms to calculate data on save option.
• Full cycle development with Planning application and security using shared services.
• Involved in gathering design specifications from Clients to build ESSBASE ASO cubes.
• Involved in designing and modifying the outlines for ESSBASE cubes.
• Developed rule files for data loading and dimension building.
• DevelopedCube Schemas and created Essbase Models to deploy the Essbase Cubes.
• Extensively used MaxL and ESSCMD to develop batch scripts to automate data load from relational systems database to ESSBASE cube.
• Implemented Hyperion Planning Classic applications in four months from the scratch to the Go Live.
• Worked on Installation and configuration EPM 11.1.2.0 version and resolved issues which were specific with 11.1.2.0
• Worked on detail level of requirements and worked with functional team experts to create the functional design documents.
• Installed and configured EPM 11.1.2.0 in a multi-server environment.
• Experience in writing formulas, Calc Scripts, Business rules according to business requirements
• Created various ODI Interfaces to load source systems data i.e., People Soft, ADP, Strata to Hyperion applications
• Created calculation scripts and business rules required for various types of calculations.
• Suggested, documented, and implemented improvements to current BI processes by leveraging functionality within and external to OBIEE
• Created around 50 web forms related to the payroll, revenue, workforce, Capital expenditure, Balance which are used for day to day budgeting purposes.
• Created global variables, Sequences, projects in Hyperion business rules.
• Automated the security setup through MaxL and CSS Import Export utilities available in Hyperion.
• Automated backup and recovery process for the Essbase applications data and metadata.
• Automated services startup and shutdown process and scripted these scripts batch and shell scripts.
• Conducted end user training sessions to train users how to use new budgeting process
• Created Dimensional Elements, validated its binding and Built Hierarchies
• Implemented robust data access security and user management.
• Provided detailed analytical reports to higher management using Hyperion Analyzer.
• Migrated Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Design and maintenance of Essbase application .
• Involved in production support and maintenance of existing Essbase cubes.
• Load Metadata using Hyperion Application Link tool into Hyperion Planning.
• Developed Calc scripts and Business Rules.
• Leveraged HFM dimensions including custom dimensions for the Essbase cube implementation.
• Leveraged corrections in the metadata and mapping rules made in HFM and FDM.
• Performed Installation, Configuration, and Integration with Upstream DataMart (FDM) including Creation of Applications,
• Configuration of Servers and Configuration of Adapters.
• Migrated HSS, Financial Reports, ODI, EPMA, Essbase, Planning, HFM and FDM applications from PROD to TEST, PROD to DEV and TEST to PROD.

Environment: Hyperion Essbase 11.1.2.X, Hyperion Planning 11.1.2.x, Financial Management (HFM), FDM, DRM, Analytic Administration Services 11.X,ODI 11.1.1.6.5 , Hyperion Financial Reporting, Essbase Excel Add-in, AIX UNIX, Hyperion Web Analysis, Exalytics server, Hyperion shared services, Smart view, and Windows 2005/2008 Server.

Confidential, Boston, MA

Sr. Hyperion Essbase, Planning and HFM Consultant

Responsibilities:

• Managed the Development/Support activities on Hyperion System 11 - Financial Management at client site as well as hands on application, security and reports.
• Administrator of Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, System 11 Web-based solution for Corporate Accounting and Financial Reporting area.
• Worked with Hyperion Support on number of issue resolutions.
• Involved in Determining customer business requirements, project scope and assisting the estimation of efforts.
• Production Support and problem solving Financial Monthly End Closing using Essbase.
• Analyzing the raw data and converting it into valuable business information by Design & development of appropriate cubes. Created new Essbase Application/Database/Outline and Making changes to existing Outline.
• Support Management Reporting Group with Hyperion Essbase, Hyperion Planning and Hyperion Reports.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Installed Planning, HFM, FDM, DRM and Essbase and configured all modules for the client.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase and Essbase Integration Services
• Developed outlines, Data Load rules for loading dimensions and data into Essbase cube
• Optimized outlines to have faster data loads, calculation and retrievals
• Played key role in troubleshooting data reconciliation issues, extract issues and technical issues.
• Trouble shooting any load failures, restoring a cube from backup if DB is corrupted.
• Involved extensively in creating Data Grids and Data Entry Forms using HFM web client.
• Developed Import formats, Mapping, Dimensions and POV in FDM.
• Designed and built a partitioned database as per business requirement
• Documented all the application and user issues and the corresponding resolutions in order to facilitate easy knowledge transfer.
• Experienced in data transformation, data mapping from source to target and data cleansing using FDM.
• Maintenance of user security and troubleshooting user access issues as they arise.
• FDM design, test, migration, import formats, location setup, security, custom scripting for GL integration from BW, Hyperion Enterprise and disparate legacy GL’s to development and production environments.
• Design, data validation, and data loads of Historical Data to Production using FDM.
• Monitored and oversaw batch jobs developed in the reporting environment
• Introduced Balancing concept to existing applications in order to have all the Interfaces and upstream in Synch with Essbase cubes.
• Maintenance, enhancement & creating of planning web forms.
• Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS Patches. Backup and Recovery of Hyperion applications.
• Participated in the application testing while monitoring the system performance, thereby reporting any anomalies in the application. Provided 24*7 supports.
• Interacted with users to understand their reporting needs. Gathered business requirements from financial team. Analyzed and Supported Reporting Environment. Suggested improvements for reporting purposes.
• Involved in monitoring the current environment servers for performance and stability.
• Involved in assigning the Security for FDM, Essbase and Planning applications.
• Administered and knowledge on installation, configuration, and optimization of Hyperion Essbase, Planning, Financial Reporting, Interactive Reporting and Web Analysis.
• Hyperion planning was used to create new web forms. The same was used to define business rules.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Developed Hyperion Business Rules with Run-time Prompts.
• Was involved in Build Planning Model using EPMA.
• Created simple and composite data forms using Hyperion Planning.
• Planned and coded complex reports developed in Excel using VBA and the Essbase API

Environment: Hyperion Essbase 11.X, Hyperion Planning 11.x, Financial Management (HFM), FDM, DRM, Analytic Administration Services 11.X, Hyperion Financial Reporting, Essbase Excel Add-in, AIX UNIX, Hyperion Web Analysis, Hyperion shared services, Smart view, and Windows 2005/2008 Server

Confidential

Sr.Hyperion Planning and Essbase Developer

Responsibilities:

• Served as a Subject Matter Expert (SME) for the Oracle EPM / Hyperion Financial Planning suite and provided guidance to the project team with respect to the set-up, configuration, and utilization of these products.
• Assisted the architects and implementation/integration team in providing conceptual design options to integrate commercial-off-the-shelf (COTS) products with internally developed components to formulate a complete solution that meets customer approved requirements and standards.
• Managed the Hyperion Essbase environment that includes three production servers and two development servers
• Played the focal point with the vendor, server team, database administrators, and other groups for all support regarding Essbase, ensuring quick resolution of issues along with continuous and reliable availability of the tools and environment
• Gathered new requirements from business users. Created application and technical architecture documents for supervisor and upper management based on existing and new requirements
• Designed and developed an Essbase application for the Missouri region that meets the Business requirements and migrated this database to production environment.
• Developed and documented an Essbase Environment Standards that included naming conventions and security setting to meet the company guidelines, standards, and best practices in the use and deployment of Essbase tools.
• Designed and built a partitioned database linked to a reporting database as per business requirements
• Developed and maintained several report scripts and calculation scripts from two main corporate reporting databases
• Directly involved in outline, calculation and reports tuning and maintenance
• Played a key role in building new Essbase applications
• Performance tuning for the applications and configuration settings to reduce the time taken for the calculations.
• Altered some of the calc scripts. Created and maintained replicated partitions between BSO applications.
• Replaced some of the calculations in BSO with a member formula to simplify the process.
• Implemented new architecture to reduce the down time of applications during and after monthly calculations and metadata changes.
• Played key role in troubleshooting data reconciliation issues, extract issues and technical issues.
• Responsible for maintaining and enhancing BSO and ASO (reporting) applications.
• Identified and reported a design bug in the Essbase & HFM applications.
• Worked on Migrations of databases from development servers to QA/Production servers.
• Designed and implemented a stable nightly backup process to back up system and production applications and assure a fast and successful restore of any database if needed. VBScript, ESSCMD and MaxL scripts were used to develop this process
• Responsible for maintenance and enhancement of supply related Planning applications.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase applications.

Environment: Hyperion Planning 11.1.1.3, Oracle Essbase 11.1.1.3, Hyperion Essbase Administrative services, Hyperion Financial Reports, Web Analysis, Hyperion Interactive Reporting 11.1.1.1,Oracle 10g, UNIX, Oracle, SQL, PL/SQL and Windows 2003.

Confidential, Cedar rapids, IOWA 

Sr.Hyperion Planning & Essbase Developer

Responsibilities:

• Participated in full life cycle of SDLC (requirements gathering, defining, designing, developing, testing and deploying the system).
• Designed, installed and configured the Oracle Hyperion 9.3 on servers
• Installed Essbase, AAS, AIS, Planning, Workspace, Financial Reports and APS.
• Integration done between Essbase and PeopleSoft using SQL server SSIS.
• Worked with IT to design the Hyperion artifacts backup.
• Prepared technical design document detailing the data acquisition, process flow, test plans and test cases for unit testing and system integration testing.
• Involved in tuning the applications for better performance by modifying the server wise and application, database wise settings.
• Designed and developed web forms using Hyperion Planning tool for the users to input Forecast and Budget data.
• Developed calc scripts, and business rules using Hyperion Business rules.
• Involved in designing and developing various financial reports like Cash Flow, Profit & Loss), variance reports and other management reports using the Hyperion Reports.
• Involved in designing and developing the corporate charts and other ad-hoc management reports using the Hyperion Analyzer.
• Developed the Corporate financial reports using Hyperion Analyzer, Reports and Excel-Add in.
• Developed reports for the regulatory purpose in Essbase Excel - Add in and Standard Reports in Hyperion Financial Reporting.
• Worked on consolidated reports where I was involved in clubbing a group of reports into one consolidated view using Hyperion Web Analysis.

Environment: Hyperion System 9.3, Hyperion Planning, Analytic Services (Essbase), Hyperion Application Link (HAL), Hyperion System 9 BI (Web Analysis and Financial Reporting), SQL Server 2000, Oracle, Data-Stage, MS-Excel and Windows 2000, Windows 2003.

Confidential, Bakersfield, CA

Hyperion Developer

Responsibilities:

• Installed Essbase Spreadsheet add-in for new users to test the user input templates.
• Created Load rules for loading the SAP information.
• Created Calc scripts for populating account items that are based on the direct feeds.
• Tested the outcome of the calc scripts with the users to cope up with the business rules.
• Assisted in setting up of dynamic web reports using Hyperion Reports.
• Created Lock and Send templates and distributed the same for controllers in Argentina.
• Created Currency conversion calculation scripts to convert the numbers from Local currency to USD and EUR.
• Changed the attribute dimensions in the existing cubes to sparse dimensions to improve retrieval performance.
• Migrated the application from the development server to the production server.
• Provided support to controllers on a round the clock basis during the month-end close process.

Environment: Hyperion Essbase, Hyperion Reports, Hyperion Planning, MS Excel, Hyperion Application Manager, Hyperion Spreadsheet Add in, Hyperion Administration services, MS DOS, MAXL.