SUMMARY

• 10 years of software industry experience with 8+ years of experience as a Hyperion Technical consultant in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase, EAS, EIS, Hyperion Planning, ODI, HFM, EPM, FDM, ESSCMD, MaxL, Essbase Query Designer, Hyperion intelligence, Hyperion Analyzer, Hyperion Reports, Hyperion Financial Reporting, Web Analysis, Essbase Excel Add - in and Smart view under Windows 2000/NT4.0, Linux and UNIX environment
• Experience in developing OLAP models and metadata outlines for loading dimensions and data into Essbase Cubes.
• Experience in creating business rules, manipulating and maintaining calculation scripts.
• Experience in design, development and implementation of various applications using Hyperion Essbase 11.1.1.x/9.x/7.x, Hyperion Planning, Hyperion Reporting and Analysis, ESSCMD, MaxL, Essbase Excel Add-In, on both Windows and Unix environment VBScript.
• 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.
• Excellent command over ESSCMD, MaxL for total automation of the process.
• Experience in Essbase Integration Services (EIS).
• Experience in optimization of Dimension building and Data loading
• Experience in providing support and maintenance for Hyperion Essbase Systems including both client/server level services and consulting.
• Expert in creating SQL Scripts for creating tables, views and stored procedures, loading data into tables.
• Worked in various environments of Development, Production-Support and Maintenance projects with excellent result-oriented approach.
• Worked on Database Optimization, Data Partitioning, Database Backups, performance tuning of Essbase application Data/Metadata processing, upgrading, testing and migrating of cubes in different environments.
• Expertise knowledge in Memory analysis, cache tuning, Configuration settings tuning, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc
• Extensive exposure to Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer/Web analysis
• Experience in handling data load through ODI, DIM, EIS, SSIS and FDM
• Experience in creating collaterals for client data validation and using Essbase Excel add-in & Hyperion Smart View.
• Experience in process automation using MaxL, ESSCMD, and Batch and UNIX scripts.
• Experience in writing queries, creating tables in Oracle/ SQL Server.
• Investigating the latest version of Oracle Essbase 11.X and Essbase Studio.
• Excellent technical and communication skills coupled with firm commitment to quality and team spirit.
• Developed Web forms using Hyperion Planning web client for the end users to input values and Forecast, Budget and Actual.
• Involved in Migration of Reports from development server to production server.
• Self-motivated, enthusiastic, performance oriented quality assurance expert with around 4 years experience in software Testing.
• Experience in complete Software Test process which includes Defining and maintaining QA artifacts i.e. (Test Strategies, Test Plans, Traceability, defect management and Metrics).
• Good experience in co-ordination, Team Work skills & interaction with the client/teams.
• Highly self-motivated and goal oriented professional
• Ability to make quick adjustments in focus and direction based on information that is being delivered

TECHNICAL SKILLS

Business Intelligence: Hyperion Essbase (6.5, 7.3, 9.3,11.1.x), Hyperion Planning (3.5, 9.3,11.1.x).

Tools: Hyperion Administration Services, Hyperion Financial Management(HFM) Shared services, Hyperion Data Relationship Management (DRM) / Hyperion Master Data Management (MDM), Integration Services, SQL, TOAD, Smartview for Office, Excel Add-In, Financial Reports, Quality Center, Crystal Reports, OLAP, MS Office

Scripts: MaxL, Microsoft Excel, VBScript, Shell Scripts, Perl, Batch Scripts & Excel Macros

Tools: Rational Rose clear case, clear quest, Quality Center, QTP, Visio

Functional Areas: People Soft, Supply Chain Management, HRMS, eCommerce, OMS

Database: Oracle 11g/10g/9i, MS Access, SQL Server and mySQL

Productivity Tools: TOAD, Unix Shell scripts, PL/SQL, SQL*Plus, Send Master

Languages: C, C++, VC++, VB.NET, PL/SQL, HTML, XML

Operating Systems: Win NT, Win 98/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Costa Mesa, CA

Hyperion Techno-Functional Lead

Environment: Hyperion Planning V 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, Oracle Database 11g.

Responsibilities:

• Pull metadata from FRA and GBC business unit hierarchies from a DRM extract file.
• ODI utilized as the ETL tool to build hierarchies.
• Based on HR information transforming of employee metadata like Employee ID as member . Concatenation of Position and Grade
• Load rules to load data into individual employee and Postion.Grade by CostString.
• Account Security by Cost String. Control READ/WRITE access to Scenarios, versions and Baseline accounts.
• Assist with migration planning artifacts from one environment to another.
• Test Plan, Training and Final Administrative document preparation
• Created new scripts and optimized existing scripts like Merit, benefits, OPE, OPE%,Pension NI. Allocation of Head Count. Aggregation Scripts.
• Audit trailing enabled throughout the file transfer chain.
• Error files and log files will be generated and contained in a directory.
• Level 0 backup of data, Application backup .
• Wrote batch commands and scripts in MaxL to be called by windows scheduler
• Extensive experience in Essbase retrievals, Lock and Sends, Multi form retrievals.
• Creation of 10 webforms for each of the 7 applications created for UK,US and GTS.
• Performance Tuning of Calculation scripts.

Confidential, Chicago, IL

Hyperion Technical Lead

Environment: Hyperion Planning V 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Developed EPMA application in Hyperion System 11.1.2.1, Configuring Hyperion Essbase
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes
• Created Organizational detailed and Financial reports for 10 year Depreciation projections using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts for SLN Depreciation calculations, Transfer of Assets and Retirements.
• Created web forms for showing 10 year projections of Forecast/Plan, Project ID creation, Variance Reporting and Summary Reports.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Performance Tuning of Calculation scripts.
• Provided training to end users in using the Samrtview add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Worked with the Infra team to assist with migration of Applcation from one environment to another, Generated dimension outline extract using LCM.

Confidential, Chicago, IL

Hyperion Technical Lead

Environment: Hyperion Planning V 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Developed application in Hyperion System 11.1.2.1, Configuring Hyperion Essbase,
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in Ess Cmd and MaxL
• Extensive experience in Essbase retrievals, Lock and Sends, Multi form retrievals.
• Responsible for dimension builds, Parallel calculations, Business Rules and member formulas.
• Performance Tuning of Calculation scripts.
• Experience in Building dimensions using Load Rules File, Load data using Rules files, two pass calculations.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created planning applications using EPMA and Planning studio.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Generated reports relating to Income statement and Balance sheet using Financial Reporting Studio
• Provided training to end users in using the Samrtview add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.

Confidential, Chicago, IL

Sr. Hyperion Essbase / Planning Consultant

Environment: Hyperion Planning V 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.1.3, Hyperion Interactive reporting 11.1.1.3, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Developed application in Hyperion System 11.1.1.3, Configuring Hyperion Essbase, Essbase integration services, for the end users.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
• Hyperion Planning application to consolidate the Planning data from all its markets across the globe.
• Managed Enterprise Performance Management Implementation practice.
• Coordinated with DRM and ETL team.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Created Data integration process to load data from file systems into Hyperion Planning using Oracle Data Integrator (ODI).
• Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Extensive experience in Essbase retrievals, Lock and Sends, Multi form retrievals.
• Responsible for dimension builds, Parallel calculations, Business Rules and member formulas.
• Performance Tuning of Calculation scripts.
• Experience in Building dimensions using Load Rules File, Load data using Rules files, two pass calculations.
• Creation of planning models, data integration components.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• UtilizedODIto load data from Oracle GL and Legacy systems intoplanning. Responsible for setting up all dimensions, members and measures.
• Configured ODI agent and leveraged LKM modules to define workflow and task automation.
• Used Journalization feature of ODI in-order to keep track of changes in data at the source level
• Used Operator GUI to schedule and automate data load processes through ODI
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created planning applications using EPMA and Planning studio.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Generated reports relating to Income statement and Balance sheet using Financial Reporting Studio and Interactive Reporting Studio.
• Generated reports relating to Revenue analysis using Web Analysis Studio.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Provided training to end users in using the MS Excel spreadsheet add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.

Confidential - Farmington Hills, MI

Sr Hyperion Consultant

Environment: Hyperion Essbase 6.5, Hyperion Planning 3.5.1, Hyperion Reports 7.0, Hyperion Analyzer/Web Analysis, Windows 2000, Web Logic, Excel Add-In, Business Objects, MaxL & VB Script, Microsoft Project, MS Excel, Office, Calculation script, Visio, SQL, PL/SQL, ETL, SQL Server, PowerPoint, SharePoint, Rational clear case, clear quest.

Responsibilities:

• Created numerous reports in Financial Reporting Studio on Income Statement, Statistics, Net Revenue, Net Income and Expenses to calculate Budget and Actual: Summary and Detailed reports, Monthly and Quarterly reports, Consolidating and combined reportsExtensively worked with Excel Add-In, Smart View, Hyperion Workspace, Hyperion Reports and Hyperion Analyzer
• Provided technical support to all business units, offered suggestions and proposed solutions to resolve issues
• Managing monthly load of actual from source systems.
• Developed the HAL routines to automate the dimension building
• Modified Business Rules to cater to the changing business requirements
• Created users, user groups and administered security for multiple applications
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Ensuring proper collection and consolidation of data for reporting.
• Design, code and testing functions, technical requirements Hyperion planning and budget module.
• Involved in the new Planning cube build process
• Configured complex rules files for attribute, alias and consolidation property associations
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Developed various MaxL and Shell Scripts to automate data loads and partitions
• Created Essbase outlines based on report specifications and schema delivered
• Performed member and data loads in Essbase Integration Services
• Involved in setup and security measures and granted access to users and assigned then to specific user groups through Shared Services based on their needs
• Provided Essbase administration and optimization training to resident technical resources
• Developed and administered reports with Hyperion Analyzer/Web Analysis and Hyperion Reports. Built simple and complex views of data; created spreadsheet reports, graphs, and pin board displays; set traffic lighting; and managed formats
• Supporting month end Financial Reporting activities

Confidential - EDINA, MN

Hyperion Planning/Essbase/Reports Consultant

Environment: Hyperion Planning V 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.1.3, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Responsibilities:

• Optimized and rewrote MDX codes in ASO member formulas in Hyperion System 11.1.1.3.
• Restructured ASO cubes as a part of optimizing ASO applications to bring down runtime and database size considerably.
• Changed Compression Dimension and used TB properties to enhance performance.
• Designed and materialized aggregation using query tracking and ratio method and automated the aggregated view creation.
• Wrote aggregation script in MaxL. And was involved in the Automation using MAXL Scripts and scheduling the batch scripts.
• Involved in the creating Filters and assigning filters to users in Essbase for ASO Cubes.
• Extensively involved in performing DBA activities like performance tuning the Calculations scripts, database tuning, and taking the Essbase backups and maintenance of previous Essbase cubes.
• Loaded the Actual Data on monthly basis into Consolidation Application.
• Worked on financial reporting. Build various reports using Prompts, User POV, Grid POV, Conditional Suppression, and Conditional Formatting and used formula in it according to the recipe provided by users.
• Worked on creating Smartview reports. Build complex Smartview reports which had complex formulas, display sheet used to pull data from various other sheet which were for data retrieval or for complex formulas. An input sheet was provided for reducing the effort for user to change the month and year in each cell, helping reducing the error caused by them in changing and providing fast and accurate reports.
• Changed solve order in ASO Cube for easier maintenance and support two pass calculation accordingly.
• Updated ASO cubes to synch with new changes in production, Performed unit testing and bug fixing.
• Assisted migration of cubes from staging to production servers.
• Documented all changes made to the ASO cube as a reference for the end users and for easier maintenance.

Confidential, CA

Essbase Planning Consultant

Environment: Hyperion EPM System11.1.1.2, Hyperion Planning 9.3.1, Essbase Administration Services 9.3.1, Integration Services 9.3.1, Essbase Shared Services 9.3.1, Oracle Hyperion Essbase System 9, Excel Add-In,Hyperion Financial Reporting Studio

Responsibilities:

• Created Essbase outlines based on report specifications and schema delivered
• Performed member and data loads in Essbase Integration Services
• Involved in setup and security measures and granted access to users and assigned then to specific user groups through Shared Services based on their needs
• Created numerous reports in Financial Reporting Studio on Income Statement, Statistics, Net Revenue, Net Income and Expenses to calculate Budget and Actual: Summary and Detailed reports, Monthly and Quarterly reports, Consolidating and combined reports
• Extensively worked with Excel Add-In, Smart View, Hyperion Workspace, Hyperion Reports and Hyperion Analyzer
• Provided technical support to all business units, offered suggestions and proposed solutions to resolve issues
• Involved in migration of cubes from version 9.3.1 to version 11.1.1.2
• Involved in Aggregate Storage and Block Storage Cube development and maintenance
• Responsible for creating and modifying Essbase load rules, complex calculation scripts, report scripts, outline formulas, and MDX formulas for new requirements
• Optimization, performance tuning and maintenance of Hyperion Essbase, Planning and Finance applications
• Wrote number of Business Rules for P&L application
• Responsible for creating partitions to improve performance
• Developed various MaxL and Shell Scripts to automate data loads and partitions
• Involved in creating OLAP models and meta outlines using EIS. Created various filters in EIS as per user requirement

Confidential

QA Engineer - Testing

Environment: Peoplesoft 8.0, TOAD 8.6, Quality Center 8.0, SendMaster

Responsibilities:

• 1.Verify that the overall functionality and operations of the PeopleSoft modules are consistent with the business rules and requirements as permitted by the restrictions of the current test environment.
• 2.Coordinate testing efforts with the development and user acceptance teams to ensure that all business requirements are met.
• 3.Confirm PeopleSoft developed interface code works as expected in a standalone environment prior to integrating into external systems.
• 4.Integration Testing will test end-to-end functionality. This test will include the integrated testing of the interfaces.
• Integration Test will provide testing for all systems included in the scope for the release.
• 5.Involved in test case review process and modified them according to testing needs.
• 6.Test execution is done from test lab in test director after creating test sets for each test phase
• 7.Performed component, system and regression tests
• 8.Reported defects to development team through Test Director.
• Provided daily status to Test lead/ Manager