SUMMARY

• Close to 10 Years of IT Experiences including Hyperion Essbase, planning, Financial reporting, smart view, OBIEE, SQL, Pl /SQ, Tableau.
• Have done Hyperion Essbase upgrade from V9.3.1 to V11.1.1.1, Involved in installation and configuration.
• Migrated Hyperion essbase applications, objects and data from version 9.3.1 to V11.1.1.1
• Involved in backup and recovery of Hyperion planning and Essbase system.
• Working experience with PBCS, multi - currency, data management and financial reporting.
• Strong database development and business intelligence modeling capabilities; Essbase calculation script, business rules and calc manager experience.
• Experience in Maintenance and Administration of Hyperion Essbase Cubes, and strong experience in Data Load Rules, Report scripts and expertise in writing MaxL Commands.
• Strong Understanding of dense and sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed, and optimized report queries.
• Have expertise in Essbase and Planning database optimization, Load rules, calc script optimization and financial report optimization.
• Experienced with Smart view, financial reporting, Tableau and OBIEE reporting.
• Have experience with sql server to create tables and stored procedure for loading data from source files, transform data as per reporting requirement.
• Experience with writing sql queries to fetch data from sql and oracle database to load in Hyperion Essbase to build outline, refresh data in cube and reporting purpose.
• Worked with ODI to transform and load data from source files, data table, using ODI created packages to refresh planning dimension and hierarchies.
• Have experienced with tableau desktop and tableau server, created report and dashboard in Tableau desktop from files, sql database and essbase cube, published datasource and dashboard on tableau server, maintained security of report and dashboard on tableau server.
• 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

• PBCS, Hyperion Essbase V11.1.2.3, V11.1.2.1, V9.3.1 V6
• Hyperion Planning V11.1.2.3, V11.1.2.1
• Hyperion Financial Reporting V11.1.2.3, V11.1.2.1
• Smartview V11.1.2.3, V11.1.2.1
• FDMEE 11.1.2.3, PBCS - Data management.
• Toad 6.5. ODI
• MS-DOS, UNIX, AIX, WINDOWS 2000/XP
• Oracle 9i/10g, MS SQL Server 2005, 2011
• MS Office2003, Star office
• Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables
• Hyperion Financial Reporting V11.1.2.3, V11.1.2.1, Smartview V11.1.2.3, V11.1.2.1, OBIEE 11.1.1.5, Tableau.

PROFESSIONAL EXPERIENCE:

Confidential - Jersey City, NJ

Hyperion Developer

Responsibilities:

• Actively participated in defining requirements, functional specifications, Designing documentations and testing strategies for Profit and Loss application for the Front office.
• Involved in end-to-end development of the PnL applications.
• Fully Involved in Development, administration and Production support activity related to Hyperion Essbase, Financial report, Tableau and sql database.
• Created ASO application for PNL statement for the Bank.
• Created Complex ASO application, created complex MDX script which does financial calculations, Allocation, Currency conversion.
• Created sql load rules to build dimension and load data, created report scripts to extract data from ASO cube for downstream system.
• Created sql tables, stored procedure and complex query for Essbase reporting needs.
• Created Sql queries for metadata and data load to the ASO cube from the sql database.
• Involved in understating the old sql scripts, Stored Procedure and convert them into financial reports needs out of Essbase.
• Creation of MXL scripts and Shell script to automate Hyperion process for overnight and ad-hoc refresh of ASO cube.
• Involved in Performance Tuning of Essbase application to minimize dimension build, data load and cube refresh time.
• Creation of users and users groups and maintaining security. Implemented robust data-access security and user management of Essbase Cube.
• Developed ad-hoc smartview reports for user interface in Essbase database
• Working with other IT teams to gather proper business requirement.
• Creating and maintaining Functional and technical specification for each projects.
• Provided end users training of using smart view, creation of ad-hoc report, and creation of report in Hyperion financial reporting tool.

Environment: Hyperion Essbase 11.1.2.1, 9.3.1, Financial Reporting 11.1.2.1, Hyperion Planning 11.1.2.1, Smart view 11.1.2.1, Sql server 2005, Tableau, Windows 2008R2, AIX 7.1, Microsoft Excel 2010, EXCEL Add-INS

Confidential

Hyperion Essbase developer/Administrator

Responsibilities:

• Involved in gathering requirements, Designing documentations and testing strategies.
• Developed Excel Templates for user interface in Essbase database
• Involved in Performance Tuning to minimize data load time and calculation time.
• Working with Business to gather financial requirement for Business reporting
• Fully Involved in Development, administration and Production support activity related to Hyperion Essbase and Planning.
• Designing, Creating and Maintaining ASO and BSO cube
• Involved in performance tuning of Essbase applications, and optimized calculation scripts to run them faster.
• Creating and maintaining load rules for dim build, data load for Essbase
• Creating and Maintaining Calculation scripts for business P&L calculations.
• Creation of MXL scripts and batch script to automate Hyperion process for overnight and ad-hoc refresh of ASO and BSO cube.
• Creation of detailed level security for Hyperion Essbase and Planning
• Provided Training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.

Environment: Hyperion Essbase 11.1.2.3, 11.1.2.1, Financial Reporting 11.1.2.1, Hyperion Planning 11.1.2.3, 11.1.2.1, Smart view 11.1.2.3, ODI, Microsoft Excel 2007, EXCEL Add-INS

Confidential - Charlotte, NC

Hyperion Essbase developer/Administrator

Responsibilities:

• Actively participated in defining requirements, functional specifications, Designing documentations and testing strategies.
• Created MXL scripts for automation of security, Dimension build and data load purpose.
• Created ASO cube using Essbase studio application for Business reporting purpose.
• Created OLAP model and metadata catalog to update hierarchy in Essbase using Essbase Studio.
• Created connection to RDBMS, created hierarchies, and updated setting and hierarchies in Studio.
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Implemented robust data-access security and user management.
• Developed Excel Templates for user interface in Essbase database
• Developed and maintained Rules file for loading of data.
• Developed and optimized some complex calculation scripts based on the financial and budgeting applications.
• Involved in Performance Tuning to minimize data load time.
• Provided Training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.

Environment: Hyperion Essbase 9.3.1, Planning 9.3.1, Microsoft Excel 2003, HFM 9.3.1, Workspace, Hyperion DIM (Data Integration Management), Web analysis - Analyzer, SQL Server 2000, DTS, T-SQL, Microsoft Visual studio 2008, Windows 2000 Advance Server.