Professional Summary:

• 7+ years of overall functional and technical experience in implementing and supporting BI solutions from mid-size to Fortune 100 Companies.
• Involved in every aspect of development lifecycle from requirements gathering, design docs to development, implementation and maintenance.
• Certified Essbase Consultant, Certified Planning Consultant.
• Specialized in Hyperion Application Development and administration using Hyperion System 11x, Essbase ASO, and BSO, Planning, Financial Reporting, Essbase Studio and ODI.
• Worked with many ETL tools such as HAL, DIM, SSIS, ODI, SQL interface, FDM etc.
• Very good experience on writing Member Formulas, Calc Scripts, BR's, MDX for calculations, allocations, aggregations etc.
• Expertise in Automations, Optimizations, Converting BSO to ASO, Database backups, Partitioning, ESSCMD, MAXL, MDX, VB scripting etc.
• Experience in Hyperion System9 modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards)
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Experience in installing and maintaining infrastructures. Performed day to day administrative tasks.
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes using CONTROL-M
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Expertise in design documentation and testing strategies.
• Involved and handled many client meetings with many diverse teams during development process.
• Hands on experience with Hyperion V 11.x Essbase, Planning.
• Hands on Experience with user training on planning, FR, Smart view etc.

Technical Summary
OLAP Tools : EPM 11x, EPM 9.3.1 and PreSystem9x.
ETL : HAL, FDM, EIS, Essbase Studio.
Databases : Oracle Fusion/10g, MS-Access, SQL Server, DB2.
Reporting Tools : FR, Web Analysis, Smart view, Report Scripts, Drill through etc
Automation Scripting : MAXL, ESSCMD, BATCH, Shell, PERL, Control - M.and Multimedia Web Design.
Operating Systems : Windows, UNIX, Linux

Confidential, Mclean VA Mar2012 -Present.
Role: Essbase/Planning Consultant

Responsibilities:

• Involved in design and development of the new cubes as per the business requirements.
• Developed the rule file and also the SQL script for pulling and modification in the rule file as per the business requirements.
• Involved in automation of the daily loads by creating the MAXL SCRIPTS and scheduling them using the windows scheduler.
• Was also involved in the daily production issues and the requests from the users.
• Involved in creating the complex Calc script for the Corp ops allocations, Variance ,Cash flow , P&L Reports, Forecast scripts, etc.
• Was involved in developing the work force applications which captures the labor expenses and the head count and the number of billed hours and break hours for the variance analysis and for the daily analysis.
• Developed the various Calc scripts and the Business rules for the planning applications for the variance
• Involved in developing the report scripts for the pulling the actuals, flash and forecasted data.
• Educating the user on the smart view and also about the reporting optionsin the smart view.
• Involved in optimization of the calc scripts and also modifying them according to the user requirements.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Developed the batch scripts and also the MAXL scripts for the daily loads to automate the process.
• Was involved on developing the various web forms and business rules as per the user requirements.
• Involved in developing the security at the user, group and cost center level using the Hyperion shared services and also using the ESSBASE.
• Implemented the column level security for the user so that they can enter the values using the web forms.
• Implemented the cost center level and dimension level security for the user to lock and send the values to the ESSBASE BSO applications.
• Was involved in developing the scripts for extracting the flat files as per the user requirements.
• Was also involved in the adding developing the queries for the checking the addition of the new clients and the cost center into the essbase and planning cubes.
• Was closely working with the CFO, VP,Director of the company and was making the changes according to their requirements.
• Was also involved in upgrading the ESSBASE and PLANNING from version 9.3.1 to 11.1.1.2.
• Involved in various production issues like the calculation and data load issue and optimizing them.
• Developed the transparent partition from BSO cube to the ASO for the data transfer.
• Worked on Excel Add-in Tools to generate various reports to analyze the business.
• Was closely working with the SAP team ,also the other finance and the data ware house team in order to get the data in a consolidated and aggregated manner for the ESSBASE feeds.
• Involved in solving the print server issue and also configuring the ghost script in order to print the web forms or any other reports through planning and HFR.
• Was involved in the daily metadata updates and how the data changes or addition of new cost centers in the ESSBASE.
• Created a detailed documentation on the production and the developing issues and how they are fixed.

Environment:
Hyperion Planning and ESSBASE 11.1.1.3 and 9.3.1, ESSBASE studio, Oracle 10.2.0, Web Analysis, FR reporting, Smart view, Windows 2003, .

Confidential, DC Oct2010- Mar 2012
Role: Essbase/ Planning Consultant

Responsibilities:

• Involved in solving the various production issues.
• Experienced in using the remedy to access the tickets and updating the response and resolution of the tickets.
• Involved in solving the tickets like the actual are not populating and calculating .issues been solved by checking the calc scripts and substitution variables and etc.
• Was involved in creating the various balance sheet ,P&L Reports, cash flow reports and many user specific reports using the financial reporting
• Was involved in developing the BSO cubes for cost centers, restructuring and for residents which were also used in the planning.
• Created replicated and the transparent partition as per the user requirements for the smart view reports.
• Developed the Maxl script for the creating dropping and refreshing the replicated and the transparent partition.
• Involved in developing and monitoring the batch files also the Maxl scripts for the daily loads and aggregating them.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the end user requirements.
• Tested and Cross tested (System testing) all the reports before publishing. And documenting all the errors occurred and how they are been resolved.
• Designed the Security Policy at User, Group, and Entity Levels using Hyperion Shared Services.
• Implemented Column Level security for specific users who can access a part of the tool, like just answers and Dashboards.
• Implemented Security by creating roles & web groups using External tables Authentication.
• Involved in loading metadata into planning by using DIM and Oracle Data Integrator (ODI).
• Involved in developing the web forms and the business rules as per the user requirement.
• Involved in the installation of the various suites of Hyperion like smart view and the EAS console and the excel add-ins on the user systems.
• Provided on call Production support during budgeting and forecasting for Hyperion Applications.
• Was involved in developing the batch script for the start and stop the services. When the workspace goes down.
• Was involved in solving the issues when two different versions of HFR jar files were used.
• Extensively used Guided Navigation for user friendly reports.
• Involved in taking the back ups and also in the monitoring of the batch if the update fails was involved in fixing the data load process.
• Was involved in assigning the security for the dimension without the admin access. By creating a member and then add all the children to that and them assign the access to the group only the one dimension. Both in planning and essbase.

Environment:
Hyperion Planning and ESSBASE 9.3.1,Hyperion Financial Reporting, ODI, FDM, DRM, ESSBASE, SQL Server 2008, smart view, windows 2003.

Confidential, NC Mar`8 to Oct'10
Role: Essbase/Planning Consultant

Responsibilities:

• Involved in designing and creating multidimensional database cubes for financial and analytical business queries.
• Worked on building dimension from multi source interfaces.
• Developed many Calc script and Business Rules to calculate complex values like Cash Cost/ User and YTD commitment, Variance, Capital expenditures forecasts, Budgeted cash flows etc.
• Created and developed planning applications to support budgeting process and ASO cube for reporting via Essbase studio.
• Created flexible workflows, task lists that pertains to the budgeting and planning process
• Created and modified rules files for accommodating data format changes and enabling cube loading.
• Developed complex matrix and logic for move data between cubes. Also used many cross ref functionality between the cubes.
• Implemented mathematical functions for computing derived data and worked on optimization of data loads and calc-scripts.
• Developed batch scripts and Maxl for automating and scheduling month end routines, backups, aggregations etc.
• Leveraged the LCM functionality to create complete artifacts backups by developing automated XML scripts.
• Designed the Security Policy at User, Group, and Entity Levels using Hyperion Shared Services.
• Developed workforce application using Hyperion that captures Labor related expenses and headcounts. This application also provides the additional variance analysis.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the end user requirements.
• Responsible for tuning the multidimensional cubs to optimized calculations time by using the calculation scripts using the combination of ESSCMD and MaxL.
• Minimized the data load redundancy by loading rules files object in-terms of performance and optimization data source files.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Worked closely with stakeholder, Steering team and SME's in project management activities.
• Created P&L statement, Balance Sheet, Cash flow statements and many user specific reports using FR, Web Analysis.
• Involved in loading metadata into planning by using DIM and Oracle Data Integrator(ODI).
• Created numerous templates to generate various reports and for Adhoc reporting.
• Developed end user training documentation and conducted numerous training sessions for end users.
• Developed a procedure for bursting the reports by Dept and Entity.
• Implemented various troubleshooting procedures to recover databases.
• Tested and Cross tested (System testing) all the reports before publishing.
• Provided on call Production support during budgeting and forecasting for Hyperion Applications.
• Created ODBC connections and imported the Physical tables, Views, keys and foreign keys as per the Business Requirements.
• Created the repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Developed Dashboards/Reports using the Oracle Business Intelligence platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Implemented Column Level security for specific users who can access a part of the tool, like just answers and Dashboards.
• Implemented Security by creating roles & web groups using External tables Authentication.
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment::Hyperion Planning and Essbase 11.1.1.3, ODI, DIM, Essbase studio, Oracle 10.2.0, SQL Server 2008, Web Analysis, FR reporting, Smart view, Windows 2003 and UNIX, OBIEE 11g.

Confidential, Ashburn VA Aug'05 to Feb'08
Role: Hyperion Consultant

Responsibilities:

• Involved in most of the phases of the project from requirements gathering to production support.
• Designed a Labor budgeting process and labor variance reporting process.
• Defined and developed Load rules, Functions, Report Scripts to perform cube build and data load.
• Created and executed calculation scripts.
• Design and creation of ASO / BSO cubes for OLAP in Hyperion Essbase.
• Designed a partitioning model for ASO write back capability.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Developed ETL procedures for loading data and metadata followed by aggregations.
• Optimized Data Loads, Calc Scripts, aggregations and retrieval performances etc.
• Developed various forms using Hyperion Planning.
• Support development activities with on site-Off shore.
• Worked on Excel Add-in Tools to generate various reports to analyze the business
• Developed many ESSCMD and Maxl scripts for automation.
• Involved in loading metadata into planning by using DIM.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Implemented robust data-access security and user management.
• Developed numerous reports during the support process.
• Automating of cube refresh through MaxL and UNIX scripts.
• Restructured as well as maintained existing Essbase cubes.
• Optimized the applications to bring down the runtime considerably.
• Applied about 31 patches just for 11.1.1.3 version and numerous for earlier versions.

Environment: Hyperion Essbase 11.1.1.3,Hyperion Planning 11.1.1.3, Hyperion System 9, Hyperion System 9 BI+, Hyperion Essbase 9.3.1, Web Analysis, Spreadsheet Add-in, DIM, Hyperion Application Link, Workspace, Web Sphere, Informatica, Windows 2003 Server, SQL Server 2000 , Windows XP and Unix.