PROFESSIONAL SUMMARY:

• Over 6 years of experience in IT industry with over 4 years of experience as a Hyperion
• Essbase and Hyperion Planning Consultant with an expertise in the area of OLAP/Business Intelligence Solutions.
• Have extensive experience in application designing and development using Hyperion Essbase, ESSCMD, MAXL, Essbase Excel Add-In, Hyperion Smart view, Hyperion Analyzer (Web Analysis), Hyperion Planning, Shared Services, Workspace and Data Integration manager.
• Participated in all stages of Software Development Life Cycle (SDLC) in Hyperion Essbase with comprehensive knowledge of business and requirements analysis, business Process modeling and project planning.
• Designed and developed Essbase cubes using Block Storage Option (BSO)/Aggregate Storage Option (ASO) & Partitioning.
• Experience in designing and maintenance of various applications with excellent balance of Dense and Sparse dimensions for better performance.
• Proficient in working with Rule Files to build Dynamic Dimensions, add Attribute Dimensions, modify existing Dimensions and Members, and Load Data dynamically.
• Skilled in Automation, Optimization, and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Expertise in ESSCMD, MaxL Scripts, Batch Scripts, Dynamic and Aggregate dimension builds, Calc Scripts, Dimension and Data Load Rules.
• Proficient in creating customized Financial and Sales Reports using Hyperion Analyzer and Excel Add-In.
• Understanding of Essbase security features, and ability to create user and group profiles, and assign the proper privileges.
• Assisted end-users with developing complex reports to meet requirements; also developed ad-hoc analysis reports as needed.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.

TECHNICAL SKILLS:

OLAP tools: Hyperion System 9 BI+, Hyperion Essbase 9.x/7.1.3/6.5, Essbase Administration Services, Essbase Integration Services, HAL,  Esscmd scripts, MAXL, Hyperion Reports7.x/9.3, Hyperion  Planning 9.3/4, Data Integration Manager.

Reporting tools: Hyperion Web Analysis, Hyperion Reports, Hyperion  Analyzer 7.x, Hyperion Spreadsheet Add-in,  Hyperion Smart view for office.

Databases: Hyperion Essbase, Oracle 10g/9i/8i, MS SQL Server 2000, MS Access.

Languages: ESSCMD, MaxL, MDX, C, HTML, DHTML, XML, JavaScript,  SQL, PL/SQL.

Data Modeling: Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions  Tables, Physical and Logical Data Modeling, Erwin4.5/4.0/3.0.

ETL & BI: Informatica Power Mart 6.2/5.1/4.7, Business Objects 6.5

Other Skills: Oracle Workflow Builder, SQL*Loader, Lotus Notes, Microsoft Office 97/2000/2003/2007, Maestro, XML Publisher 5.6.

Operating Systems: Windows NT4.0/98/2000/2003/XP/Vista, UNIX (Sun Solaris, AIX)

PROFESSIONAL EXPERIENCE:

Confidential, Ridgeland, MS Jun 08 –till date
Role: Hyperion Techno Functional Consultant

Confidential is a diversified financial services company advising clients in all aspect of private and investment banking solutions. Project required maintenance of multi-dimensional databases for its budgeting, sales forecasting, marketing analysis and reporting using their Hyperion Essbase and BI Tools suite. Reports were delivered via the Excel Add-in and Hyperion Web Analysis.

Responsibilities:

• Worked in gathering the business requirements from the Corporate Finance team.
• Created the applications in Planning and synced the database from Production to UAT environment.
• Involved in new enhancements to the current Hyperion System.
• Created and updated the Web forms for budgeting and forecasting system using System 9 Hyperion Planning.
• Converted BSO Cubes to ASO Cubes and added dimensions to the cube using Hyperion System 9.
• Worked on cube optimization for the application for faster data load, better calculation times of the cube & fast retrieval of the data using dense/sparse settings.
• Created and updated the report scripts for budget data.
• Implemented the DIM (Data Integration Management) process for the extraction and loading of data into the databases and for the dimension maintenance processes.
• Created Adhoc reports for Actual and Budget data validations.
• Monitoring production runs for the daily Nightly processes.
• Worked with batch scripts with Esscmds for load rules and cal scripts scheduling.
• Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports using Web Analysis and Excel Add-in.
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications. Also worked on User Authentication and Provisioning (Role-Based Authorization) Essbase, Planning, Reporting and Analysis and Business Rules users.
• Designed power point presentations for training the Business Users in Essbase Excel add-in and Smart View for office.
• Working on performance tuning issue for the Nightly Process.
• Resolved the issues raised by the business users.
• Worked closely with the other teams to fulfill related tasks.
• Worked with the Oracle Hyperion Support.
• Worked in creating the MSAD domain directories in Shared Services.
• Intensive troubleshooting was one of the requirements due to heavy data loads and the cubes were supposed to be available to the users 24/7.

Environment: Hyperion Essbase 9.3.1,Hyperion Planning 9.3.0,Financial Reports 9.3,Essbase Excel Add-in 9.3, Hyperion Data Integration Management(Informatica)9.3, Microsoft Excel 2000/2003, Oracle10g , Windows NT 4.0, ESSCMD, Smart View for Office, MS Project, Windows 2000.

Confidential, New Jersey, NJ Feb 07-May 08
Role: Hyperion Administration/ Developer 
Confidential is a leading provider of digital office equipment, including color and black & white multifunctional products consisting of copiers, printers, facsimile systems, scanners, digital duplicators, and wide format copiers. We are providing data to the end users across country through our Essbase cubes. I was involved in the working with cubes targeted for net income statements, earning statements and various business reports. Essbase Integration Services was used to load and update the Essbase cubes. 

Responsibilities:

• Involved in total SDLC (Software Development Life Cycle) with Essbase Cube development.
• Worked with business analysts for gathering requirements, functional specifications, testing strategies and developing a project plan.
• I was involved in the working with cubes targeted for net income statements, earning statements and various business reports. Essbase Integration Services was used to load and update the Essbase cubes.
• Imported the Reports, Analyzed and established the links to the existing reports with the new Essbase cube.
• Worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data.
• Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with certain updates on data values.
• Created and executed calculation scripts for automation of actual and forecasting data.
• Wrote MAXL scripts for automation of various database tasks.
• Used Hyperion planning for the development of web forms for the data entry.
• Worked with Securities in Planning, Essbase.
• Implemented the HAL process for the extraction and loading of data into the databases and for the dimension maintenance processes.
• Monitoring production runs for the daily drivers loading, monthly actuals loading, dimension maintenance and the forecast cycling processes.
• Involved in installation and up-gradation of Hyperion Essbase.
• Worked with Essbase DBA for security management.
• Involved in software upgrades from Essbase version 6.5 to 7.1. and 7.1 to 7.1.6
• Prepared Profitability Reports, which detail Unit Cost, Price/Volume Trends, and Expense Variances over prior periods.
• Intensive troubleshooting was one of the requirements due to heavy data loads and the cubes were supposed to be available to the users 24/7.

Environment:Hyperion Essbase 7.1/6.5.4, Hyperion Integration services, Hyperion Planning 4.5, Hyperion Reports7.x, HAL, Microsoft Excel 2000/2003, Web Analysis, Oracle 9i, SQL, PL/SQL, Windows NT 4.0, ESSCMD, Excel Add-in, MS Project, Windows 2000, Sun-Solaris UNIX.

Confidential, Philadelphia, PA Aug 05–Dec 06 
Role: Hyperion Developer
Confidential is a leading provider of credit enhancement for the global financial and capital markets. Project had Oracle and flat files as sources and Oracle as the warehouse database. The modern trends of data warehousing and relational database management were methodically adopted for developing an efficient database. Hyperion Analyzer was effectively used on this database for reporting system. Equally validated and updated data was available to the users, though restricted by their authorized access levels.
Responsibilities:

• Involved in the analysis of existing business model, requirements and mapping the traceability of the same.
• Involved in Designing and Developed Hyperion Essbase Cubes using Essbase 7.1.
• Defined and developed Dimension Load rules, Data load rules to perform dynamic cube build and data loading.
• Created and executed calculation scripts for automation of actual, Budget and forecasting data.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Set up partitions to eliminate redundancy of data.
• Optimized structure and loading through appropriate storage allocations and also optimized calculations scripts.
• Migrated application changes through development environments and to production
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Extensively worked with Essbase Excel Add-In and Query Designer to create Excel sheet reports.
• Designed and implemented standard reports using excel pivoting, drilling and chart utilities.
• Compiled Budgeting and Forecasting entries into Hyperion Planning to generate standard and web-based reports.
• Involved in weekly backup of database and applications
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Actively participated in team and client meetings to synchronize the Hyperion project advancement.

Environment: Hyperion Essbase 7.1, Hyperion Reports, Essbase Integration Services(EIS),Informatica 6, Oracle 9.i, Windows 2003 server, Hyperion Planning , HAL,MS SQL server, Oracle, Unix, Excel Add-in.

Confidential Feb 04-Jun 05
Role: Oracle Developer
Confidential is one of the leading IT software services company which offers a wide range of information technology services including software development, managed IT services, engineering design, data warehouse development, and systems integration outsourcing.

Responsibilities:

• Developed oracle stored procedures accessed by a search engine which performed the near and exact match search of a requested part. Stored procedures were written in PL/SQL to conform to the new normalized data model. Information such as the description of the part, the quantity in stock, division that the part belongs to, and its unit price could be obtained.
• Load data into tables and schemas with the help of SQL * Loader Utility.
• Creation of database objects such as tables, views, database triggers, sequences,
• Synonyms, Partitioning the tables, and indexes.
• Fine Tuning of the SQL Statements to improve the database Performance.
• Interacting with user and troubleshoot the problems involved with the development of stored procedures and triggers.

Environment: Informatica Power Mart 5.1 Oracle 8i, PL/SQL, SQL, Windows 2003 server.