SUMMARY

• 5 Years of Experience in Design, Analysis, Development, Support and Implementation of Oracle Enterprise Performance Management (EPM).
• Extensive experience in Hyperion Financial Management (HFM), Hyperion Essbase Administration Services, Hyperion Financial Data Quality Management(FDM), Smart View, Hyperion Financial Reports, Web Analysis, Web Forms, MAXL.
• Responsible for the administration of Hyperion Financial Management (HFM), Enterprise Performance Management Architect (EPMA), Hyperion Reporting and Smart View.
• Strong experience 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.
• Experience in working on Essbase BSO and ASO applications with partitions, database outlines rules files, calculation scripts, report scripts, Maxell scripts and ESSCMD for Essbase servers’ administration.
• 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.
• Expertise in Developing and enhancing Hyperion reports using with Web Analysisand Financial reporting and scheduling the reports from workspace.
• Very good experience of Smart view and excel add in Strong customer relationship to get accurate reporting information and ongoing initiatives.
• Good experience in training and preparing manuals for onsite and offshore team members and end users.
• Hands on experience in creating data grids and web data forms to load data and Posting, scheduling the journals to adjust data.
• Hands on experience in writing Business rules and member lists.
• Expertise in financial reporting and smart view.
• Extensive expertise in Database Optimization of Hyperion Financial Management.
• 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.
• 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.
• 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, EPMA,, Hyperion Enterprise.

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

Programming Languages: SQL, VBA, MAXL

Operating Systems: Windows 2007/XP

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

PROFESSIONAL EXPERIENCE

Confidential, Bethlehem-PA

Hyperion Consultant

Environment: Hyperion Planning 11.1.2.2, Essbase and Hyperion Financial Management, Hyperion Financial Reports, Windows 2008

Responsibilities:

• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Performed metadata building using outline load utility for different dimension and various applications.
• Maintain the dimensions through dimension library in EPMA
• Developed Dynamic Web forms for various applications with POVs, menus, run time prompts and Pages.
• Developed Rules files for data Metadata and Data loading in Essbase for BSO application.
• Created POCs for each OPC in Aggregate Storage Option (ASO) and set the properties for each dimension based on the technical specification.
• Created schemas for Essbase studio to create outline for ASO cube.
• 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.
• Worked on migration of applications form one environment to other. Migrated application from development server to Pre-Production and Production server.
• Worked on security in shared services. Build various security filters and granted access to the application and its dimensionality according to the requirement provided. For various users/groups.
• Worked on MAXL scripting for automation. Used MAXL scripts in batch files for performing data and metadata
• Worked on Design Documentation for various applications. Explained from starting to end about the description of application. Its dimensionality, various data forms, menus associated and business rules. The Various financial reports associated with it.
• Worked on providing User training documents. Build excel files describing the data forms, how they work and business rules association with them and what rule is doing.
• Worked on designing filters for the entire reporting cube giving user read access to Essbase.
• Modified Essbase filter for planning applications giving users write back capabilities in smart view for their specific security allotment.
• Extensively worked on Lifecycle Management to migrate security, planning application and its components from DEV to PROD environment.
• Extensively worked with Hyperion Shared Services to give access and provision to users and groups.

Confidential, Dallas-TX

Hyperion Consultant

Environment: Hyperion Planning, Hyperion Essbase

Responsibilities:

• Responsible for development and maintenance of Hyperion Essbase applications to help in the analysis of Client’s business performance and provide insights into various customer segments.
• Gathered user requirements and then transformed them into Dimensions and members.
• Optimized Aggregate Storage Option and Block Storage Option outline.
• Developed Rules file for Dimension Building and Data Loading.
• Created reports using Hyperion Financial Reports & Hyperion Smartview.
• Designed and developed web forms as per the business requirements using Hyperion Planning.
• Extracted data manually from different sources to combine different sources into one business report.
• Developed Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Developed web forms using Hyperion Planning for users to input data.
• Designed Task lists for planning applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.

Confidential, MS

Hyperion Financial Management Developer

Environment: HFM System 11.1.1.3.0, Essbase Administration Services, Hyperion Financial Reports, Hyperion Smartview, FDM

Responsibilities:

• Participated in defining requirements from the end user, functional specifications, design documentations and test strategies.
• 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.
• Performed admin activities related to Hyperion Financial Management 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.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM.
• Involved in user access provisioning and the security filter on the system. Assigned accesses and privileges to various end users in different planning applications using Shared Services.