SUMMARY

• Over 8 years of comprehensive experience in IT and 7 plus years' experience in management and development of Hyperion Essbase cubes, Hyperion Planning applications, Experience in developing ESSBASE cubes using Block/Aggregate storage technologies
• Substantial experience in creating, maintaining and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions using MaxL, and ESSCMDs for Data Loading.
• Widespread experience in Hyperion Planning Forms, Security, Metadata Maintenance, Business Rules and ESSBASE Excel Add - In
• Experience in consolidation of data, calculation scripts, MAXL and reporting in Hyperion,
• Hyperion Planning, Enterprise Performance Management Architecture EPMA, Data Relationship Management (DRM) V11.1, FDMEE
• Skillful in upgrades of Oracle Hyperion products, retrieval of data through Excel Add-Inn and Smart view, data forms and data grids
• Experience in both BSO (Block Storage Options) and ASO (Aggregate Storage Options) cubes for better performances and optimization
• Used Outline Editor to restructure and modify existing dimensions, dimension members, attribute dimensions, and member properties
• Developed and maintained rules file for loading of data and building the dimensions dynamically
• Expertise in working on web analysis, data forms, task list, financial reporting and smart view
• Extensive expertise in database optimization with dimension building, data loading, indexing, formulas, calculation scripts, cache management, business rules and partition management
• Technical experience gained in administration of Hyperion performance suit by using shared services for user/group accesses/privileges and application organization
• Exceptional skills acquired in Planning Workspace by designing Web forms for data inputs, registering applications and retrieving data in real time.
• Thorough understanding of Hyperion software product configuration and system development life cycle" SDLC"
• Detailed grasp of Hyperion Administration and optimization and performance tuning techniques relating to data loading
• Outstanding analytical and problem solving skills
• Trained and assisted end-users with developing complex reports to meet requirements and developed ad-hoc analysis reports as needed
• Excellent technical and communication skills coupled with firm commitment to quality and team spirit.
• Proven ability to work in teams and handle stressful and time sensitive situations
• Excellent communication skills developed through prior work experience

TECHNICAL SKILLS

Languages: HTML.

OS: Microsoft Windows Server, 2003, 2005, 2008, Vista, XP, NT and DOS. UNIX, Linux Databases Oracle, SQL Server 2005, SQL Server Management Studio

Tools: Hyperion Spreadsheet Add-in, Hyperion System 11 Smart View, Hyperion Financial Reporting Studio, Oracle Business Intelligence Enterprise Edition, Database Relationship Management (DRM)

PROFESSIONAL EXPERIENCE

Hyperion Consultant

Confidential - New Jersey, NJ

Responsibilities:

• Involved with business users to understand and gather enhancement requirements.
• Analysed the exiting Hyperion system and the models to understand how it is built and provided solutions to customer on the best redesign and implementation.
• Involved in the changes to the chart of accounts and re-org of the business
• Created web forms based on the requirements from the business
• Re-wrote existing business rules to comply with the changes made to the web forms
• Modified the existing cube dimension, hierarchies, web forms, business rules, calculation scripts based on the new chart of account changes.
• Optimized the existing cubes by performing the best practises optimization processes.
• Worked with the administrators to move all the changed artifacts from the development box to production.
• Created new dimension build and load rules to allow the new changes.
• Provided leadership in modifying the exiting revenue model and allocation process to an effective one and reduced any manual processes.
• Designed security matrix and assigned filters.
• Created reports using Smart View for monthly, quarterly and annual data.
• Maintained metadata including extracting, loading and updating metadata structure.
• Created load rules and performed all source mapping in FDMEE.
• Have been involved in providing training to the users for SIT testing.
• Create test cases in the test phase for users to do their testing.
• Wrote new, and optimized existing calculation scripts, batch commands and scripts in MaxL
• Modified Business Rules to cater to the changing business requirements, created users, user groups and administered security for multiple applications.
• Maintained security for Planning, Business Rules and Essbase.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using ODI.
• Loading planning data using planning desktop and smart view client.
• Performed data validation for the business rules and maintained Web Forms.
• Provided Essbase administration and optimization training to technical resources.
• Developed and administered reports with Spreadsheet Add-in and Smartview.
• Responsible for automating jobs and processes in Essbase and Planning. Automation involved Batch scripting, and Maxl.

Environment: Hyperion Planning 11.1.2, Essbase 11.1.2.3, Hyperion Financial Reporting Studio 11.1.2, Essbase Excel Smart view, ODI, Oracle 11g, MS Excel 2007/2010, Windows Server 2003/2008/Unix, DRMFDMEE

Hyperion Consultant

Confidential

Responsibilities:

• Developed Essbase cubes for the business community based on the business request.
• 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.
• Designed security matrix and assigned filters
• Involved in developed Hyperion planning application and related artifacts migration from DEV, UAT to PROD.
• Created complex load rules for loading data into Essbase.
• Worked on creating an update user script for planning applications to ensure inactive users are removed from shared services.
• Managed existing Hyperion Essbase/Planning/DRM/ODI infrastructure for client and provide day to day support within the given SLAs.
• Performed month-end activities to support the business.
• Created Web forms based on user requirements to allow user data inputs.
• Performed weekly maintenance activities to ensure all Hyperion applications are up and running for the users.
• Developed Rules file for Dimension Building and performed Metadata and Data loading.
• Created reports using Smart View for monthly, quarterly and annual data.
• Migrated applications across environments utilizing LCM (Lifecycle Management)
• Created reports using Hyperion Financial Reporting, Spreadsheet Services.
• Documented all the configurations and new reports creation and published it to the end users.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Migration of the Essbase Application from Development to Production.
• Provided infrastructure support to the client's business units
• Maintained all three Hyperion Essbase platforms, namely Development, UAT and Production
• Created Hyperion Financial Security matrix and Hyperion Financial Reports at user's request
• Ensured monthly Planning and Forecasting processes run smoothly in Planning and Essbase Applications
• Maintained, enhance and troubleshoot Hyperion business rules and calculation scripts
• Maintained metadata including extracting, loading and updating metadata structure
• Built, maintain and troubleshoot SmartView ad-hoc reports and templates
• Coordinated issue resolution with internal and external support providers
• Worked with end users to develop and evolve the application process while maintaining a stable, productive environment
• Managed integration of date into Hyperion from various source systems and monitored application performance
• Maintained Hyperion Security matrix.
• Created versioning and hierarchies in DRM for metadata management.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Exported/Import data from DRM using the DRM migration modules.
• Created action scripts to change properties in DRM
• Administered FDMEE and ODI

Environment: Hyperion Planning 11.1.2, Essbase 11.1.2.3, Hyperion Financial Reporting Studio 11.1.2, Essbase Excel Smart view, ODI, Oracle 11g, MS Excel 2007/2010, Windows Server 2003/2008/Unix, DRMFDMEE

Hyperion Consultant

Confidential - Livingston, NJ

Responsibilities:

• Created reports using Hyperion Financial Reporting, Spreadsheet Services.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked on Shared services for User/Group administration and maintenance.
• Involved in Migration of the Essbase Application from Development to Production.
• Provide infrastructure support to the client's business units
• Maintained all three Hyperion Essbase platforms, namely Development, UAT and Production
• Created Hyperion Financial Security matrix and Hyperion Financial Reports at user's request
• Ensure monthly Planning and Forecasting processes run smoothly in Planning and Essbase Applications
• Maintain, enhance and troubleshoot Hyperion business rules and calculation scripts
• Maintain metadata including extracting, loading and updating metadata structure
• Build, maintain and troubleshoot Smart View ad-hoc reports and templates
• Coordinate issue resolution with internal and external support providers
• Work with end users to develop and evolve the application process while maintaining a stable, productive environment.
• Manage integration of date into Hyperion from various source systems and monitor application performance
• Maintain Hyperion Security matrix.
• Proven background with systems support and direct contact with users to resolve issues with financial business applications.
• Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Assisted the manager in creating and managing project schedules and plans (Cube build and calc script development, General Expense/Allocation model, Balance Sheet budgeting, P&L Budgeting)
• Provided day to day functional support/system administration of the internal reporting systems that enable management/financial reporting and financial planning, via Hyperion Planning, and native Essbase Applications.

Environment: Hyperion Planning 11.1, EPMA, Essbase Administration Services (EAS), Hyperion Shared Services, Hyperion Smart View, PeopleSoft, Oracle Database 10g, Windows Server 2003/Linux, MS Excel 2003/2010

Hyperion Consultant

Confidential

Responsibilities:

• Identified requirements, documented them and translated the system specifications into physical design for Essbase data cubes.
• Created and Managed the BSO and ASO cubes in Essbase and followed the Hour-Glass model for the dimension order on Dense /Sparse dimensions.
• Involved in creating the design document for the Essbase applications which gets the metadata from the Oracle PeopleSoft system and Data loading.
• Involved developing the Hyperion planning dimensions by using the functional specifications document for the forecasting applications.
• Involved in Installation and Configuration of the Development server consisting of Hyperion System and Suite 11.1.2.3, ESSBASE, Hyperion Shared Services, Financial Reports, Smart view from Excel Add-In
• Created reports using Hyperion Financial Reporting, Spreadsheet Services.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked on Shared services for User/Group administration and maintenance.
• Improved the Performance (Optimized the Planning, Essbase system) by changing the dimension order and working on configuration file including Cache design techniques.
• Experience with end user training including the preparation/lead of formal training and information sessions
• Experience opening, managing, and resolving with Oracle Support for Hyperion
• Good experience with in-depth understanding of Hyperion backup and recovery methodologies.
• Strong understanding of database structures, theories, principles and practices.
• Evening and weekend work to perform maintenance and upgrades to support the monthly planning process.
• Special projects and process improvements as determined necessary by management.

Environment: Hyperion Planning 11.1.2, Essbase 11.1.2.3/9.3 , Hyperion Financial Reporting Studio 11.1.2, Essbase Excel Smart view, ODI, Oracle 11g, MS Excel 2003/2007, Windows Server 2003/2008/Unix

Hyperion Developer/Admin

Confidential

Responsibilities:

• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting systems
• Create Oracle / Hyperion Planning and Essbase solutions - specializing in Workforce Planning and also have extensive experience building Revenue, Capital, Income Statement, Balance Sheet, and Cash Flow applications.
• Highly skilled at creating detailed design, calculations, and automation of processes for Oracle / Hyperion Planning and Essbase.
• Daily and weekly back up process as well as Data loads using Maxl and ODI processes. Reporting using Excel Smart view, Hyperion Reporting
• Wrote new, and optimized existing calculation scripts, batch commands and scripts in MaxL
• Creating Repository for Hyperion Planning Application
• Conduct project requirement gathering sessions, document project requirements, define tasks, estimate timeline and identify resource requirements.
• Efficiently manage project timeline and deliverables to ensure integrity of project scope and costs to meet project deadlines and deliver on time and on or under budget.
• Migrate applications across environments utilizing LCM (Lifecycle Management)
• Provide detailed documentation and knowledge transfer to enable the client to manage the solutions created for them.
• Conduct training sessions for clients to demonstrate Oracle / Hyperion Planning product enhancements and best practices.
• Installed ODI as a Service in DEV, UAT and PRODUCTION environments in addition, Create UNIX backup scripts for ODI and involved in designing the Master and Work Repositories as well as security
• Cloned Hyperion Planning Cubes and synced in essbase.

Environment: Hyperion Planning 11.1.2, Essbase 11.1.2.2/9.3 , Hyperion Financial Reporting Studio 11.1.2Essbase Excel Smart view, ODI, Oracle 11g, MS Excel 2003/2007, Windows 7/Unix

Hyperion Developer

Confidential - Seattle, WA

Responsibilities:

• Involved in meetings with the business users to get the requirements, worked on documenting the requirements.
• Involved extensively in back to back implementation of Essbase and Planning version 11.1.2.1
• Created and maintained BSO cube as per client requirements and performed optimization by using appropriate dimension configurations, outline structure strategies such as dynamic calculations, attribute dimensions and partitioning etc.
• Worked with financial management and reporting tools such as HFR, Smartview and Excel Add-In.
• Designed, developed, and implemented Hyperion Financial Reporting system for the financial department using Essbase, for better management decisions.
• Created Calc scripts using the Calc script editor for performing calculations.
• Automated the Essbase Cubes using Oracle data integration tool and scripts. Optimized and performance tuned Data Load/Calculations, Essbase Development and Maintenance of Essbase Cubes, also performed optimization by tuning the caches.
• Developed calculation scripts and member formulas using XREF also used the function to make data available from the source cube to the target cube.
• Involved in data extraction from the company source systems using ODI and uploading the data into Essbase/ Planning dimensions.
• Performed metadata Load using outline load utility for different dimensions.
• Involved in developing Process management for workflow to promote the budget or forecast for different scenarios and versions.
• Build various calculation scripts and business rules to perform various calculations for different applications.
• Performed data validation for the calculation scripts created for end users.
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications.
• Involved in Migration of the Planning Application from Development to Production.
• Developed Business Rules to copy data from one version to another using Run-time prompts.
• Involved in creating documentation for each module created for the end user and provided training and assistance to the users at the required in the project plan.

Environment: Hyperion Planning 11.1.2x, Essbase 11.1.2x, Hyperion Financial Reporting Studio 11.1.2x, Essbase Excel-Add In & Smart view, ODI, Oracle 10g, MS Server 2008, Windows 7.

Hyperion developer/Admin

Confidential - San Jose, CA

Responsibilities:

• Involved in meetings with the business users to get the requirements, worked on documenting the Detailed Requirement Specifications.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• 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.
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization.
• Maintain Hyperion Servers; create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups. Migration to new production server and supporting end user, planners for budgeting.
• Daily and weekly back up process as well as Data loading job monitoring.
• Reporting using Excel add-in, Hyperion Smart view.
• Wrote new, and optimized existing calculation scripts, batch commands and scripts in MaxL
• Modified Business Rules to cater to the changing business requirements, created users, user groups and administered security for multiple applications.
• Maintained security for Planning, Business Rules and Essbase.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using ODI.
• Loading planning data using planning desktop and smart view client.
• Performed data validation for the business rules and maintained Web Forms.
• Provided Essbase administration and optimization training to technical resources.
• Developed and administered reports with Spreadsheet Add-in and Smartview.
• Responsible for automating jobs and processes in Essbase and Planning. Automation involved Batch scripting, and Maxl.
• Performed metadata Load using outline load utility for different dimensions.
• Involved in designing and development of the Expense Labor Cube and Capex Planning Cube
• Created rule files to load Data into Planning cubes and ASO Cubes.
• Developed Task lists and workflow process for all the Planning applications.
• Involved in developing Process management for workflow to promote the budget or forecast for different scenarios and versions.
• Build various calculation scripts and business rules to perform various calculations for different applications.
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications.

Environment: Hyperion Planning 9.3, Essbase 11.1.1.3/9.3 , Hyperion Interactive Reporting Studio 9.3, Essbase Excel Add-In 7.X, ODI, Oracle 10g, MS Excel 2003/ 2007, Windows XP.

Configuration Analyst

Confidential

Responsibilities:

• Reviewed analysis documents prepared by the Systems Analyst and configured (using graphic user interface tools) the CBA System to complete a new client implementation.
• Executed test plan (including regression testing) by identifying/creating test participants and performing calculations for expected results.
• Determined if configuration performs accurately, reflects requirements, and has zero negative impact to existing provisions.
• Documented defects when actual results did not meet expected results.
• Analyzed issues/defects and debugs the system when configuration is not producing expected results.
• Researched issues to determine if source of error is with the test data, test plan, or configuration.
• Resolved issues with test cases or set-up and re-tests configuration.
• Escalated issues as appropriate