SUMMARY

• 8+ years of proficiency and experience in a range of Hyperion Administrator/Developer products including Essbase, Hyperion Planning, workforce planning, Hyperion Financial Management, Oracle Data Integrator, Integration Services, Smart view, and Spreadsheet Add - In, in both Windows and UNIX environments.
• Strong Experience in designing Essbase/Planning applications.
• Installed Entire EPM 11.1.2.x or higher, EPM Suite in Windows and UNIX environments.
• Worked on End to End implementations of Hyperion projects (HFM, Planning and Essbase)
• Used various types of utilities in Hyperion planning applications for dimension building and maintenance purposes like outline load utility, import export security and cube refresh.
• Worked on Upgrade Projects related to HFM/Planning/Essbase from 7.x/9.x to 11.x and 9.x to 11.x.
• Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Worked on two end to end implementations from requirement gathering to the production migration.
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications.
• Extensive knowledge in HFM classic and EPMA applications, Hyperion FDQM and financial reporting.
• Skilled in installations, upgrades, and configuration procedures in client/server environments.
• Expertise in building Relational Databases using SQL Server and Oracle and knowledge of Essbase server upgrades across NT and UNIX platforms, Fact and Dimensions Tables, Snow-Flake Modeling, Star-Schema Modeling
• Strong Experience in creating and designing planning Classic and EPMA applications.
• Experience in Hyperion Planning, HFM, Essbase, HFR, ODI, ETL and OLAP tools
• Rebuilt classic applications into EPMA applications.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase and Planning.
• Thorough understanding of multidimensional and relational database architecture and their applications for effective planning, budgeting, strategizing and forecasting procedures.
• Strong Experience in developing outlines, calc scripts, Rule files, report scripts, excel templates, Smart View.
• Strong experience as a Hyperion Essbase Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
• Strong experience in Financial management applications, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
• Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization
• Developed Data Forms, Smart List, Business Rules, calculation Scripts, prompts, Menus, Task List, Planning units
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented
• Strong Experience in designing Business requirement documents, creating financial reports, Functional Requirement documents, converting FSG's to HFR reports.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

PROFESSIONAL EXPERIENCE

Sr. Hyperion Consultant

Confidential - Wilmington, DE

Responsibilities:

• Developed and deployed EPMA and classic HFM applications used for consolidation purposes.
• Analysis of Business Requirements Document, regular meetings with the business users to gather all the functional requirements for metadata, data load, developing calculation scripts, business rules and web forms
• Created and Loaded Metadata for HFM consolidation Actuals and Budget using EPMA to generate variance reports.
• Designed complex security model for HFM, Planning, and Essbase applications as per client requirements.
• Conduct project requirement gathering sessions, document project requirements, define tasks, estimate timeline and identify resource requirements.
• Worked on the installations of EPM 11.1.2 versions and migrated applications from 9.x to 11.1.2
• Configured the source and target adapters in HFM from FDM and created the machine profiles
• Developed and Maintained Oracle / Hyperion Planning and Essbase solutions - specializing in Workforce Planning, Capital Expenditure and also have extensive experience building Revenue, Capital, Income Statement, Balance Sheet, and Cash Flow statements using planning applications.
• Maintained security for Planning, Business Rules and Essbase.
• Configured adapters in FDM and developed load adapter script in FDM to load data into the Essbase application
• Conduct training sessions for clients to demonstrate Oracle/Hyperion Planning product enhancements and best practices.
• Developed BI Reporting dashboard, queries, reports using Hyperion Interactive reporting (IR) Developed clear script as per the POV set in FDM to clear data in Essbase based on the configuration options in locations.
• Created configuration files for FDM feeds to Essbase.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Created complex and simple reports using Excel Smart view, Hyperion Reporting.
• Developed complex calculation scripts for allocations and back calculation for the accounts like Operating Earnings, Net Income Reconciling Items, Retained earnings
• Created various business rules for currency conversion and constant currency USD rate.
• Developed Dynamic web-forms for faster performance and better results as per the business requirement.
• Resolved various issue on EPMA while deploying and validating the planning and ASO applications
• Used ODI as the ELT tools for the metadata maintenance of classic and Essbase BSO/ASO applications.
• Developed and maintained Essbase studio application and drill thru reports.
• Created various automated hyperion jobs thru Maestro automation tool
• Involved in providing solution and approach steps to L1/L2 support and administrators
• Provide user training and educating administrators in new implementation or changes made to the existing applications
• Maxl scripts to automate version copying in Essbase ASO cubes.
• Followed SDLC process and provided documentation on development and test evidences.

Environment: HFM Hyperion Financial Management, Hyperion Planning, ESSBASE, EPMA, HFM, ESSBASE studio 11.1.2.1, Web Analysis, FR reporting, Smart view, FDM, People Soft, Windows 2003.

Sr. Hyperion Consultant

Confidential - Chicago, IL

Responsibilities:

• Worked closely with ETL and SAP teams to fetch source data of HFM applications
• Collaborated with users on report requirement acquisition.
• Involved in creation functional & technical specification documents depending on the Business requirements.
• Created, configured and maintained HFM (Classic and EPMA) and FDM Applications
• Worked extensively on planning application for Planning, budgeting and Forecasting (PBF), Hyperion Financial Reports, and web forms for planning users.
• Developed Dynamic Web forms for various applications with POVs, menus, run time prompts and Pages.
• Hyperion Planning application to consolidate the Planning data from all its markets across the globe.
• Integrated FDM Applications with HFM Applications by creating mappings between FDM and HFM Applications for loading data.
• Participated in the development of Multi-Dimensional Data Marts using Hyperion Essbase technology and the development of analytic reporting of Business Performance Measurements using the Hyperion suite of products including Hyperion Analyzer, Hyperion Reports, Hyperion Planning and Hyperion Financial management.
• Assisted in technical specification preparation.
• Created the BSO and ASO cubes in Essbase and followed the Hour-Glass model for the dimension order on Dense /Sparse dimensions.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM and HFM.
• Created several web forms depending on the requirement in Hyperion Planning.
• Maintained data base for optimum performance for using Calculation Scripts and Business Rules.
• Performed data migration from 9.3 to 11.1.1.3. Framed MAXL scripts to automate the calculation scripts.
• Used Essbase to deliver meaningful insights for managing finance that are easy to interpret and understand even by non-technical users.
• Conducted tests to see if the data is behaving in the expected manner.
• Involved in the installation of Essbase Administration Services, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer and Hyperion Application Link in Windows environment.
• Extensively used Workspace for performing general HFM Web and Reporting activities.
• Involved in Deploying Hyperion planning 11.1.1.3 in different environments.
• Developed reports for the regulatory purpose in Excel-Add in and Standard Reports in Hyperion Reports.
• Process automation using ESSCMD and MaxL Scripts.
• Generated different reports using Smart View.
• Developed load rules for loading specific type of data files.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
• Supported the users in Maintenance period.
• Maintained users and security for FDM and HFM Applications using Shared Services.
• Gave access and privileges to various end users for different reports and synchronized the passwords during logon.
• Created reports understanding and analyzing the Stored Procedures.
• Created reports using SQL Statements for DB2 database.

Environment: Hyperion Financial Management HFM, Hyperion Essbase 9.3/11.1.1.3 , SQL Server 2005, Financial Reporting 9.3, Work space, Hyperion Planning 9.3, EAS, EIS, DB2, Windows 2003 server, Unix/AIX, Excel Add-in

Hyperion Consultant

Confidential - Boston, MA

Responsibilities:

• Worked with Subject matter experts (SME) and business analysts to gather the business requirements during development stages and prepared BRD and FRD
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool
• Extensively used Workspace for performing general HFM Web and Reporting activities.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Designed Essbase and planning applications for all day to day financial data analysis and for budgeting and forecasting purposes.
• Developed complex calculation scripts and formulas for the existing ASO and BSO cubes to implement the business logic.
• Worked on Workforce and Total Expense Planning Cubes, Modifying outlines, business rules, calculation scripts, backing up application, reloading data, optimizing as needed using 11.1.1.3
• Wrote complex and simple business rules and calculation script to meet all the custom calculation needs.
• Designed Outlines, report scripts, Global variables, Location aliases for Essbase application development.
• Designed Data forms, Business rules, menus, task lists, workflow process for planning application development.
• Worked with Hyperion Classic, EPMA planning applications for budgeting and forecasting
• Designed ETL using ODI to integrate various source systems to Essbase and planning applications.
• Automated dimension building and data loading process using maxl and batch scripting.
• Customization of applications, smart lists, data forms, menus and dimensions where done through workforce planning.
• Designed dynamic reports and charts using financial reporting to see the monthly consolidated data.
• Involved in Knowledge transfer and development transition to the other team members and to production team (onshore and offshore).
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Documented complete application development and maintenance process as per client standards.

Environment: HFM Hyperion Financial Management, Hyperion system 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Financial Reports 11.1.2, EAS 11.1.2, Hyperion Planning, Oracle 11g, Oracle SQL Loader, Windows 2000 Advanced Server, Linux.