SUMMARY

• Having 9+Years’ Experience in Hyperion Suite of Products, software development life cycle process which includes Analysis, Development, Testing and Implementation.
• Hyperion Consultant, Developing, and Supporting projects using Hyperion Financial Management with FDM, HFR and Smart View.
• Good experience in Hyperion Finance management, Hyperion Workspace, Hyperion Financial Reporting Studio, Smart View.
• Expertise in Hyperion, Hyperion Planning, EPMA, HFM, FDM, MaxL, Excel add - in, Smart-view, Web Forms, and Hyperion reports, Oracle Data Integrator, Workspace, Shared Services, Interactive reporting studio and Financial reporting studio.
• Configure FDM by setting up Adapters using workbench, define import formats, create locations, mappings, validation rules and groups and load data into HFM.
• Involved in Implementation & Supporting projects of HFM. Involved in creation of Hyperion Financial Consolidation Application to maintain Actual & Budget Data.
• Managed provisions of the users and groups as well related to the project.
• Performed the tasks such as data loading, consolidation, calculation & translation.
• Good working experience with Hyperion Financial Management 9.3.1, Financial reports, financial data quality management.
• Good knowledge About 11.1.2.4
• Develop/Update HFM security groups and roles as required to meet business objectives.
• Good knowledge of Oracle Hyperion tools like FDMEE, DRM, HFM, and HFR Studio.
• Oracle HFM, HFR, upgrade from versions 11.1.2.1 to 11.1.2.3 version.
• Having knowledge about versions 11.1.2.1, 11.1.2.3 and 11.1.2.4
• Good working experience in Financial Data quality Management (FDM), Upstream, Smart View, and Web Analysis.
• Development, Migrate the Applications HFM, HFR.DRM, from: 11.1.2.1 to 11.1.2.3 in Dev UAT Prod.
• Setup metadata with dimension properties and loading PBCS to FDMEE.
• Supporting business users the Hyperion Finical management, (HFM) Hyperion Financial Data Quality management (FDMEE), Oracle Data Relationship Management) DRM around month end close.
• Support end-users on data loading through FDMEE during month end close.
• Strong knowledge about versions 11.1.2.1, 11.1.2.3

TECHNICAL SKILLS

Skill Set: Hyperion financial management 11.1.2.1 to 11.1.2.3 and 11.1.2.4 Hyperion Shared, Services 11.1.2.1 Hyperion Reports 11.1, 2.3(Financial Data quality Management FDMEE), Upstream, Smart View, and Web Analysis.

Domain Knowledge: Financial Services which includes accounts and mortgage.

Tools: Peregrine Service Center, Rational Clear Quest and Clear Case, Web AnalysisFinancial Reporting, Report Scripts, Smart View, Excel spreadsheet add-in

Data Management: Hyperion Application Link

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Hyperion

PROFESSIONAL EXPERIENCE

Confidential, Chicago - IL

Hyperion Consultant

Responsibilities:

• Created import profiles to build dimensions in EPMA.
• Involved in application Migration from Development to Production.
• Compared outlines in between Production and Development using Outline Extractor.
• Prepared excel templates for data reconciliation, validating scripts in dev & prod cubes.
• Used EPMA Batch client to automate data load and dimension building.
• As a functional consultant worked on entire SDLC of entire Hyperion Implementation.
• Data Migration between different Hyperion FDMEE, HFM HFR applications. 11.1.2.3 to 11.1.2.4.
• Installation & Configuration of DEV, PROD UAT & DR environments.
• Make Metadata changes in as per business user requests submitted to Hierarchy process.
• Collaborates with business analysts and others functional leads and Users to access system configuration, security controls, system interfaces, audit logs, and support services on a periodic
• Hands on experience on Hyperion shared services for creating the new groups and providing responsibilities and access controls for various applications to users.
• Update report as need based on metadata (Account and Entity).
• Update Rules if necessary based on cash flow changes or other business need.
• Update/Create new reports as requested by user’s new version PBCS.
• Worked with SOX team in providing resource reconciliation.

Environment: Hyperion Finical management, (HFM) Hyperion Financial Data Quality management (FDM), Oracle Hyperion Financial Reporting, oracle PBCS and Essbase . Windows 2008 R2.

Confidential

Hyperion/ Essbase / planning Consultant

Responsibilities:

• Created import profiles to build dimensions in EPMA.
• Involved in application Migration from Development to Production.
• Compared outlines in between Production and Development using Outline Extractor.
• Prepared excel templates for data reconciliation, validating scripts in dev & prod cubes.
• Used EPMA Batch client to automate data load and dimension building.

Confidential

Hyperion - Hyperion Admin and Support

Responsibilities:

• Upgrade Hyperion EPM applications from 11.1.2.1 to 11.1.2.3 in DEV, UAT, and PROD.
• Make Metadata changes in as per business user requests submitted to Hierarchy process.
• Hands on experience on Hyperion shared services for creating the new groups and providing responsibilities and access controls for various applications to users.
• Update report as need based on metadata (Account and Entity).
• Update Rules if necessary based on cash flow changes or other business need.
• Update/Create new reports as requested by user’s new version 11.1.2-3.
• Created import profiles to build dimensions in EPMA.
• Involved in application Migration from Development to Production.
• Compared outlines in between Production and Development using Outline Extractor.
• Prepared excel templates for data reconciliation, validating scripts in dev & prod cubes.
• Handling data load failures happening through EIS from Relational database to Essbase databases.
• Worked on data related issues and fix with in SLA periods for smooth Budgeting process.
• Moving Essbase outlines and data from one environment to other environments.
• Coordinating with Server Team for maintaining Essbase servers on Dev/QA/UAT/Production environments.
• Interacting with Oracle Support in order to work relate to product related issues.
• Have done performance tuning in improve data loads and data retrievals for Essbase ASO and BSO applications.
• Troubleshooting planning related issues with in time and supporting month end budgeting process.
• Experienced in writing Calculation scripts in Calculation Manager.
• Migration of planning applications from one environment to other environments.

Environment: Hyperion Finance Management (HFM, PLANING, FDMEE ) 11.1.2.3, 11.1.2.1 Hyperion Workspace, Smart View, Hyperion Financial Reporting Studio, Web analysis, Oracle 11i, MS Excel spreadsheet Add-in, Windows 2008 R2. maintained Rule files, Calc Scripts & MaxL Scripts such as Hyperion Essbase, Hyperion Planning, and Financial Reports.

Confidential

HFM/ planning/ Consultant

Responsibilities:

• Created Application profiles, User Defined Member lists.
• Creating Journals templates and adjusting the data with journals.
• Working Knowledge on Load Data, Extract Data, Inter Company Transactions, Journals Process Management and Reports.
• Copy, Clear the financial data by Using Database management system.
• Created DRM application in DRM console.
• Developed Hierarchies in DRM application.
• Prepared the Technical Documents by evaluating the mappings in DRM.
• As scope for the DRM is to feed the metadata objects migration from one environment to another using Migration Utility.
• Migrated DRM objects from one environment to other environment.(Dev,QA,UAT,PROD)
• Created documentation for application and system support.
• Handled/Resolved issues related day to day support activities in terms of Metadata management.
• Coordinating with Oracle Support in order to fix the issues product related.

Environment: Hyperion financial management 11.1.2.1Hyperion Shared Services 11.1.2.1 Hyperion Reports 11.1.2.1Financial Data quality Management (FDM), Upstream, Smart View, and Web Analysis

Confidential

Developer

Responsibilities:

• Managing Metadata and defining attributes.
• Creation of application profile.
• Created HFM application on both desk top and web-based client.
• Manage the financial review cycle using Process Management.
• Involved in creating member lists in the HFM applications.

Confidential

Hyperion Admin

Responsibilities:

• Created Web forms for User Input.
• Involved use of the Essbase API and VBA to perform functionality.
• Created various reports using Financial Reporting and Web Analysis.
• Created Users and Provisioning of security using Shared Services.
• Migrated Applications from Development to Production Environment.

Confidential

Team Member

Responsibilities:

• Coordinating with Client and Business Analyst to understand and develop an Optimized Cube.
• Developed a Multi-dimensional database (MDDB) application using Essbase that stored and maintained company's Payroll and Employee data and performed the loading and manipulation of data into the database using Load Rules files.

Environment: Hyperion Workspace, Hyperion Shared Services 9./3/1 Hyperion Business Rules, Linux, Unix(Solaris), SQL Server 2003 and Windows 2003, Hyperion Essbase 7.1.2, Excel Add-In, Maxl, Hyperion Reports 7.0, Hyperion