SUMMARY

• 7+ years of experience including Hyperion ranging from Essbase, Planning to Hyperion Financial Management. This covers many fields like Retail, Financial, Pharmacy, Insurance, Manufacturing, communications etc.
• Extensive hands on technical experience in many aspects of Data Warehousing and OLAP software systems in analysis, design, development, implementation, reporting, administration and consulting in a Client - Server environment.
• Hands on Experience in Hyperion Essbase v 11.1.1.1/3/2 / v9.3.1/v7.1.5 and Planning (Budgeting and Forecasting) 11.1.1.3/11.1.1.2/9.3.1 which includes all phases through Application Development, Testing, Report Building to Production support on Windows and UNIX Environment.
• Proficiency in Workspace, EPMA11, Workforce Planning, CAPEX in Architecture, Shared services, Hyperion Application Link, EIS, EAS, Load Rules, Business Logic, Essbase API, Excel VBA, MDM/DRM on windows and UNIX systems.
• Developed Hyperion Reporting Tools like Excel Add-In, Smart view, Hyperion Financial Reporting, Hyperion Interactive Reporting and Hyperion Web Analysis according to the Business needs.
• Architected framework for automation using Hyperion scripting (MAXL, ESSCMD, VB, CALC and MDX scripting).
• Has a sound base in tools like Databases (Oracle, SQL, DB2 and MS Access), ETL (Informatica), QA etc.
• Expert in Essbase Cube Analysis, Design & Maintenance, Essbase Database Administration upgrades, Database backups, Performance tuning and Optimization.
• Created the Meta Data using EPMA (Data synchronization, ADS files), Essbase Studio, Planning (Outline Loader, HAL and ODI) and in Essbase (EIS, Text files).
• Expertise in Star and Snow flake Schema Modeling in Essbase Integration Services (EIS), E-R modeling for RDBMS Data Sources, and various tools for automation of OLAP.
• Designed and developed ESSBASE cubes using Block/Aggregate storage technologies with excellent balance of dense and sparse dimensions allocation strategy, developing various OLAP Models and Meta-Outline.
• Expert in developing Hyperion Planning Forms, application security process, creating users/groups, security profiles and application access to different groups using filters.
• Knowledge of Essbase Integration Services and Partitioning (using Transparent, Replication and Linked Techniques).
• Migration of the Hyperion Applications from one environment to the other using different file transfer methods.
• Drill thru implementation in ASO cubes for drilling down to ledger details.
• Experience using Hyperion Data Integration Management (DIM) with its adapters to load data into a Planning cube using the Informatica.
• Experience in installation, configuration, server settings, and backups, client installations of Hyperion products such as EssBase, EssBase Integration Services, Analyzer and Hyperion Reports on both Windows and UNIX environments.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle, SQL Server, DB2 databases.
• Familiar with the SDLC methodology of system development.
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Self motivated and committed person with strong communication and analytical skills. Ability to work in a time-constrained and time-oriented environment.

TECHNICAL SKILLS

OLAP: Hyperion Essbase 11.x/9.x/7.x/6.x, Spreadsheet Add-In, Essbase Administration Services, Hyperion Planning, Hyperion Performance Suite, Hyperion Intelligence, ESSCMD, MAXL, MDX, Hyperion Objects, Hyperion Portal,Essbase Partitioning, Hyperion Essbase SQL Interface, Hyperion Essbase API, Hyperion Currency Conversion, Essbase Calc & Report Script.

BI Tools: Hyperion System 9 BI+, Hyperion System 9 Planning, Hyperion Interactive Reporting, SQR Production reporting.

Reporting Tools: Hyperion Web Analysis, Hyperion System Interactive Reporting, Hyperion Smart View, Hyperion Analyzer, Excel Add-in.

Dimensional Modeling: Start-Schema Modeling, Snowflake Modeling.

ETL Tools: Informatica, Data Stage.

GUI: Visual Basic 6.0/5.0, LABVIEW, MATLAB.

Scripting Languages: MAXL, ESSCMD, CALC scripts, MDX, PL/SQL, C, C++, HTML, DHTML.

Databases: Oracle, MS Access, MS SQL Server 2000/2005.

Operating Systems: MS-DOS, UNIX (Solaris, Linux), WINDOWS 98/2000/NT 4.0/XP.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Hyperion Essbase Developer

Responsibilities:

• Involved in requirements gathering, design, and implementation of various multidimensional cubes using Hyperion Essbase v9.3.1.
• Developed outlines from scratch for ASO and BSO applications depending on the business changes.
• Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an ESSBASE Applications by means of several build methods such as generation, level and parent-child s.
• Timely implementation and monitoring of incremental data load into various cubes and as part of the regular maintenance using manual and automation process.
• Modified the existing Outlines, Metadata, Member formulas and Rule files as business requirement changes for the FY12.
• Writing MAXL scripts to automate calculation scripts and also data load into ESSBASE database using Rules files.
• Developed and manipulated Calc Scripts to improve Essbase database performance.
• Applied security on different applications by creating Filters on its dimension members.
• Created Transparent Partitioning on databases using MAXL scripts.
• Performance optimization by tuning the caches.
• Drill thru implementation in ASO cubes for drilling down to ledger details.
• Involved in upgrade from 9.3.1 to 11.1.1.3.
• Architected framework for automation of cubes using Batch scripts/shell scripts and MAXL for refresh of development with production data.
• Handled weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Involved in several meetings with SAP and PeopleSoft teams regarding Rule Files, Data Files.
• Excel Add-In and smart view are used as the reporting tool in the enterprise.
• Developed technical documentation for different cube loading process.
• Providing support to the Hyperion user community with technical guidance and required documentation.
• Creating complex Store Procedure, Triggers, Cursors, Tables, Views and several other SQL statements and Joins for applications.

Environment: Hyperion Essbase v9.3.1, Oracle 10g, SQL Server 2000, Excel Add-in, Smart view, MAXL, Calc script, PL/SQL, SQL*Loader, Toad.

Confidential, Rochelle Park, NJ

Responsibilities:

• Created the Planning application for Multi currencies.
• Ability to do budgeting and forecasting at the country, entity, business unit, multiple currency and department level with the ability to generate reports at these levels.
• Created Users and Groups in Hyperion Essbase, Hyperion Reports and Hyperion Analyzer and assigned privileges to them.
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Created various ASO and BSO applications in Essbase.
• Developed Outline building and Data Loading using rules file for BSO cubes, calculation scripts, report scripts, MDX queries and formulas for dimension members.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Ability to create and manage flexible workflows as it pertains to the budgeting and planning process.
• Involved in assigning security for Hyperion Planning application using Hyperion Shared Services.
• Applied security on different applications by creating Filters on its dimension members.
• Developed EIS Meta-outline for the cube and created various filters as per user requirement.
• Used HAL, EIS to load data values, accounts, entities, and custom dimensions from flat file into Planning Cube.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server.
• Installation and Configuration of the Development server consisting of Hyperion ESSBASE, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Hyperion Reports, Web Analysis and Workspace.
• Develop Business Rules to copy data from one version to another using Run-time prompts.
• Migration of the Planning Application from Development to Production.
• Performance optimization by tuning the caches.
• Developed PL/SQL scripts for back end validation/ updates.
• Maintain Outline, Metadata, Member formulas as business requirement changes.
• Meta data is developed in Hyperion Planning for the Planning, actual or Budget data and loading the data.
• Designed Reports as per user requirement using Hyperion Reports.

Environment: Hyperion Planning 11.1.1.1/3/2 , Hyperion Essbase 11.1.1.1/3/2 , Hyperion EPMA 11.1.1.1/3/2 , Hyperion Analytic Administrative Services, Shared services, Hyperion Web Analysis, Smart view, Financial Reporting, Hyperion Application Link (HAL), Business rules, Calc Scripts, MAXL, VBA, PL/SQL, SQL*Loader, Toad, Unix, Oracle10g.

Confidential, Greensboro, NC

Hyperion Consultant

Responsibilities:

• Created Aggregate Storage Option (ASO) and Block Storage Option (BSO) cubes.
• Extensively worked on dense and sparse strategy dimension allocation, performed dynamic calculations to improve the cube performance.
• Developed Outline building using EAS/AAS for ASO/BSO cubes, RULE files for dimension build and data load, calculation scripts, report scripts, MDX queries, formulae for dimension members.
• Worked on building metadata using EPMA and Essbase studio options.
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases.
• Involved in Application migrating and database objects from test environment to production environment using Hyperion Administrative services console.
• Involved in design, development and enhancement of database (MDDB) outlines.
• Developed Batch Scripts and Rules files to dynamically upload dimensions and data from source database to Essbase Cubes.
• Developed & Maintained Rules Files, Calc Scripts, MAXL Scripts and Reports.
• Implemented security filters for users at different operating levels.
• Worked on PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers.
• Created and optimized Calculation Scripts in Hyperion Essbase.
• Fixed the existing calc scripts to optimize the performance.
• Automated the entire build, load and calculations using MAXL scripts.
• Involved in creating various applications in Planning for budgeting purposes.
• Extensively involved in creating Data entry forms and business rules for several applications in Hyperion Planning.
• Migrated development application to production environment, provided documentation on the process.
• Design and development of reports using Interactive Reporting and Web Analysis Studio.
• Created dashboards using the Interactive Reporting Studio.

Environment: Hyperion BI System 9, Essbase 9.3, Hyperion System 9 Planning, Hyperion Web Analysis 9.3, Financial Reporting, Hyperion Financial Management, Hyperion Intelligence Designer, Excel Add-in, Hyperion Interactive Reporting Studio, JavaScript, Unix, MAXL, SQL Server 2005,, PL/SQL, Toad.

Confidential, Delaware

Hyperion Essbase Developer

Responsibilities:

• Worked on Hyperion system 9 BI+ to create various ASO and BSO applications for budgeting and forecasting.
• Designed and developed numerous cubes and Multi-dimensional databases Involved in writing custom Essbase calculations scripts.
• Created and modified load rules, dimension building and Business Rules.
• Worked as a team member on Hyperion Essbase & Hyperion planning 9.2 for Budget and Revenue.
• Worked on performance tuning to minimize data load time that was feeding Essbase Cubes using various external database systems.
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes using CONTROL-M workload automation software, migrating fact data between different Hyperion applications.
• Maintained and support existing applications, worked on production issues and participated the routine maintenance of Essbase applications for performance.
• Created and maintained Essbase financial application objects including outline, Calc scripts, data- load rules and user security objects.
• Written number of MAXL and ESSCMD Scripts for Essbase cubes to feed data from various external subsystems for comprehensive financial reporting.
• Retrieved data using Excel Add-In utility to analyze cube outline for data integrity, stability and synchronization.
• Used MAXL and ESSCMD scripts to create batch files for database optimization.
• Worked on quarterly/annually forecasts and budget reports using Excel Ad-In utility.
• Optimized performance of Essbase cubes by restructuring the database outline.
• Drill thru implementation in ASO cubes for drilling down to ledger details.
• Optimization of dimension build, data load, cube aggregation.

Environment: Hyperion Essbase system 9 BI+/7.x, Smart view utility with Essbase Excel Add-in, Hyperion Reports, Hyperion Analyzer 7.0, Oracle 8i/9i, MS-Excel, MS-Access, Windows XP, ESSCMD scripting, HAL.

Confidential

Hyperion Developer

Responsibilities:

• Building and maintenance of two new Essbase cubes, one for its budgeting & forecasting and the other one for its financial reporting & Cost Analysis.
• Extensively worked with Hyperion Reports to produce the consolidation reports, financial planning and analysis reports for management.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Involved in upgrade from 6.X to 7.X.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developing Calc Scripts and Report Scripts.
• Developed calculation scripts to perform the calculation on the outline.
• Used ESSCMD to run calculation scripts to calculate part of a database and to copy data values between members.
• Migrating Essbase security from one server (6.5) to another server (7.1.2).
• Development of Business rules with or without Run time Prompts.
• Planning and forecasting applications like budget templates and reports were developed and customized.
• Automated the data loading process and back up through batch scripts & scheduling.
• Optimized the applications to bring down the runtime and database size considerably.
• Designed and created web-based dashboards in Hyperion Analyzer and production reports in Hyperion Reports.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Environment: Excel Add-In, ESSCMD, Essbase Administration Services, Hyperion Planning v7.x, Hyperion Essbase7.x, EAS v7.x, Hyperion Analyzer v7.1.3, MAXL, SQL Interface, Essbase API, Essbase Deployment Services, UNIX Shell Scripting and Hyperion Essbase Spreadsheet Services.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, prototype development, and development of database, developing code and validating programs.
• Developed data transfer strategy from various data sources like oracle, operational and validate data models defined in the ER diagram.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Oracle Data warehouse.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Various PL/SQL triggers were written to handle the automatic order issuing.
• Tuned the SQL statements using execution plans generated using TOAD and SQL*Plus.
• Used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Created database scheduler scripts and applications using UNIX shell scripts, SQL *Plus script.
• Maintained performance tuning by using SQL-Related Performance Tools like SQL Trace and TKPROF.
• Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.
• Created of Adobe forms that combine high presentation with XML data handling.
• Developed graphical interface of Adobe Designer enables users to quickly design forms, maintain form templates.
• Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle 8i/9i, Sun Solaris 8.0, Informatica 6.2, SQL, PL/SQL, TOAD, Shell Scripting, MS Office, Adobe Designer, Data Modeler, SQL*Loader, UNIX, Windows 2000.