Oracle EPM cloud- PBCS, Hyperion Essbase, Hyperion Planning 11.X, Orac

Sri Phani Bala. K

PROFESSIONAL SUMMARY:

Extensive expertise in Oracle EPM cloud- PBCS, Hyperion Essbase, Hyperion Planning 11.X, Oracle Data Integrator (ODI) and SAP BPC and ANAPLAN.

Managing Oracle EPM / Hyperion deliverables including obtaining functional requirements and translating to technical deliverables.

Worked on end-to-end implementations including Technical Specification preparation, Configuration, Design Development, Testing, Go-live activities and End-User training in Oracle EPM Cloud, Hyperion Planning, Essbase, ODI,SAP BPC and ANAPLAN applications

Worked in Development and Maintenance of Projects involving Enhancements, resolving Critical Issues, Data Reconciliation, providing permanent solutions for Recurrent Issues, Automation, Scheduling Process Chains and Job monitoring during Target setting, Budgeting, Forecasting, Period-end close in Oracle Hyperion Planning and Essbase Modules and SAP BPC, BW.

Have strong experience in interacting effectively with Business Users and different technical teams.

Practical experience earned while implementing and supporting Enterprise applications for biggest companies in US and Middle East.

Strong in problem solving, analytical & troubleshooting skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction

Expertise in Creating Applications and BSO / ASO Cubes in Oracle EPM cloud and On – Premise.

Fluent in using Hyperion Essbase Application Manager Modules, Outline Editor, Calc Script Editor, and Data Prep Editor.

Create and Manage Metadata- base hierarchies, alternate hierarchies according to the needs of the organization.

Build Outline using Hyperion Planning Outline load Utility.

Expert Knowledge on creating, maintaining Hyperion artifacts Outline, Rules File, Calculation Scripts, Business rules, Report Scripts, Partitions, Web forms, MaxL scripts, Smart View Workflows, Task Lists, Menus and Security.

Built Packages, Procedures and Interfaces in ODI for in bound and out bound metadata and data loads.

Expert knowledge in Scheduling and monitoring ODI jobs and logs

Working with cross functional teams source system, ERP team and EPM developers

Have good understanding of SAP systems such as SAP ECC, SAP BW, SAP COPA, GL, BCS, and MDG etc.

Have built custom interfaces such as SAP ECC to Hyperion / BPC, COPA to Hyperion / BPC, BCS to Hyperion / BPC, ATLAS to Hyperion / BPC. Etc.

Experience in developing Data forms using Hyperion Planning for the users to input Forecast, Budget, Actual data.

Expert Knowledge on create and Manage Valid Intersections according to organization requirements

Proficient on Creating and managing Smart Push jobs and Data Mapping

Knowledge on Creating Dash boards, Infolets.

Created Users and User Groups in Shared Services and Assigned Security to Web Forms, Task List and Business Rules.

Security Management through restricting user accounts with Roles and Privileges.

Hands on experience in Application backup activities and migration of applications across environment using LCM mechanism in Hyperion Shared Services and EPM cloud modules

Exporting security out of Planning Application using LCM mechanism.

Maintained database optimization while performing Data Loading, Business Rules, Calculation Scripts, and Report Scripts.

Having good exposure in Budgeting and Forecasting process.

Worked closely with GFP&A for executing Forecast cycles and also Managed Month end and Quarter-End close in Oracle Hyperion Planning & SAP BPC

Support Finance business users on data variances in EPM applications

Trained the business users on Smart view (Hyperion), Excel Add-In and EPM- add-in (SAP BPC) in larger groups.

Conduct root cause analysis and develops solutions leveraging enterprise-wide practices related to client Hyperion software based on project change requests, Tasks and Defects.

Delivering Enhancements relating to all functionality within Hyperion Planning, including Metadata, Data load, Calculation Scripts, Business rules, Web forms, MaxL scripts, Smart View Workflows and Security

Ensure Functional and Technical requirements are met through development, code fixes, enhancements, system testing, Regression testing, Performance testing, system Interface testing and Security testing activities.

Experience in using HP ALM (Application Life cycle Management) to track project status, log and monitor defects.

Expert knowledge on preparing test scripts to help business /Financial users to participate in UAT(User Acceptance Test)

Experience in communicating and coordinating deliverables with onsite –offshore model

Effectively communicate all system modifications to business users and change control.

Experience in manage/ maintain Production system with regular health checks, ensure system is up and running optimized way.

Experience in resolving all the production issues by using ticketing system (Service Now) and within defined SLA’s.

Good experience in using Agile, Waterfall methodologies and followed it extensively in projects.

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

OLAP Development Tools

Oracle EPM, Hyperion Planning System 11.X, Hyperion Essbase, Hyperion Shared Services, Oracle Data Integrator (ODI), Smart View, Essbase Administrative Services, Essbase Integration Services. SAP BPC,SAP BW, ANAPLAN

Reporting Tools

Smart View, Excel ADD-IN, Tableau, SAP EPM- Add-in, Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Interactive reports, Hyperion Spreadsheet Add-in, Tableau.

Client: Synchrony Financial Services, Alpharetta, GA (Jun 2021- Present)

Role: Sr. Consultant Oracle EPM Cloud and ODI

Client is a leading Financial Services provider in USA. This project uses Oracle EPM- PBCS/EPBCS for their Planning and Budgeting activities. This Project uses Oracle EBS and GL are source systems and ODI acts as ETL tool.

Responsibilities:

Environment: Oracle E/PBCS, ODI 11g

Participated in business requirements for new enhancements and coordinating the delivery of the projects on time.

Worked with Functional team on the enhancement of the existing process.

Create and manage applications in PBCS and EPBCS.

Configure PBCS for ODI, integrate Metadata and Data from EBS, GL applications.

Developed ODI Packages and Interfaces to meet metadata and Data load requirements.

Data feed automation to and from EPM applications.

Scheduling and Monitoring the ODI jobs regularly and fixing the issues based on log files.

Work on the change management system, create test scenarios for UAT and move to Production.

Responsible for the overall support and on – going maintenance of all environments of the Hyperion Planning system budgeting and forecasting systems.

Metadata- Added Accounts, Entities and custom dimensions to Hierarchies.

LCM used for migration on an ad-hoc basis for application artifacts, security.

Create and Manage Smart Push jobs and Data Mapping

Created Business Rules, Forms, Data Push Jobs

Created Valid Intersections

Responsible for data load for the month-end process

Responsible for SOX compliance for Hyperion Application.

Client: Applied Materials, San Jose, CA (Aug 2016 – Jun2021)

Role: Techno Functional Analyst – Oracle Hyperion / SAP BPC /ANAPLAN

Client is a leading equipment supplier to the semiconductors, Display and solar industries in USA. Client provides materials engineering solutions used to produce virtually every new chip and advanced display in the world. This Project supports both Hyperion Essbase and Hyperion Planning.

Responsibilities:

Environment: Hyperion 11.x, SAP BPC 10.0, ANAPLAN, Tableau

Played vital role during the project in all phases of Project life cycle including Requirement Gathering, Analysis, Design, Development, Functional Testing, Integration Testing, Performance Testing, Security testing, UAT, Deployment, Hyper Care, Post Go-Live activities.

Requirement gathering and understanding the solution feasibility, Technical Specification preparation, Configuration, Design Development, Testing, Go-live activities and End-User Training

Plans, documents and executes all phases of the project lifecycle, including scope management, requirements management, work breakdown schedule and timeline management, priority and dependency management, and the assignment of roles and responsibilities.

Responsible for Project planning, project tracking & project deliverables.

Worked with Business to users to help to prepare Business Requirement Document (BRD).

Worked with BI, BW, ABAP, ECC, MDG, COPA, Close Support, BODS teams to discuss Functional Specs and provide requirement

Worked with Finance Users to help or prepare Functional Specification Document (FS).

Responsible for interacting with Business Lead & users to write the technical specifications based on Functional specifications, Unit test documentation, Test Cases and test scripts for Integration testing and UAT, KT and giving end user training.

Delivered Detailed Application Technical Design Document.

Have participated in project development activities (e.g. Creating Hyperion Planning Application, Loading of Master Data and Transaction data into Planning cubes)

Developed Essbase Calculation scripts and Calculation rules as per business requirement

Maintaining tables in SAP (Hyperion to SAP), Scheduling BI Process chains, Job Extraction, Monitoring logs

Build custom interface from the source system (ECC, COPA, BCS, AKT, ATLAS, and MDG) to Hyperion.

The loading of Actual data and employee data from SAP was developed using load rules and automated the process the using MAXL scripts, scheduled batch scripts and monitor the logs.

Developed MaxL Scripts in combination with ODI to automate the data loads on a daily, weekly and monthly basis

Build inter model interfaces to push the data from one cube to another.

Created custom and adhoc reports in Hyperion for the data validation as per the user requirement.

Develop many complex reports and Input forms as required.

Created many Test Scripts and Test cases to support Integration testing and User Acceptance Testing.

Worked on Change Request process, and HPQC for documentation and approval process

Worked on go-live cut over plan activities and successfully handled & resolved the Post Go Live issues.

Worked closely with GFP&A and helped in planning related issues within time and supporting month end and quarter end budgeting process

Worked on data/user related issues and fix with in SLA periods for smooth Budgeting process

The final solution was developed and delivered composed of 3 planning databases and 4 Essbase BSO databases

Developed complete budgeting/forecasting solution that included Revenue, Capital Expenditure, Operational Expenses and Workforce planning along with cost center and profit center allocations.

Delivered signed off UAT scripts from testers and resolution of issues identified during testing.

Trained system administrators on use and maintenance of system.

Provided 3rd tier support for applications post go-live

The final solution enable 200+ users spread geographically throughout the world to perform monthly forecasting and annual planning

Client: NISSAN, Franklin, Tennessee (Mar 2016 – Aug2016)

Role: Senior Hyperion Consultant

This is a migration/Upgrade project from Hyperion 11.1.1.0 to Hyperion planning 11.1.2.3

Responsibilities:

Environment: Hyperion 11.x, Informatica

Worked on end-to-end implementations including Technical Specification preparation, Configuration, Design Development, Testing, Go-live activities and End-User training in Oracle Hyperion Planning, Essbase, ODI

Requirement gathering and understanding the solution feasibility, Technical Specification preparation, Configuration, Design Development, Testing, Go-live activities and End-User Training

Create/ Update and maintenance of Essbase objects outlines, dimensions, measures, members, Calculation Script, Load Rules, MaxL, LCM, and Report Scripts

Deployment/Migration of application into different environments Dev, QA and Production environments for Hyperion Essbase, Planning.

Developed and maintained ODI interfaces to load Metadata into planning application.

Worked with Business and Finance Users to manage and resolve issues during the Project implementation process

Preparation of business scenarios and Test Scripts and Test cases for Integration testing and UAT

Data Reconciliations, Support Business Users on Month End, Quarter End and Year End activities.

Provide functional/technical expertise to support consolidation process and corporate reporting.

Provide timely and effective technical support to troubleshoot issues and minimize down time for the end user during the month-end close processes, edit rule files and creating duplicate environment from backups to compare/ analyze the changes

Assist with data/problem/issue resolution, process improvement and resolving the root cause of problems

Documentations as per organization standards, training for Business users and Knowledge Transfer to Production Support team.

Hyper Care support and Post Go-Live support

Client: Saudi Aramco, Saudi Arabia, UAE (March 2015 – February 2016.)

Role: Hyperion Consultant

Client is the state - owned oil company of the kingdom of Saudi Arabia and fully integrated, global petroleum and chemicals enterprise. They are the leader in hydrocarbons exploration, production, refining, distribution, shipping and marketing and the top exporters of crude oil and Natural Gas Liquids.

Responsibilities:

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3,

Application Creation in Hyperion Planning

Loading Metadata into the planning application.

Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual data.

Created Calculation scripts & Variables as per the requirement.

Developed Business rules and attached to the input forms to calculate data on save Option.

Created users and user groups in the Planning applications and assigned security to web forms.

Designed workflow management cycles.

Migrated artifacts using LCM.

Served as a liaison between the client and offshore team to understand the requirements, propose the design, to facilitate the User Acceptance Testing. Was involved in the planning application designing, designing of data forms, optimizing the business rules, planning application configuration, task list and security implementation.

Helped in preparation of Test Scripts and Design Level Document for Planning and Reporting track

Developed Essbase cubes for Sales, Production, Planning and Budgeting.

Client: Sarvottam Health Care, Hyderabad (September 2011 – February 2015)

Role: Hyperion Consultant

Responsibilities:

Environment: Hyperion Essbase, Hyperion Planning 11.1.1.3

Involved in the data analysis for designing outline, formulas, proprieties, and scripts.

Outline creation based on the business requirements.

Created Dimension build rules for building the dimensions in the outline.

Created Load rules for data to move from Warehouse to Essbase cubes.

Created UDA’s, Filters for Project and Created security using those.

Created calculation scripts for project.

Enhanced calculation scripts to load data based on ad-hoc user requirements

Refreshed Reporting scripts and rules files

Managed security and administration using filters and groups.

Backup management.

Security management for the Hyperion application.

Created test cases for unit test for test forms and business rules.

Preparing User documents for the end client.

Contact this candidate