PROFESSIONAL SUMMARY:

• Resourceful, results - driven Finance/IT professional with around 4 years of professional experiences including technical experience in Design, Analysis, Development and Implementation of Oracle Enterprise Performance Management (EPM).
• Extensive experience in Hyperion Financial Management (HFM), Hyperion Financial Data Quality Management(FDM), Smart View, Hyperion Financial Reports, Web Analysis
• Responsible for the administration of Hyperion Financial Management (HFM), Enterprise Performance Management Architect (EPMA)
• Expertise in providing security for Financial Management, Workspace and ability to create user and group profiles for assigning proper privileges using both User provisioning, Native security and Shared services modes.
• Solid understanding of multidimensional architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Administered the Hyperion Financial Management Application while leveraging important design considerations such as member properties, user management and security, formulas, hardware requirements, data sources etc.
• Skilled in performance monitoring, tuning, and optimization; Played an active role in reconciling data/metadata across products and environments.
• Excellent technical, oral, communicational and analytical skills. Admirable interpersonal abilities and an efficient team player.
• Assisted end-users with developing complex reports to meet requirements. Also developed ad-hoc analysis reports as needed.
• Worked closely with Finance teams such as Controllership, Financial Planning and Analysis.
• Expert in forming and maintaining positive and productive working relationships in teams
• Knowledge of Hyperion Enterprise.

TECHNICAL SKILLS

OLAP Tools: Hyperion Financial Management 11.X/9.X/7.X (Classic as well as EPMA), Hyperion Financial data Quality Management, Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, DRM, ODI, EPMA,, Hyperion Enterprise.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Spreadsheet Add-in, Hyperion Smart View.

Programming Languages: VBA, MAXL

Operating Systems: Windows 2007/XP

Databases: Oracle 11i, MS-Access, Microsoft SQL Server 2008 R2

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Hyperion Consultant

Roles & Responsibilities

• Created new and maintained existing reports using Financial Reports, Smart View Templates/Reports (using HSGetValue) and Ad hoc Queries as required by the business users.
• Gathered requirements for Smart View and Financial Reports.
• Maintained currently developed Hyperion Financial Management Applications including development of new functionality and processes (metadata, business rule, Financial Reports and Smart View Report development) within the applications in 11.1.1.2
• Performed admin activities related to Hyperion Financial Management 11.1.2.2 and managed Shared services responsibilities.
• Developed/Enhanced business rules, web forms, data grids, and Hyperion financial reports.
• Seamless Integration of FDM with Hyperion Financial Management applications by automating the load processes using batches and monitoring data loads and error rectification
• Under general direction, formulated and defines system scope and objectives.
• Prepared detailed technical specifications from which programs will be written.
• Provided technical solutions on complex projects.
• Worked closely with business end-users to identify new functionality and requirements.
• Developed processes and control framework for financial systems and reporting tools.

Environment:Hyperion Financial Management 11.1.2.2,, Hyperion Financial Data Quality Management 11.1.2.2, Hyperion Financial Reporting Studio 11.1.2.2, Smart View, Ad hoc Analysis, Web analysis, Microsoft Excel 2010, and Windows 2008

Confidential, Columbus, IN

Hyperion Consultant

Roles & Responsibilities

• Actively involved in full project development life cycle of Hyperion Financial Management, Financial Data Quality Management and Reporting Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, and implementation.
• Worked with Finance team in creating metadata for HFM Application
• Developed, maintained, debugged and optimized HFM Rules
• Responsible for creating System Test plan as well UAT Scripts.
• Extensively used Financial Reporting Studio / Smart View to design reports which saved significant amount of time and helped in extracting and manipulating corporate data.
• Automated FDM load process using visual basic script programming to run monthly balance sheets and ledgers.
• Sophisticated process that built two cubes one daily snapshot and one comparison that restructured the data with current day hierarchies
• Implemented robust data-access security and user management
• Worked with End users in supporting the application during close process
• Provide end to end support for the application

Environment: Hyperion Financial Management V 11.1.1.3, EPMA, Financial Data Quality Management, Shared Services, Financial Reporting, Web Analysis, Smart View, SQL Server, MS Excel 2003 and 2007.

Confidential, NY

Hyperion Developer

Roles & Responsibilities

• Involved in the up gradation of Hyperion Financial Management from version 9.3.X to 11.1.X
• Played an active role in all phases of the development lifecycle including requirements gathering and analysis, application design and development, implementation, and maintenance.
• Design and Build the security for users using shared services.
• Involved in Backup and Recovery procedures of different Hyperion Applications
• Involved in production support activities like responding to the users, debugging the calculation scripts to meet users expected results, fixing the validation issues etc.
• ODI data loads Interface usage for Bulk Metadata changes, changing dimensions in Planning.
• Worked with various technical team and functional team in order to implement Hyperion Financial Management.
• Experience in Creating Users and Groups with different roles and access control.
• Developed Metadata in Hyperion Financial Management using .ads file.
• Developed data forms, Data Grids for the users to enable them to enter financial data into the system.
• Created business rules that replicate the functionality of complex formulas existing in excel.
• Used Shared Services for defining and allocating provisions to the users of the company as per the needs of higher management.

Environment: Hyperion Financial Management 9.x, Financial Data Quality Management, BI Plus 9x, Oracle 9i and 10G, PLSQL, Reconciliation Framework, Smart View and Financial Reports 9.x