SUMMARY:

• EPM Hyperion Technology consultant with 12+ years of experience in consulting, especially designing and architecting solution in EPM Hyperion suite of products.
• Extensive experience in design and development of EPM Hyperion projects and successfully delivering them across financial services, global digital industrial company, international cruise line.
• My responsibilities covered overall technical delivery, including EPM Hyperion solution architecture, business case development, creating EPM center of excellence, and implementation.
• As an EPM Hyperion techno functional consultant, I focus on understanding the client’s business issues, identifying inefficiencies in the process, technology architecture and advising them in developing future state processes and solution to deliver the business outcome.
• Organized and participated in requirement gathering meetings with the Business Users to study the As - Is process of Headcount and Compensation Planning
• Documented the requirements in design artifacts and created Business Requirement document to get the sign off from the Business Management and stakeholders
• Engaged in Agile methodology to define 30-day sprints to formulate the product catalog, involved in defining requirements, participated in outlining requirements and development of a project plan with business personnel
• Designed and Developed the EPM Hyperion Workforce Planning to automate the Workforce and Headcount Compensation Planning
• Implemented Workflow Process Management
• Planning Unit for the business units in United States and Europe for approval of Headcount budget compensation and bonuses
• Automated the workflow with the help of email alerts to the business users
• Validation Rules for the Budget compensation in the Process Management Planning unit for the approval
• Written complex Business Rules for
• Budget Headcount and Compensation Planning
• Bonus Management and Non-Management Bonus Calculations
• Profit Sharing calculations based on Percent of Earnings of the employees
• Adding New requisitions and calculating their compensation from the effective start date
• Loading Data for Actuals from Oracle HCM view containing demographic data and Lawson views containing payroll data
• Calculating the Headcount and Compensation for Forecasts and writing them to another the consolidated Budget Application through XWRITE functions and transparent partitions
• Implemented FDMEE and ODI to integrate the target Workforce Application to the Oracle HCM and Lawson View
• Created Interface, Packages and Scenarios to integrate the Oracle Lawson view, HCM view, and file-based data to the ODI Staging tables
• Pushed the data from ODI staging tables to FDMEE AIF Open Interface tables and finally to Hyperion Workforce Planning Application
• Creation of email alert scripts in Jython with attachment of the data load execution logs in FDMEE for importing, validation and loading of data in HFM
• Created FDMEE Jython script BefImport Event for loading the FX Rates into the Hyperion Multi currency FX Rate Application
• Configuration of the FxRate Data load from FDMEE to HFM Production Application using automated batch scripts scheduled on EPM server
• Implementation of Hyperion Planning and Essbase Capital Expenditure Project:
• Assessed the As-Is Budgeting and Capital Planning Process
• Written Planning Business Rules to
• To dynamically create Projects and Program templates in Hyperion planning using Business Rule
• Complex calculations for Asset Planning and Expenditure, creation of cash flows using the date of Operating Expenditure Start date and End date and Capex Costs
• To sort the Project’s Start date and End date from the Asset Installation date using Business Rules
• Create the Workflow Process Planning Unit through the Entity Hierarchy in Hyperion Planning
• To submit a request for asset acquisition
• For approval of the Capex Costs related to the Asset Planning
• When a planned request is changes it requires re approval
• During forecasting when a budget request is changed only increased allocated funds require approval
• Any other changes in the costs to be notified through email alerts to Project lead and Senior Manager
• Co-ordinate with the Business users during the monthly close and quarter close process for any change in the metadata or discrepancy in the consolidated data tie ups

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Techno Functional Consultant

Responsibilities:

• Testing and tuning HFM Consolidation performance by running multiple parallel consolidations through Java API in HFM 11.1.2.4
• Modified FDM Import scripts to import EBS data via entities into HFM 11.1.2.2
• Testing and Tuning Data loading performance through Java API in HFM 11.1.2.4
• Implementing changes in the HFM Java API to tune the performance of consolidation and data loading including loading data for multiple ledgers at the same time
• Testing the impact of entity hierarchy change on business rules, Financial Reports, Historical and present data
• Improving HFM Consolidation performance through incremental load testing from FDM
• Working on Hyperion Financial Management Reports Studio for modification or development of new reports
• Constructing dynamic and static member lists in HFM
• Conducted a Proof of Concept (POC) to develop FDM Import Integration Script to fetch GL balances by Entity Segment code from FDM EBS View
• Presented the POC demonstration to the end Business users
• Created a technical design checklist and Test cases artifacts to document the design details and test scripts
• Integrating EBS R12 directly with FDMEE 11.1.2.4 with ODI set up
• Implementing the AIF open interface in FDMEE with Oracle database by creating a ODI procedure to fetch data from EBS view to AIF Interface tables
• Testing the data loading performance in FDMEE for HFM and FDMEE 11.1.2.4 POC implementation
• Created a procedure in ODI to push data from EBS R12 view to AIF Open Interface tables for FDMEE 11.1.2.4 integration with EBS R12
• Worked on POC for ODI Change Data Capture for pushing incremental data changes from EBS to HFM in HFM 11.1.2.4 implementation
• Run the ODI package for metadata push from DRM to HFM
• Created ODI Package to run parallel consolidations and parallel loading through HFM Java API in 11.1.2.4
• Created ODI packages to run single full load and multiple parallel loads from EBS to HFM 11.1.2.4

Confidential, San Rafael, CA

Hyperion Essbase Planning and HFM Consultant

Responsibilities:

• Involved in requirement analysis and documentation leading to an effectiveHyperionsolution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in-order to increase efficiency
• Translated business models and diagrams into operational multidimensional outlines to build Essbase cubes and associated different dimensions with their respective members and carefully assigned their properties, formula scripts
• Worked on PBCS and EPBCS Applications, migrated Workforce and Planning Application from On Prem 11.1.2.4 to Custom PBCS application
• Automated the PBCS Application Backups, download and business rules through EPMAutomate utility
• Created Data Maps and Smart Push to push data from BSO Workforce Application to reporting data cubes in the PBCS application
• Worked on writing MDX queries in the smart forms for business users according to their requirements
• Trained users on Smart Forms, Task lists in the Navigation Flows in the workforce PBCS application
• Configured the security model for implementation of Budgeting and Reporting cube in the PBCS application
• Create ODI Interface and Package to integrate Oracle Datawarehouse with Essbase Planning cube directly. Imported data from different data sources including OLTP database, excel and text files, created rule files and built dimensions and loaded data using Load Rules files
• Written\modified simple to complex Calcscriptandsimple to complex Business rules as per business requirement Written\modified MDX script for ASO applications, written member formulas for ASO applications, created Partitions between ASO application to migrate data.
• Created Hyperion Essbase MaxL Scripts and executed Essbase scripts for Essbase ASO and BSO Cube Data Loads and Cube Administration
• Expertise in Calc scripts, MaxL, Dimension build rules, Cube Partitioning, Data load. rulesandreport scripts, upgrading, testingandmigrating of cubes in different environment.
• Key strength in Automation, OptimizationandPerformance Tuning ofEssbaseapplication, thorough understanding of ASOandBSO cube architecture,EssbaseCache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Participate in Monthly close process
• Creation of Consolidation Applications including validation, deployment of application
• Migration of Consolidation application from one environment to another; Life Cycle Management of HFM artifacts including security, users and roles, reports and analysis objects
• Change of metadata of the Hyperion Financial Management application including full deployment of the application, extraction of data from Oracle EBS system through FDMEE, maintenance of rules such as modification and reconsolidation, data synchronization between HFM and Planning application in the UAT and PROD environment
• Update of metadata changes in the HFM architecture or dimension hierarchy
• Primary point of contact to troubleshoot and resolve HFM and EPMA related questions and issues where possible and work with the Oracle helpdesk to address issues and critical severity tickets

Confidential

Software Engineer

Responsibilities:

• Created Essbase applications based on requirements gathered from the business and built dimension outlines with member and attribute associations, formula scripts.
• Developed data load rules files to parse spreadsheet and flat files for input to the cube
• Maintained Hyperion Planning and Essbase data cubes, dimension building, data loading and optimization techniques
• Translated business models and diagrams into operational multidimensional outlines to build Essbase cubes and associated different dimensions with their respective members and carefully assigned their properties, formula scripts
• Used MaxL in creating batch scripts to automate data load and dimension building through load rules in Essbase Planning cube
• Designed Hyperion Planning Web Forms and Reports to display pre-allocation and post-allocation data
• Produced reports by queries, and filters using Essbase Query Designer to display meaningful, and easy to read reports for management as well using Essbase Excel Spreadsheet add-in to retrieve and drill down on relevant information
• Involved in setting the database properties, and creating filters on Dimensions
• Designed and developed the database calculations like consolidations, member formulas, and complex Allocation calc scripts to tailor specific tasks on dimensions and members
• Setup Hyperion Essbase and Planning Security using Shared Services, implemented and maintained user security on Task Lists, Business Rules and Web Forms
• Creating database calculation scripts and dimension member formulas with attention to dimension ranking and categorization (sparse or dense) as well as dynamic and intelligent calculations as part of 3 Essbase applications and 2 planning applications
• Used Hyperion Planning what-if-scenarios to dynamically consolidate and report on financial budgets, forecasts, and plans
• Archived Essbase applications on a regular basis and recovered them from backups as part of disaster recovery and business continuity processes
• Integrated FDMEE Applications with HFM Applications by creating mappings between FDMEE and HFM Applications for loading data.
• Configured users and access rights in FDMEE
• Applied security levels to users for Application Objects and Locations within FDM.
• Created Import Groups, Import Scripts and Integration Scripts for importing data to the Locations in FDM.
• Created Validation Rules in FDM for ensuring data integrity between source and target systems.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM and HFM
• Created Check Entity Groups in FDMEE for consolidation to parent entity hierarchy
• Created Check Rule validations as part of Check Workflow process such as Balance Sheet Validations
• Create Cross dimensional and multi-dimensional mapping in FDMEE using #SQL scripts

Confidential

Software Engineer

Responsibilities:

• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
• Translated end user requirements into application design specifications, maintained optimal match between cube design and report specifications
• Developed outlines and optimized them by grouping and positioning
• Created and modified rules files for accommodating data format changes and enabling cube loading
• Developed Aggregate storage cubes (ASO) cubes, wrote MDX Queries for aggregate views
• Developed batch scripts and rules files to dynamically upload dimensions and data from Legacy system to Essbase Cubes
• Developed ODI interfaces to execute SQL queries at the source and populate the data into flat files to load in FDMEE staging tables and push the data into Essbase cubes
• Extensively worked on Hyperion Planning reporting infrastructure including Metadata Layer Infrastructure, Data Acquisition and Data Distribution Infrastructure
• Involved in developing web forms applications, assigning security, Workflow procedures and developed several planning applications as per the business needs and best performance
• Design of BSO Cube as per the requirement, setup load rule files to load data from data warehouse into Essbase Cube
• Designed the Excel templates for business users to load the budget data, developed MaxL scripts, Calc Scripts, and MDX formulas Developed SQL statements to extract data from server
• Designed and implemented standard reports using excel pivoting and chart utilities
• Optimized the applications to bring down the runtime and database size considerably
• Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with certain updates on data values
• Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers
• Providing production support, and problem analysis, with 7/24 on call. Successfully resolved on call issues under extremely stressful and time pressured situations
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, and editing/validating scripts