SUMMARY

• 7 years of IT experience, over 6 years of Experience in administration, design, development, analysis, and implementation of various applications in Client/Server OLAP environment using Hyperion Essbase, Hyperion Analyzer/WebAnalysis, Hyperion Reports/Financial Reporting, Hyperion Planning, Hyperion DRM/MDM.
• Extensive experience in Essbase and Hyperion Planning administration
• Extensive experience with development of highly formatted complex reports using financial Reporting/Hyperion Reports with multiple data sources
• 2+ years of strong Experience in Data integration using ETL tool INFORMATICA PowerCenter 5.0/6.x/7.0 and PowerMart5.0/6.x, Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading and using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer
• Expertise with building dashboards in Webanalysis and Interactive Reporting
• Expertise with VB, VBA and Javascipt
• Experience with building and deploying Hyperion Planning applications from the conceptual stage. Also experience in deploying prebuilt Planning modules like capital expense planning and workforce planning.
• Proficient in technical documentation including Design, SLAs, Requirements, Application Maintainence and troubleshooting documentation.
• Excellent understanding of Essbase architectural concepts like attribute dimensions, UDAs, Time Balancing, Two Pass Calculations, CFG file settings, dense and sparse dimensions
• Extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation for corporate finance.
• Expertise with developing on Windows and UNIX/SOLARIS environments
• Strong database development and business intelligence modeling capabilities
• Experience in Hyperion Essbase Security, user provisioning, native as well as external authentication
• Extensive experience on the installation, configuration, server settings, backups, client and server installations of Hyperion products such as Essbase, Essbase Integration Services, Essbase Analyzer and Hyperion Reports on both Windows and UNIX environments.

TECHNICAL SKILLS

Tools: Hyperion Essbase 6.x/7.x/9.x/11.x,Hyperion Planning 9.x/11.x,Hyperion Essbase Integration Services(EIS),Hyperion Essbase Administration Services(EAS).

Reporting Tools: Hyperion Reports 2.x/7.x, Hyperion Web Analysis 11.x, Business Objects, Hyperion Financial Reporting 11.x, Interactive Reporting.

ETL Tools: Oracle Data Integrator (ODI), Hyperion Application Link (HAL),Data Integration Management(DIM).

Languages: C,SQL, PL/SQL

Operating Systems: Windows NT 4.0/XP/2000/2003

Database: SQL(2000,2005), Oracle 9i/10g/11

PROFESSIONAL EXPERIENCE

Confidential, Berkeley Heights, NJ

Hyperion Developer

Responsibilities:

• Created Business Rules for forecasting future year data and then allocating at brand, customer and entity level based on business process off of Raw G/L data feed
• Developed dashboards in WebAnalysis for Key Performance Metrics & Brand Summary
• Responsible for maintaining security in Shared Services
• Create Scorecard reports, Summary PnLs and KPI reports in Financial Reporting, grouped them into books and scheduled them using batches
• Involved in upgrading Hyperion from version 9 to 11 including re - writing data load and build jobs and processes as well implementing new version 11 features like transaction replay
• Developed complex templates for adjustment and other data entry into Essbase using Planning web forms
• Created various partitions in Essbase - replicated as well as transparent for sharing data across different cubes
• Created automation to export out the budget and forecast data to load back into Oracle

Environment: Hyperion EPM System 11.1.2, Hyperion Financial Reporting 9, Hyperion Webanalysis 9, Hyperion Planning 11, Oracle 11i, Windows 2003 server

Confidential, Jersey City, NJ

Hyperion Developer/ Administrator

Responsibilities:

• Developed and maintained 2 Essbase cubes for New York Life real estate division
• Developed automation jobs to refresh the hierarchies from MDM into the oracle warehouse and then from there into Essbase
• Upgraded the system from 9.3 to Oracle Hyperion EPM System 11.1.1.3. Configured all components including web-tier(apache), Essbase, Shared Services, Financial Reporting and Web Analysis on Development, UNIT and QA Servers
• Involved in upgrading Hyperion from version 9 to 11 including re-writing data load and build jobs and processes as well implementing new version 11 features like transaction replay
• Developed complex templates for adjustment and other data entry into Essbase using Planning web forms
• Created stored procedures to generate flat file extracts to feed Essbase cubes
• Optimized calculations and data loads for the Essbase OLAP engine
• Developed automation for cube build, data load, updating partitions using MaxL and windows batch scripts
• Configured Hyperion DIM to load ledger data from Oracle Financials into Essbase cubes.
• Created various partitions in Essbase - replicated as well as transparent for sharing data across different cubes
• Developed various dashboards using Webanalysis with cascade filters, drop down menus, split panels and conditional formatting
• Created automation to export out the budget and forecast data to load back into Oracle

Environment: Hyperion EPM System 11.1.2/11.1.1.3/9.3.1/9.2.0 , Hyperion Data Relationship Manager (DRM) 9, Hyperion Data Integration Management (DIM) 9, Hyperion Financial Reporting 9, Hyperion Webanalysis 9, Hyperion System 9 Planning, Oracle 10g/11i, Ms SQL Server 2005, UNIX AIX

Confidential, New York, NY

Sr. Hyperion Analyst/ Administrator

Responsibilities:

• Developed and maintained Essbase Application Objects such as database outlines, calculation scripts, and dynamic dimension build and data load rules files.
• Extensively involved in performing DBA activities such as performance tuning the Calc scripts, database tuning, and taking the Essbase backups
• Completed tuning, debugging, upgrades, 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.
• Executed and documented test cases to successfully reviewed new application components for use with Hyperion products such as Excel Spreadsheet Add-in, Analyzer, and Reports.
• Wrote efficient calc scripts to control the order and flow of database calculations producing accurate results.
• Generated reports regarding system documentation, and help archives.
• Involved in software upgrades and migration of cubes from one environment to another environment.
• Developed calculation scripts for budgeting and forecasting based on actual data.
• Responsible for overseeing automation, running month end jobs, scheduling report batches and ensuring data integrity in the Hyperion environment
• Developed VBA macros in excel to create customized excel reports using the essbase excel add in
• Created custom graphical dashboards with pivots, charts and pinboards in Hyperion Analyzer (Webanalysis), developed javascript to provide functionality to various dashboard objects

Environment: Hyperion Essbase 9.x, Analytical Integration Services (AIS), Hyperion Planning 9 (workforce planning module), Oracle E Business Suite 11i, SQL Server 2005, Windows 2003 Server

Confidential, Framingham, MA

Database Developer/ Hyperion Developer

Responsibilities:

• Involved in upgrading of Essbase 6.x to 7.x with EAS and EIS.
• Extensively involved in designing the new Structure for Metrics. Developed the Load Rules to automatically validate the data and feed into Essbase new structure.
• ETL processes in DTS and SSIS to extract data from SQL Server and provide flat files for Essbase load and build
• Developed calculations in Essbase (Member Formulas, Calculation Scripts, and Business Rules).
• Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods.
• Worked with Essbase integration services to create OLAP model and Meta outline for Essbase OLAP server; developed various filters as per user requirements and drill-through reports . Designed and developed web forms for Data Input.
• Created Essbase applications, security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users, user groups and their security rights

Environment: MS SQL Server 2000, Hyperion Essbase 6.x, SAP, DB2 v 8.0, Crystal Enterprise 11, Windows 2000, Oracle Data Integrator (ODI)

Confidential

Application Developer

Responsibilities:

• Worked on a conversion project to convert the existing front end to use Visual Basic 5.0.
• Was involved in the database design phase of the project.
• Interacted with the Business owners to discuss requirements and creating technical design document.

Environment: Basic 5.0, Oracle 7.0, Crystal Reports, Windows 95.