• Working as a PBCS consultant for a US-based government project.
• Interacted with business users to create Financial and workforce planning applications
• Integration with Oracle Fusion using Data Management for data ingestion
• Introduced the write-back functionality for Budgetary controls.
• Designed the workflows for approval hierarchy and provided the what-if capabilities.

• Fit Gap Analysis for HFM to FCCS Cloud upgrade and devising the strategy for the same.
• Led the two major Hyperion On-Prem upgrades from 11.1.2.4 to 11.2 for a healthcare and financial services client.
• Designed/Re-engineered the data integration using FDMEE with multiple source systems like Oracle EBS and other SQL sources
• Strong understanding of metadata updating and automated the metadata load feed to HFM using DRM.
• Created the task flows for automation of data copy and consolidation.
• Designed the feed for downstream systems like Essbase, OFSAA, and other systems.
• Well-versed in ownership management, user provisioning, and process control.
• Implementing the OrgByApplication functionality in an existing application to leverage the restatement of financial statements.
• Optimized/modified the consolidation rules for restatement consolidation along with consolidation methods.
• Led a team of 10 resources in the EPM space.

• Integrated the source systems data with the HFM application using FDMEE
• Designed Import format and data mapping and optimized the mapping using Jython scripts to handle the mapping during the execution.
• Build the validation, unmapped, and other reports in FDMEE.
• Involved in the integration of data source with HFM application using FDMEE and outbound integration of HFM with Essbase using FDMEE.
• Resolved complex issues related to HFM Rules, Journal posting, and other user queries.
• Designed Essbase cube for Management Reporting having functionalities like currency conversion and calculated the measures like AUM, Sales and Asset Information, and other financial measures.
• Integrated the metadata using DRM to govern the integrity of Master data.
• Wrote the Dynamic Time Series and other rolling forecast calculations to view the data.
• Designed the alternate hierarchy for reporting purposes and security design for the users using shared services.
• Post-go-live support till the services stabilize.

• Involved in the requirement gathering meetings for HeadCount Application (Customized Workforce Planning), IT Planning application (Capex and Opex), and Spend and Regulatory Reporting application.
• Strong experience in integrating multiple source systems with planning and Essbase cubes.
• Designed the applications from scratch to reduce manual efforts for users.
• Build the outline using Rule File and outline load utility.
• Designed web forms, task lists, and Business rules (including reusable templates), planning unit workflows in Hyperion planning.
• Designed complex business rules for calculating the measures like AUM, Capital Ratio, Liquidity ratio, and other risk measures per the client's need.
• Written the valid intersections in planning web forms to accommodate the user requirement.
• Created the partitions for the different databases to ensure data availability.
• Integrated the Essbase cube with OBIEE for reporting purposes and designed the dashboards in OBIEE.
• Performance optimization on the calc script to reduce the execution time.
• Migrated the 20+ cubes and two planning applications from 11.1.2.1 to 11.1.2.4.
• Automation of the applications using maxl and batch script.

Project1

• Involved in the entire SDLC lifecycle starting from Requirement gathering design and build phases.
• Designed a sales planning and forecasting application for a Life Science organization.
• Calculated the employee, material, and other overhead costs using business rules.
• Designed the outline, data load rules, and web forms from scratch.
• Created the provisioning for the users using shared services

Project2

• Involved in the required design document and designed the technical specification document for capturing the requirements.
• Extracted and transformed the data from oracle by writing the complex stored procedure.
• Building the outline and loading the dimension data using Essbase Studio.
• Wrote MDX scripts for Dynamic Time series and other measures calculation.

• As part of an upgrade, migrated some 20+ odd Essbase and planning applications from version 9 on the Windows platform to 11 on the UNIX platform.
• Rewrite the calculation scripts for existing cubes to enhance functionality and optimize performance
• Designed the backup and restore strategy for EPM applications and wrote the shell scripts.
• Automated the data load and other activities using maxl scripts.
• Integrated the metadata using Data Relationship Management for outline building and designed the custom properties to accommodate the user requirements.

Client: GSK Inc., USA
Project: GSK-SUP-DISCOVER
Duration: Oct’11 - May’12
Tools: Hyperion Planning, Essbase, Essbase Studio, Unix 11.1.1.3
Responsibilities:

• Responsible for General Database Administration, Query Performance tuning
• Analyzing the Outline and Hierarchy of Metadata, modifying members in the outline, and changing the hierarchy as per requirement.
• Automation of dimension building, data-loading, and calculations using MAXL scripts.
• Providing internal and external authentication by designing filters per user and group level access using HSS.
• Debugging the issues fetching through Excel-Add In and giving the desired solution.
• Maintaining Dimension hierarchy members (add, remove, edit members) changes based on changes in business requirements.
• Taking Backups daily and validating, checking log files regularly.
• Monthly loading forecast values and actual values and Aggregation of the cube.
• Performing the data load daily, monthly, quarterly, and yearly. Also, as per the business need.

Client: Cardinal Heath, USA
Project: CAH-IT6-DWH
Duration: Sep’09 - Sep’11
Tools: Hyperion Planning, Essbase, Essbase Studio, Unix 11.1.1.3
Responsibilities:

• Analyzing the Outline and Hierarchy of Metadata, modifying members in the outline, and changing the hierarchy as per requirement.
• Writing and modifying Calc Scripts depending on the requirement.
• Automation of dimension building, data-loading, and calculations using MAXL scripts.
• Debugging the issues fetching through Excel-Add In and giving the desired solution.
• Writing test cases for every change request in the unit and functional testing.
• Creating forms for users for any new requirements and mapping database connections.
• Involved in HAL routine changes based on business requirements for the metadata and data load.
• Maintaining Dimension hierarchy members (add, remove, edit members) changes based on changes in business requirements.
• Taking Backups daily and validating, checking log files regularly.
• Monthly loading forecast values and actual values and Aggregation of the cube.
• Led a team of 3 resources from offshore.

Client: Shell
Project: Shell Downstream Central Interface
Duration: Jun’08 - Aug’09
Tools: SQL Server Integration Services 2005 (SSIS), ODBC, OLTP, OLAP, SQL Server
Responsibilities:

• Eliciting the business requirements with solution designers, business analysts, on-site team, and other stakeholders.
• Involved in Analysis, Design, coding, debugging, and testing of the system.
• Experience in Microsoft SQL Server Database Administration, including planning, backup, and recovery strategies.
• Created a package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task, Slowly Changing Dimensions (Table Difference Component), Send mail task, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to the data warehouse.

Client: Sony Corporation, USA
Project: SCA-INF-SUP
Duration: Feb’08 - May’08
Responsibilities:

• Backup, Recovery, and other disaster management activities.
• Activities are monitored such as Disk utilization and CPU utilization and taking the necessary actions.
• Participated in Code review, Unit, and Regression testing.
• Shrinking the database in case of oversize the database.