SUMMARY

• Over 8+ years of total IT experience of which over 6+ years of experience in design, analysis, development and implementation of various applications in Client/Server environment using ETL, Hyperion Essbase 11.x,9.x, & 7.x, Hyperion Planning, Hyperion DRM, Hyperion Reports, ESSCMD, MaxL,Essbase Excel Add in, Essbase Query Designer, under Windows 2000/NT4.0 and Unix environment.)
• Experience in providing services related to Hyperion BI Platform OLAP Essbase server & Client tools such as Application manager, Integration Services, Planning, and Administrative Services, that combines data integration, metadata management, and online analytical processing (OLAP) with query and reporting.
• Proficiency in Oracle Hyperion Data Relationship Management (DRM) solutions. Expertise in using DRM for managing users, properties, verifications and validations, managing system categories, node types, migrating DRM metadata, working with formulas and transaction requests.
• Involved in different Hyperion Planning application integration, migration and production support.
• Excellent proficiency in Hyperion Planning web - forms (Planner group, admin group).
• Developed Foreign Exchange rate web-form to support multi-currency budget application without using in-build multi-currency budget functionality in Hyperion Planning.
• Implemented Driver based methods using smart list in Hyperion Planning for various calculation. To support Salary calculations (% Sal per year, % Sal per month), Headcount Adjustment, Salary Band.
• Excellent proficiency in Business rules.
• Developed Hyperion Planning Security.
• Involved in Hyperion Planning application migration for QA and Production environment.
• Excellent proficiency in Hyperion Planning end user (Financial Users) training, training documentation and daily production support.
• Implemented Workforce and CAPEX planning and customized the plan types according to client’s requirement.
• Developed generic scripts to take back up for Hyperion Planning Applications (Essbase cubes & Relational Database).
• Developed Error log reporting system to send out to user before the scenarios occur during Actuals load in Hyperion Planning.
• Excellent proficiency in both Star Schema and Snow-Flack Schema data modeling techniques.
• Having Strong knowledge and expertise in Optimization of Dimension Building and Data Loading.
• Excellent control over ESSCMD for total automation of the process.
• Strong in developing Use Case Model, Analysis Model, Design Model, Implementation Model.
• Excellent knowledge of data analysis and modeling.
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Meta Data Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
• Having extensive experience in integrating Business Analysis, Multi-Dimensional Modeling using Hyperion Essbase, creating, manipulating and maintaining calculation scripts (Calc Scripts) using Planning, Business Rules and creating reports using Hyperion Reports to help financial facilities and other business logics in an organization. Executed data migration between different Hyperion applications.
• Involved in Hyperion Applications Development and Production Support. Experience in providing Support & Maintenance for Hyperion OLAP Essbase Systems, including both client and server level services and consulting.
• Expertise with Microsoft Office tools
• Experienced in ETL and ELT process related to ODI for metadata loading and data loading for Hyperion planning and Essbase.
• Experienced in ETL purely custom based design, development and implementation on Oracle 10g platform.

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Planning 11.x/9.x, Hyperion Essbase 11.x/9.x/7.x, Essbase Administration Services (EAS), Analytic Integration Services (AIS /EIS), Workspace, Essbase query designer, Integration Services, Performance Management, Oracle Data Integrator (ODI)

Reporting Tools: Web Analysis, Smart View, MS Excel Add-In, Interactive Reporting and Hyperion Financial Reporting (FR)

MS Office Tools: MS Office Suite 2010/2007/2003/2000.

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, Shell Script.

Modeling Tools: Star schema, Snowflake schema, Dimension and Fact tables, Logical andPhysical Modeling

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

Operating Systems: Windows NT/2000 /XP/Server 2003/2008, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

DRM Architect /Sr. Essbase Consultant

Responsibilities:

• Updated the OD( Confidential ) Metadata, added new metadata, changed existing properties by using action scripts.
• Added newhierarchiesto hierarchy group.
• Combined the OD( Confidential ) and OMX(Office Max) hierarchies.
• Created a new hierarchy group for export.
• Created new property category/property definition for the new Essbase cube.
• Modified the current validations.
• Created new queries for selective export.
• Analyze the currentvalidationsand turn on off depending on adding newproperties/validations.
• Created new external connections to export the metadata.
• Created Export book and different exports for each dimensions.
• Metadata migration using Version Backup and Restore functionality of DRM to UAT/Production.
• Exported Properties/Exports using the DRM Migration Utility.
• Update the existing HFM DRM design to support building the new Finance cube in Essbase.
• Identify the additional attributes/flags/ fields that are needed to support the new Finance cube Essbase build .
• Tag existing HFM metadata that will be used for the new Finance Essbase cube.
• Add a new dimension and metadata for Location.
• Populate OD locations from the FMR DRM application (extract FRM DRM location hierarchy and members and load into HFM DRM application).
• Populate OMX locations from Excel spreadsheet.
• Expand the existing cost center dimension by approximately 750 members.
• Populate using an Excel spreadsheet OD and OMX Locations and Cost Center.

Environment: Oracle Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2 Essbase Administration Services (EAS), Oracle Hyperion Shared Service 11.1.2.2, Hyperion DRM 11.1.2.2 Excel Add-in, Smart View, Microsoft Office Excel/Word.

Confidential, Bentonville, AR

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Assisted in Migration from Hyperion 9.3.1 to Hyperion 11.1.2.1.
• Responsible for gathering and analyzing requirements for the Business Management module.
• Managed access to Data Forms and Folders including assigning access and changing access using Hyperion Planning.
• Extensively involved in importing and exporting Access Permissions.
• Created Rule files using SQL queries to pull data from the SQL Database.
• Created View from various table to feed the Essbase system using SQL queries.
• Wrote complex SQL queries using Inner join and Outer join.
• Worked on creating and initializing Workforce Planning application.
• Worked on customization of Business rule and web forms on out of the box one that got created during Workforce initialization.
• Customize dimensions, smart lists and UDAs which are created after initialization of workforce planning.
• Modified Labor applications Web forms and Business rules for workforce database.
• Involved in assigning access and groups to various users of the company and maintained the applications securely using Hyperion Shared services.
• Creating and customizing data forms, asymmetric and Composite data forms, creating business rules with runtime prompts, creating task lists, managing the review cycle for planning units and review budget data by using process management, creating substitution and user variables.
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Managed Security Filters using Planning Administration.
• Created and provision users with necessary roles on applications using Hyperion Shared Services.
• Developed Essbase ASO Cubes for Department Level and Store Level for Confidential Stores in the entire United States.
• Developed outlines, MaxL Scripts, Rules Files for loading dimensions and data into Essbase cube.
• Developed Report Scripts for different SBU’s (Sales Business Unit) of Confidential in the entire United States.
• Developed Report Scripts for different GBU’s (General Business Unit) of Confidential in the entire United States.
• Developed Rules file for specific requirement so that Alias name is displayed as per requirement.
• Developed batch scripts using MaxL for the automation of various processes.
• Optimized outlines to have faster data loads, calculation and retrievals.
• Worked extensively on security and access settings for the reports and cubes in Workspace and Shared Services.
• Migrated application from test to pre-prod and production.
• Testing to validate data provided by mainframe in excel add in.

Environment: Oracle Hyperion Essbase 9.3.1/ 11.1.2.1 , Hyperion Planning 9.3.1/11.1.2.1 Essbase Administration Services (EAS), Oracle Hyperion Shared Service 9.3.1/11.1.2.1 , Excel Add-in, Smart View, Microsoft Office Excel/Word.

Confidential, Chicago, IL

Sr. Hyperion Essbase/Planning/DRM Architect

Responsibilities:

• Created Map reporting application design for reporting purpose from one BSO cube to other BSO cube and BSO cube to ASO cube.
• Worked on migration of applications form one environment to other. Migrated application from development server to Pre-Production.
• Worked on creating various financial reports on FR studio.
• Worked on migration of reports and providing the security to different groups.
• Worked in creating the security file and importing it in planning for different environment. Using command utility for importing the sec file.
• Worked on creating the security filters for Essbase and importing them.
• Worked on metadata building and data loading using outline load utility for various dimension for different applications. Created various shell scripts for different dimensions.
• Worked on customization of workspace logon page and panel. Made changes in css file to create different themes.
• Build rule files and passed on different parameters for loading data.
• Worked on creating ASO cube for reporting purposes. Designed, Developed ASO cube and customized the hierarchies according to the requirement.
• Performed optimization on ASO cube and BSO cube. Developed the script for ASO cube for optimization and incremental load.
• Worked on creating Calc scripts. Some were developed for aggregation; some for data export in customize form.
• Worked on developing Business rule for allocation purposes, calculated expense.
• Developed training material and presentation for end user training.
• Provided User training and workshop, in that helped troubleshooting their problems and to get them use to new tool.
• Worked on installation and configuration of Hyperion Product Essbase and planning in Linux single server as well as clustered servers using GUI interface.
• Actively performed tasks. Involved in meetings with users for gathering requirements for implementation.
• Build shell scripts and MaxL script for automation of data loads and metadata loads.
• Involved in gathering requirements for user grouping and for building and redesigning exports in DRM.
• Created version and Hierarchies in DRM.
• Loaded the data by Automator and also by creating import profile in DRM.
• Created properties and categories in DRM.
• Built the logic for the hierarchies in DRM.
• Configure the applications so the users could see all the metadata at loci in DRM.
• Created both Read only hierarchies with no export profiles and also hierarchies with export profiles in DRM.
• Done incremental loads in DRM.
• Worked on security in DRM.
• Scheduled tasks in DRM using windows scheduler.
• Created a release document for deploying the hierarchy in DRM production environment.

Environment: Hyperion Essbase11.1.2.2, Hyperion Planning 11.1.2.2, Hyperion DRM 11.1.2.2, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.2, Oracle Database 11.2.0.3, Windows Server 2008, LINUX 5.3, MS Excel 2010.

Confidential, Dallas, TX

Sr. Hyperion Essbase/Planning/DRM Architect

Responsibilities:

• Working as an individual team/developer for various major projects, involved in application design and process flow model to meet detail technical requirements to serve as implementation guidelines.
• Responsible for gathering and analyzing requirements for the Business Management module.
• Assisted in migrating from 11.1.1.3 to 11.1.2.1
• Created the financial budgeting and planning process of the firm by interfacing with users, planners, and administrators of the system.
• Identified various planning units of the business and translated them into Dimensions and Members (Scenario, Version and Entity) of Hyperion Planning application and Essbase database
• Created planning application and data load processes using EPMA.
• Checking Error File for Dimension build, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Developed data forms, task lists, calculation scripts, runtime prompts, and menu lists for the users to enable them to enter financial data into the system.
• Developed Web forms using Hyperion planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• Developed business rules that calculate an assortment of financial data and also replicate the formula processing capabilities of Excel.
• Involved in performing DBA activities like create users, password setting, group and filters.
• Worked on FDM application and developed oracle GL interface to load data in planning application.
• Built summary financial reports for the upper management and comprehensive reports for the daily users by using Web Analysis and Smart View.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Identified and allocated proper access and security measures to different types of users in the company per the needs of higher management.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Written MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes.
• Created Pivots and Charts using Web Analysis.
• Extensively used Traffic Lights in Web Analysis Reports.
• Exported and Imported reports from different Workspace environment (like Dev, test and prod).
• Created and maintained connection for reports in Workspace.
• Build complex Smart view reports and data entry templates which had complex formulas and display sheet, used mainly for data retrieval for other sheets containing 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.
• Lead the Hyperion training program at the company aimed at providing initial overview of Planning features to the power users and navigating the application
• Providing technical guidance and support to end-users by developing appropriate documentation
• Involved in the configuration of the new Hyperion DRM system.
• Gathered the requirements for developing versions/Hierarchies.
• Developed brand New Hierarchy in DRM by using importing.
• Created derived and defined attributes which are required for the DRM system and for the hierarchy maintenance in DRM.
• Developed exports for the data validation and the maintenance of the metadata.
• Created validations in DRM.
• Created defined properties that club multiple properties from Feed systems.
• Created Sort by property for the Sorting order to be in control.
• Categorized the exports based on each version by creating books.
• Created node types and associated them with Property categories for populating property categories.

Environment: Hyperion Essbase 11.1.1.3/11.1.2.1 , Hyperion Planning 11.1.1.3/11.1.2.1 , Hyperion DRM 11.1.2.1, Web Analysis, Essbase Administration Services (EAS), EPMA, FDM, Shared Services, Smart View, Web analysis, Oracle Database 11g, MS Excel 2010.

Confidential, Memphis, TN

Sr. Hyperion Essbase/Planning Developer

Responsibilities:

• Translated end user requirements into application design specifications, assuring optimal match between requirements, cubes, outlines and report specifications
• Involved in Performance tuning and Performance monitoring for satisfying the users reporting requirements, including Error Handling, Troubleshooting, handling restructuring and server problems.
• Created planning applications using outline load utility.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Assigned user access and privileges on Web Forms and Business Rules
• Involved in the development of new cubes and modifying existing cubes. Optimized cubes by altering the Dense/ Sparse settings for the different Dimensions
• Responsible for migrating cubes to production server for the sales department, which used Hyperion Essbase as their OLAP server.
• Developed outlines, Calc scripts, data load rules for loadings
• Created various rules files for dimension building, data loading.
• Created queries using Essbase Query Designer to retrieve dimensions, database members into worksheet.
• Performed optimization for various data load rules and Calc scripts.
• Enhanced the existing Hyperion planning application to support Workforce Estimation (WFE).
• Created reports to analyze P & L at customer and product levels using Web Analysis.
• Created reports in Excel by accessing data through relational, multidimensional, BI sources.
• Performed database tuning by setting appropriate index, data and Calc cache.
• Updated User security through Shared Services and integrated it with ODI.
• Designed and developed ASO and BSO cubes for optimum analysis, performance and reporting needs.
• Developed Interactive Reports such as net margin, various reports for credit, debit, liability, variance reporting, product line analysis reports and product hierarchy reports.
• Created key performance indicators reports using interactive reporting.
• Used various conditional numeric functions to add computed columns in query, result, pivot and reports section in Interactive reporting and did problem solving and Query Tuning while report generation.
• Combined tables, Queries, Pivot, and charts into dashboard and wrote scripts to drill down in dashboard for Interactive reporting.
• Trained reporting analysts on Hyperion reports for a gradual shift to Hyperion Reports as against the traditional excel spreadsheets.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Workspace 11.1.1.3, Hyperion Shared services 11.1.1.3, Oracle Data Integrator 10.1.3.4, Hyperion Planning 11.1.1.3, ESSCMD, Hyperion Interactive Reporting Studio 11.1.1.3, Oracle 11G, PL/SQL, Excel Add-in, IIS, Windows Server 2003.

Confidential, Parsippany, NJ

Hyperion Essbase Developer

Responsibilities:

• Developed rule files for automating the data load as against the ‘lock and send’ procedure used by the company.
• Developed complex Calc scripts that were used to allocate the values to leaf level members in Block Storage cube.
• Optimized applications by balancing out the block size with Sparse/Dense dimension alterations.
• Developed MaxL scripts to automate the process of dimension build and data loading.
• Optimized the Calc scripts resulting in the reduction of calculation time from 2 hrs. to 45 mins
• Involved in taking regular backups and restores of Essbase application. Implemented robust data access security and user management.
• Converted BSO cubes to ASO cubes for aggregation and reporting purpose using Query tracking method.
• Designed aggregated view for optimization.
• Created member formula for calculation purposes.
• Involved in creating filters and assigning filters to users in Essbase for ASO cubes.
• Worked on financial reporting. Build various reports using User POV, Grid POV, Prompts, conditional formatting and conditional suppression according to requirements provided by users.
• Built summary financial reports for upper management and comprehensive reports for the daily users using Hyperion financial reporting studio.

Environment: Hyperion Essbase 9.3.5, Hyperion Financial Reporting Studio 9.3.5, Excel Add-In, Windows NT 4.0, Oracle 10g.

Confidential, Buffalo, NY

Hyperion Essbase Developer

Responsibilities:

• Designed, developed, and implemented multi-dimensional database application using Essbase.
• Designed and developed monthly, quarterly and yearlyRetail P&L Cubes.
• Developed Calc Scripts to calculate various figures for the outline.
• Developed and maintained Rule files, Calc Scripts, EssCMDs & MaxL Scripts.
• Automated the Essbase Cubes using EssCMDs and Batch Scripts.
• Developed and optimized Data Loads and Calculations.
• Optimized the Dense/Sparse configuration in the BSO cube.
• Preparing Relational Data Sources, Consolidating Relation data & developed the OLAP model & Meta -Outlines, Implemented Star Schema and used EIS to interface with the company’s existing Oracle data warehouse.
• Developed the PL/SQL stored procedures for implementing the business logic.
• Constructed Oracle Database Triggers and Indexes.
• Responsible for Code Reviews and PL/SQL Code Tuning.

Environment: Hyperion Essbase 9.3.5, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, Oracle 8i, PL/SQL.

Confidential, Jacksonville, FL

Hyperion Essbase Developer

Responsibilities:

• Involved in defining designing documentations and testing strategies
• Developed outlines, Calc Scripts, data rules for loading, EssCMDs Scripts
• Created Essbase outline formulas and Calc Scripts using advanced Calc Script functions
• Debugged and optimized data loading by grouping, positioning
• Produced ad-hoc reports by dynamic on-line querying in Analyzer
• Developed two cubes - one for Xomed Sales, one for Production, Planning and Budgeting
• Retrieving reports using Excel Add-in and generating batch reports using Hyperion Reports
• Maintaining the OLAP application and taking regular backups
• Thorough internal training and practical experience got familiarized with budgeting system, mainframe applications and the General Ledger database.

Environment: Hyperion Essbase 7.x, MS-Excel 2000 Spreadsheet Add-In

Confidential

Database Developer

Responsibilities:

• Performed system study, designing and developing databases and stored procedures in SQL.
• Responsible for Code Reviews and PL/SQL Code Tuning.
• Developed Test Plans.
• Developed the on-line context-sensitive user help.
• Developed test cases/scripts based on defined business/functional specifications and user cases.
• Worked on Data warehousing designer, Mapping Designer, and Transformations.
• Used the repository manager to give permissions to users, create new users.
• Tested all the significant fields to extract and extensively involved in extraction of the different flat files, Oracle RDBMS and MS Access.

Environment: SQL Server 6.5/2000, Oracle 8i, Oracle Developer, MS Access.