SUMMARY:

• Around 10+ years of Professional IT experience with emphasis on Oracle Hyperion Business Intelligence Application Design, Development, Testing, Administration, Implementation of OLAP and Client/Server projects using industry accepted methodologies, procedures and support.
• Certified Oracle Hyperion Planning 9.3.x Administrator and Developer expert.
• Certified Oracle Hyperion Planning 11 Certified Implementation specialists.
• Expertise in creating and deploying Planning/Essbase applications in Classic, EPMA mode and on cloud services (PBCS/EPBCS) used for all Forecast and Budgeting purposes.
• Expertise in writing custom Essbase calculation scripts, automating the Essbase cube metadata and data loads, nightly backup using MaxL shell scripts and experienced in writing Report Scripts.
• Hands on in using EMP Automate tool in PBCS for Data upload.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization.
• Extensive experience in deploying EPMA based planning applications.
• Extensive experience in building SmartView based reports using excel VBA.
• Experience in developing and deploying complex Hyperion Planning solutions including Data forms, Business rules (Calculation Manager), Menus, Task lists, Smart lists, Workflow process and application migration as well as application management and troubleshooting.
• Involved in requirement gathering & analysis, requirements elicitation and documentation and developing Business & Technical requirements documents for Hyperion Essbase / Planning Implementation.
• Knowledge in designing semantic/Data Warehouse layer for Hyperion implementation using Oracle and MSSQL database.
• Designing the Dashboard for management reporting and operational reporting using tools like Web analysis, HFR and Smart View.
• Experience in Resource management and leading the team which comprises of Onsite and Offshore model.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.

TECHNICAL SKILLS:

BI Tools: Essbase 11.1.x/9.x, HFM 11.1.2.4, Planning 11.1.2.4/9. x/, Smart View, Hyperion Analyzer 11.1.x/9.x, Hyperion Financial Reports 9.x/7.x, Essbase Excel Add-in, Interactive Reporting, Hyperion Enterprise 6.5.1

ETL Tools: Informatica 8.1/7.1, ODI 10/11G, FDMEE

Database: Oracle 9i/10g/11g, DB2 8.0, MS SQL Server 2000/2005

O/S: Win 2000, Win XP, Linux, Unix

Programming Languages: Python, VB Script, HTML, Essbase Calc Script

Application Servers: OAS, Websphere 602, WLS 91

Web Servers: Tomcat, Apache, IIS

OLAP Tools: Hyperion Essbase Administration Services 7.1.2.0 / 11.1.3.0.00 Hyperion Planning 4.0 / 9.3.1/ 11.1.3.0.00 / 11.2.0.0.00 Hyperion Planning Desktop 1.5

Middleware: Web Logic, IBM s Web Sphere, Java Web Server

Defect Tracking: Siebel, BugDB

Cloud Technology: Oracle Cloud Services

PROFESSIONAL EXPERIENCE:

Senior Specialists

Confidential

Roles and Responsibilities:

• Requirement gathering & analysis Requirement elicitation.
• Business requirement documentation & technical design documentation
• Solution design and prototyping
• Assisting in UAT and SIT
• User Training
• Post go -live support.

Environment: PBCS, Oracle EBS

Senior Specialists

Confidential

Roles and Responsibilities:

• Requirement gathering and client interaction on the project progress
• Design and developing the Workforce Planning module out of the box concept to meet the client requirements on PBCS environment for Full Time and Part Time New/Existing Hire process.
• Implementing the Transfer process to have a data check and validation prompt trigger for cross check based on the available budget data.
• Designing and creating placeholder for future Capex planning
• Implementing workflow process management for Budget approval and Rolling forecast
• Guiding the team members to get the various reports, valid intersections, security setup, testing and other activities

Environment: PBCS

Oracle Hyperion Planning/HFM Senior Business Consultant

Confidential, CA

Roles and Responsibilities:

• Responsible for the Hyperion EPM 11.1.2.4 application Development, maintenance and Migration of Hyperion Planning/Essbase applications
• Developed nightly backup strategy and back up scripts using MAXL and batch files.
• Responsible for time-to-time key user interaction from project implementation prospective.
• Created management reports using Hyperion Financial Reporting.
• Built several reports from HFR, for variations to meet each BU requirements.
• Created user friendly documents for training purposes like Setting up Smartview, Accessing HFM Actual data, Accessing Planning applications from SmartView for Budget, Forecast purposes, loading Journal entries, working with Data Forms etc.
• Responsible for Month-end closure consolidation, reporting, analysis and data validation
• Handling Metadata change requests, creating rolling forecast and budgeting forms, required business rules from Calculation Manager for Planning application.
• Created data forms, smart lists, Tasks list, Menus required for planning process management.

Environment: Hyperion EPM 11.1.2.4, Hyperion Planning 11.1.2.4, Hyperion Essbase11.1.2.4, Hyperion Workspace system 11.1.2.4, Essbase Shared Service 11.1.2.4, FDMEE, Hyperion Reports, Hyperion Financial Management 11.1.2.4, Oracle 11g, SmartView, Hyperion Enterprise 6.5.1, Hyperion Retrieve 6.4.1.1.

Senior Hyperion Package Consultant

Confidential

Roles and Responsibilities:

• As a Senior Hyperion Planning lead responsible for requirements gathering, interaction with business team, translation of business requirement in to technical design document
• Implementing Currency Conversion Process for SmartPlan and SmartGM applications
• Implementing Data transfer script for moving data from smartGM to smartPln applications
• Creating an Essbase reporting cube from EPMA, which includes the dimensions mapped from SmartGM and SmartPlan applications. This is done in order to accomplish the reports generations from FR.
• Creation of Simple and composite Planning data forms
• Making changes to the dimension hierarchies, attributes and re-deploying the planning applications.
• Worked on customized business rules for Workforce planning.
• Creation of business rule using Calculation Manager
• Developed numerous Business Rules (Calc Manager), calc scripts, and Report scripts.
• Designed data forms, smart lists, Tasks list, Menus required for planning process management.
• Designed the automation process required for Metadata and data updates for Hyperion planning applications
• Designed the rule files required for the dimension building and data loading.
• Designed security matrix related to all the applications.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting using Hyperion Financial Reports
• Developed data integration programs for loading metadata and inbound/outbound data integration to/from Oracle general ledger and HR Info into Planning. EMPA Interface tables were used to load meta data into EMPA Shared Library.
• Responsible for migrating objects across environments using Artifact Life Cycle Management utility.
• Documented admin and user guide for forecasting.

Environment: Hyperion EPM 11.1.2, Hyperion Planning 11.1.2, Hyperion Essbase11.1.2, Hyperion Workspace system 11.1.2, Essbase Shared Service 11.1.2, Hyperion Reports, SQL, Windows Scheduled tasks, ESSCMD, Excel Add-In, Essbase Utilities.

Senior Hyperion Package Consultant

Confidential

Roles and Responsibilities:

• As an Hyperion Admin, worked with SME and End Users to understand the user requirements.
• Gathered requirements from the business users, Installed and configured Oracle Hyperion EPM suite of products.
• Work closely with business stakeholders to ensure the application is maintained and satisfies the finance requirements for monthly Meta Data changes
• Responsible for implementing a process containing assessment, environment hardware sizing, capacity planning, installation and rollout.
• Setting up the complete Hyperion planning infrastructure for implementation support. Installed the Oracle Hyperion products components such as Hyperion Shared Services, Essbase, Planning, EPMA, Workspace, EAS, Calculation Manager, HFM, FDM, ODI, etc
• Migration of Development environment components to Test environment and from Test environment to production environment.
• Performance tuning of the products like Planning and Calc manager in the production environment.
• Ensure conformance to all applicable standards including, but not limited to, technology, architecture, infrastructure and security.
• Hands-on and technically contribute to process and technology for the assigned delivery assignment
• Developed new planning and Essbase applications
• Developed the Planning Process using the Hyperion Planning Workflow.
• Designed Task Lists for the Budgeting process and assisted Business users with the process management.
• Load data to target systems from various source systems.
• Developed Business Rules and assigned them to web forms to run them on save. Designed Smart Lists for better ease of use for the business users.
• Developed the security model for the Hyperion planning applications by assigning filters using Shared Services.
• As part of the support performed hot and cold backups. Restored from the backup as required
• Migrate cubes from Dev to Test, Test to Production using Migrate Wizard in Administrative Services.
• Created MaxL scripts to update outlines in batch, load data and execute calc scripts, during maintenance.
• Involved in Performance Tuning to minimize data load time.
• Configured dense/sparse settings to improve the performance of Database and reduce the calculation time.

Environment: : Hyperion EPM 11.1.1.3, Hyperion Planning 11.1.1.3, FDM, Hyperion BI+ Reporting, ODI 11g, Hyperion Smart View, Microsoft Excel 2003, Oracle 10g, Windows 2003, UNIX, Essbase Excel Add-In.

Senior Product Engineer

Confidential

Roles and Responsibilities:

• Gathered requirements from the business users, Installed and configured Oracle Hyperion EPM suite of products.
• Developed new pre-packaged analytics, Ex: Capex and WFP.
• Hands on development and application testing of Hyperion suite for version 9.3.x to till 11.1.2.x
• Assisted in developing Smart View Offline product for version 9.3.1 as a team member
• Designed Task Lists for the Budgeting process and assisted Business users with the process management.
• Designed Web Forms using Hyperion planning web client for the users to enter data.
• Load data to target systems from various source systems.
• Designed Smart Lists for better ease of use for the business users.
• Developed Rules files, Calculation scripts, Reports scripts for the Essbase applications.
• Designed numerous reports using financial reporting studio, web analysis and Hyperion Smart View.
• Extensively used Macros functionality in to develop shorter and easy to maintain Business Rules.
• Developed the security model for the Hyperion planning applications by assigning filters using Shared Services.
• Maintained the existing ASO and BSO cube applications by updating their Outlines as per Business.
• Responsible for implementing a process containing assessment, environment hardware sizing, capacity planning, installation and rollout.
• Developed numerous Business Rules (Calc Manager), calc scripts, and Report scripts.

Environment: Hyperion Planning 9.x, Hyperion Essbase 9.x, Interactive Reporting, Financial Reporting, Linux, Oracle 11g, Oracle Application GL module. Hyperion EPM 11.1.1.3, Hyperion Planning 11.1.1.3, FDM, Hyperion BI+ Reporting, ODI 11g, Hyperion Smart View, Microsoft Excel 2003, Oracle 10g, Windows 2003, UNIX, Essbase Excel Add-In

Confidential

QE Engineer

Roles and Responsibilities:

• Involved in preparing the detailed test plans and test cases based on the Functional Specs PRD Documents
• Participated in inspections and reviews, requirements design, project meetings, etc.
• Wrote UI/functional test cases.
• Conducted WebUI testing, Functional Component level testing, integration testing, and acceptance testing and verifying the results with expected results, which should complain with the predefined requirements.
• Using Java Test frame which will simulate the browser http requests for the different servers UI Server, Metadata Server and Headline Server for Functional Component level testing.
• Automated binary build installation steps using shell and tcl scripts
• Created and Performed Load Testing for Functional Component level using API (Silk Performer) both XML and DHTML requests.
• Reporting the Bugs and preparing the Test Report