PROFESSIONAL SUMMARY:

• Around 9 Years of experience in IT with Six years of experience in Data Warehousing, ETL & OLAP with focus on Hyperion Suite of Technology.
• Over 6 years of functional experience in design, analysis, development and implementation of various applications in Client/Server environments using Hyperion Essbase 11.X/9.X/7.X/6.X, Essbase Integration Server (EIS), Hyperion Financial Reports, Hyperion Analyzer, Hyperion Planning, HFM, DRM,FDM, HAL, ESSCMD,MaxL, Essbase Spreadsheet Add - in, Essbase Query Designer. HyperionData Integration management (DIM)
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add-In, Hyperion Analyzer, Smart view.
• Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view, Hyperion Intelligence designer 8.3.2, MDM or DRM, ODI, OBIEE, EPMA.
• Expertise in writing Calc Scripts, Report Scripts and Load rules. Good Exposure on Hyperion Dashboard.
• Implemented/Installed the EPM applications Essbase 11.1.2/9.3.1 , Planning 11.1.2/9.3.1 in Windows Server 2003.
• Creating Macros/ CDF’s using VB scripts through Excel Spreadsheet Add-in, SmartView.
• Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulas and Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Upgradations, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Created & Used ODI routines to update the metadata changes in Planning.
• Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Possess excellent project management skills in managing, developing and implementing the project. Possess excellent analytical, interpersonal, logical, communication skills, reliable and great team player.
• Experienced in knowledge transfer, preparing the required documentation and the clients.
• Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

TECHNICAL SKILLS:

OLAP/Reporting Tools: Hyperion Essbase System 11.x/ 9.3.1/6.5.4/6.3/6.1 , ESSCMD, Maxl Hyperion Financial Report V 11.x, Interactive reporting (BRIO) Hyperion Analyzer, Hyperion Planning 11.x, Hyperion Workforce, FDM, HFM, DIM, Hyperion spreadsheet Add In Micro Strategy Web, Clarity.

Analysis & Methodology: Rational Unified Process (RUP), UML, Rational Rose, Use Cases, Rational XDE, Photoshop, Macromedia Flash, Adobe Photoshop, Six Sigma

Languages: SQL, PL/SQL, Pascal, C/C++,JAVA

Databases: Essbase, Oracle 10G, Oracle 10i, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2.0.

Software tools: SQL *Plus, TOAD, Aqua Data Studio, ODI 11.x.

Operating System: Windows 2000/NT 4.0/98/95, UNIX (Solaris, HP), LINUX.

Project Management Tools: Microsoft Visio 2000, Rational Requisite Pro and Rational Clear Case.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Hyperion Planning/FDM EE Consultant

Responsibilities:

• Created Workforce and capex and P n L planning application.
• Designed and developed web-forms in Hyperion planning and provided security to users.
• Created region based Task lists and added all the steps to submit budget and forecast for the end users.
• Created Forecast Business rules using calc manager and used variables and RTP’s.
• Created RuleSet in Planning to combine and group the business rules.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube; develop MDX queries.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Performed application development tasks using Hyperion Essbase API and Hyperion Essbase
• Managed and maintained FDM Locations and provided security to all users.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Created and and maintained FDMEE maps and migrated the maps from one server to other.
• Developed batch process to load FDM data, and created Validation reports in FDMEE.
• Objects to manage Essbase security, partitioning, and meta-data management and change control.
• Partitioned Essbase cubes using transparent partitions created and managed the partitions, and processed cube’s administrator and end user security.
• Automated and installed several Essbase utilities to simplify user/supervisor interaction with Essbase cubes.
• FDMEE design, test, migration, import formats, location setup, security, custom scripting for GL integration. Loading data thru FDM using HFM.
• Updated the HFM documents like rules, metadata, data forms, data grids.

Environment: Hyperion Essbase 11.1.1.3/9.3.1 , EAS, EIS, Hyperion Planning 11.1.1.3/9.3.2 , Hyperion financial Reporting 11.1.1.3, Hyperion workspace 11.1.1.3, Hyperion web analysis, HFM, ODI, MAXL, Essbase Deployment Services.

Confidential, KOP, PA

Hyperion Planning Consultant/SME

Responsibilities:

• Was responsible for Installing, Configuration, Upgrading and Migration from Hyperion 9.3 suite to Hyperion 11.1.1.3(Oracle EPM).
• Provided documentation of all the technical and functional issues which would be helpful to users for future .
• Was responsible for creation of validations and verifications as per the Business needs for validation of data through DRM.
• Was Responsible for requirements gathering for the implementation of Hyperion DRM
• Was responsible for administrating the task of maintaining the server, providing user security and application maintenance.
• Was responsible for setting up the properties, properties categories, system ps and queries in DRM.
• Was responsible for creating and testing new business rules and calculation scripts as per the needs of the users using Hyperion Planning.
• Was responsible for building financial reports for co-operate using Hyperion Financial Report.
• Was responsible to write and designing a test case strategy.
• Was responsible for system maintenance and applying patches if necessary.
• Creating application, managing metadata file in HFM, creating accounts and entity, custom etc.
• Using VB scripting extensive to write HFM rules and FDM import scripts.

Environment: Hyperion Essbase 9.3/11.1,PeopleSoft, Hyperion Financial Reports Studio V9.3, HFM, Smart View reports, Hyperion Analyzer, Hyperion Integration Services, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Windows NT/2003, Shell scripts.

Confidential, LA, CA

Hyperion Consultant/Business Analyst

Responsibilities:

• Was responsible for importing and exporting of data using Hyperion DRM from E-Business Suite.
• Was Responsible for requirements gathering for the implementation of Hyperion DRM
• Was responsible for creating an application for data analysis using DRM.
• Was responsible for creation of validations and verifications as per the Business needs for validation of data through DRM.
• Was responsible for mapping the data through DRM.
• Was responsible for initiating the workflow process for DRM using BPEL.
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for Installing, Configuration, Upgrading and Migration from Hyperion 9.3 suite to Hyperion 11.1.1.3(Oracle EPM).
• Was responsible for administrating the task of maintaining the server, providing user security and application maintenance.
• Was responsible for defining and creating batch scripts for automation in import and export using DRM.
• Worked in coordination with the OBIEE team for the Integration of DRM and OBIEE.
• Was responsible for installation and configuration of SOA for deploying the DRM request client application.
• Was responsible for setting up the properties, properties categories, system ps and queries in DRM.
• Was responsible for transfer of data from General Ledger (GL) and ERP systems using DRM (Data Relational Management).
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units and loading data using ODI.
• Was responsible for managing and auditing the master data using DRM.
• Conducted boot camp sessions for users for handling issues for DRM administration and its functionality.

Environment: Hyperion Essbase 9.3/11.1,OBIEE, E-Business Suite, BPEL, SOA, Microsoft Access, Windows Scheduled tasks, Windows NT/2003, Shell scripts.

Confidential, Stamford, CT

Hyperion Administrator

Responsibilities:

• Was responsible for creating, building, testing and documentation of reports for Co-operate reporting purposes and also for all the business units.
• Worked in coordination with the team in installing and configuration of OBIEE (Oracle Business Intelligence Enterprise Edition) and also tested the functionality and report building.
• Was responsible for creating dashboards, report optimization for reporting based on financial data using Hyperion Interactive Reporting and Hyperion Financial Reporting studio V9.3 for creating new financial reports and procedures.
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units, assigning and assisting users with tasks for functioning of Hyperion suite of products like ESSBASE, Planning, generating Reports and Analyzing the data.
• Implemented graphical, flowchart environment for building and validating business rules using HFM (Hyperion Financial Management).
• Responsible for Managing and administering for ASO and BSO cubes.
• Was responsible for creating production support reports for the business units to access the reports via web browser using SQR studio.
• Was responsible for validation of data using DRM.
• Was responsible for cube building using the Integration Services (EIS).
• Worked on uploading financial reporting information to EPM application using Hyperion FDM application.
• Was responsible for Creating Interactive dashboards using OBIEE for reporting
• Was responsible for mapping of the data through DRM.
• Was responsible for creating and testing new business rules and calculation scripts as per the needs of the users using Hyperion Planning.
• Customization of applications, smart lists, data forms, menus and dimensions where done through workforce planning.
• Was responsible for Installing, Configuration, Upgrading and Migration from Hyperion 9.1 suite to Hyperion 11.1(Oracle EPM).
• Was responsible for importing and exporting of the data using DRM from E-Business Suite.
• Was responsible for providing flexibility to business users to load data into the database based on the business unit's requirements.
• Used HAL to load members into Hyperion Planning application from SQL source.
• Was responsible for administrating the task of maintaining the server, providing user security and application maintenance.
• Was responsible for providing documentation, support and for users for Interactive reporting.
• E Business Suite is used in the back end to pull the Budget and Actual data.
• Integrated EBS with Hyperion DRM.
• Conducted boot camps for Installation of Oracle EPM (Hyperion v11.1) for the users and them to handle the configuration issues.

Environment: Hyperion Essbase 9.3/11.1,OBIEE, E-Business Suite, Hyperion Financial Reports Studio V9.3, Hyperion Analyzer, Hyperion Integration Services, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Windows NT/2003, Shell scripts.

Confidential, NY, NY

Sr. Hyperion Consultant

Responsibilities:

• Worked as an HFM administrator and created rules and give access privileges to the users.
• Was responsible for Designing and Reporting for forecasting using the Hyperion Intelligence designer 8.3.2.
• Worked on workforce planning to handle and forecasting of data for financial expenses.
• Was responsible for handling the administration of BSO cubes.
• Was responsible for creating an application for data analysis using DRM.
• Was responsible for creating and maintaining of web data forms and journals using HFM.
• Used Hyperion Planning 9.3.1 to create new web forms to reduce the work load of the user thereby focusing on a Planning, Budgeting and Forecasting.
• Responsible for system life cycle documentation (SDLC) for the changes made to the system.
• Was responsible for building financial reports for co-operate using Hyperion Financial Report.
• Was responsible to write and designing a test case strategy.
• Created new complex calc- scripts for data calculations for reporting purposes and also re-scripted existing calc scripts for more effective calculations.
• Responsible for Data Optimization and performance tuning for Essbase.
• Was responsible for transfer of data from General Ledger (GL) and ERP systems using DRM (Data Relational Management).
• Was responsible for developing dimension build rules, data loading and also maintain calc scripts via Esscmd and Maxl scripts.
• Was responsible for defining and creating batch scripts for automation in import and export using DRM.
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units.
• Created Dashboards for reporting using the Web Analysis.
• Was responsible for taking sessions for users for generating financial reports using Interactive reporting (BRIO) and financial reporting studios.
• Was responsible for leading the team to maintain and development of Essbase cubes.
• Created reports using Web Analysis for financial data.
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using the smart view for office.
• Was responsible for providing support for the project team for development until the production.
• Documentation of all the issues which could occur for the users and their respective solutions for was been created.
• J D Edwards is the ERP is used in the back end and Actuals data was pulled from JD Edwards table space.
• Integrated JD Edwards with Hyperion.

Environment: Hyperion Essbase 7.1.6/9.1, Clarity, Hyperion Administration Services, PeopleSoft, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, SQL, Windows NT/2003, Shell scripts.