PROFESSIONAL SUMMARY

• Over 8 years of experience in all phases of SDLC including Design, Analysis, Development, support, maintenance and Implementation of Business Intelligence BI and Oracle Enterprise Performance Management EPM Solutions.
• Worked extensively on Hyperion Fusion Enterprise Performance Management EPM System 11 v.11.1.2 and 11.1.1 and System 9 v.9.3.1/3 of Planning, Essbase, DRM and BI Reporting tools.
• Extensive Techno-functional experience in Development, Enhancements, Production support, Optimization, Upgrades, Applying Patches, Migrations and Installations.
• Supported various Forecasting/Budgeting models Periodic, Monthly, Quarterly, AOP and SBP.
• Very good understanding of Financial Planning process, Chart of accounts and other dimension hierarchies.
• Well versed in industry standards, best-practices and experienced in supporting multiple Finance and Planning teams from various domains.
• Well versed in Change management and Version Control processes.
• Developed numerous Essbase Multi-Dimensional Database MDDB cubes and various OLAP application models using Hyperion Essbase 9.x and 11.x.
• Experience in requirement gathering, requirement analysis and documentation.
• Working knowledge of scheduling tools like Control-M and Autosys.
• Experience working in multiple environments Windows and Linux in multiple operating system versions.
• Experience of having worked with different databases Oracle 9i, 10g, 11g , MS SQL Server 2003, 2005 , DB2 and MS Access.
• Extensive experience in Hyperion Financial Reporting created numerous Financial Reports, and also worked on automation of the same.
• Strong understanding of Multi-dimensional and Relational data models.
• Experience in setting up users'/groups security access requests through Shared Services and through Native Security.
• Experience working on ODI in configuration, creating interfaces and troubleshooting.
• Performed upgrades, database backups, performance tuning, optimization, dense/sparse settings, partitioning etc.
• Strong experience in Essbase Cube Analysis Design, Essbase database Administration.
• Experience in creating/modifying Outlines, Business Rules, Calc scripts, Member Formulas, MDX scripts, Rules files, Financial Reports, ESSCMD and MAXL Scripts.
• Detail oriented and resourceful in the completion of projects with an ability to multitask and meet strict deadlines.
• Experience in handling 24 7 on call production support.
• Excellent analytical, logical, communication oral and written and Interpersonal skills.

TECHNICAL SKILLS

OLAP: Hyperion Fusion EPM System 11, Hyperion Planning v.11 and 9, Essbase v.11.1/v.9.3.1/3, ODI, FDM, DRM, Web Analysis, Hyperion Financial Reporting, Hyperion Interactive Reporting.

Operating Systems: Windows 2003, 2008 , UNIX, LINUX

Databases: Oracle 9i, 10g, 11g , MS SQL Server 2003, 2005 , DB2, MS Access, Toad

Server: UNIX, Windows.

Scripting: VBScript, Macros, Unix Shell Scripting.

BI Reporting Tools: Excel Add-in, Smart view.

Application Software: MS-Office suite Excel, PowerPoint, Word, Outlook

WORK EXPERIENCE

Confidential

Sr. Hyperion Consultant

Role and Responsibilities:

• Handled primary responsibility for all application management tasks: Dimensions, MetaData / Outlines, Calculation scripts, report scripts, Substitution Variables and Load rules, Planning Meta Data, Outlines, Task lists, Workflow and Forms.
• Led the team in all phases of the SDLC for the consolidated application project Requirements, Design, Development, Testing and User Training, along with detailed documentation. Also handled the Project Management aspect of this implementation.
• Identify opportunities to optimize performance of existing systems and data structures.
• As the primary administrator for the application, involved in troubleshooting various infrastructure related issues in the distributed environment.
• Ensure that all issues are resolved within SLAs, perform root cause analysis where required, to prevent reoccurrence of incidents.
• Modified multiple VBAs/Macros to generate extracts, etc using Essbase Excel Add-in.
• Perform all the forecast open and close related activities during each Forecast period.
• Automated the scheduling process for Hyperion Financial Reports and provided user training and created multiple sample Financial Reports using Hyperion Financial Reporting.
• Ensured that data integrity is maintained at all times within the Hyperion suite in an integrated metadata environment.
• Manage User and Group Security utilizing Shared Services and Native Security.
• Facilitate the migration of artifacts in connected and disconnected environment for development, testing ST, SIT and production using LCM utility.
• Created a new Essbase cube to enable users to enter actual rates for employees with additional security.
• Created multiple interfaces in ODI to load metadata and build dimensions in Hyperion Planning.
• Used HP Service Manager to track and update all the changes, incidents and requests. Also created multiple solutions for frequent issues faced by the application.
• Assist users in the installation of Essbase Excel Add-in, Smartview, Visual Explorer and troubleshoot any issues in the process.
• Conducting user-training for the consolidated Hyperion Planning application.
• Created multiple data forms and data upload templates for users.
• Involved in all AOP and SBP activities, towards the year-end.
• Created and modified numerous Business Rules and Calculation scripts.
• Managed users' security through Hyperion Shared Services for individual users and user-groups.
• Worked with the Control-M team for automating daily backups of the application.
• Worked on providing Business Rules security through My Projects in EAS.
• Provide technical support for Planning applications problem identification, resolution and documentation.
• Created Batch files, automation scripts for data back-up, Importing, Exporting data etc using Maxl.
• Created an additional ASO Essbase cube for Financial Reporting purposes.
• Interact with DBAs for frequent requests regarding the databases for the development and production environments.
• Extensively involved in development and testing of the new secured Essbase cube for the actuals usage for the application.
• Assisted users during UAT for minor and major enhancements.
• Leverage Oracle's technical support wherever needed for issues.

Environment: Hyperion Fusion EPM System 11, Hyperion Essbase Admin Services 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Shared Services 11.1.2.1, Oracle Data Integrator ODI , Hyperion Financial Reporting, ESSCMD, Smartview for Office, Visual Explorer, Oracle DB, Control-M, Windows NT/2000, MS-Visio, MS-Project.

Confidential

Sr. Hyperion Essbase and Planning Consultant

Role and Responsibilities:

• Coordinated the installation efforts of Hyperion planning suite.
• Act as Single point of contact for Hyperion Planning. Supported and maintained Hyperion Planning, Essbase and Reports. On-Call support 24 7.
• Provided Technical support for Planning applications, problem identification, resolution and documentation.
• Extensively worked on Unix and Linux environments and used Unix shell scripting.
• Extensively used Hyperion DRM Data Relationship Management for metadata management and version control of metadata.
• Provided support for Infrastructure related issues in a distributed environment.
• Used Hyperion Financial Reporting to create numerous reports and also to analyze existing fiscal reports for tax purposes.
• Developed numerous technical documents.
• Facilitate the movement of artifacts in connected and disconnected environment for development, testing ST, SIT and production using LCM tools/utilities.
• Extensively involved in designing and modifying the Planning application using outline load utilities, data forms and business rules and talk lists.
• Involved in applying patches for Hyperion Planning and Essbase Opatch .
• Trained end users on the various functionalities available in Hyperion which includes data retrieval and entry via data forms, Hyperion reports, journal entry, allocation, schedules, web interface forms and SmartView
• Presented detailed trend analytical reports, Ad-hoc to induce collaborative decision making.
• Extensively used Oracle SQL queries.
• Worked on Essbase API and Java EAS API for addressing a Business requirement.
• Involved in providing security authentication for the users of Hyperion Planning, and maintaining workflow management process.
• Used Autosys for scheduling daily application backups.
• Leverage Oracle's technical support wherever needed for issues.

Environment: Hyperion Fusion EPM System 11, Hyperion Essbase Admin Services 11.1.2.0, Hyperion Planning 11.1.2.0, Hyperion Shared Services 11.1.2.0, Hyperion DRM, Autosys, Unix Shell scripting, Essbase API, Hyperion Financial Reporting, Hyperion Interactive Reporting MaxL, ESSCMD, Smart View for Office, MS Project, Oracle DB, Linux, MS-Visio, MS-Project.

Confidential

Hyperion Consultant

Role and Responsibilities:

• Hyperion Planning was used to build the Planning Budgeting application from scratch to meet the Business functional requirement and to map the data from external source applications.

• Create Metadata/Meta topics, Data Marts which are suitable for the source system account format in Hyperion Planning, Hyperion Essbase respectively.
• Troubleshoot and resolve any Hyperion System related Issues.
• Developed a couple of new Applications from scratch as per business requirement.
• Metadata development such as building flat file formats for updating Account, Scenario, Entity and other dimensions.
• Used Essbase Integration Services EIS , ODI to load data values, accounts, entities, and custom dimensions from flat file into Cube and also Planning applications.
• Created Batch files, automation scripts for data back-up, Importing, Exporting data etc using Maxl.
• Designed/Modified Outlines, Business Rules, Calc scripts, MDX scripts, Rules files, MAXL Scripts as per demand.
• Shared service was used to maintain the user provisioning and level of access Interactive user, Planner, Viewer, offline user and creating the projects.
• Making a user friendly environment for the end-users using the Dashboard in a click button way .
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, actual accounting changes and other variance explanations data.
• Data forms and Data grids were sent every day to end users for their glance at the financial data.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Extensively worked on Database optimization and performance tuning of Essbase cubes for faster retrieval and calculation performance.
• Trained End-Users on process control, reporting methods and using Hyperion performance suite.
• Involved in Hyperion Installation from scratch from Shared services to installing the modules like Planning and cleared the Installation issues which occurred in the process.
• Migrated reports from Dev to UAT and then to PROD. Responsible for testing the Reports, production data validation and all other related aspects through all phases of the SDLC.
• Involved in troubleshooting the production issues in support to the Essbase applications and all Reporting objects Production Support .
• Involved in troubleshooting, Data validation, Performance tuning and Performance monitoring.

Environment: Hyperion Planning and Essbase v.11.1.1 and 9.3.1, Shared services, Essbase Integration Services, ODI, Essbase Studio, Smartview, Oracle 10g, Toad v.9, MS SQL Server, Windows server.

Confidential

Hyperion Consultant

Role and Responsibilities:

• As part of Production support team, supported and maintained the existing Hyperion Planning 9.2 and Hyperion Enterprise Environments.
• Coordinated Hyperion application migrations across the Environments, Security set-up and ongoing support.
• Troubleshoot and resolve any Hyperion System related Issues.
• Configured and maintained users from Microsoft Windows Active Directory MSAD by setting it up in Hyperion Shared Services.
• Coordinated setup and maintenance of Hyperion Environments PROD, DEV and UAT and migration of Hyperion applications across the environments.
• Performed Unit testing for both break/fix and maintenance/minor enhancements.
• Coordinated Disaster Recovery Planning and Capacity Planning.
• Applied software patches to resolve the issues encountered by Hyperion system 9 bugs Opatch .
• Created and maintained batch jobs UNIX and Windows which automate Data Loads, Calculation and developed scripts for automation of services start up and stop up.
• Coordinated software upgrade from Hyperion System 9 to Oracle Hyperion EPM system 11.
• Tuned the Database design by analyzing the business needs, defining the Plan Types, checking the system requirements, loading the test data, defining reports and calculations.
• Maintain outline, metadata and member formulas as business requirements.
• Created and provision the users with necessary roles on applications using Hyperion Shared Services.
• Maintained Rules files for loading of data from Essbase administrative services.
• Maintained Web Forms, Task lists and Planning Units and managed security for the same.
• Implemented robust data-access security and user management.
• Created a Transparent partition with ASO and BSO cubes to leverage the advantages of both technologies.
• Automated data loading from multiple sheets using MaxL.
• Tuned Analytic services for optimal performance, data retrieval and calculation.
• Involved in the documentation of the related tasks in the project.

Environment: Hyperion Essbase 9.x, Hyperion Enterprise, Essbase Administration Services, MaxL, Excel Add-In, MS Project, Oracle DB, Windows NT/2000, MS-Visio, Unix Shell scripts, Microsoft Project.

Confidential

Hyperion Developer

Roles and Responsibilities:

• Creating the security filters and assigning the read/write/row level permissions to the end users based on the business requirements/specs documents.
• Setting up users, groups according to business departments and assigning security to them in Shared Services/Essbase Administration Services console as per requirements.
• Developed simple to complex calculation scripts, MDX, MaxL scripts and modified the existing calc scripts to suite with the end user needs.
• Modified the existing outlines to implement the new functionality based on the user requirements.
• Worked with SQL Interface to load the data from the oracle warehouse into the Essbase cubes using the data load rule files and also through Text files.
• Created Outlines in Essbase database using dimensional building methods rules files .
• Designed and developed the outlines for the applications based on the functional requirement documents.
• Extensively worked on Database optimization and tuning of the Essbase cubes for fast retrievals and calculation performance.
• Extensively worked on dense and sparse strategy dimension allocation, performed dynamic calculations to improve the cube performance.
• Using Essbase Integration Services star schemas, snowflake schemas provided detailed data analysis/insights into data through reports to the business users.
• Design various reports using Financial Reporting Studio, Web Analysis and Smart view based on the user requirements/reporting requirements.
• Worked on Excel Add-In templates. Designed and Developed reports based on the client's needs.
• Implemented nightly cron jobs to print DBA reports, SQL and PL/SQL scripts.
• Automate cubes using Maxl scripting.
• Created Maxl scripts for data back-up, Importing, Exporting data to and from Essbase etc.
• Involved in Application/database migrations, Database objects, Reports across different environments using Hyperion Administrative services console.
• Involved in Trouble shooting the Production issues in support to the Essbase Applications, Hyperion Reports and all database objects Production Support .
• Developed the documentation required to transfer knowledge for the users and for the administration and support.

Environment: Essbase v.9.3.1, Shared Services, Essbase Administration Services EAS , Essbase Integration Services EIS , Excel-Add In, Oracle 9i, SQL Server, UNIX Server.