SUMMARY

• Over 8+ years of IT experience with extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Extensive experience in the development, design, analysis and implementation of various applications usingHyperion Essbase, Essbase Administration Services (EAS), Essbase Integration Services (EIS), Hyperion Analyzer/Web - Analysis, Hyperion Shared Services, Hyperion Reports, Hyperion Planning, Hyperion Enterprise Performance Suite, Hyperion Interactive Reporting (BRIO), Hyperion Financial Reporting, SQR reporting, Hyperion Workspace, Smart View andEssbase Spreadsheet Add-Inon WindowsandUnix environments.
• Deliver an EDW solution that provides an integrated data store to allow for analysis across subject areas such as customer, product, service, and transactional revenue. It provides a single, common repository of information used across the enterprise for data categories captured in the EDW.
• Proven track record of successful implementation of all project lifecycle stages from requirements gathering implementation and enhancements.
• Proficient in all phases of data warehousing life cycle including ETL, OLAP development, administration, maintenance reporting and end-user support. Data staging (Extraction-Transform-Loading), data presentation and data accessing.
• Experience in architecting complete data models combining multiple transaction systems ETL tools and relational and multi dimensional data stores for star schema, snow flakes schema designs and reporting tools.
• Created ETL Design Specifications Document with in depth details about Source, Target, Naming Standards, Parameters/Variables, Lookup, Program Logic/general Processing Rules, ETL Logic, Folder, Session, and Workflow details.
• Commendable knowledge and experience inautomation, Essbase cube designing, partitioningandoptimizationof report queries.
• Developed numerous cubes from conceptual stage, designedEssbase ASO and BSO applications, OLAP Models and Meta-Outlineswithexcellent balance of dense and sparse dimensions.
• Experience in Installation, Configuration and troubleshooting, Server settings of Hyperion productson client and server side under Windows, UNIX and LINUX environments.
• Assist infrastructure personnel to define and document the technical architecture that includes ODI, DRM.
• Creating business rules using validations and verification in MDM/DRM.
• Creating FTP modules to ftp the files from stage area to MDM server.
• Developed procedure for Emailing details of the Failed Validations in MDM.
• Documentation of System, design, Unit Test Cases, Implementation Plan, Support Plan for Staging and MDM process.
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
• Created the hierarchies using oracle DRM.
• Defining EPM strategies, gathering functional requirements, technical specifications, design, build, test, deploy, post production support, end user training. racle Hyperion Performance Management system, Foundation services including Enterprise Performance Management (EPM); Shared Services and Workspace.
• Experience in developing and designing reports and dashboards in Hyperion Interactive Reporting.
• Experience with migration between different Essbase versions and applying patches to upgrade Hyperion versions
• Publishing the Business Intelligence Reports on Hyperion Portal.
• Created various financial reports like Contribution margin, Income Statement, Cash Flow, Profit & Loss Statement, Operating Profit, Variance reports and other management reports using Hyperion Reports.
• CreatedSQLscripts for creating tables, views, and stored procedures loading data into tables and DB2 databases, and reports for SQL server reporting services.
• Worked onfinancial reporting systemsand using HyperionEssbaseand developedFinancial BudgetingandForecastingOLAP applications.
• Worked in varied environments ofDevelopment, Production-Support, andMaintenance projectswith excellent result-oriented approach,
• Excellent written and oral communication/presentation skills.
• Results-oriented individual who views challenge as opportunity. Motivated team player capable of working independently and with excellent communication, analytical, and strong inter-personal skills.

TECHNICAL SKILLS

Oracle Hyperion Tools: Oracle Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Financial Management (HFM) 11.1.2.3, Hyperion Financial Reports 11.1.2.3,Hyperion BI Reporting Tool, Hyperion Administration Services, Hyperion Shared Services, Hyperion Smart View,Hyperion Analyzer, Hyperion Metadata Management- HAL and DRM,Hyperion Visual Explorer Essbase Administration Services, Essbase integration Services, Enterprise Performance Management Architect, Hyperion Workspace, Hyperion Shared Services, Smart View, Excel spreadsheet add-in.

Reporting Tools: Hyperion Reports, Hyperion Interactive Reports (Brio),SQR reporting, Hyperion Web-Analysis, Hyperion Financial Reports, Crystal Reports, Query Designer.

RDBMS: Oracle 10G/9i/7.x, DB2 SQL Server Reporting Services (SSRS), SQL Server Integration Services SSIS.

Operating Systems: Windows 9x/2000/NT/XP,UNIX (Solaris, Linux)

Languages: PL/SQL, Visual Basic, C/C++, SQL, ESSCMD, MaxL, Report Scripting

Web Design Tools: HTML, DHTML, XML, VBScript, JavaScript, JSP, ASP

Applications: MS Office Suite, MS Outlook, MS FrontPage, Adobe Photoshop 6, Macromedia Dream Weaver 4

Testing Tools: WinRunner, Test director, LoadRunner, Quick Test Pro, Rational Robo, PVCS Bug Tracker

Environment: HP-UX, SAP R/3 releases 4.6B, and 4.6C, Sun Solaris 2.6/2.7,Win 3.x/95/98, Win NT 4.0, MS DOS 6.22, Siebel 2000 V 6.0.2, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Chattanooga - Tennessee

Responsibilities:

• Responsible for Hyperion Essbase cube development and support, application design and creation, documentation and conversion to production.
• Designed and developed Aggregate Storage cubes for Management Application using Essbase Administration Services 11.1.2.3
• Designed outlines and Developed rules files for dimension building and loading the data. The load involved data file as well as SQL load.
• Developed MaxL scripts and shell Scripts to automate the Essbase processes.
• Implemented incremental data load using load buffer and created data slices to optimize data loads..
• Designed and developed Daily Accounts and Monthly accounts cubes in BSO.
• Developed calculation scripts, outline formulas scripts.
• Involved in troubleshooting, Performance tuning and Performance monitoring to meet user requirements.
• Designed transparent and linked partition for optimizing performance.
• Worked extensively with SQL server 2008.
• Migrated cubes from MSAS to Essbase using EIS which requires thorough understanding of star schema.
• Worked extensively with Excel Add-In and Smart View Hyperion reports and Executive Viewer. For creating reports.
• Involved in the production support and security maintenance of various BSO cubes.

Environment: Essbase Administration Services 11.1.2.3, Essbase Integration Services 11.1.2.3, Essbase 11.1.2.3, Hyperion System 11, Excel Add-In, Executive Viewer 9.3.1.1,SmartView, Microsoft SQL server 2008.

Confidential, Columbus, Oh

Sr.Hyperion Planning/Essbase Developer

Responsibilities:

• Led the development and design specifications of ESSBASE cube and planning applications with Business Customers.
• Involved in analyzing requirements andhigh level design documentsand offered various build options/solutions.
• Created the planning application and Essbase ASO and BSO applications based on the business specifications.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Responsible for migration of ETL objects into Production repository from development repository.
• Monitored the monthly and weekly data load and coordinated with ETL team.
• Helped DBA by developing ETL (PL SQL) scripts to populate DataMart tables.
• Created complex Member Hierarchies, Calculation and and Data Load rules.
• Restructured and redesigned existing Hyperion Planning and Essbase applications for better performance enhancements.
• Developed and maintained business rules, Calc scripts, report scripts, MDX formulas on ASO cubes and related macros for the Essbase applications.
• Design metadata for planning and build dimension hierarchy using EPMA profile utility for workforce planning model.
• Build dimensions using profiles on Hyperion EPMA in dimension library. These dimensions were used as shared dimensions in the application.
• Created Business rules using EPMA calc manager and deployed them to Hyperion Planning application.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Involved in designing budgeting application, dimension/outline building (with multiple hierarchies).
• Efficiently used ASO and BSO cubes mix architecture with various partitioning strategies.
• Designed and developed several ad-hoc and financial reports using Hyperion Financial Reporting
• Involved in automating Cube build, Data loads, Calculations and security assignment (end to end automation) in MaxL andUnix batch processes.
• Generate and execute Hyperion Planning out of the box currency conversions including the automation of Exchange Rates loading process.
• Monthly synchronization of Planning and Essbase Metadata through existing environments using LCM.
• Optimized the applications to bring down the runtime and database size considerably.
• Handled production support and maintenance of existing cubes.
• Supported other Hyperion ESSBASE & Planning projects within Confidential .

Environment: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Financial Reporting 11.1.2.3,EPMA,Hyperion Essbase Administration services 11.1.2.3, AIX, DB2, and MS excel add in and Smart view 11.1.2.3.

Confidential, Washington D.C

Hyperion Consultant

Responsibilities:

• Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Responsible for BI Server Upgrades, Migrations, Clustering and Consolidations from 9.x to 11.x on Windows and Solaris platforms.
• Created the database outlines, re-arranged the dimensions to meet the optimal performance of the database and conducted daily routine maintenance.
• Applied Hyperion Planning 9 to provide a framework for perpetual planning, managing volatility, reporting on frequent planning cycles involving both short and long term planning.
• Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process
• Developed Allocation Business Rules using Hyperion Planning and created data entry web forms using Hyperion Planning.
• Extensively worked on Oracle Hyperion Data Relationship Management (DRM) solutions of Master Data Management (MDM) for specific master data configurations, batch file imports, hierarchy management, and compliance with regulations.
• As MDM/DRM Consultant, involved in creating hierarchies, properties, validation/verification, import & exports, implementing security & automation of processes.
• Export/Import data from DRM using the DRM migration modules.
• Handled Go Live activities like setup of prod environment, Migration of MDM & Oracle database objects.
• Created versions in DRM with different hierarchies and blended the data.
• Mentor and transfer DRM technical knowledge and processes to other Client team and department personnel, as requested.
• Responsible for setting FDM security standards and administration of FDM roles across the company.
• Developed standardized financial data management (FDM) processes with its Web-based guided workflow user interface.
• Dynamic calculation rules were executed for strategic business objectives.
• Responsible for up gradation of Essbase from 9.3 to 11.1.2.2 and Identified database settings on Windows platform.
• Was responsible for Hyperion suite of products, ESSBASE, Planning, HFM Reports and Analyzer. Was responsible for assigning work for the DBAs related to Hyperion suite products, and conduct meetings with the business units to gather user requirements, build road-map and the plan targets/deadlines.
• Worked on Oracle data integration (ODI) platform that covers all data integration requirements.
• Implemented the Drill-Thru functionality to drill back to the detail data using Essbase Studio.
• Worked on Calculation manager for building and calculating business rules for planning and financial management applications.
• Used Calculation manager for creating, executing and scheduling Calculation Scripts.
• Designed Aggregate storage cubes (ASO) for faster data load.

Environment: Hyperion System 11.1.2.2/9.3 , OBIEE,Essbase Studio, HFM, ODI, DRM, Hyperion Planning 11.12.2, Hyperion Essbase 11.12.2, EAS11.1.2.1, Hyperion Interactive Reporting 9.3/11.1.1.3 , FDQM, Oracle 10g,Toad

Confidential, MN

Hyperion Essbase Developer

Responsibilities:

• CreatedOLAP Modeland Meta Outline forEssbase OLAPserver usingEssbase Integration Services.
• DevelopedHyperion Essbase Cubesfor reporting purpose by usingHyperionfrom properly formatted data using Excel/SQL/Test Filesfor free form data loading throughRule Fileand configured Outline to add new dimensions, members and attributes.
• Analyzed all the dimensions and member inEssbase Outlinebased on dimension type,Density/Sparsity, Query FrequencyEtc for optimal performance.
• Involved in troubleshooting to optimize calc time, data load time and retrieval time of various Essbase cubes.
• DevelopedCalc Scriptto calculate complex values Cash Cost/User, YTD commitment, Variance, Capital Expenditures forecasts, Budgeted Cash Flow etc.
• Resolved issues related to Security, Security filters, Attributes, Aliases, Dimension building, Exporting data, EssCmd, Database portioning, Intelligent calculation, Calculation order, Outline calculation attributes, Member formulae, Dynamic calculations, Dynamic time series and Calc scripts.
• Worked withEssbase Integration Services(Meta Outline Workflow/Filters/Drill Through Reports).
• DevelopMaxL Scriptsfor generating scheduling daily backup batch process and error checking.
• Extensively worked withHyperion ReportsandHyperion Analyzer. Developed reports for forecasting monthly expenditures, expense management and control, comparing actual vs. planned expenditure etc.
• Other duties involved providing support and maintenance forHyperion OLAP Essbase Systems, including both client and server troubleshooting.
• Developed the Financial Reports and Sales Reports usingHyperion Reports.
• UsedSmart Viewto integrate MS Office products with financial management and analytic services.

Environment: Hyperion Essbase 11.1.2.1, Essbase Integration Services 11.1.2.1, Hyperion Analyzer 11.1.2.1, Hyperion Reports 7.0, Essbase Excel Spreadsheet Add-In, Hyperion Smart View, MaxL, ESSCMD, MS-Office, MS SQL Server 7.0, Oracle 9i, SQL, PL/SQL, UNIX, MS Windows 2000/XP.

Confidential, Winston-Salem, NC

Essbase Developer Analyst

Responsibilities:

• Translated end user requirements into application design specifications.
• Engaged in entire software development life cycle. Involved in defining requirements, functional specifications, designing documentation and testing strategies.
• Participated in outlining requirements and development of a project plan with business personnel.
• Created outlines and optimized them by grouping and positioning.
• Developed Calc script to calculate complex values like Cash Cost/ User and YTD commitment, Variance, Capital expenditures forecasts, Budgeted cash flow statements etc.
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Developed customized Hyperion Reports (Interactive Reporting (IR)) and Dashboards (JavaScript) for different business clients of the company using enterprise Data Warehouse.
• Managed the project in breaking down the existing EDW to manageable data marts.
• Applied advance database concepts according to business needs like degenerate dimension, factless fact table, bus matrix architecture for building EDW and build strategy for late arriving fact rows.
• Developed batch scripts and MaxL for automating and scheduling month close process.
• Created and modified rules files for accommodating data format changes and enabling cube loading.
• Implemented mathematical functions for computing derived data and worked on optimization of data loads and calc-scripts.
• Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
• Developed a comprehensive reporting system using Hyperion Analyzer using the approach of Financial Dashboard.
• Prepared profitability reports, templates, analyzer report, forecasting templates and templates for ad-hoc forecasting.
• Developed web forms using Hyperion Planning web client for the users.
• Administered users and user groups.
• Developed web forms using Hyperion planning web client for the users to input Forecast, Budget, Actual Accounting changes and other variance explanations data.
• Wrote shell scripts for automation, scheduling and error checking.
• Provided production support during the latter part of the project.

Environment: Essbase Administration Services 9.3.1, Essbase Shared Services 9.3.1, Oracle Hyperion Essbase System 9, Excel Add-In, Interactive Reporting (Sys 9), Web Analysis (Sys 9), Web Analysis - Web Analyzer, Hyperion Workspace, Microsoft SQL server 2005

Confidential

Associate Consultant

Responsibilities:

• Extensively worked onPower Center 7.1clienttools likeDesigner, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked onPower Center 7.1workflow managertools likeTask Developer, work let designer and workflow designer.
• DevelopedInformatica mappingsand also tuned them for better performance
• Created InformaticamappingswithPL/SQLProcedures to build business rules to load data.
• MaintainedVersioning for all the Objects using Merant Version Manger.
• Used most of the transformations such as theLookups,Input, output, Joiner, Expression,Source qualifier, Aggregators,Filters,SequenceandUpdate strategy, Router.
• Created and ran varioustaskslikeSessions,command, Email&Workflowsto load the data into the Data warehouse components.
• Developed and documented data Mappings/Transformations and Sessions.

Environment: Informatica - Power Center7.1, MS Sql Server, Sql, PL Sql, UNIX Shell Scripts, Windows 2000.