SUMMARY

• 9+ years of professional experience in IT of which more than 7+ years of expertise in the area of Data Warehouse and OLAP software systems design and implementation.
• Strong Technical and Functional experience in Application Architecture, design, analysis, development and administration of various financial applications in Client/Server environment using Oracle EPM System 11, Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Essbase Integration Services(EIS), Hyperion Essbase Studio, Hyperion Financial Reporting(HFR), Hyperion Reports, Interactive Reporting(BRIO),Web Analysis, Esscmd, MaxL, MDX and Essbase Smart view.
• Skilled in data modeling technique using Snowflake and Star Schema for designing data warehouse and data mart modelling.
• Strong expertise in Batch Scripting, Calc Scripting, software installation, system upgrade, server maintenance, data back - ups and security.
• Skilled in Architecture design and maintenance of financial applications using Essbase Block storage (BSO) and Aggregate storage (ASO) Kernels.
• Experience in implementing full lifecycle projects starting from requirement analysis, design, development, unit testing, system testing, integration testing, user acceptance testing etc.
• Extensive experience in creating, maintaining, and supporting all application objects including outlines, formulas, calculation scripts, rules files for dimension builds and data loads, caches, and security profile through Essbase Administration Services (EAS) and MaxL scripts. Also involved in automation of these procedures using Batch Scripts.
• Extensively used Oracle's Hyperion® Workspace, to provide the user interface for viewing and interacting reports using Hyperion Financial Reporting Studio & Hyperion Web Analysis and enabling users to create queries against relational and multidimensional data sources.
• Skilled in optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migration of cubes in different environment.
• Hands-on experience creating reports using Essbase Excel Add-In, Web Analysis, Hyperion Reports, Hyperion Financial Reporting Studio and Smart view.
• Expertise in implementation and Maintenance of Hyperion Planning applications, Business Rules, Web forms, Security Groups and Users etc.
• Proficient in software documentation, technical report writing, collaborative and strong leadership qualities, flexible in work schedules.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills.

TECHNICAL SKILLS

OLAP: Oracle EPM System 11, Hyperion Essbase 11.1.2.3/ 9.3.1 , Hyperion Planning 11.x/9.x, Hyperion Shared Services System 9 BI+, Essbase Integration Services (EIS), Oracle Essbase Studio, HFM, Oracle Data Integrator (ELT), OBIEE.

Databases: Oracle 11g/10g / 9i, Teradata, MS SQL Server 2000/2005,MS Access, SQL plus

Reporting Tools: Hyperion System 9 BI+ Interactive Reporting (BRIO/Hyperion Intelligence), Hyperion Financial Reporting (HFR), Hyperion Web Analysis, Excel Add-in, Smart View.

Programming languages: Java, C, C++, PL/SQL

Operating Systems: Windows 2008/2003/NT/XP,UNIX,LINUX

Web Technologies: HTML, XML, Java Script, Servlets, JSP

Office tools: MS Office 2007/ 2010/2013 - Word, Excel, Power Point, Quick Books, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Sr. Hyperion Consultant

Responsibilities:

• Upgraded the Hyperion Essbase from 11.1.1.2 to 11.1.2.3, designed the cubes architecture for load balance and migrated all financial applications and perform sanity checks.
• Responsible for security migration of ~5K users across all applications using MaxL.
• Involved in Technical Analysis of new Business requirements and outline the proposed IT solution.
• Created Forecast & Budget planning application, Web forms, Implemented the Budget approval process.
• Developed the Schema and created the Drill-Through enabled applications using Essbase Studio.
• Performed tuning, optimization of outline, block size, data and index cache settings and partition of the Cubes.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Worked with EDW team and developed SQL’s for ETL extracts and fast exports for direct load.
• Created SQL load rules for both ASO & BSO applications and used Outline Load Utility for planning applications.
• Optimized the database by configuring Sparse and Dense dimensions, restructured the database by adding new members, Data storage & Consolidation properties.
• Developed Business Rules for allocations, eliminations, moving the data, calculating formulae etc depending upon the business case.
• Involved in application development using Hyperion planning application including (workforce & CapEx) and created Data forms, Menus, Task List, Smart List and business rules.
• Created Financial Reports for downstream applications using both Hyperion Financial Reporting and Report Script Editor.
• Involved in Critical production issues including month-end/fiscal year close and training users on new features and helping with P1/P2 issues.
• Involved in optimization and tuning of the Essbase ASO and BSO Applications (Max 150 GB Size).
• Optimized the applications down-time by creating mirroring the applications across Servers.
• Involved in Modifying Informatica ETL’s and Linux Batch Scripts.
• Provided troubleshooting services and assistance to end-users in resolving error, prepared training material and well-designed documents covering both the functional and technical aspects of the project.

Environment: Oracle EPM System 11, Hyperion Planning 11.1.2.3, Hyperion Essbase 11.1.2.3/11.1.1.2 , Shared Services, Hyperion Financial Reporting, Informatica, Smart view, MaxL, Teradata, Linux OS.

Confidential, Washington DC

Hyperion Essbase/Planning Administrator

Responsibilities:

• Responsible for Security updates, filters creation, data loads jobs monitoring and for monthly forecast and Year end budget close.
• Created rules file for data load from flat files and SQL databases using the optimization techniques.
• Created multiple data forms and Data grids for Hyperion Planning applications for Actual and budgeting data load.
• With each data load, removed the Orphaned parents and restructure the databases and validate the data values.
• Worked with Business to during budget & Year-End cycle maintenance activities, provide backups and data-lock for review by upper management.
• Created and tuned Calculations scripts to improve the calc time, allocate data in top-down order and tuned the application for better retrieval performance
• Used transparent partition to create cube that allow users to analyze current actual, forecast with Prior years archived data.
• Provided Production Support for monthly and quarterly closing and assisted the team on data load and users access issues.
• Migrated the applications from Dev to Prod using Hyperion Life Cycle Management and applied the security.
• Designed multiple reports using Hyperion Financial Reporting and Smart View for end users.
• Prepared data enriched documentation for on Essbase/Planning Data load, Application work flow and training material on Smartview for end Users.

Environment: Oracle EPM System 11, Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Shared Services, Hyperion Financial Reporting, Smartview, ESSCMD, MaxL, Oracle 10g, Linux

Confidential, Tampa, FL

Sr. Hyperion Essbase Administrator/ ODI Support

Responsibilities:

• Gather the business requirements, Analysis of user requirements and outline the proposed IT solution.
• Involved in the installation, deployment and configuration of Oracle EPM 11.1 system in the patch environment.
• Outlined the data flow process into Hyperion Cubes and was involved in development as well as administration of Hyperion Planning application and Essbase application
• Developed outlines, dimension builds using various reference methods, data loads from flat files and Oracle Data Integrator.
• Develop data extracts from the data warehouse environment using ODI.
• Created variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables
• Designed ASO/BSO Cubes using Essbase Administrative Services Console.
• Performed tuning, optimization of outline, block size, data and index cache settings and partition of the Cubes.
• Used Essbase administration activities such as filter creation, creation of users and creation of groups and maintenance of Essbase Servers.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Developed many load rules for loading specific type of data files and for dimension build.
• Optimized the database by configuring Sparse and Dense dimensions, restructured the database by adding new members, Data storage & Consolidation properties.
• Developed many calc scripts for allocations, eliminations, moving the data, calculating formulae etc depending upon the business case.
• Involved in application development using Hyperion planning and creating web forms and business rules.
• Involved in full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Involved in generating various reports in Hyperion Planning.
• Involved in database and security refreshes in Hyperion Planning.
• Interacted with customers related to complex business issues and problem solving.
• Involved in optimization and tuning of the Essbase Block Storage Applications.
• Optimized the applications to bring down the runtime considerably.
• Developed various financial reports (P&L validation) using Hyperion Financial Reporting and Smart View.
• ETL jobs creation & customization using Oracle Data Integrator (ODI).
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Provided troubleshooting services and assistance to end-users in resolving error, prepared training material and well designed documents covering both the functional and technical aspects of the project.

Environment: Oracle EPM System 11,Hyperion Essbase 11.1.3, Hyperion Planning 11.1.3, Oracle Data Integrator 11g, Shared Services, Essbase Excel Add-In, ESSCMD, MaxL, Oracle 11g, Unix.

Confidential, Philadelphia, PA

Hyperion Essbase Developer

Responsibilities:

• Gather the business requirements, Analysis of user requirements and outline the proposed IT solution.
• Design, develop and maintain various Essbase cubes for the enterprise.
• Import the data from different sources Oracle9i, IBM DB2 into Essbase Server.
• Designed ASO/BSO Cubes using Essbase Administrative Services Console.
• Used Essbase administration activities such as filter creation, creation of users and creation of groups and maintenance of Essbase Servers.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Developed many load rules for loading specific type of data files and for dimension build.
• Optimized the database by configuring Sparse and Dense dimensions, restructured the database by adding new members, Data storage & Consolidation properties.
• Developed many calc scripts for allocations, eliminations, moving the data, calculating formulae etc depending upon the business case.
• Extensively used ESSCMD to run calc scripts.
• Involved in application development for integrated supply chain planer using Hyperion planning and creating web forms and business rules.
• Loaded the metadata into Planning application using Planning Outline Load Utility and Improved calculation time on Essbase cubes.
• Involved in full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Involved in partitioning the Essbase server for optimization and tuning of the Essbase sever.
• Developed various financial reports on Financial reporting (HFR) using Essbase Query Designer for analyzing the data at different levels.
• Created 10 Web analysis documents (Analyzer). 6 from the Essbase cubes and 4 from relational source (SQL Server-data warehouse).
• Prepared training material and well designed documents covering both the functional and technical aspects of the project.

Environment: Hyperion system 9.3.1(ASO & BSO), Hyperion planning 9.3.1, oracle9i, Essbase Spreadsheet Add-In, Windows 2003, UNIX, Web Analysis, Hyperion Financial Reports.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Analysis, Design and development of the data warehouse.
• Designed and implemented the database as per the requirement of the application.
• Created Oracle Packages, Procedures, Functions and Triggers using PL/SQL to enforce business roles and /or relationships in data model.
• Developed on-line context-sensitive help pages for the new users.
• Responsible for Code Reviews and PL/SQL Code tuning.
• Created tables, indexes, views and audit triggers.
• Responsible for import and export of data using Oracle’s Export/Import Utility.
• Responsible for monitoring the day-to-day activities of the application for the performance of the database.