SUMMARY

• Eight plus years of diverse experience in Information Technology with emphasis on Data warehousing OLAP tools.
• Over 6 years of Proficiency and experience analyzing, designing, developing, implementing, tuning and supporting the Oracle Hyperion Suite of tools, including Hyperion Essbase, Hyperion Planning,, Hyperion Financial reporting, Hyperion Interactive reporting, Web Analysis, Shared Services, Smart view, Spreadsheet Add - In, Financial Data Quality Management(FDM), Oracle Data Integrator(ODI), in both Windows and UNIX environments.
• Hands on experience in installing and configuring Hyperion system.
• Worked in varied environments of Development, Production-Support, and Maintenance projects.
• Strong experience in understanding business and building cubes from conceptual stage.
• Expertise in Calc scripts, MaxL, ESSCMD, Dimension build rules, Partitioning, Data load rules and report scripts, upgrading, testing and migrating of cubes in different environment.
• Key strength in Automation, Optimization and Performance Tuning of Essbase application, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports
• Strong background as a Hyperion Essbase Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
• Expertise in Hyperion Planning Data forms, Task list, Business Rules, security, backup and migration.
• Created templates and ad-hoc reports using Excel Add-in, Smart view for budget and forecast analysis.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outline.
• Applied in-depth understanding of STAR and SNOWFLAKE SCHEMA modeling techniques to develop optimized OLAP models and meta-outlines using relational and other database sources.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Created numerous design documents and provided training to the end users.

TECHNICAL SKILLS

OLAP & BI Tools: Oracle Hyperion Essbase 11.x/9.x/7.x, Oracle Hyperion Planning 11.x/9.x, Essbase Administration Services (EAS), Shared services, Essbase Integration Services, Workspace, Essbase query designer, Oracle Data Integrator (ODI), Hyperion Financial Data Quality Management (FDM/FDQM).

Reporting Tools: Financial Reporting, Interactive reporting, Web Analysis, Spreadsheet Add-In, Smartview

Databases: Oracle 11g/10g/9i, MS SQL Server (2003, 2005), MS Access.

Languages: MaxL, MDX, ESSCMD, Shell Script.

OS/Environment: MS-DOS, WINDOWS 98/2000/NT 4.0/XP/2008, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

Sr. Hyperion Essbase/Planning/Report Consultant

Responsibilities:

• Developed Essbase outline formulas and Calc Scripts using advanced Calc Scripts functions.
• Retrieving data using Smart-view to analyze cube outline for data integrity using MaxL Scripting and ESSCMD to create batch files for optimization.
• Developed batch scripts using MaxL for the automation of various processes.
• Optimized outlines to have faster data loads, calculation and retrievals
• 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.
• Worked on reports rationalization and functional and technical documentation, unit testing and integration testing of reports.
• Performed monthly backups of Hyperion data. Helped facilitate creation and loading of quarterly budget data.
• 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.
• Managed access to Data Forms and Folders including assigning access and changing access using Hyperion Planning.
• Extensively involved in importing and exporting Access Permissions.
• Managed Security Filters using Planning Administration.
• Was solely responsible for developing all the FR reports from scratch in Finance reporting team.
• Designed many extremely complex reports using Hyperion Financial Reporting using multiple grids and multiple data sources.
• Developed detailed Reports for every functional Unit, stocking, Price, Volume Trends and calculating Expense Variances over prior periods.
• Built various reports like Income statement, Balance Sheet, PPE and Analysis reports for the Minority Corps and Partnerships.
• Designed reports to display YTD and YTD prior year for any input month/quarter chosen even though there is no YTD substitution variable member in the cube.
• Have used various kinds of complex formatting in the reports like Conditional Formatting, Conditional Suppression, Related Content, and Suppression on Rows and Columns etc to suit to the requirements of the client.
• Have used various kinds of functions in the OFR studio like MemberAlias, GetCell, ReportDesc and ReportName etc. Also used various kinds of Mathematical functions like Sum, Average, Count, Eval, PercentOfTotal and Cell or Grid References etc.
• Prepared Books, Snapshots and Batches by assembling various set of reports. Scheduled the batches according to the specific needs of the client to run the reports weekly, monthly etc.
• Migrated applications from test to pre-prod and prod environments.
• Identified FR bugs and worked with Oracle to fix the issues.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, Hyperion Financial reporting 11.1.2.2, Windows Scheduled tasks, Hyperion Smartview, Essbase Utilities, Windows Server 2008, Oracle Database 11.2.0.3.

Confidential, Atlanta, GA

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user training across subsidiaries.
• Created Budgeting and Forecasting applications using Hyperion Planning Classic method for the Finance department.
• Worked on creating and initializing Workforce Planning application.
• Modified Labor applications Web forms and Business rules for workforce database.
• Modified Business rule for calculating salary, bonus for the company as per their business formulas.
• Modified Transfer Employee form as per user requirement.
• Customize dimensions, smart lists and UDAs which are created after initialization of workforce planning.
• Developed SYM and ASYM data forms, Composite data forms, task lists, calculation scripts, define business rules with run-time prompts and menu lists for the users to enable them to enter financial data into the system.
• Automated Outline load utility and rules files for data and metadata load in planning application.
• Worked on performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, using two-pass calculations, changing buffer size, setting numeric precision
• Created a transparent partition for the ASO cube as target for BSO source cubes to enhance reporting.
• Migrated Planning Applications, Data forms & Business Rules from Dev to Prod Environment.
• Designed financial reports for the upper management and comprehensive reports for the daily users by using Hyperion Financial reporting.
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting.
• Created Balance Sheet and P&L statement using financial reporting.
• Coordinated several offshore sessions to guide them on building application specific reports.
• Used Shared Services for defining and allocating provisions to the users of the company as per the needs of higher management.
• Performed monthly backups of Hyperion data. Helped facilitate creation and loading of quarterly budget data.
• Provided Hyperion Essbase, Planning, Workforce Planning, Workspace, Shared Services guidance and mentoring to junior and offshore developers.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Worked on creating design documents explaining end to end implementation of the project.
• Conducted various workshops explaining users how to build reports in financial reporting studio.

Environment: Hyperion Essbase 11.1.2.2, Hyperion Planning 11.1.2.2, Hyperion Financial reporting 11.1.2.2, Windows Scheduled tasks, Hyperion Smartview, Essbase Utilities, Windows Server 2008, Oracle Database 11g.

Confidential, CA

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Performed metadata building using outline load utility for different dimension and various applications.
• Developed Dynamic Web forms for various applications with POVs, menus, run time prompts and Pages.
• Developed Rules files for data loading in Essbase for BSO application.
• Build various business rules for to perform various calculations for different application. Build admin rules and user rules.
• Worked on Creating Locations, Import formats, and mapping for loading data into Essbase applications using Hyperion FDM.
• Setup security for FDM locations for users.
• Worked on building rule files for data load and metadata loading for ASO applications.
• Worked on migration of applications from development server to Pre-Production and Production server.
• Worked on security in shared services. Build various security filters and granted access to the application and its dimensionality according to the requirement provided. For various users/groups.
• Worked on MAXL scripting for automation. Used MAXL scripts in batch files for performing data and metadata
• Designed and developed various types of chart reports, pivot reports, view reports, tabular reports in Interactive reporting.
• Created Dashboards getting data from Oracle & Essbase cubes in Interactive Reports.
• Worked on Design Documentation for various applications. Explained from starting to end about the description of application. Its dimensionality, various data forms, menus associated and business rules. The Various financial reports associated with it.
• Worked on providing User training documents. Build Documents (excel files) describing the data forms, how they work and business rules association with them and what rule is doing.
• Worked on designing filters for the entire reporting cube giving user read access to Essbase.
• Modified Essbase filter for planning applications giving users write back capabilities in smart view for their specific security allotment.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Interactive Reports Studio 11.1.1.3, Hyperion Financial Data Quality Management 11.1.1.3, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, Oracle Database 11g, Windows server 2003/Linux.

Confidential, Harrisburg, PA

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Involved in production support and maintenance of four existing cubes.
• Responsible for the conversion of a BSO application to ASO.
• Created planning application using Workspace and Planning Studio.
• Developed custom fact table according to business needs.
• Developed business rules and Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance and budgeted cash flow statements.
• Automated the dimension build and data load process using MaxL Scripts.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Designed Task lists and Workflow process for all the Planning applications.
• Used the Conditional Suppression functionality in Financial Reporting to suppress the rows/columns to display dynamically based on Prompts, User POV.
• Extensively used Traffic Lights in Web Analysis Reports.
• Created Users and groups in Hyperion Shared services and assigned privileges to them.
• Optimized the existing cubes and calculation scripts to improve the performance.
• Applied security on different applications by creating Filters on its dimension members.
• Extensively involved in documentation and end user training.
• Used ODI as a data integration (ETL) tool.
• Created Data Integration interfaces, procedures and projects for loading SQL and File System data into Planning and Essbase using ODI.
• Use of Operator GUI within ODI in-order to debug data loading issues and also schedule procedures.
• Installed version 11.1.1.3 and configured it.
• Upgraded Hyperion system from version 9.3.3 to 11.1.1.3

Environment: Hyperion Essbase 9.3.3/11.1.1.3 , Hyperion Planning 9.3.3/11.1.1.3 , Hyperion Financial Reports 11.1.1.3, Hyperion Integration Services, Oracle Data Integrator (ODI) Hyperion Administration Services, Hyperion Web Analysis, MAXL, ESSCMD, Excel Add-In, Windows NT/2000, Oracle 9i.

Confidential, Simi Valley, CA

Sr. Hyperion Essbase Consultant

Responsibilities:

• Involved in entire life cycle of the project, from requirement gathering to production support.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application.
• Involved in development of rules files - for performing operations on records, fields, data, dimension building.
• Applied Intelligent Calculation - for Calc scripts, partial calculations, calculating data blocks, turned OFF Intelligent Calculation where it was not necessary and affected performance.
• Optimized and tuned Database outline tuning to increase retrieval speed of Hyperion Essbase BSO cube.
• Performed Essbase Calc script tuning and debugging as well as enhancements.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Migrated entire security on both the development and production Hyperion Essbase servers in a totally seamless fashion, with no data loss for users, groups, and hierarchy and access information. This included no changes in passwords too.
• Optimized several databases based on business needs and user interaction, to improve calc script run times and retrieval times. This including optimizing outlines, dimension orders, member storage type, etc.
• Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Essbase tasks.
• Developed Load Rules to automatically validate the data and feed into Essbase.
• Worked on month-end procedures on Essbase cubes for Expense, Budget, Metrics, etc. related tasks and reporting.

Environment: Hyperion Essbase 9.3.3, Hyperion Reports 9.3.3, Hyperion Integration Services, Hyperion Administration Services, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, SQL, Windows NT/2003, SQL Server 2005

Confidential, Emeryville, CA

Hyperion Essbase Developer

Responsibilities:

• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Optimized Data Loads and Calc Scripts by applying different techniques.
• Developed and ran Calc scripts to calculate complex values like Acquisition Cost, Gross Margin / Inventory Turn, Revenue / Payroll Hr. Total Head Count, Revenue per QTY, Return on Assets, Property, Cash Cost Per User and YTD Commitment & Variance
• Worked extensively in developing automation scripts using Hyperion Essbase EssCMDs and MaxL.
• Maintenance of Batch Scripts, Scheduling runs through Autosys.
• Users input capability to the applications maintained by Filters for many applications.
• Technical support for existing cubes, problem identification, resolution and documentation.
• Worked as a team member in Hyperion Essbase & Planning Implementation.
• Modified the existing outline according to the requirements for Hyperion Planning application.
• Used Hyperion Planning for testing of new calculation scripts by entering and running Calc scripts.
• Presented detailed analytical reports to higher administrative people using Hyperion Reports/ Analyzer to induce collaborative decision making.

Environment: Hyperion System 9, Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Integration Services, Hyperion Administration Services, Essbase Excel-Add-in, MS Access, SQL Server 2000, Windows 2000/NT 4.0

Confidential, Houston, TX

Hyperion Essbase Developer

Responsibilities:

• Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations
• Developed Rules file for Dimension Building and performed Metadata and Data loading
• Developed business rules and Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
• Created reports using Hyperion Web Analysis Studio and Smartview for monthly, quarterly and annual data
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache
• Designed Task lists and workflow process for all the Planning applications
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports in Shared Services
• Created documentation for the users and provided required training for data entry and reports

Environment: Hyperion System 9, Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Integration Services, Hyperion Administration Services, Essbase Excel-Add-in, MS Access, SQL Server 2000, Windows 2000/NT 4.0

Confidential, Northbrook, IL

Hyperion Essbase Developer

Responsibilities:

• Participated in development of a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Rule files.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase Cube.
• Developed Rule files to upload data from the financial system databases to Essbase cubes and then developed a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial and marketing data.
• Developed Calc scripts and ran them to calculate complex values using Block Storage cubes. Involved in troubleshooting, Performance tuning and Performance monitoring.
• Automated the cube building process through MaxL and shell scripts and created a scheduling mechanism using Autosys.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase Cube; wrote Report Scripts to develop Income and expense Statement analysis reports.
• Maintained cubes and took regular backups
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Developed Report Scripts to develop Income & expense Statement Analysis Reports along with Revenue and Quantity Reports.

Environment: Hyperion Essbase 7.1, Essbase Excel-Add-in, MS Access, SQL Server 2000, Windows 2000/NT 4.0

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL programming that included writing of Stored Procedures, Packages, Functions and Database Triggers.
• Created Temporary Tables to store the data from Legacy system.
• Used SQL*Loader scripts to load the data into temporary tables and PL/SQL procedures to validate the data.
• Creation of Materialized views and function based indexes
• Setting up various notification scripts which will notify if the database is not up and running or if any directory space is filled up.
• Used Oracle packages for automation, Oracle designer for data modeling.
• Used Visual SourceSafe for version control and performing various builds.

Environment: Oracle 7i, SQL*Loader, Toad, UNIX