SUMMARY

• Having 9+ years of extensive experience in the development, design, analysis and implementation of various applications using Hyperion System 11.x/9.x This includes Hyperion Shared Services, Hyperion Financial Reports, Hyperion Financial Management and Financial Data Quality Management, Smart View and Excel Add - In.
• Knowledge on Hyperion Financial Management Installations, Hyperion Essbase and Planning also in ODI. Design & development of OLAP and decision support systems with focus on Oracle Hyperion Suite of Technology.
• Extensive experience in Developing Data Forms for Exchange rates.
• Proficiency and experience in a range of Hyperion products including EPMA applications and FDMEE.
• Created extensive Data Grids and Data Entry Forms to view or enter the data using HFM web client.
• Trained user community to manage the review process using process control and journal creation.
• Used to automate the tasks such as data loading, calculation & translation.
• Strong development experience in Hyperion System 9 /System11 suite including
• Hands on experience in the development of metadata and Dimensions like Entity, Year, Value, Scenario, Account, ICP, Period, View, consolidations, allocations, forms .
• Knowledge and experience in understanding the Business rules and writing the rules as per business request.
• Hands on experience in providing securities, provisions and assigning the control access.
• Experience in attending the status calls and interacting with Client.
• Excellent Interpersonal, analytical and communication skills.
• Created substitution variables as per business requirement and used in Calculation Scripts.
• Created Excel Templates for ad-hoc reporting using Lock and Send.
• Created required web Data forms to facilitate the entry and review of data and provided access to users based on security level of access.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies
• Strong problem-solving, communication, interpersonal, training, and presentation skills.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP/2008, Windows Server 2003.2008 R2R.

Languages: C,C++,Java, VB Script

BI Tools: Hyperion Financial Management, Financial Data Quality management, Hyperion Business rules, Hyperion Financial Reports, EPMA, Hyperion Essbase, Hyperion Planning and ODI

MSOffice Tools: MS Word, Excel, PowerPoint

Databases: Essbase, Oracle 10g, MS SQL Server 2008, 2005, 2000

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineer

Environment: Hyperion Financial Management 11.1.2.3, FDQM, EPMA, FDMEE, ODI, Smartview, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server

Responsibilities:

• Create and deploy applications and designing metadata.
• Loaded metadata for Accounts, entities, Scenario and custom dimension.
• Extracted, loaded the metadata whenever metadata changes occur.
• Doing Consolidations and Analysis through HFM Client and Web.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Build the Taskflows for two HFM applications
• Build the Data synchronization mappings between two HFM applications
• Managing POV in the explore data setting.
• Creating Member lists and Rules using VB scripting.
• Creating Journals.
• Posting and Unsporting of Journal for adjustments of Entities.
• Mapping between FDM and HFM.
• Creating locations in FDMEE and Batch rule file setup
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly data.
• Worked Extensively on Shared Services and Energy LDAP, HFM/FDM applications 11.1.2.3. Performed weekly, monthly, and quarterly data loads and verifications.
• Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.
• Responsible for security provisioning using shared services across the entire Hyperion environment.

Confidential

HFM Technical Consultant

Environment: Hyperion Financial Management 11.1.2.3, FDQM, EPMA, FDMEE, ODI, Smartview, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server

Responsibilities:

• Create and deploy applications and designing metadata.
• Loaded metadata for Accounts, entities, Scenario and custom dimension.
• Extracted, loaded the metadata whenever metadata changes occur.
• Doing Consolidations and Analysis through HFM Client and Web.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Creating Member lists and Rules using VB scripting.
• Creating Journals.
• Posting and Unsporting of Journal for adjustments of Entities.
• Mapping between FDM and HFM.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Performed daily backups of Hyperion data. Helped facilitate creation and loading of Monthly, quarterly data.
• Worked Extensively on Shared Services and Energy LDAP, HFM/FDM applications 11.1.2.3. Performed weekly, monthly, and quarterly data loads and verifications.
• Created reports Using Hyperion Financial Reporting, SmartView and Excel Add-ins.
• Responsible for security provisioning using shared services across the entire Hyperion environment.

Confidential

HFM Techno Functional

Environment: Hyperion Financial Management 11.1.2.2, FDQM, Smart view, Financial Reporting, Microsoft Excel 2010,MS SQL Server 2005, Windows 2003 and 2008 R2R Server.

Responsibilities:

• Worked as an administrator to give access and privileges to various end users in different HFM applications
• Installation, Troubleshooting and Configuration of Hyperion HFM in distributed Environment
• Participation to build HFM Profile, Application and Metadata based on General Ledger Mappings and doing corrections to Metadata
• Created users and groups and provision with specific roles and assigned Security Classes in user management console
• Loading Inter-Company Transaction and Journals into Target Application
• Manage the financial review cycle using Process Management
• Involved in creation of Web Entry Forms, Web Data Grids and Smart View Forms
• Modified the Rules based on exiting HFM Quarterly application
• Running Consolidations after Data Load
• Loading Data through Financial Data Quality Management

Confidential

Hyperion consultant

Environment: Financial Reports, Hyperion FDQM 9.3.1, Hyperion

Responsibilities:

• Involved in extracting reports using Hyperion Analyzer.Created and HFM applications profile.
• Designing and implementing data load process.
• Designing and implementing FDM data load process.
• Creating Data grids and Data Forms.
• Responsible for Financial Reports - developing new reports.
• Creating Rules and testing and loading into application.
• Setting the POV in FDQM
• Locking the entities if process not requires modifications.
• Resolving the client issues.

Confidential

Hyperion consultant

Environment: Hyperion Essbase, Hyperion Planning, Hyperion Smartview Hyperion Shared Services (HSS).

Responsibilities:

• Created high level budgeting application and building the Hyperion Planning, Essbase application to aid the company in their budget planning and financial reporting requirements.
• Design and implement Planning application to fulfill the needs of the Sales executives to forward forecasting revenue system. (Strategic Forecasting system).
• Creating Rule File’s to load data and Build dimension by Parent Child Reference, Generation reference and Level Reference.
• Developed Applications, Databases, and Outlines and optimizing the Outlines.
• Developed rules files (dimension build rules and business data load rule files).
• Developed and implemented Dimensions and member Attributes.
• Creating the users and groups and also giving appropriate provisions to them using Hyperion Shared Services.
• Involved in Essbase cube analysis, design and maintenance, database backups, performance tuning and optimization on System 11.1.1.3
• Part of multi-dimensional modeling, calc scripts, MaxL Scripts. Strong at making automation script and scheduling using MaxL Commands.
• Created substitution variables as per business requirement and used in Calculation Scripts.
• Created Excel Templates for ad-hoc reporting using Lock and Send.
• Created required web Data forms to facilitate the entry and review of data and provided access to users based on security level of access.

Confidential

Hyperion Consultant

Environment: Hyperion Financial Management 9.3.1.Microsoft Excel 2003, MS

Responsibilities:

• Created and HFM applications profile.
• Involved in creating the HFM application.
• Designing and implementing data load process.
• Responsibility to verify Validation Rules and HFM Rules.
• Created Database outlines and optimized the outlines by arranging the dimensions.
• Creation of grids by using Explore Data Module and consolidate the grids to refresh the values upon loading.
• Creation of Web Data Entry Forms by using Web Application.
• Creation of Journals and doing Process Management in HFM.
• Running Consolidations after data load.
• Involved in creating security to the end users.
• Replicating the client issues and resolving the same Management.