PROFESSIONAL SUMMARY:

• 8+ years of proficiency and experience in a range of Hyperion Developer products including Essbase, Hyperion Planning, workforce planning, 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.
• 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.
• 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 teh production migration.
• Experience in working through all phases of Software Development Life Cycle (SDLC) including teh design, development, implementation, and maintenance of financial applications.
• Skilled in installations, upgrades, and configuration procedures in client/server environments.
• Expertise in building Relational Databases using SQL Server and Oracle and noledge of Essbase server upgrades across NT and UNIX platforms, Fact and Dimensions Tables, Snow-Flake Modelling, Star-Schema Modelling
• Strong Experience in creating and designing planning Classic and EPMA applications.
• Experience in Hyperion Planning, 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.
• Developed Data Forms, Smart List, Business Rules, calculation Scripts, prompts, Menus, Task List, Planning units
• Experience in working with BSOmulti currencyplanning application as well ASOmulticurrency application with currency conversions usingcalcscripts
• 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.
• Experience in setting up security in shared services and planning\essbase
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS:

BI Tools: Hyperion planning 11.x/9.x/4.x/3.x, Essbase 11.x/9.x/7.x/6.x, Oracle Business Intelligence suite, Financial Reporting, Hyperion interactive reporting (BRIO) 11.x/9.x/8.x/6.x, Hyperion strategic finance (HSF), Smart View, Essbase Administration services, ESSCMD, MaxL, Hyperion workspace, Hyperion shared services, Hyperion Reports 9.x/7.x/2.x, Excel Add- in, Essbase Studio, Hyperion Visual Explorer.

Middleware: Web Logic, IBM’s Web Sphere, Java Web Server

Databases/ERP: Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6,IBM AS/400

Operating Systems: Windows XP, Window 2000, 2003 MS-Dos, UNIX, Linux (RHEL6)

PROFESSIONAL EXPERIENCE

Confidential, Renton, WA

Hyperion Essbase developer

Responsibilities:

• Analysis of Business Requirements Document, regular meetings with teh business users to gather all teh functional requirements for metadata, data load, developing calculation scripts, business rules and web forms
• Conduct project requirement gathering sessions, document project requirements, define tasks, estimate timeline and identify resource requirements.
• Worked on teh installations of EPM 11.1.2 versions and migrated applications from 9.x to 11.1.2
• Developed and Maintained Oracle / Hyperion Planning and Essbase solutions - specializing in Workforce Planning, Capital Expenditure and also has 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 teh 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 teh POV set in FDM to clear data in Essbase based on teh configuration options in locations.
• Created configuration files for FDM feeds to Essbase.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by
• Created complex and simple reports using Excel Smart view, Hyperion Reporting.
• Developed complex calculation scripts for allocations and back calculation for teh 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 teh business requirement.
• Resolved various issue on EPMA while deploying and validating teh planning and ASO applications
• Used ODI as teh ELT tools for teh 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 teh existing applications
• Maxl scripts to automate version copying in Essbase ASO cubes.
• Followed SDLC process and provided documentation on development and test evidences.

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

Confidential, NY

Hyperion Consultant

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• As a Hyperion Administrator involved in Installation and Configuration of Hyperion products such as Planning, Essbase and reporting tools.
• Worked on Hyperion system 9 planning to support complex financial applications for budgeting and Forecasting.
• Created web forms in Hyperion planning for users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting.
• Created Financial Budgeting and Forecasting OLAP applications with Hyperion planning.
• Used Hyperion Planning 9 to create EAS applications / security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users / user groups and security rights.
• Worked on Hyperion system 9 BI+ to create various ASO and BSO applications for budgeting planning and forecasting for higher management of decision support system.
• Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Involved in estimating and tuning teh Essbase database performance.
• Hands on experience in backup and recovery of database.
• Provided security for various levels of users using Hyperion Shared Services.

Environment: Hyperion Essbase 9.3.1, Hyperion planning 9.3.1, EIS Integration services, Hyperion Reports 7.0, Hyperion Web analyser, Hyperion Planning desktop, Oracle 9i,SQL, PL/SQL, MS Excelspreadsheet Add-in, Windows 2000.

Confidential, MA

Hyperion Consultant

Responsibilities:

• Involved in creation functional & technical specification documents depending on teh Business requirements.
• Worked extensively on planning application for Planning, budgeting and Forecasting (PBF), Hyperion Financial Reports (HFR), and web forms for planning users.
• Assisted in technical specification preparation.
• Created several web forms depending on teh requirement in Hyperion Planning.
• Inputting Budget and forecasts of Data into web forms online through Hyperion planning, Smart View and web using workspace, Developed load rules for loading specific type of data files.
• Maintained data base for optimum performance for using Calculation Scripts and Business Rules.
• Generated different reports using Smart View, created reports using SQL Statements for DB2 database.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users. Process automation using ESSCMD and MaxL Scripts.

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

Confidential

Hyperion Consultant

Responsibilities:

• Analyzed user requirements and involved in teh process of finalizing dimensions for cubes.
• Designed, developed and managed Hyperion system 9.3 applications - Essbase BSO and ASO cubes, rules and calculation scripts.
• Developed load rules for loading specific type of data files.
• Created several web forms depending on teh requirement in Hyperion Planning.
• Responsible for creating users and groups and providing authorization to them.
• Prepared quarterly forecasts, annual budget using Hyperion Reports and Hyperion Analyzer.
• Developed SQL extracts and batch scripts using ESSCMD and MaxL Scripts to automate data file creation for Essbase cube dimension builds and data loads.
• Familiarity with Master Data Management (MDM) using Oracle.
• Responsible for providing training to teh end users.

Environment: Hyperion Essbase 7.1.2/6.5, Essbase Administration Services, Essbase Integration Services 7.1.2/6.5, Excel Add-In, ESSCMD, Oracle 9i, Windows 2000, UNIX

Confidential

Jr. Hyperion Consultant

Responsibilities:

• Interacted with key business users to develop functional and technical specification.
• Performed a Key role in teh new development of a corporate systems Essbase implementation.
• Planning and Analyzing teh Data, Defining Dimensions, Applying Analysis Rules, Developing and Generating teh Outlines, interacting with teh End Users for teh Report Layouts, Test Consolidations, Loading teh data into teh Database and Testing teh Data.
• Modifying/Writing Calc Scripts, creating Rules file, Formulas, creating Filters to restrict access to cube.
• Loading Sales, Revenue, and Head Count Data to cubes, creating current Actual/Forecast/Budget members.
• Created Currency Exchange Rate tables for teh Multi currencies
• Developed/Modified automated batch scripts to automate teh data loading and to run Calc scripts at scheduled intervals.
• Synchronized teh Test/Development Environment with teh Production Environment, Used HAL to load Metadata and mapping of teh Metadata with planning data.

Environment: Hyperion Essbase 7.1.2/6.5, Essbase Administration Services, Essbase Integration Services 7Reference: Will be provided upon request.