SUMMARY

• Over 7 years of IT experience with primary focus 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), Hyperion Essbase, Hyperion Planning, Hyperion DRM/DRG, Smart View, Hyperion Financial Reports, Web Analysis
• Actively involved in Hyperion Financial Management (HFM) administration, Enterprise Performance Management Architect (EPMA), Journal entry creation and opening and closing periods
• Extensively worked on report development using Smartview, Hyperion Financial reporting.
• Experience with creating action scripts to make bulk updates to Hierarchies and created variety of exports (flat files and load to RDBMS tables)
• Actively involved in Data validation between legacy system reports and Hyperion reports.
• Expertise in creating Data forms and Data grids
• Expertise in provisioning 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.
• Played an active role in data reconciliation, Metadata management across products and environments.
• Excellent team player with good communication, interpersonal and analytical skills.
• Assisted end - users in developing complex reports to meet requirements. Also helped business users in ad-hoc analysis.
• Documented business processes and trained business users in various tasks associated with HFM and Smartview reports.
• Worked closely with Finance teams such as Controllers, Financial Planners in Business Analysis, Data validation.
• 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 Shared Services, EPMA, Hyperion Enterprise.

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

Operating Systems: Windows 2007/XP

Databases: Oracle, MS-Access.

PROFESSIONAL EXPERIENCE

Confidential, Bethlehem PA

Hyperion Consultant

Responsibilities:

• Maintained Currently developed Hyperion Planning and Essbase applications along with enhancement of the multidimensional cubes.
• 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 the developed Hyperion Financial Management Applications including development of new functionality and processes (metadata, business rules, Financial Reports and Smart View Reports development) within the applications in 11.1.1.2
• Configured and created new Planning application using classic application, and built business rules, Macros, web forms, calc scripts.
• Worked with DRM to create hierarchies, import/export data using DRM migration modules.
• Created monthly versions of Hierarchies in DRM to support month end activities.
• Performed admin activities related to Hyperion Financial Management 11.1.2.2 and managed Shared services responsibilities.
• Actively worked with financial controllers in monthly close cycle.
• Developed/Enhanced business rules, web forms, data grids, and Hyperion financial reports.
• Deep knowledge of Hyperion Essbase calc script and planning business rules development
• Optimized data loads and calculations within ASO and BSO Essbase architecture.
• Seamless Integration of FDM with Hyperion Financial Management applications by automating the load processes using batches and monitoring data loads and error rectification
• Worked closely with business end-users to identify new functionality and requirements.
• Developed processes and control framework for financial systems and reporting tools.

Confidential, Columbus, IN

Hyperion Developer

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 a multi-dimensional database (MDDB) OLAP application using Essbase that stored and maintained company's financial and marketing data.
• 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.
• Involved in performing DBA activities such as performance tuning the calculation scripts, along with taking periodical ESSBASE backups.
• 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

Confidential, White Plains, NY

Hyperion Developer

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.
• 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.
• Loaded 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.

Confidential

Report Developer (Internship)

Responsibilities:

• Involved in documenting requirements, functional specifications, preparation of design documentations and testing cases
• Performed data validation and metadata building for various applications.
• Involved in Data validation and development of Reports.
• Worked on financial reporting. Build various reports using Prompts, User POV, Grid POV, Conditional Suppression, and Conditional Formatting and used formula in it according to the recipe provided by users.