SUMMARY

• Highly experienced in design, analysis, development and implementation of various applications in client/server environment using Hyperion Essbase/Planning, PBCS, PSPB, Financial Reporting Studio, OBIEE, DRM, ODI, HFM, FDM/FDMEE on Windows and UNIX environments.
• Experience in Oracle Planning & Budgeting Cloud Service Specialist (PBCS/EPBCS)
• Extensively used out of the box features in implementing Hyperion PSPB.
• Extensive Experience in working with various Hyperion products such as Hyperion system 11 BI+ Analytic Administration Services, Workspace, Hyperion System 11 Business Rules, Hyperion System 11 Smart View, Hyperion System 9 BI+ Financial Reporting and Hyperion System 11 Shared Services.
• Expertise in theinstallation and configuration of Hyperion productssuch as Shared Services, Essbase, Essbase Integration Services, Planning, Analyzer and Reports on both Windows and UNIX environments.
• Extensive experience in building Financial Budgeting & Forecasting, Fin Statement, Contribution Margin, Sales, Profit Margin, Variance Calculations, Exchange Rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules and Essbase Excel Add - In), and Reports.
• Expertise in creation and maintenance of numerous Essbase applications leveraging both BSO and ASO technologies.
• Expertise in writing custom Essbase calculation scripts, automating the Essbase cubes using MaxL, ESSCMD.
• In depth knowledge of Oracle Data Integrator (ODI), FDMEE
• Expertise in batch scheduling the MaxL scripts using CONTROL-M software.
• Hands-on expertise creating reports usingEssbaseExcel Add-In and SmartView Add-In.
• Proficient in batch scripting,UNIX Shell scripting, Excel VBA coding,PL/SQL scripting, software installation, application and data back-ups, security.
• Hands on experience in integration OBIEE with EPM products.
• Excellent client relation skills and the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and the client community.
• Good Team player possessing excellent communicational skills, motivated and ability to quickly adapt and work under minimal supervision.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Hyperion Consultant

Responsibilities:

• Involved in PBCS application design and development with 3 plan types HGVFIN17, HGVFIN, and HOA cubes.
• Developed budget initialization processes for Metadata and Data loads from the source Oracle EBS to PBCS using Oracle EPM Automate and batch scripts.
• Created reports usingHyperion Financial Reporting Studio, EPRCS &HyperionWeb Analysis Studio.
• Created Departmental Income Statement, Balance sheet, Operational, Flash, SEC reports usingHyperionFinancial Reporting Studio and Smart View.
• Designed and developed web forms, task lists and user security as per the business requirements using PBCS.
• Created business rules forPlanning application in calculation manager using PBCS.
• Extracted data manually from different sources to combine different sources into one business report.
• Extensively worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data.
• Involved in estimating and tuning the Essbase database performance.
• Documented the recovery process for Hyperion Essbase in the event of disaster recovery.
• Provided production support and dealt with the user issues.
• Designed security in Hyperion Essbase applications for multiple users/groups.
• UsedHyperionLife Cycle Management Utility (LCM) for allHyperionrelated artifacts migration from one environment to other.
• Automated periodic data loads and Calc scripts using MaxL and Batch in Essbase.
• Migrated objects/applications between environments/servers using LCM utility and documented the steps in case of any compatibility issues during migrations.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.
• Developed web forms to input data and task list.
• Designed complex financial reports in EPRCS using multiple database connections.
• CreatedHyperionSecurity by creating Users, Groups and Filters for Analytic Services andHyperion Reports.
• Developed processes and control framework forfinancialsystems andreportingtools.

Environment: Oracle Planning and Budgeting Cloud Services-PBCS version 16.07, Oracle Enterprise Performance Reporting Cloud Service (EPRCS)version 16.07

Confidential

Sr. Hyperion Consultant

Responsibilities:

• Participated in gathering business and functional requirements from detailed business meetings and translate them into Program specification documents.
• Provided PSPB expertise with requirements gathering, fit-gap analysis, and application design.
• Involved in optimizing 3 planning cubes-OPPLAN, PSPLAN and CAPPLAN.
• Integrated Oracle Fusion with Hyperion Planning/PSPB.
• Designed Decision Packages (DP) using PSPB to formulate government budget and implemented the entire lifecycle of DP.
• Designed Budget Request (BR) packages using PSPB containing one or multiple budget request for funding a position, hiring an employee, and operating expenses.
• Designed metadata and configuration, HCP dimension, data element and development.
• Designed custom CAPEX cube for capital structure using PSPB.
• Developed, build and deployed PSPB-employee and position based application.
• Designed budgeting application hierarchy in Hyperion Planning using PSPB.
• Created composite web-forms, task lists, business rules using PSPB.
• Created decision packages using PSPB.
• Assisted with the development of Hyperion Planning for P&L and Workforce Planning.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library by importing GL information from ETL processed data mart.
• Created HAL routines for dimensional build and data load.
• Created users, groups, filters and assigned different kinds of Security access to users in PSPB.
• Mapped the planning cubes using "Map Reporting Application" to push data from one cube to the other.
• Developed prototype layout for different Hyperion Intelligence (BQY) reports.
• Created OCE files and developed Hyperion Interactive Dashboard reports, Pivots and chart reports
• Developed OLAP Models and Meta outlines in EIS and schedule cube build and data load using EIS scheduler.
• Automate Data load and Dimension build Process, Email notification Via ODI
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Developed rules files to load data from the database to Essbase cube.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting.
• The reports were used by the capital and sector controllers to view the capital and expense at the sector level and the line of business level.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.
• Created Mappings while loading metadata and data loads
• Created financial reports and Web analysis reports.
• Create book of financial reports including snap shot report and external file as well.
• Schedule the book report and configure and send the report in email and also configure printer to print book for controller.
• Generate book output as a static HTML Web site.
• Improved Book PDF navigation, Links in Table of Contents and Bookmark links in PDF document.

Confidential

Sr.EPM Administrator/Developer

Responsibilities:

• Setup a new Oracle EPM environment with the Reporting and Analysis component.
• Perform the migration of two existing Oracle EPM instances onto the new single environment.
• Oracle EPM Environment Architecture Planning for virtual servers (instead of dedicated servers)
• Oracle EPM Software installs (v11.1.2.2). Oracle EPM Application configuration, security, project setup, etc.
• Created multiple Planning applications and developed several Business rules for Capex and workforce planning requirements.
• Worked with Web forms and composite webworms.
• Provided production support for more than 200 EPM users.
• Worked with the Infrastructure team to apply all the patches (with fixes) provided by Oracle corresponding to Service requests with Oracle.
• Created different user groups, provisioned users to different user groups and assigned them different roles using Shared Services.
• Design security for Hyperion Planning application using Hyperion Shared Services.
• In charge of all EPMA metadata updates (manual and automated), Security module, Process Management, Web Forms
• Strong understanding of the Hyperion System 11.1.2.0 EPMA relational repositories which support front end applications.
• Wrote complex Business rules/Calculation Scripts to support allocation and Seeding process.
• Migrated HSS, Financial Reports, ODI, EPMA, Essbase and Planning From PROD to TEST, PROD to DEV and TEST to PROD with LCM.
• Optimized the Essbase BSO and ASO cube by changing the outline to an hour glass model.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Design Migration of the Planning Application from Development to QA and from QA to PROD.
• Synchronized data between different EPMA applications via EPMA Data sync process.
• Used Hyperion planning 11.1.2.0 to create new web forms to reduce the work load of the user there by focusing on planning, budgeting and forecasting.
• Created multiple packages in ODI to Extract, Manipulate and Load data between source and target systems.
• Created multiple Interfaces in ODI to load data and metadata in Essbase and Planning applications.
• Created many automated process in ODI for nightly and monthly data, metadata and security processing.

Confidential

Hyperion Developer

Responsibilities:

• Integrate DRM and EPMA for Metadata changes
• Maintain metadata in DRM and create CDC process for metadata change for month end process
• Created property types and property definitions in DRM.
• Created and automated nightly hierarchies build and property changed using DRM action scripts.
• Worked with DRM exports to generate ADS files to load in to EPMA.
• Create Shared and local dimension based on the application requirement
• Created web forms in planning with drill through capability to the source system using Oracle FDMEE.
• Created web forms in Hyperion planning for users to create, modify the plan details and also web forms for the capital controllers to allocate amount among various plans.
• UsedHyperionLife Cycle Management Utility (LCM) for allHyperionrelated artifacts migration from one environment to other.
• Automated periodic data loads and Calc scripts using MaxL and Batch
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Prepared physical, logical and presentation layers in OBIEE.
• Developed many analysis and dashboards using Essbase and Planning as a data source.
• Worked with Web forms and composite webworms.
• Involved in estimating and tuning the Essbase database performance.
• Documented the recovery process in the event of disaster recovery.
• Provided production support and dealt with the user issues.
• Created Physical and Logical models in ODI.
• Created multiple packages in ODI to Extract, Manipulate and Load data between source and target systems.

Environment: Hyperion Essbase 11.1.2.2, Hyperion planning 11.1.2.1 EAS Administration services, Hyperion Financial reports, HyperionPlanning desktop, Smart View, Oracle 10g,MS Excel spreadsheet Add-in, Windows 2000.

Confidential

Hyperion Administrator/Developer

Responsibilities:

• Administration and maintenance of Hyperion Planning & HFM, FDM, DRM, ODI and Essbase v. 11.1.2.1
• Maintain metadata in EPMA (including extracting, loading and updating the metadata structure)
• Ensure monthly close process runs smoothly in Hyperion Planning & HFM, FDM, DRM, ODI and Essbase applications
• Coordinate issue resolution with internal and external technical support providers
• Support corporate, field and remote users with Hyperion applications and Smart View
• Build, maintain and run financial reports in Hyperion Financial Reporting Studio
• Designed security for Financial Reporting Studio users.
• Load data to HFM as needed during monthly close process
• Work with end users to develop and enhance the application process in a manner that will result in a stable productive environment
• Monitor application performance; identification and communication of resolution of issues
• Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS as well as Hyperion Patches.
• Maintenance of user security and troubleshooting user access issues as they arise.

Environment: Hyperion Essbase 11.1.2.1, Hyperion planning 11.1.2.1 EAS Administration services, Hyperion Financial reports, HyperionPlanning desktop, Smart View, Oracle 10g, MS Excel spreadsheet Add-in, Windows 2000.