RAVIJYOT KAUR

Solution Architect - Hyperion Planning +918*********

adjiy5@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 11 years of diverse experience in the field of Information Technology with Oracle and Infosys in key technologies like Hyperion Planning and Essbase.

Presently working in Oracle India Private Limited since 8 years and 5 months (Jul’12 – Present).

Remarkable Experience in Hyperion Planning and Essbase tools for 10 years.

Designed and developed Workforce Planning and Capex business process solutions for EPBCS on EPM Cloud.

Designed and developed end-to-end Strategic Workforce Planning (SWPCS) business process solution.

Experience in developing different Hyperion Planning artifacts (dimensions, forms, dashboards, menus, data maps etc)

Expert in writing Business rules in Calc manager.

Experience of writing templates and rules using Groovy.

Having adequate knowledge of Dynamic Member Creation in Hyperion Planning (Member on the Fly feature).

Effective contribution while developing solutions in the areas of process flow, business logic and user interface.

Experience of working and co-coordinating with teams at different sites.

Excellent leadership, communication, analytical and interpersonal skills.

CERTIFICATIONS AND TRAININGS:

Oracle Certified Implementation Specialist for Oracle Hyperion Essbase 11.1.2.

Trained in Hyperion Planning by Oracle.

Trained in Hyperion Financial Management (HFM), Hyperion Close Management and Disclosure Management by Oracle.

Successfully completed Infosys E&R training with 5.00/5.00 CGPA.

REWARDS AND RECOGNITION:

Awarded as MOST VALUABLE PLAYER for KPLAN project.

Won ESOR STAR Performer Award, for Essbase Production Support and Enhancement project.

EMPLOYMENT SUMMARY:

Oracle India Private Limited: Since Jul’12 till date

Growth Path

Jul’12 - Jun’16: Member Technical Staff

Jul’16 - Dec’18: Senior Member Technical Staff

Since Jan’19: Principal Member Technical Staff

Project 01: EPBCS Workforce and Capex on Cloud – from Jan’15 till date

Project Description: Oracle Hyperion Workforce Planning is a special-purpose planning module that makes headcount, salary, and compensation planning fast and efficient across the enterprise.

I am engaged in the Development of Planning Module Workforce business process on cloud. Designed with pre-built functionality and best practices that are ready to use right out of the box, it simplifies the planning of workforce and workforce related expenses, such as compensation including bonuses, fringe benefits, overtime and merit increases.

Served as the main Point of Contact in the Development team for the following teams - Testing/QE, Documentation, Curriculum Development, Pre-Sales, Consultants, Product Management.

Key Responsibilities:

Discussed the complete solution with functional stakeholders.

Designed multi cube solution including two BSO cubes and an ASO cube for reporting.

Have written all the business rules and templates in calculation manager and also leveraged groovy.

Have developed different Hyperion Planning artifacts such as dimensions, forms, dashboards, menus, smartlists, data maps etc.

Used Structures to build the work flow of application.

Project 02: Strategic Workforce Planning on Cloud (SWPCS) – from May’16 till date

Project Description: Oracle Strategic Workforce Planning is a special-purpose planning module that translates long-term corporate strategy into execution plans by ensuring that the strategy is supported by the right workforce—the right skill sets and headcount at the right time.

I am engaged in the Development of Strategic Workforce Planning business process on cloud. Designed with pre-built functionality and best practices that are ready to use right out of the box, it has capabilities to look at short-, medium- and long-term plans, to identify demand and supply skills gaps.

Served as the main Point of Contact in the Development team for the following teams - Testing/QE, Documentation, Curriculum Development, Pre-Sales, Consultants, Product Management.

Key Responsibilities:

Discussed the complete solution with functional stakeholders.

Designed multi cube solution including two BSO cubes and an ASO cube for reporting.

Have written all the business rules and templates in calculation manager.

Have developed different Hyperion Planning artifacts such as dimensions, forms, dashboards, menus, smartlists, MRAs etc.

Used Structures to build the work flow of application.

Project 03: Workforce and Capex on Premise – from Jul’12 till Dec’14

Project Description: Oracle Hyperion Workforce Planning module makes the headcount, salary, and compensation planning fast and efficient across the enterprise. Oracle Hyperion Capital Asset Planning automates the planning of capital assets and related expenses, such as depreciation, maintenance, and insurance.

Key Responsibilities:

Building Scripts in Calculation Manager as per the Requirements

Worked on new enhancements as per the requirements.

Worked on Development bugs raised by Clients and Testing Teams.

Developed various Planning artifacts.

Project 04: PSB – from Jul’12 till Dec’14

Project Description: Public Sector Planning and Budgeting, is an integrated budgeting and planning solution in the Oracle Hyperion Enterprise Performance Management System suite.

Public Sector Planning and Budgeting, is an integrated budgeting and planning solution in the Oracle Hyperion Enterprise Performance Management System suite that enables public sector and higher-education organizations to manage existing and projected budgets using current and previous General Ledger and Human Resource Management (HRMS) data.

Key Responsibilities:

Building Scripts in Calculation Manager as per the Requirements

Worked on new enhancements as per the requirements.

Worked on both Installed and Java environments of EPM.

Created Charts and Graphs in Hyperion Planning for PSB for all the 12 Models.

Infosys Technologies Limited: From Aug’09 to Jul’12

Project 01: KPLAN – from Apr’11 till Jul’12

Project Description: KPLAN project is an Implementation of a new Essbase application for Sales planning.

KPLAN is a warehouse trade planning tool which enables business planners to plan the products to be maintained in the warehouse in an efficient and controlled manner. Planners analyze the historical actual data and arrive at the numbers for the next fiscal year. Once planned, Planners submit the data to central repository in the form of Essbase cube. This data is processed into Essbase as per Business requirements and then reported to the management to make decisions.

My Role: Hyperion Essbase Consultant

Key Responsibilities:

Worked on the Development of a new Essbase application that involved creating hierarchy and developing all the required Essbase objects. It is a Sales planning application and involved the development of complex logic for calculations.

My role involved requirement gathering, providing analysis and design approaches, extensive interaction with the customer. The work required lot of onsite-offshore-client coordination.

Development activities involved-

oCreating load rules for Building Dimensions

oCreating data load rules, generating and testing the data/structural load files

oScripting allocation logics and aggregation calculation scripts

oCreating report scripts as per the Business requirements

oWriting ESSCMD scripts

oCreating security

Extensive interaction with the client and users.

My profile included responsibilities of being single point of contact at offshore.

Technologies/ Tool: Hyperion Essbase

Team Size: 1 in India (Hyderabad) and 1 at Onsite

Project 02: Essbase Production Support and Enhancement – from Feb’10 - Apr’11

Project Description: Kraft ESSBASE is a Production Support and Enhancement project for Kraft’s Financial Planning, Budgeting and Forecasting applications.

The Project involves supporting the Kraft Essbase applications which includes resolving complex technical issues, Enhancements of the existing applications which helps Kraft to maintain the integrity of the data. As the Essbase is used to maintain the Profit and Loss data, it is very critical to make sure that the application is running as desired at all time.

My Role: Hyperion Essbase Consultant

Key Responsibilities:

Worked on the Maintenance and Enhancement of Hyperion Essbase applications. My role in the project demanded resolution of Production issues and Change requests related to financial planning, consolidation, allocation and reporting.

Analysis, Debugging, Testing and Solutions of the Change Requests/Enhancements received from the client and users.

Worked on Data Load, Data Calculation and Data reporting.

Worked on the Enhancement of Partitioning applications that involved working on Replicated Partitioning.

Security Management.

Intensive interaction with the users.

Being the single point of contact at Offshore for a year, provided flawless and on-time support to the project.

Trained new resource on Essbase and Kraft Essbase applications.

Technologies/ Tool: Hyperion Essbase

Team Size: 1 in India (Hyderabad) and 3 at Onsite.

EDUCATION:

Bachelor of Engineering in Computer Science with 78% from Swami Keshvanand Institue of Technology, Jaipur, Rajasthan University, India completed in 2009.

Qualified Senior Secondary Education with 77% from Guru Harkrishan Public School, Indore, India completed in 2005.

Qualified Higher Secondary Education with 87% from Gyan Jyoti Senior Secondary School, SriKaranpur, India completed in 2003.

PERSONAL DETAILS:

Father’s Name : RavinderPal Singh.

Date of Birth : 21st December 1988.

Languages Known : English, Punjabi and Hindi.

Nationality : Indian

Contact this candidate