SUMMARY

• IT Professional with 8+ years of experience in OLAP, Business Analysis, Requirements gathering, Designing, Developing/ Testing and Support of Hyperion Enterprise Performance Management Suite (EPM) applications.
• Team player with excellent communication, presentation and interpersonal skills.
• Have the ability to prioritize and manage multiple tasks under pressure and innovative approach to identifying problems and finding solutions.
• Good experience in working with various Hyperion products such as Hyperion Planning 11.x\9.x, Hyperion Essbase 11.x\9.x, EAS, Workspace, DRM, Shared Services, Hyperion Financial Reporting Studio, Smart View, Essbase Excel Add - in on Windows environment.
• Proficient in dynamically building Dimensions, Attributes using rule files and loading fact data in an Essbase Applications by means of several build methods such as generation, level and parent-child references.
• Developed Essbase cubes using Block/Aggregate storage technologies (BSO/ASO).
• Good Experience in application creation using both Hyperion EPMA and Classic Administration.
• Experience in installation and configuration of various Hyperion products such as Essbase Administrative services, Hyperion Planning, Hyperion Financial Reporting Studio, Interactive Reporting Studio, Shared services, Hyperion Smart view.
• Performing Regular maintenance of Hyperion products - Installation of patches, analyzing the issues and proposing solutions.
• Expertise in administrative tasks including Backups, Automation, Maintenance of application in sync across the environments and providing production support, troubleshooting the user issues.
• Expertise in Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Experience in performing migration between different environments.
• Implemented various types of calculations such as Dynamic & Two-Pass, Member formulas, UDA’s, attributes, driver driven calculations, allocations and XREF functions for calculations.
• Used Outline Load Utility to load metadata for classic planning applications.
• Expertise in loading data into the cube, validating data into cube, Metadata Modification, Provisioning users.
• Expertise in writing custom Essbase calculation scripts, automating the Essbase cube metadata and data load, backups using MaxL and Batch scripts.
• Hands-on expertise in using Essbase Excel Add-In and SmartView Add-In.
• Involved in Life cycle of Hyperion product implementation.
• Experience in creating customized Financial Reports according to the client requirements using the Financial Reporting Studio and Interactive Reporting Studio.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Planning System 11.1.2.2\11.1.1.3\9.3.1, Hyperion Essbase 11.1.2.3\11.1.1.3\9.3.1,HyperionSharedServices 11.1.2.2\11.1.1.3\9.3, Oracle Hyperion Integration Tools: FDM, Smart View, Essbase Excel Add-in, Essbase Administrative Services, Essbase Integration Services and Essbase Studio.

Reporting Tools: Hyperion Financial Reporting Studio, Web Analysis, Interactive reports, Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View.

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.

Languages: VBScript, HTML, SQL, PL/SQL, C, Perl.

Databases: Oracle 10g, MS SQL Server (2008, 2012), MS Access.

Operating Systems: Windows Server 2012/2008/2003

Web & Application Servers: Tomcat Apache, Web Logic, Web Sphere.

PROFESSIONAL EXPERIENCE

Confidential, Livingston, NJ

Hyperion Developer\Administrator

Responsibilities:

• Participated in gathering business and functional requirements from detailed business meetings and translated them into program specification documents.
• Involved in the development and support of the Planning applications.
• Extensively used outline load utility for building the dimensions of the planning application.
• Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget data.
• Adjustment calculations, budget and forecast values based on previous data.
• Developed OLAP models and Meta outlines in EIS and scheduled the outline build.
• Deployed the Essbase models developed from cube schemas in Essbase Studio as cubes onto the Essbase server.
• Created new versions by merging different hierarchies across various versions using the blender in DRM.
• Created As of version from the current working version for the next period of cycle.
• Created Books to categorize the exports.
• Developed both ASO and BSO applications depending on the requirement.
• Developed Rules files pull the data from Oracle database and load it to Essbase cube.
• Developed complex MDX formulas for calculating the reporting sign, activity which is a calculated value of actual and forecast balances.
• Created complex CALC scripts and involved in performance tuning.
• Developed MaxL scripts to load data files and automate Essbase operations.
• Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with data based on the fiscal year.
• Responsible for performance monitoring backup and recovery of the cubes.
• Created security filters and groups to regulate the user access to applications.
• Have understanding of how OBIEE works and provided data for OBIEE reporting applications.
• Performed query based aggregations to enhance the performance of reports on the cubes.
• Created report scripts to extract data from the Essbase cube.
• Involved in the design and implementation of Essbase security by assigning filters to groups.
• Created standard templates in Smart view and trained users to use Smart View for adhoc reporting.
• Involved in troubleshooting report issues like performance and bugs reported by users.
• Involved in trouble shooting the system related issues with Oracle Support and worked on several service requests with Oracle on these system related and functionality issues.

Environment: Hyperion Essbase 11.1.1.3/11.1.2.2/11.1.2.4 , Hyperion Planning 11.1.1.3, Hyperion Financial reports 11.1.1.3 Smart view, Essbase Excel Add-in, Essbase Administrative Services, Hyperion Shared Services, Hyperion Interactive Report Studio, Essbase Integration Services, Essbase Studio, Hyperion Workspace, and Windows 2012/2008.

Confidential, Piscataway, NJ

Hyperion Developer\Administrator

Responsibilities:

• Involved in the development of Web forms and business rules on the Planning app.
• Developed smart lists, menus to be assigned to the web forms.
• Developed task lists to provide step by step guidance for the end user.
• Involved in developing calculation scripts, data import to the Essbase application.
• Design and implement security for the users providing access to the application.
• Developed the rules files to import data into Essbase application.
• Involved in the migration of the artifacts across the environments using LCM utility.
• Created and maintained the dimensions in the Dimensional Library using EPMA.
• Created Applications in Application Library and deployed them as planning applications.
• Wrote several MAXL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Worked with different business users in the design and development of Hyperion reports.
• Involved in the development and support of the Planning applications.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning, Essbase Administration Services, ODI, FDMEE, EPMA, Hyperion Financial Reporting, Smart View, Windows.

Confidential, Cleveland, OH

Hyperion Consultant\Administrator

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Created web forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Developed HBR (Hyperion Business Rules) with Run-Time Prompts for realizing various business functionalities like creating a project, enter the planned amount for the project and consolidating to the upper level of the hierarchy.
• Design of architecture and Installation, Configuration of Hyperion 11.1.1.3 system consisting of Planning, Essbase and Financial Reporting Studio, Shared services and Workspace.
• Created additional accounts and migrated existing accounts from other application.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library by importing GL information from ETL processed data mart.
• Involved in the development of CALC scripts for top down allocation of project budget, forecasting, rule files for loading budget and actual data to the Essbase cube.
• Designed ODI Interfaces Extraction/Loading/Transformation, data consolidation, data Integration
• Used ODI Topology Manager to create connections to various technologies (such as Oracle, SQL Server, Flat files, XML, etc.,)
• Involved in maintaining and creating new data servers, connections for different data sources through the ODI Topology manager.
• Used ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration and Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports using SmartView.
• Created Books and batches for the financial reports for providing information for all selected fiscal years as requested by business.
• Scheduled the batch reports to run weekly.
• Involved in the automation of nightly backups, extraction of data and loading data.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning Capex11.1.1.3, ODI11.x, Hyperion Financial Reports11.1.1.3, Smart view, Essbase Excel Add-in, Essbase Administrative Services, Hyperion Shared Services 11.1.1.3, Hyperion Workspace 11.1.1.3 and Windows2008/2003.

Confidential, Strongsville, OH

Hyperion Administrator

Responsibilities:

• Developed various cubes, Calc scripts, load rules forecast and budgeting for the next 24 months, combining various cubes, SQL performance tuning and optimized Calc time.
• Worked on Hyperion budgeting and forecasting solution to integrate financial and operational planning processes and improve business predictability.
• Built an efficient and optimized Hyperion cube and train members for support.
• Worked with financial users to understand the functionality and to identify the outline structure to build a cube.
• Created a new planning application which will overtake the present budget application.
• Built reports using Financial Reporting Studio for different end-users, including Financial Users, Sales Managers, Actuaries, and Cost-Center Administrators.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting.
• Loaded monthly actual and forecasting data into Fin plan application and load FTE’S, and pay grades into workforce application.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting and workflow process.
• Wrote several MAXL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Maintained security by creating, managing, and assigning provisions to the users in the shared services.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments along with installation and configuration of ODI and ERPI.
• Created UAT Scripts closed worked together in creating Training Manual.

Environment: Oracle Essbase 11, Hyperion Planning, Hyperion Smartview Add-in, Oracle Hyperion Financial Reporting, Hyperion Workspace, Windows 2003 Server, SQL Server 2008.

Confidential

Hyperion Developer\Administrator

Responsibilities:

• Created complex Member Hierarchies, Calculation and Report scripts and Data Load rules.
• Extensively developed numerous Essbase ASO and BSO Cubes with balanced Dense and Sparse dimensionalities.
• Involved in the development of Essbase OLAP model applications using Star and Snowflakes schema design.
• Involved in maintenance and modifications of batch scripts and Meta data outline.
• Added drill down, drill up and filter capabilities in most of the reports.
• Created numerous dashboards by using Web Analysis and Interactive Reporting.
• Managed application security for Hyperion Planning and Essbase users through Hyperion Shared Services.
• Used Essbase EIS for dimension building, data loading and developing reports.
• Extensively worked for entity-department level forecasting requirements with Hyperion Planning application.
• Installed and configured Hyperion EPM product suite on Windows.
• Restructured and redesigned existing Essbase cubes for better performance enhancements.
• Handled performance tuning through query tracking method and data load calc scripts optimization by using MaxL.
• Worked with different business users in the design and development of Hyperion reports.
• Provided training to IT support staff and different user groups on weekly, monthly, quarterly and yearly Data and Reports rollup.

Environment: Hyperion Essbase 11.1.1.3/9.3.1 , Smart view, Hyperion Planning 11.1.1.3/9.3.1 , HFR, Web Analysis 11.1.1.3/9.3.1 , MaxL, Workspace, Shared Services, Oracle 11i.

Confidential

Hyperion Consultant\Developer

Responsibilities:

• Design enhancements for Hyperion reports.
• Creation of Excel add-in reports.
• Involved in creating various web forms and Hyperion reports.
• Wrote SQL queries for data validation.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Proficient is using MaxL scripts for calculations
• Created various MDX formulas for dimensional metrics.
• Optimized the database outlines to have the optimum load, calculation and retrieval times.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports using SmartView.
• Scheduled batches to process sets of reports and books using batch editor and batch scheduler.

Environment: Hyperion Essbase 9.3.1, Smart view, HFR, Hyperion Planning 9.3.1, Web Analysis 9.3.1, MaxL, Workspace, Shared Services, UNIX, Oracle 11i.