PROFESSIONAL SUMMARY:

• 11.4 years of professional experience on designing, Administration, Development, Reporting, and Migration of OLAP systems with focus on Oracle Hyperion Suite of Technology
• Proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, FDQM, and Smart View VBA.
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta - Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Strong with understanding of Accounting concepts and principles
• Knowledge on using Oracle Data Integrator (ODI) and Financial Data Quality Management (FDQM) and CCC 10.2.4 for scheduling and automation
• Expertise in Partitioning, Calc scripting and dynamic dimension build methods, data load rules, tuning and optimization in Essbase.
• Expertise in creation and maintenance of Hyperion Planning applications, business rules, web forms, security groups and users etc.
• Expert in providing solutions for automations and proficient in MaxL, Smart View VBA(macros), SQL, MDX, batch scripts, VB Script, Powershell, JavaScript.
• Passionate about problem solving and automations and to provide solution for scalable and robust architecture
• Worked on Oracle EPM 11.1.2.3/11.1.2.4 which has features such as: Dimension Library, Application Library, Calculation Manager and Life Cycle Management.
• Creation of roadmap to migrate on Premise to PBCS, the benefits, pros and cons and the ROI
• Conversant on migration / upgrade of Hyperion planning and Essbase applications.
• Experience on Data Warehousing and Business Intelligence Concepts.
• Currently gaining knowledge on OACS, Data Science, Python, and Cloud computing.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Outstanding team player with an aptitude to learn. Strong analytical, communication, interpersonal, customer interaction and problem solving skills in technology arena.

SKILLS PROFILE:

Front-End: Hyperion Planning 9.3.1/ 11.1.1.3/11.1.2 .4 , HFM 11.1.1.3/11.1.2 .4 , QED, CCC 10.2.4

Databases: Hyperion Essbase 6.5/7.1.2/ 9.3.1/ 11.1.1.3/11.1.2 .4 , SQL Server 2005/2008/2012 , Sybase ASE/Anywhere

Languages : MaxL, JavaScript, SQL, MDX, VBScipt, PowerShell, Java, HTML

Reporting Tools: Hyperion System 9/11 Financial Reporting/Hyperion Reports 7.5, Hyperion System 9 Interactive ReportingSmart View 9.3.1/11.1.2 .4 , Tableau Desktop

Operating System: Windows 10, Windows Server 2000/2003/2008 R2/2012R2.

ETL: HAL 7, FDQM 9.3.1/11.1.2 , ODI 10g/11g

PROFESSIONAL EXPERIENCE:

Confidential, CA

Environment: s: Hyperion Planning 11.1.2.4, Hyperion Essbase 11.1.2.4, ODI 10g, Hyperion FDQM, SQL Server 2012, CCC 10.2.4, QED, SmartView VBA, Powershell, Cimcon Software

Sr. Hyperion Consultant/Team Lead

Responsibilities:

• Involved in discussions with business users to derive requirements. Held design sessions and created functional and technical design documents using Microsoft Visio and Power Point.
• Requirement analysis of the issues and prepare scope of work.
• Creation of automated Smartview VBA enabled Flowsheet template
• Designed end to end accrual process from exporting the data from the cube and posting to SAP
• Create SQL procedures for scanning and building Territory currency
• Creation of end to end ODI packages and scenarios
• Creation of Interfaces to load data and build metadata from Text file and SQL tables
• Creation of a Data Mart by exporting Hierarchy, Dimension and level 0 data as fact table to provide reporting from Tableau
• Creation of Tableau dashboard
• Creating SCC jobs which triggers SQL procedure and loads in Essbase ASO
• Creating menus and task lists.
• Using FR Utility ScheduleBatch.cmd to generate report from command line
• Creating VB script to auto populate the FR xml(command line file) file with the parameters extracted from planning web forms
• Creation of Smart View VBA templates for reconciliation and email it to users through SCC tool
• Using ODI to extract date and re formatting to alpha numeric and loading it back to a text member n Smart View adhoc analysis and Task List to International users
• Using extensively formula rows and columns in web forms to simulate what if scenarios before committing to the database
• Load data using Financial Data Management and managed the location during financial close cycle
• Creating dynamic calc scripts based on Actuals data changed
• Creating QED models for metadata management for users
• Redesigning shared service groups to be more inclined for a modular approach and to remove redundancy
• Acted as the technical lead for Hyperion Planning/Essbase related issues including providing technical support for users and supervisors
• Documentation of the existing business and operational process
• Provided hands-on to the end users and prepared end-user manuals
• Translate and supervise translation of business requirements into detailed solution architectures and designs.
• Used ODI, FDQM and Cognos Command Center for scheduling and automations.
• Responsible for automations using MaxL, Smartview, VBA, Powershell, MDX, batch scripts and Excel VBA(Macros).
• Optimization and fine tune the existing applications so it works efficiently and reduce the end to end forecasting close cycle

Confidential, CA

Environment: s: Hyperion Planning 9.3.1/ 11.1.1.3/11.1.2 , Hyperion Financial Management 11.1.1.3/11.1.2 , Hyperion Essbase, BI Framework 9.3.1/ 11.1.1.3/11.1.2 , Financial Reporting 9.3.1, HAL 7, FDQM 9.3.1/11.1.2 , ODI 10g/11g, QED, SCC 3.0.6

Sr. Hyperion Consultant/Team Lead

Responsibilities:

• Study of the AS-IS Hyperion Applications.
• Requirement analysis of the issues and prepare scope of work.
• Interaction with Business users to help them in any IT needs and enhance processes which are time consuming
• To come up with new functionality or business logic, so to expedite the process.
• Closely working with business team to carry out their estimate and Budget forecast cycle
• Optimize Business Rules for Consolidation and Allocations within Planning in the existing applications.
• Performing data loading and outline changes through HAL/ODI and using rules files.
• Modifications on the web-forms (Changes due to outline restructure, POV member change, addition of HBRs).
• Created and modified menus and task lists.
• Working with Journals creation, posting and rejection
• Consolidating and publishing all periods after submission is completed
• Handling Metadata management in HFM
• Loading data through FDM in HFM
• Copying ownership data from one scenario to another
• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.
• Automation of data loading, metadata extraction and building using MaxL and Batch scripting.
• Optimization of BSO cubes: Custom setting type of compression, data cache, calculator cache settings, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size.
• Acted as the technical lead for Hyperion Planning/Essbase related issues including providing technical support for users and supervisors
• Performed upgrading of Essbase cubes and Hyperion planning applications.
• Performed data and metadata reconciliation of development and production server.
• Prepare Unit test plan document for validation of different objects like the financial reports, calculation scripts, and Rule files in previous and later versions to identify different errors.
• Involved in Knowledge transfer and development transition to the other team members and to production support team.
• Documentation of the existing business and operational process.
• Provided hands-on to the end users and prepared end-user manuals.

Confidential, CA

Environment: s: Hyperion Planning 9.3.1/ 11.1.1.3/11.1.2 , Hyperion Essbase 9.3.1/ 11.1.1.3/11.1.2 , Financial Reporting 9.3.1, HAL 7, FDQM 9.3.1/11.1.2 , ODI 10g/11g, BI Framework

Sr. Hyperion Consultant

Responsibilities:

• Study of the AS-IS Hyperion Applications.
• Requirement analysis of the issues and prepare scope of work.
• Interaction with Business users to help them in any IT needs.
• Closely working with business team to carry out their estimate and Budget forecast cycle
• Coming up with drivers basis to calculate and effectively allocate monthly compensation of an employee
• Creating business rule to transfer employee from one cost centre to another
• Creating smart list for extensive list of Occupation code to select from by the end users in the Overhead module
• Enhancing and optimizing depreciation calc for Capital module
• Creating dynamic web forms which validate prior year cash, future year and current year cash flow with total Budgeted amount for an asset
• Creating ODI jobs for loading planned assets and loading of cash actuals
• Creation of complex allocation scripts to allocate cost from Admin cost centres to profit centres
• Add user or change user roles in Planning.
• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.
• Automation of data loading, metadata extraction and building using MaxL and Batch scripting.
• Performed upgrading of Essbase cubes and Hyperion planning applications.
• Performed data and metadata reconciliation of development and production server.
• Prepare Unit test plan document for validation of different objects like the financial reports, calculation scripts, and Rule files in previous and later versions to identify different errors.
• Documentation of the existing business and operational process.
• Provided hands-on to the end users and prepared end-user manuals.

Confidential, CA

Environment: s: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1, Hyperion System 9, Financial Reporting 9.3.1, HAL 7.0.

Hyperion Developer

Responsibilities:

• Study of the AS-IS Hyperion Applications.
• Requirement analysis of the issues and prepare scope of work.
• Identify the impact on the different reports (Financial Reports) and behaviour of Essbase cubes/Planning applications due to migration.
• Created integration flow diagrams though HAL for loading and extracting metadata and data from Hyperion Essbase and Hyperion Planning applications.
• Creating new calculation scripts/business rules which takes care of the new fiscal year time period.
• Optimize Business Rules for Consolidation and Allocations within Planning in the existing applications.
• Performing data loading and outline changes through HAL and using rules files.
• Modifications on the web-forms (Changes due to outline restructure, POV member change, addition of HBRs).
• Created and modified menus and task lists.
• Add user or change user roles in Planning.
• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.
• Automation of data loading, metadata extraction and building using MaxL and Batch scripting.
• Performed upgrading of Essbase cubes and Hyperion planning applications.
• Performed data and metadata reconciliation of development and production server.
• Prepare Unit test plan document for validation of different objects like the financial reports, calculation scripts, and Rule files in previous and later versions to identify different errors.
• Documentation of the existing business and operational process.
• Provided hands-on to the end users and prepared end-user manuals.

Confidential

Environment: s: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1, Financial Reporting 9.3.1, Smart View 9.3.1

Hyperion Developer

Responsibilities:

• Understand the existing subscriber revenue model for budgeting by working in close co-ordination with Functional Consultant so as to address their pain areas.
• Design Hierarchy of Accounts (Net Sales, Net Churn, ARPU, etc.,), Entities and Custom Dimensions involved therein.
• Design requisite interfaces in ODI.
• Created ODI mappings for transformation of data from Source Systems to Essbase.
• Developing Web forms and MS-Excel interface (Using Smart View) as input-output interface.
• Developing complex business rules/calculation scripts for consolidation (Bottom-Up Planning) and allocations (Top-Down Planning).
• Developing Work-Flow management, task list, menus and smart lists.
• Formation of Financial Reports to cater MIS reporting (Quarterly/Monthly) for revenue and expense budgeting.

Confidential

Environment: s: Hyperion Planning 9.3, ODI 10.1.3, Hyperion Essbase 9.3, Financial Reporting 9.3, Smart View 9.3

Hyperion Developer

Responsibilities:

• Understand the existing budgeting and forecasting (expected) process by working in close co-ordination with Functional Consultant so as to address their pain areas.
• Design Hierarchy of Accounts (Gross and Net Sales, Cost of Sales, Taxes, Depreciation, Margin), Entities and Custom Dimensions involved therein.
• Created ODI mappings for transformation of data from Source Systems to Essbase.
• Developing Web forms and MS-Excel interface (Using Smart View) as input-output interface.
• Developing complex business rules/calculation scripts for consolidation (Bottom-Up Planning), allocations (Top-Down Planning), Inter SBU Sales and Margin Eliminations, Valuation, Service Allocation, etc.,
• Prepare solution documents.
• Provide solution to the new requirements (Multicurrency, 4-4-5 distribution).
• Automation and scheduling using MaxL and Batch scripts.
• Developing Work-Flow management, task list, menus and smart lists.
• Formation of Financial Reports to cater MIS reporting (Quarterly/Monthly) for revenue and expense budgeting.