SUMMARY

• 8 years of IT experience, over 6 years of Experience as Hyperion Consultant, with and expertise in the area of Data warehouse and OLAP Software systems design and implementation.
• Strong Technical and Functional experience in development and administration of various financial applications using Hyperion Essbase, Essbase Integration Services, Hyperion Financial Reporting, Hyperion Reports, Web Analysis, ESSCMD, Essbase Spreadsheet Services, Smart view.
• Reporting, Hyperion Planning, Hyperion DRM.
• Experience using Hyperion Enterprise and knowledge of Hyperion Financial Management(HFM).
• Involved in projects covering all the areas of software development life cycle (SDLC).
• Good understanding of Essbase architectural concepts like attribute dimensions, UDAs, Time Balancing, Two Pass Calculations, dense and sparse dimensions.
• Experience in Hyperion Essbase Security, user provisioning, native as well as external authentication.
• Expertise with building Web analysis and financial reports using financial reporting studio and HFM.
• Developed and maintained Essbase Application Objects such as database outlines, calculation scripts, and dynamic dimension build and data load rules files.
• Proficient in writing simple to complex SQL Queries.
• Experience in SQL Server Development and Administration in Production, Testing and Development Environments and various Business Intelligence tools (BI) like SQL Server Integration Services (SSIS).
• Complete debugging, and routine maintenance of Essbase applications, as well as provided support for these applications.
• Perform constant application administration by enforcing security measures, scheduled backups and data exports, data loads, and optimization of databases.

TECHNICAL SKILLS

Tools: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Essbase Integration Services (EIS), Hyperion Essbase Administration Services (EAS)

Reporting Tools: Hyperion Web Analysis 11.1.2.1, Hyperion Financial Reporting 11.1.2.1, Smart view, Planning Web forms

Database: Sql Server 2008/2008R2, Essbase 9BI+, SSIS, Powershell

Languages: C,C#

Job Function: Design, Analysis, Processing, Upgrading, Maintenance, Testing

OS/Environment: Windows 2000,UNIX,Windows NT

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Hyperion /Sql Developer

Responsibilities:

• Worked on ASO/BSO Cubes development process in DEV and PROD environments.
• Redesigned and restructured the existing cubes using Hyperion administration services (EAS) and Integration Services (EIS).
• Created cube from scratch by first developing OLAP Model using Star Schema data modeling technique and Meta Outline, and then loading dimensions and data for Essbase OLAP Server using Essbase Integration Services. Developed various filters as per user requirements and Created Drill - through reports.
• Extensively involved in Creating new Applications and regular updating of cube outline.
• Converting BSO cubes to ASO Cubes.
• Performed dimension build and data load for the Essbase cubes using EIS and SQL Server Dimension tables.
• Worked on member hierarchies and updating their Properties in Metadata Management Sheet.
• Created Data Load Rules Files to load the actual data and Calculation Scripts for the cube aggregation. Developed calculations in Essbase (Member Formulas, Calculation Scripts).
• Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods.
• Experience in implementing Hyperion Essbase security features, planning dimension level securities and Responsible for setting up users, security groups and access filters to ensure maximum-security maintenance through shared services.
• Created SSIS Packages to run the Query that populates the relational tables in SQL Server Management Studio and convert flat file extracts into SQL Tables to feed Essbase cubes. Worked on views creation in SQL server Management Studio to extract desired information for cubes from existing tables while working on EIS.
• Maintanence of Starting/Stopping of Essbase Servers.
• Expertise in writing custom Essbase calculations scripts, automating the Essbase Cubes using MaxL, Esscmds, Batch Scripts.
• Created Provision and Audit reports on security using Shared Services.
• Developed various Reports using Web analysis with cascade filters, drop down menus, split panels, charts and conditional formatting.
• Analyzed, designed and Developed AFE, Budget and LOS Reports using Financial Reporting Studio and Smart view and HFM. Ensured accuracy of reporting data that is provided to all levels of staff and senior management.
• Responsible for technical issues for Hyperion Essbase Version upgrade from 11.1.1.3 to 11.1.2, Shared Services, Hyperion BI+, and Web Analysis. Worked on fixing Production tickets, promoting them to UAT, testing them in UAT and promoting them to Production.
• Worked on Smart view for data manipulation and report creation.
• Designed and developed Dimension hierarchy with properties in EPMA and web forms for data inputs as per the business requirements using Hyperion Planning.
• Created Planning Web forms and Build the Calc scripts, Business rules.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Applied HFM to create Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Maintained Essbase databases using Planning application to meet financial requirements. Developed applications using Hyperion Financial Management (HFM) Suite for automation and reporting process.
• Responsible for Resolving Hyperion Tickets and closing which are posted in SharePoint site.
• Designed and developed Dimension hierarchy with properties in EPMA and web forms for data inputs as per the business requirements using Hyperion Planning.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Participated in Hyperion Planning implementation in Oracle EPMA.
• Maintained and executed entire Budget and Forecast cycle in Planning by creating new forms, calculations scripts, Business rules and Reports for Hyperion Planning.
• Added members as well as member formulas in planning applications in Oracle EPMA.
• Tested the validity of member formulas in Oracle Planning EPMA.
• Deployed the Planning applications in EPMA.
• Created complex business rules, validating and deploying them in Oracle EPMA rule editor.
• Responsible and Team Member for Hyperion Upgrade from 11.1.3.1 to 11.1.2.1 and DRM Implementation.
• Team member and participated in Implementing DRM.
• Load Data into DRM and Daily Maintenance of Dimensions which feed to Hyperion.
• Participate in creating Staging tables and Created Import and Export files using SSIS Packages for DRM staging tables.
• Adding and updating properties for members in DRM.
• Documents Internal and External process and procedures for custom applications must be in SOX compliance within/outside Auditors.
• Used Power shell Scripting for creating Various Batch files.

ENVIRONMENT: Hyperion version 11.1.2.1, Hyperion EIS 11.1.2.1, SQL Server 2008 R2, Hyperion Financial reporting studio 11.1.2.1, Hyperion Web analysis 11.1.2.1,HFM, MAXL

Confidential, Boston, MA

Hyperion developer

Responsibilities:

• Identified requirements, documented them and translated the system specifications into physical design for Essbase data cubes.
• Engaged in entire software development life cycle. Involved in defining requirements, functional specifications, designing documentation and testing strategies.
• Developed strong Finance System/Admin for HFM.
• Build Calculations For HFM.
• Participated in outlining requirements and development of a project plan with business personnel.
• Developed Calc script to calculate complex values like Cash Cost/ User and YTD commitment, Variance, Capital expenditures forecasts, Budgeted cash flow statements etc.
• Developed batch scripts and Maxl for automating and scheduling month end copy to previous 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.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Executed performance tuning and optimization in both the data retrieval and data loading scenarios.
• Developed a comprehensive reporting system using Hyperion Reports and Hyperion Analyzer using the approach of Financial Dashboard.
• Prepared profitability reports, templates, analyzer report, forecasting templates and templates for ad hoc forecasting.
• Administered users and user groups
• Wrote shell scripts for automation, scheduling and error checking.
• Provided production support during the latter part of the project.

Environment: Hyperion Essbase, Web analysis, Hyperion Analyzer, Hyperion Reports, Essbase Integration Services, Microsoft Excel 2000, Excel Add-In.

Confidential

Database Developer

Responsibilities:

• Performed system study, designing and developing databases and stored procedures in SQL.
• Involved in Writing, Procedures, Functions and Triggers using Oracle's PL/SQL structures to enforce business rules and/or relationships uncovered in the data model.
• Responsible for Code Reviews and PL/SQL Code Tuning.
• Developed test cases/scripts based on defined business/functional specifications and user cases.
• Worked on Data warehousing designer, Mapping Designer, and Transformations.
• 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 2008, Microsoft office, SSIS,SSRS

Confidential

Responsibilities:

• Actively took part in gathering requirements and specifications.
• Designed and Created new tables in the existing database and fields in the existing tables in the database according to new requirements.
• Designed and implemented the database as per the requirement of the application.
• Created Oracle Packages, Procedures, Functions and Triggers using SQL to enforce business roles and or relationships in data model.
• Creation of complex SQL statements performs data modeling and create/maintain and modifies complex database triggers and data migration script.
• Developed on-line context-sensitive help pages for the new users.
• Responsible for Code Reviews and SQL Code tuning.
• Responsible for monitoring the day-to-day activities of the application for the performance of the database.

Environment: SQL Server 2005