SUMMARY

• Over 7+ years of IT experience with over 6 + years of experience as a Hyperion consultant, Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems Administration, design and implementation.
• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 11 and system 9, Hyperion Essbase 7.X/6.X, Essbase Integration Services, Hyperion Analyzer, Hyperion Financial Reporting Studio, Hyperion Planning version 3.X/4.X/9.X AND 11.X, Workforce Planning, ODI, HFM with version 9.X /11.X, FDM with version 9.X/11.X, FDQM with version 11.X, DRM, Informatica Smart view and Spreadsheet Add - In on Windows 2000/NT and administration .
• Responsible for security groups and access for the users in Financial Reports and Hyperion System 9 and system11 Planning.
• Experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using, Hyperion System 11 and 9(BI), Hyperion Essbase, Hyperion Analyzer, Hyperion Reports, Hyperion Planning, FDM, HFM, ODI, DRM, ETL(informatica), Analytical integration Services and PeopleSoft.
• Strong database development and business intelligence modeling capabilities; Essbase calculation script knowledge, creating rule files, Process automation and data loading, dimension building.
• Strong knowledge of Financial Domain applications and Functional analysis for Planning, Budgeting and forecast applications and help in administration.
• Proficient in the Star and Snowflake Schema data modeling technique used to design for data warehouse and data mart.
• Extensive experience on the installation, configuration, server settings, backups, client and server installations of Hyperion products such as Essbase, Essbase Integration Services, Essbase Analyzer and Hyperion Reports.
• Experience with the entire Microsoft Office Professional .

TECHNICAL SKILLS

OLAP Development Tool: Hyperion System 11 and system 9.3,Hyperion Essbase 7.0/6.x,, MS Excel spreadsheet add-in, HFM.

ETL Tools: Oracle Warehouse Builder, ODI,FDM,FDQM

Business Intelligence Tools: Hyperion Planning system11 and 9.3.x, Hyperion Analyzer 7.x/6.x, Financial Reports, H.A.L, Hyperion Enterprise Services, PeopleSoft.

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP

Databases: Oracle 11i/10i/9i, MS SQL Server 2000.

Hardware Platform: Linux, SUN Solaris, Windows 2003/2008/NT Servers

Languages: PL/SQL, C/C++, SQL, HTML, XML, ASP.

Web Design & other tools: HTML, MS FrontPage, Dream Weaver, Macromedia Flash, MS Office2003.

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.

Process/Modeling Tools: System Development Life Cycle, MS Visio, Rational Rose, ERWin4.0.

Project Management: MS Project 2000/2003

Reporting Tool: Hyperion Financial reporting studio, OBIEE, Hyperion Analyzer.

PROFESSIONAL EXPERIENCE

Confidential, Woodcliff Lake, NJ

Hyperion DRM/Planning/Essbase/ODI/HFM developer

Responsibilities:

• Create Metadata/Meta topics, Data Marts which are suitable for the source system account format in Hyperion Planning & Budget, Hyperion Essbase and Interactive Reporting Studio respectively.
• Experience on Hyperion Reporting tools, Essbase including installation and maintenance of Essbase client and server components .
• Developed a couple of new Applications from scratch as per business requirement.
• Workspace was used as a centralized system to register the application, creating the Web data forms/data grids, Workflow, Task lists, launching Business rules and Accessing Reports
• Installing, configuring, upgrading of Hyperion Reporting Components including that of Essbase and its server and client components
• Metadata development such as building Meta topics for Account, Scenario, Entity and other Dimensions.
• ODI experience in designer, topology, tuning, security
• Worked on 11g version on ODI
• Maintenance of repository, Optimization of Memory and Cash ODI Servers.
• Created Batch files, automation scripts for data back-up, Importing, Exporting data etc using Maxl.
• Designing the Hyperion Model with queries joined using the Data warehouse base tables.
• Mostly big hierarchy updates load properly to all applications and cubes with minimal impact on the user community using DRM
• Extensive experience in latest versions of Oracle EPM (Hyperion) 11.1.2, 11.1.1.3 and 9.3.1 versions with emphasis on MS Excel based reporting.
• Work with Hyperion Planning Administrators to ensure that hierarchy updates load properly to all applications and cubes with minimal impact on the user community using DRM
• Developed Web Forms, Composite Web Forms, Menu, Task Lists, and User Variables based on the Functional and Technical Requirements requested by the business.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Performed the performance tuning by using the Dense/Sparse settings, developed the required alternate rollups for reports and DRM worked on multiple ERP, GL, EPM instances.
• Successfully delivered 2 global end-to-end Hyperion projects.
• Full understanding of ASO, BSO, partitions, dynamic calcs, shared members and additional Essbase terminology with a strong understanding of general business and accounting processes.
• Experience in building and optimizing data loads and calculations within ASO and BSO Essbase architecture.
• Designed & built data load scripts and exception handling procedures in Essbase.
• Responsible for all aspects of Essbase development, maintenance and use of applications supported by Essbase Shared Services group.
• Designed/Modified Outlines, Business Rules, Calc scripts, MDX scripts, Rules files, MAXL Scriptsas per demand.
• Shared service was used to maintain the user provisions and level of access (Interactive user, Planner, Viewer, offline user) and creating the projects.
• Making a user friendly environment for the end-users using the Dashboard (in a click button way).
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Data forms and Data grids were sent every day to end users for their glance at the financial data.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Design reports using Interactive Reporting Studio, Financial Reporting Studio, Smart view, Hyperion Web Analyzer based on the user requirements.
• Extensively worked on Database optimization and performance tuning of Essbase cubes for fast retrieval and calculation performance.
• Designed and developed numerous reports based on end user’s needs.
• Trained End-Users on process control, Reporting methods and using Hyperion performance suite.
• Involved in Hyperion Installation from scratch from Shared services to installing the modules like Planning, HFM and cleared the Installation issues which occurred in the process.
• Hyperion Planning was used to build the Planning & Budget application from the scratch to meet the Business functional requirement and to map the data from external source applications.
• End to End implementation of Planning for Budgeting and Forecasting for the business is developed.
• As a Admin, maintenance of Metadata for Hyperion HFM and Planning Applications
• Creating and modifying rules for various statistical calculations as needed
• Loading the actual monthly close files into HFM thru FDM and planning thru DRM.
• Automating controls over the transfer and import of subordinate system data files (configuration management, date ranges for uploads, single upload controls to avoid duplication, upload controls to identify and confirm origin of the data)
• Create Metadata/Meta topics, Data Marts which are suitable for the source system
• Participated in the team designing and developing Financial Management Application (HFM) cube.
• Used Financial Data Quality Management (FDM) application as required.
• Involved in Application migration, Database objects from Dev environment to prod environment using Hyperion Administrative services console.
• Migrated reports from Dev to UAT and then to prod. Responsible for testing the Reports, production data validation and all other related aspects through all phases of the SDLC.
• Involved in Trouble shooting the Production issues in support to the Essbase Applications, Interactive Reports and all Reporting objects (Production Support).
• Involved in troubleshooting, Data validation, Performance tuning and Performance monitoring.
• Used so many tools in supporting this project such as ODI, Outline extractor, HAL, Financial Reporting, Interactive Reporting, Web Analyzer, Smart view, Essbase Excel Add-in, Toad.

Technology/Platform: Hyperion Essbase System 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion financial Reporting Studio 11.1.2.674 , Hyperion Workspace 11.1.2.1, Smart view, Microsoft Excel 2010,, Window 2003 Server, Solaris.

Confidential, Charlotte, NC

Hyperion Planning/Essbase/ODI/DRM developer

Responsibilities:

• Integrate planning, Budgeting, Forecasting and performance measurement on enterprise-wide basis and improve accuracy of forecast.
• Four main planning applications and 2 Essbase applications were developed to track forecast and budgets.
• Developed various reports for different group of users using Hyperion Financial Reporting studio and ESSBASE STUDIO.
• Worked on ASO, BSO, partitions, dynamic calcs.
• Experience in building and optimizing data loads and calculations within ASO and BSO Essbase architecture.
• Responsible for all aspects of Essbase development, maintenance and use of applications supported by Essbase Shared Services group.
• Experience in the full life-cycle development for EPM systems including requirements, design, development, testing, rollout and training.
• Used ODI to bring and load data values, accounts, entities, and custom dimensions from flat file into Cube.
• Worked on ODI to create the source, target, mapping and workflow etc
• Possess a thorough understanding of databases and general programming concepts.
• Designed & developed Planning and Budgeting process using Hyperion Essbase and Planning Products.
• Working in PeopleSoft like GL, AP, purchasing, Project Costing and Expense modules in finance, People code development and SQL development.
• Responsible for implementation, migration and technical-support for maintaining Hyperion Essbase production and Development servers.
• Working offshore and supporting CBS clients through WebEx, GoToAssist or other remote desktop tools and DRM in compliance & audit, complex dimension management.
• With the leadership qualities and also as a versatile team player in the migration team worked with other analysts to understand requirements, specifications, testing strategies and also for planning the project time line for migration.
• Created Planning and Essbase applications in Hyperion System 9.3 and system11, Created scripts in MAXL for dimension building and data loading and automated them.
• Security setup on planning application and reports.
• Performed product wide migration of Hyperion Essbase Version 9.3 to 11.2.0 and also system 9.3.1 Implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Followed Software Development Life cycle of developing new cubes and redesigning and restructuring the existing cubes.
• Production Support for Hyperion Financial reporting, Planning applications, FDM, HFM. Actuals and Budget data processing, migration and security related operations.
• Work with “Budget Team” to identify reporting requirements and translate requirements into developing the right solution for user analytical / reporting solutions.
• Develop and implement disaster recovery strategy and helps in administration
• Develop business rules and calculation scripts to improve the functionality for budget analysis, currency conversion and consolidation.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion System 9.3.
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
• Used Hyperion Reporting studio to generate various kinds of Annual and Quarterly Financial reports.Used Hyperion Scheduler to schedule various reports on day to day basis.
• Developed Multiple Web forms for data input and Reports on demand.

Technology/Platform: Hyperion Essbase System 9, Hyperion Planning 9.3, Hyperion 9.3 BI+ (Financial reporting Studio, Workspace, Web Analysis) Financial Reports 9.3, Essbase Integration Services 6.5.4, Microsoft Excel 2000, Oracle 10i, Windows 2003 Server, UNIX.

Confidential, Woonsocket, RI

Hyperion Essbase/Planning Developer

Responsibilities:

• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass and stick fashion.
• Developed application in Hyperion System 9.2
• Installed Hyperion Planning software and Essbase integration services, for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
• Created scripts in MAXL for dimension building and data loading and automated those processes
• Used Master data management software to configure, import, export, and integrate dimensional and master data across BI, data warehouse, financial & operational systems, providing for accurate, consistent and compliant enterprise reporting.
• Involved in creating Rule files and batch files to automate the data load process.
• Created wrapper scripts (.ksh) to automate all the variables and all the (.scr) scripts.
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed and developed optimized Essbase applications.
• Work with Hyperion Planning Administrators to ensure that hierarchy updates load properly to all applications and cubes with minimal impact on the user community using DRM
• Developed Web Forms, Composite Web Forms, Menu, Task Lists, and User Variables based on the Functional and Technical Requirements requested by the business.
• Created users and user groups in the Planning applications and assigned security to web forms.
• DRM worked on metadata. .
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services. Loaded data using Essbase Integration Services (EIS).
• Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Implemented Data Access layer to Communicate with the Oracle Database.
• Installed and upgraded Hyperion Planning applications.
• Created and mapped HAL jobs to load the hierarchies into different planning applications.
• Worked as an administrator to give access and privileges to various end users in different planning applications, and synchronizing the passwords during the Essbase logon, or using external provider in Essbase.
• Created and managed numerous Data entry forms and Created many Business Rules for several applications.
• Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes.Created various Reports in Hyperion Reports.

Technology/Platform: Hyperion Essbase System 9, Hyperion Analyzer 7.0, Hyperion Planning 3.5.1, Hyperion Reports 7.1.2, Essbase Integration Services 6.5.4, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server, UNIX.

Confidential, NJ

Hyperion Essbase Developer

Responsibilities:

• Designed and developed numerous Essbase applications in system 9.0.
• Interacted with users to support analysis and provide definition and requirements for the Financial Management reporting and other Essbase supported processes.
• Created many groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Installed and set up the server with Hyperion Essbase, Hyperion Analyzer and HAL. Developed Aggregate Storage Cubes using Essbase system 9.
• Set up the server settings, optimized different Essbase objects, and implemented partitioning among different production cubes to improve performance of all the Essbase applications.
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
• Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Developed automation scripts for application refresh and back ups using Hyperion Essbase Esscmds and MaxL.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Essbase 7.1.
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
• Interacted with end users and developed numerous Business Rules in Hyperion Planning.
• Involved in gathering requirements and developing a project plan.
• Involved in gathering data and supervising data load.
• Involved in creating Rule files and batch files to automate the data load process.
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Implemented robust data-access security and user management.
• Developed Excel Templates for user interface in Essbase database
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services. Loaded data using Essbase Integration Services (EIS).
• Generated reports relating to strategy, fraud, collections and accounts receivables using Hyperion Analyzer 6.5.

Confidential

Oracle Developer

Responsibilities:

• Designed and developed Graphical User Interface using Forms.
• Developed the PL/SQL stored procedures for implementing the business logic.
• Developed the on-line context-sensitive user help.
• Development of reports (stores ledger, invoice preparation) using reports 3.0
• Developed test plans for invoice, order entries, billing, shipping, and Stock maintenance.
• Conducting Functional testing, System testing and GUI testing.
• Tested the functionality by creating dummy transactions.
• Manually tested different reports generation.
• Created Packages, Procedures and Functions.
• Configure Oracle Clients on Win NT Workstations.
• Creating Complex Stored Procedures, Functions and Packages.
• Developing Oracle Schema Design and Table Structures.
• Constructing Oracle Database Triggers and Indexes. Code Reviews, PL/SQL Code Tuning and Plan SQL.
• User Management; Create, Modify and Delete user accounts.
• Grant Roles and Privileges to Users.

Environment: Developer 2000, PL/SQL, SQL, Oracle 9, and Windows NT