INTRODUCTION:

Around 10 years of experience in the field of Information Technology, this includes pioneering work in business Analysis, requirements, development, testing, implementing and support of Hyperion system applications and Client/Server projects using industry accepted methodologies and procedures.

EXPERIENCE SUMMARY:

• Extensive experience in the development, design, analysis and Implementation of various applications using PBCS, Hyperion Essbase 11.x/9.X/7.X/6.X, Hyperion Planning 11.x/9.x, PBCS, EPBCS, Hyperion Financial Management 11.x/9.x, DRM, FDMEE, FDQM,OBIEE, ODI and Informatica.
• Installed and Configured various version of Oracle EPM, DRM, OBIEE and Informatica in distributed environment.
• Worked extensively on Essbase Block storage (BSO cubes) cubes and ASO cubes. Familiar with many performance improvements techniques like Partitioning, cache optimization, indexing, paging, outline optimization, Member formula and calculation script optimization. Broadcasting to publish, print and e - mail the pre-built Excel based financial reports
• Experienced in Administration of EPM products such as Hyperion Planning, Essbase, Profitability and Cost Management and Hyperion Financial Management.
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules) and Reports.
• Excellent functional and technical expertise in maintenance and support activities with making sure of all the quality and SOX processes being followed correctly.
• Functional knowledge of Budgeting, forecasting, month end financial and operating reports.
• Extensive experience in migrating Hyperion Planning, Financial Management, Essbase, Financial reports, Interactive Reports and FDM applications.
• Worked with various teams such as server operations, support and data warehousing team in completing the migrations and patches.
• Experienced in Financial management applications, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, reports and automation of HFM tasks using task flows from workspace.
• As a technical/functional consultant worked on complete life cycle of the Hyperion DRM Implementation
• Experience in migrating OBIEE RPD, catalogs and Informatica workflows across the environments
• Worked extensively on Hyperion Shared services Roles/Groups Authorizations including custom groups to make user authorization and control easy to maintain and extensible. Also implemented Row Level security for business units to protect crucial financial information based on individual profit centers.
• Experienced in Oracle, SQL Server, and MS Access.
• Strong communication, organizational and interpersonal competencies, adapt to change and quick in learning new versions and applications.

TECHNICAL SKILLS:

EPM: Hyperion System 11.x/9.x/7.x

OLAP: Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Essbase Integration Services, Hyperion Hub, Hyperion Workforce Planning, Hyperion Capital Asset Planning (CAPEX).

Reporting Tools: OBIEE, Hyperion Financial Reporting, Hyperion Interactive Reporting (Brio), Essbase Spreadsheet Add-In, Smart View, Clarity 6.0/7.0/FSR.

Data Management: FDMEE, DRM, FDQM, ODI and Informatica

Languages: XML, Visual Basic 6.0, PL/SQL, SQL, Perl, Shell Scripting

Software: MS Office, MS Visual Basic, MS Project, FileMaker Pro, BIG-IP

Database: MS Access 7.0/2000/97, Oracle 8i/9i/10g, MS SQL Server

Operating Systems: Windows 98/2000/NT, UNIX, Solaris 8.x

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Hyperion Consultant

Responsibilities:

• Upgraded EPM and ODI systems to the latest version.
• Trained Business admins and end users on Simplified Interface new options available in latest version (11.1.2.4) and PBCS.
• Migrated the 11.1.2.4 application to Oracle PBCS.
• Created Nightly backup and aggregation script using EPM Automate.
• Automated Planning Employee and other dimension build from ODI.
• Created New Planning Application in PBCS for PandL.
• Created Business Rules, Data Forms and FR Report for PBCS app.
• Outline Optimization - Modified Hour Glass Model (AKA Dress form or Hourglass on a Stick).
• Performed tuning on Calc Scripts and Business rules.
• Optimized Block Size, Block density, cache settings, indexing, paging and compression settings.
• Decreased database size and improved performance.
• Actively involved in Federal System Security Plan Assessment (SSP).
• Performed a proof of concept (POC) on Amazon Web Services (AWS) for EPM Setup.
• Coordinated with Oracle to come across few bugs we faced after upgrade.
• Administration of Hyperion Planning and Essbase Applications.

Environment: Oracle PBCS,Windows 2008, Hyperion EPM 11.1.2.1, EPM 11.1.2.4 (Planning, Essbase, Financial reports), ODI.

Confidential, Topeka, KS

Hyperion Consultant

Responsibilities:

• Migrated on Premises Planning application to Oracle PBCS.
• Enhancements on PBCS application.
• Administration of PBCS apps.
• Utilized EPM Automate for daily aggregation and backup jobs on PBCS.
• Developed ASO Essbase Cubes as per Business Requirement.
• Delivered complex Financial Report for external reporting purpose.
• Resolved existing failure reports.
• Trained Users on Smart View, Workspace and FR reporting.
• Configured FDMEE for Actual Data loads for ASO and Planning application.
• For every month end metadata refresh, Replicating Prod apps to UAT or Test based on Users request.
• Enhancing and improving Business rule performance.
• Loading exchange rates to various applications on a monthly basis, quarterly basis as per cycle.
• Administration of Hyperion Planning and Essbase Applications.
• Involved in the performance tuning of the Essbase server.
• Automated the monthly loading process using MaxL, Shell Scripts.
• Developed load rules, calc scripts, webforms, Business Rules.
• Designed and implemented Security model for planning applications.

Environment: Oracle PBCS,Windows 2008, Hyperion EPM 11.1.2.4, (Planning, Essbase, Financial reports) and FDMEE.

Confidential, Saddle Brook, NJ

Hyperion Consultant

Responsibilities:

• Administration of Hyperion Planning and Essbase Applications.
• Developed Essbase Cubes as per Business Requirement.
• Involved in the performance tuning of the Essbase server.
• Automated the monthly loading process using MaxL, Shell Scripts.
• Developed load rules, calc scripts, webforms, Business Rules.
• Designed and implemented Security model for planning applications.
• For every month end metadata refresh, Replicating Prod apps to UAT or Test based on Users request.
• Enhancing and improving Business rule performance.
• Loading exchange rates to various applications on a monthly basis, quarterly basis as per cycle.

Environment: Windows 2008, Hyperion EPM 11.1.2.3, (Planning, Essbase, Financial reports), HFM, Informatica.

Confidential, Boston

Senior Hyperion DRM Developer/Architect

Responsibilities:

• Implemented Oracle Hyperion PBCS Automation jobs at Santander.
• Dimension build and data load in PBCS.
• Responsible for creating Workflow models and tasks built to govern the HFM Chart of Accounts, including some governance Chart of Account properties
• Created Request, Enrich and Approve levels for workflow
• Created HFM metadata application file produced by exports combined as a book
• Responsible for Edit checks, validations and reconciliation assistance around HFM Chart of Accounts.
• Integration exports, tables, and other files necessary for consumption by other systems.
• Maintenance and workflow models for alternate SHUSA hierarchies.
• Managed Version metadata according to the financial close period and provide a robust audit trail for all updates to versions, hierarchies, and properties.
• Improve and enforce internal control objectives and SOX compliance.
• DRM Extract Automation from Hyperion Workspace.
• Experience in creating Versions, nodes and Hierarchies in DRM.
• Created Business Rules using Validation and Verification in DRM.
• Used Migration module to Export/Import data in DRM.
• Involved in FDMEE mapping automation using the DRM hierarchy.

Environment: Oracle PBCS,Windows 2008, Hyperion EPM 11.1.2.2, (Planning, Essbase, Financial reports), HFM, DRM, FDMEE and ODI.

Confidential, Hoboken, NJ

Hyperion Consultant

Responsibilities:

• As a part of production support, look after Hyperion applications; make sure the system is up and running, available for all users.
• Administration of Hyperion Planning and Essbase Applications
• Created calc manager rule to calculate Tax rate and merit rate for each employee.
• Installed and Configured DRM.
• Experience in creating Versions, nodes and Hierarchies in DRM.
• Created Business Rules using Validation and Verification in MDM/DRM.
• Used Migration module to Export/Import data in DRM.
• For every month end metadata refresh, Replicating Prod apps to UAT or Test based on Users request.
• Migrating New Catalogs, RPD files for OBIEE and Workflows for Informatica.
• Working on daily tickets from users, application Owners on various Hyperion issues, change requests, enhancements.
• Responsible for Development and maintaining all technical aspects of the HFM Application which includes constructing Metadata, changes, maintenance of application structures
• Maintained Hyperion Financial Management system and assisted in administration consolidation of monthly financial information.
• Creating DRM utilities for monthly metadata refresh for different hierarchies in Production for EBS, HFM, and Essbase and Planning applications.
• Working on development activities i.e., Setting up source Systems, registering Target EPM Applications, enabling FDM Applications, Extracting General Ledger Data, Selecting Source Accounting Entities (Name of ledgers or business units), working with Import formats, Defining Locations, Defining Metadata Rules, Defining Period Mappings, Defining Category Mappings, Viewing Process Details.
• Creating and Running Imports using DRM and adding different Hierarchies for same version.
• Maintaining Data Governance issue log for keeping track of DRM templates and monthly requests
• Maintained Hyperion Financial Management system and assisted in administration consolidation of monthly financial information.
• Enhancing and improving Business rule performance.

Environment: Windows 2008, Hyperion EPM 11.1.2.2, (Planning, Essbase, Financial reports), HFM, OBIEE, Informatica, DRM.

Confidential, Phoenix

Hyperion Consultant

Responsibilities:

• Involved in the configuration of Hyperion Essbase.
• Developed Essbase Cubes as per Business Requirement.
• Involved in the performance tuning of the Essbase server.
• Automated the backup process using MaxL scripts.
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle Database into Hyperion Cube.
• Created PL/SQL queries in Teradata to develop the tables as per business requirement.
• Interacted with the data staging team to get appropriate data into Essbase cubes.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in creating the Security Filters and assigned to the users for restricting the data from being accessed.
• Configured ODI to load data into planning applications from third party source like Lawson, Oracle ERP database.
• Created ODI routines and packages to update metadata for several planning applications.
• Developed interface in ODI to extract data from Essbase and Planning applications using MDX query and Calculation scripts.
• Worked on ODI Settings in topology manager.
• Designed system architecture according client requirements and provided list of tools to be used to fulfill client requirements
• Environment: Windows 2008, Hyperion EPM 11.1.2.1, Planning, HFM, FDQM, DMR, ODI and Teradata.

Environment: Windows 2008, Hyperion EPM 11.1.2.1, Planning, HFM, FDQM, ODI and Teradata.