PROFESSIONAL SUMMARY:

• Has 8 Years 4 months of IT experience in analysis, design, development and maintenance of various applications in Client/Server environment using Business Intelligence (OLAP) and Data Warehousing tools which includes Hyperion Essbase (6.x, 7.x and 9.x and 11.1.1.3), Hyperion Planning (9.3.x and 11.1.1.3) Finance Data Quality Management 9.3.1 (FDQM) and Oracle Data Integrator 10.1.3.5.
• He also has experience as Essbase Administrator and performed various activities like, Installation of Hyperion Products and handled Performance Optimization issues raised in the system like outline Optimization, Calculation script optimization.
• He is having good knowledge in building the Currency Databases in Essbase.
• He Acted as Onsite coordinator and Hyperion consultant for various clients.
• He also involved in building the offshore - onsite model for the setups, connectivity etc. He is Hyperion Certified Consultant
• Participated in all phases of Application Development (requirements gathering, source systems study, data quality analysis, data loading).
• Participated in multiple End-to-End implementation and Integration projects
• Has good experience in Migration projects
• Good experience developer documentation including Technical designs, User Guides, change requests and Test Scripts.
• Experience in preparing developer guidelines
• Experience in imparting training to end users.
• Good knowledge of Data warehousing and OLAP concepts
• Installation of Hyperion System ( 9.3.1, 11.1.1) on windows
• Good problem solving and analytical skills

TECHNICAL SKILLS:

Datawarehousing: Hyperion Essbase(V6.x,V7.x,V9.x,V11.x), Hypeiron Planning(V9.x) and V11.x), Hyperion Shared Services, Hyperion Workspace, FDQM, Hyperion Application Link, HFR, Web Analysis

ETL Tools: Oracle Data Integrator, Star Analytics

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Responsibilities:

• Involved in Monthend Close and Consolidation process and responsible for the Dataload
• Gathering Requirements for the COA Changes and Update of the Metadata and UAT
• Coordinating with the ETL team for the Submissions and reconcillation
• Migrated application of the application across the environments
• Preparation of quality documents and Design, Admin Documents
• Developed the Security mechanism for the user management
• Supporting the end user queries.

Environment: Hyperion Essbase, HFM, FDM, Smartview, Hyperion Financial Reports, ODI, SIS, Financial Reports

O/S: Windows Server 2003

Confidential, California

Responsibilities:

• Involved in End to End Implementation of Hyperion Planning
• Devoloped ETL Jobs using HAL for the Medata Updating
• Developed Web forms for the Dataload
• Developed Business Rules for the Labor Cost calculation
• Developed Calculation scripts for the allocation logic
• Migrated application from Dev to QA and Prod.
• Preparation of quality documents and Design, Admin Documents
• Developed the Security mechanism for the user management
• Supporting the end user queries.

Environment: Hyperion Planning 9.3.1,Hyperion Application Link, Hyperion Essbase 9.3.1, Hyperion Shared Services, Financial ReportsO/S: Windows Server 2003

Confidential, North Carolina

Responsibilities:

• Writing maps from source metadata to Confidential Metadata
• Creation of the Formats of the source files
• Writing the validation rules
• Training the users about the process of FDQM

Environment: FDQM 9.3.1,Hyperion Essbase 9.3.1 and SQL Server 2005

Confidential, North Carolina

Responsibilities:

• Involved in Requirement Gathering for Planning Requirements
• Involved in the Design of the Planning application
• Loaded Metadata using ODI
• Loading Data into Planning application using ODI
• Developed Smarlists in Planning Applications
• Developed Input mechanism with Data forms
• Loading the budget and Actual figures into Essbase
• Written Business rules for the Allocation and Reallocation Logic
• Written Maxl and Batch scripts for Loading Data
• Created Static Reports using Financial Reports
• Created Analytical Reports using Web Analysis
• Developed Test Methodology for the UAT.
• Solved the pending issues in the Customer P/L reporting in quick time
• Have done the optimization of calculation script which reduced to 2 hrs from 6 hours for the execution of script for the actual
• Prepared the plan for the migration and successfully done the upgradation of Essbase
• Migrated Essbase from 9.3.0.1 to 9.3.1
• Done the Transformations using ODI and loading data into Planning.

Environment: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1,Hyperion Shared Services, Web Analysis, Financial Reports, Oracle Data IntegratorO/S: Windows Server 2003

Confidential

Responsibilities:

• Went to Germany for the Application Study and brought the project from Germany to UK
• Acted as Onsite coordinator from UK to offshore team.
• Helped in getting the set up for the offshore
• Created the currency database for the currency conversions
• Restructuring of the databases based the requirements from client
• Creating and amending Calculation scripts based on the requirements
• Creation of the Calculation scripts for YTD calculations
• Running of batch scripts as and when necessary
• Export of the data from one database to another database through report scripts.
• Creation of Input sheets for the sales companies for data load
• Updating of VBA Macros depending of the requirement
• Helping the users for the submission of the data
• Answering the queries from the users about the retrieval of the data from Excel Add-in’s

Environment: Hyperion Essbase 6.5.7, Hyperion Excel Add-ins, VBA Macros

Confidential

Responsibilities:

• Provide business and financial users with an efficient robust system for Multi Dimensional Sales Analysis.
• Provide trend analysis capability by using time based measurement. I.E. Year on Year Value and Percentage variances.
• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts
• Identifying the root causes of issues that arise and provide improvements to avoid them. Automating the process using MAXL Scripts.
• Responsible for defining and implementing Security Matrix like creating users, groups and filters.

Environment: Hyperion Essbase 7.1.2, Excel Add-in,Hyperion Analyzer

Confidential, California

Responsibilities:

• Build the outline and rule files
• Developed calculation scripts and formulas
• Optimized the cube and calc scripts
• Developed the reports using Hyperion Analyzer
• Developed Security matrix
• Involved in automation using Maxl
• Developed scheduling methodology

Environment: Hyperion Essbase,Excel Add-in,Hyperion Analyzer

Confidential

Responsibilities:

• Analysis of the specifications provided by the clients
• Developing the HTML pages and Java Servlets
• Database management and JDBC connectivity
• Responsible for overseeing the Quality procedures related to the project.