NAME

(M) 91 xxxxxxxxxx *********@gmail.com

OBJECTIVE

To contribute to a Business Intelligence team where the BI conceptual knowledge and practical
development/implementation experience of Oracle Hyperion BI applications coupled with excellent client
management skills can be utilized to deliver value added solution to the business users.
SUMMARY

Around 8 years of experience in client engagement, requirement gathering, developing and

implementing Oracle Enterprise Performance Management solutions using Oracle Hyperion
Planning/Essbase, Oracle Hyperion Financial Management, Oracle Financial Data Management,
Data Integration Management and Oracle Financial Reporting for primarily Manufacturing,
Healthcare and Banking sector clients.
Completed Oracle Hyperion Planning 11 Certified Implementation Specialist certification in 2014.
Inherent part of the Pre-sales team that provided Oracle Hyperion architecture based solution
responses which was then successfully converted to implementation/maintenance projects
Customer-focused, highly organized self-starter with effective customer-service skills and demonstrated
ability to manage technical aspects, architect customized solutions, build and maintain relationships
and communicate solution strategy to clients.
Experienced in planning and managing projects, interacting with multi-national clients from onsite and
offshore.
Proven troubleshooting skills and committed follower of quality and process standards laid by the
company.

EXPERIENCE

Oracle Hyperion Business Intelligence Consultant Aug 2014 - Present

[Company Name]. Bangalore

Project Overview Global Integrated Planning Hyperion Application Development & Support

The engagement is structured to do Development, Enhancement, Support and Maintenance of

Planning/Essbase cubes for Planning, Budgeting and Forecasting tracks for a Telecom client based in UK.
Delivered responsibilities Role Release Manager (Planning/Essbase)
Managing deployment and migrations for all major global and technical releases.

Manage escalations and high priority issues within planning cycles and processes.

Coordinating change requests and related UAT to ensure the release goes with zero or minimum known
defects post production go live.
Publishing release documents pertaining to metadata and security elements post go live.

Managing offshore production support team for Planning/Essbase & FDM and helping them resolve
issues in conjunction with SI partners and clients.
Proposing and developing new solutions to automate processes related to artifact migration, security;
bring in checks and balances to ensure issues are caught proactively and root-cause analysis is swift.
Technology Oracle Hyperion Planning/Essbase 11.1.2.3, Oracle Hyperion Financial Data
Management 11.1.2.3, Oracle Hyperion Smart View 11.1.2.3

Project Overview Corporate Financial Systems Hyperion Application Development & Support

The engagement is aimed to do Development/Implementation, Enhancement, Support and Maintenance of

HFM/FDM and Planning/Essbase cubes for Financial Consolidation and Reporting; Supply Chain Metrics
Reporting; Planning, Budgeting and Forecasting tracks for a Manufacturing domain Client based in USA.
Delivered responsibilities Role Oracle Hyperion (HFM/Planning/Essbase) Consultant
Travelled onsite (New Jersey, USA) to do the Business and Systems Analysis process and
understand the as-is (Hyperion Enterprise) monthly/quarterly/annual financial data submission and
consolidation and allocation functional and technical processes in detail along with a team of
implementation consultants with a view to setup HFM and FDM for global financial consolidation and
reporting.
Helped the implementation team in Metadata build, setting up HFM rules, validation rules, building
member lists, shared services and application access process, smart view reporting templates, etc.
during the build phase.
Aided the team in building FDM mappings to be able to submit data coming through different source
systems like SAP, JDE and manual templates.
Travelled to Shanghai, China to facilitate HFM end user training sessions for batch consisting of Asia
Pacific users.
Worked with the project management team to sail through the User Acceptance Testing thereby
resolving with the team any identified technical issues or variances in data between HFM and HE.
Planned and implemented global roll out of Smart View tool installation and connection preferences
setup for close to 500 end users.
Develop differential rules to calculate Inventory metrics viz. DOH, DPO and DSO for Actual and Budget
scenarios as well as 13 month average calculations.
Develop reports using Interactive Reporting and SQL batch scripts to produce exception reporting for
Process Control and Promotion Control for audit purposes.
Basic high level performance tuning to HFM application, underlying relational Oracle DB and Smart
view registry parameters (on client end) to optimize query response times.
Supporting month end financial close process, working on issues raised by users and providing
resolutions (answers) to their queries, redirecting tickets to Corporate team or backend IT team as
necessary, providing system access thru Shared services to QA and Production systems as necessary.
Built a Planning cube to capture current access to the HFM application for the managers of the users to
approve the access of their immediate subordinates to the system for audit purpose every quarter.
Supporting client team during external auditing by producing history audit logs from HFM application,
FDM audit tables and Shared services module.
 Handled an offshore team of 4-5 resources for close to 3 years and trained them to support, enhance
and maintain the HFM application as well as Planning/Essbase cubes as part of month end financial
and supply chain close process.

Technology Oracle Hyperion Financial Management 11.1.2.1, Oracle Hyperion Financial Data
Management 11.1.2.1, Oracle Hyperion Planning/Essbase 11.1.2.1, Oracle Hyperion Smart View
11.1.2.1.103

Project Overview - Management Accounting & Planning System

The engagement is aimed to do Development and Enhancement of Planning/Essbase cubes for Planning,
Budgeting and Forecasting tracks for a Banking domain Client based in USA.
Delivered responsibilities Role Oracle Hyperion Consultant
Travelled onsite (Richmond, USA) to do the Business and Systems Analysis process and understand
the monthly outlook and allocation processes in detail with a view to setup an offshore support model to
co-ordinate development and support all related techno-functional tasks.
Led an offshore team of five for around six months to ensure high quality and timely deliverables related
to the MAPS process which include deliverables related to development, testing and support phases.
Played an individual contributor (Hyperion consultant) role to resolve functional and technical issues in
sister concern teams related to Hyperion Interactive Reporting, Hyperion Financial Reporting and
OBIEE tracks.

Technology Oracle Hyperion Planning 11.1.1.3, Oracle Hyperion Essbase 11.1.1.3, IR, FR.

Project Overview - Budget Transaction System

The project was aimed to do Development and Enhancement of Planning/Essbase cubes for Planning,
Budgeting and Forecasting tracks for a Healthcare domain Client based in Australia.
Delivered responsibilities Role Oracle Hyperion Planning Consultant
Travelled onsite (Sydney, Australia) to do the Requirement Gathering process for an ongoing
Budgeting process meant to track budget numbers in greater detail, in understanding the clients
existing planning exercise and translate it into Hyperion Planning Design requirements.
To be part of the Solution Definition team, in mapping client business requirements to Hyperion
application functionalities and coming up with future solution architecture for Budgeting and tracking
budgeted numbers.
To design and create a prototype for the Budget Transaction application including metadata and data
to incorporate Budget data posted through manual inputs into the primary Planning application and an
RDBMS application and demo it to high level Finance user groups and take approval to build the main
application.
 To develop the entire Budget Transaction application including metadata and data to incorporate Budget
data posted through manual input into the primary Planning application and an RDBMS application for
tracking Budgeting numbers with additional information viz. User name, Transaction time, etc..
To be part of UAT for the entire Budgeting process from end to end and aid in identifying and fixing
issues pointed by the end users.
Handling an offshore team of four members to track their deliverables, doing CUT and SIT and
managing the final deliverable before moving it to UAT through a period of 3 months.

Technology Oracle Hyperion Planning 11.1.1.2, Oracle Hyperion Essbase 11.1.1.2, Web Analysis.

Project Overview - Financial Budgeting & Planning and Reporting

The project is aimed to do Development and Enhancement of Planning/Essbase cubes for Planning,
Budgeting and Forecasting tracks for a Manufacturing domain Client.
Delivered responsibilities Role Oracle Hyperion Planning Consultant
To be part of the Requirement Gathering process for Budgeting & Forecasting, in understanding the
clients existing planning exercise and translate it into Hyperion Planning Design requirements
To be part of the Solution Definition team, in mapping client business requirements to Hyperion
application functionalities and coming up with future solution architecture for Headcount Budgeting.
To create the entire Planning application including metadata and data to incorporate Headcount data
from SAP BW source system into primary Planning application for Budgeting process considerations
using DIM mappings.
To develop an offline cost center budgeting template in Excel using complex Smartview function,
formulas and macros to aid budgeting users in the organization that do not have relevant Hyperion
Smartview licenses.
To be part of UAT for the entire Budgeting process from end to end and aid in identifying and fixing
issues pointed by the end users.
To develop reports in Hyperion Financial Reporting and report books in Workspace for business users
to budget headcount in the Planning application along with other financial accounts.
Develop Interactive Reporting reports highlighting the status of all the important DIM workflows and
publishing it in Hyperion Workspace for the end user reference on a daily basis.
Aid in development of complex UNIX based MaxL scripts used to trigger commands from DIM server to
start Replicated partitions on Essbase server.
Building Workflow for planning approval process and locking data in Essbase once planning process is
frozen.
Creating Replicated and Transparent partitions from source to copy cubes to enable data flow into
reporting cubes from the primary Planning & Forecasting cubes.
Creating Financial Reports with traffic lighting for highlighting forecasting accuracy of the Forecasting
process.
 Creating Budget book for approvals by Finance top level management users using Financial Reports.
Technology Oracle Hyperion Planning 9.3.1, Oracle Hyperion Essbase 9.3.1, Oracle Hyperion Financial
Reporting 9.3.1, DIM 7.1

Project Overview- Hyperion Enterprise to Hyperion Financial Management Migration

The internal solution was being developed with a view to enable customers who had Hyperion Enterprise
migrate Hyperion Financial Management which is a faster and better consolidation tool
Delivered responsibilities Role Oracle Hyperion Consultant
Installation and configuration of Hyperion Financial Management v4.0
Building HFM metadata and security from Hyperion Enterprise metadata using Excel based macros.

Technology Oracle Hyperion Financial Management 4.0, Oracle Hyperion Enterprise 6.0

Project Overview Hyperion Planning & Reporting Testing

The project involved developing Functional and Technical Test cases/scripts as part of CUT and SIT.

Delivered responsibilities Role Oracle Hyperion Consultant

Guiding the Planning & Reporting Testing team on functional aspects to aid them in developing
Functional and Technical Test cases/scripts as part of Code and Unit Testing and System Integration
Testing.

Technology Oracle Hyperion Financial Reporting 11, Oracle Hyperion Web Analysis 11

Project Overview Process Consulting for Implementing Hyperion Planning

The project involved Consulting for implementing Hyperion Planning to perform Budgeting & Planning.
Delivered responsibilities Role Oracle Hyperion Consultant
Scoping of Planning & Budgeting requirements of the customer on a high level.
Charting hardware requirements required to be employed to implement Hyperion Planning solution.
Charting an ideal workflow for planning approval process.

Technology Oracle Hyperion Planning

Project Overview Migration of Hyperion Performance Suite and Hyperion Financial Reports
The scope of the project covered migrating Hyperion Performance Suite and Hyperion Financial Reports
from an old server to a new server without any change being evident to the end users.
Delivered responsibilities Role Oracle Hyperion Consultant
Installation, Configuration and Migration of all Hyperion Reports and HPS from and old to a new server.
Involved in UAT, fixing issues pointed out by end users and delivering post production support.
Proactive testing of issues arising out of migrating users from Novell to MSAD.
 Setting up user security, performing unit testing of all financial reports and components of HPS.

Technology Hyperion Performance Suite 8, Oracle Hyperion Financial Reporting 7

Project Overview Development of Essbase cubes for Management Budgeting & Reporting
The project required building Management & Budget Reports from Essbase cubes which earlier had HFM
as their data source.
Delivered responsibilities Role Oracle Hyperion Consultant
Reconciling Essbase and HFM outlines; reconciling Essbase calc scripts with HFM rules and
reconciling data at every level between Essbase and HFM hierarchies meant for Management
Budgeting & Reporting
Building Hyperion Financial Reports having Hyperion Essbase as data source.

Technology Oracle Hyperion Essbase 7, Oracle Hyperion Financial Reporting 7, Oracle Hyperion
Financial Management 3.5

BIIM Pre-Sales Consultant May 2007 Mar 2008

[Company Name] - Bangalore

Delivered responsibilities Role Presales Consultant

Responding to RFPs/RFIs with appropriate suggestive solution, solution architectures, effort
estimations and customer references.
Proactive Demand Generation: Charting the IT infrastructure, Problem Statement, Solution Map and
Entry & Influencing Strategy for prospective Retail, Utilities & HealthCare clients.
Organizing Knowledge Sharing sessions for onsite and offshore based Presales Consultants.
Preparing Project plans viz. Gantt charts on Microsoft Project 2003.
Preparing Effort Estimation & Resource loading charts for prospective projects.

Management Trainee May 2006 June 2006

[Company Name]. Mumbai/Hyderabad

Project Overview
Analyze the Wholesale dealer channel infrastructure, coverage and display over two territories.
Delivered responsibilities Role Dealer Channel Analyst
Develop and analyze Wholesale Dealer (WD) performance using K.S.F metrics and identify
improvement areas using SPSS 13
Primary survey of dealers and retailers across 14 towns and cities of A.P
 Benchmarking against desired performance

EDUCATIONAL DETAILS

Qualification College / University Year of Passing

P.G.D.B.M. I.M.T, Ghaziabad 2007
B.E (Electrical) Faculty of Technology & Engineering, M.S.U, Baroda 2005
XII G.S.E.B 2001
X G.S.E.B 1999