SUMMARY

• 7+years of professional IT experience in OLAP, Business Analysis, Requirements gathering, Designing, Developing and Testing of Hyperion Enterprise Performance Management Architecture EPMA and Java applications.
• Over 7 years of Strong experience in Hyperion Planning 11.1.2, 11.1.1.3/9.3.1 , Hyperion Essbase 11.1.2/ 11.1.1.3/9.3.1 /7.x, Hyperion Financial Reporting.
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add - In, Hyperion Analyzer, Smart view and OBIEE.
• Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view, Hyperion Intelligence designer 8.3.2, MDM or DRM, ODI, OBIEE, EPMA.
• Expertise in writing Calc Scripts, Report Scripts and Load rules. Good Exposure on Hyperion Dashboard.
• Implemented/Installed the EPM applications Essbase 11.1.2/9.3.1 , Planning 11.1.2/9.3.1 in Windows Server 2003.
• Creating Macros/ CDF’s using VB scripts through Excel Spreadsheet Add-in, Smart views.
• Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulas and Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Upgradations, Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Created & Used ODI routines to update the metadata changes in Planning.
• Involved in developing Web forms using Hyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Possess excellent project management skills in managing, developing and implementing the project. Possess excellent analytical, interpersonal, logical, communication skills, reliable and great team player.
• Experienced in knowledge transfer, preparing the required documentation and training the clients.
• Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

TECHNICAL SKILLS

OLAP Tools: PBCS, EPBCS, Hyperion Essbase 6.5, 7.1, 9.2, 9.3.1,11.1.1.3,11.1.2.3,11.1.2.4 and Hyperion Planning 4x, 9.2, 9.3.1, FCCCS, Hyperion Financial Management (HFM) 9.3.1 and 11.1.2.2.

Reporting Tools: Hyperion Reports, OBIEE, Interactive Reporting 9.3 and 11.1.2.3, Financial Reporting, Smart view

ETL Tools: Oracle Data Integrator (ODI), Data Relation Management (DRM). FDQM, FDM, FDMEE.

Languages: SQL, PL/SQL, C/C++, Shell Scripting, VB, VB Script, Java, Java Script, PL/SQL

Operating Systems: Exalytics server, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux

Databases: Oracle 9i, Oracle 10g and Oracle 11g8i, Oracle 12c, 9 MS SQL Server 2000/2005, DB2

Markup Languages: Core FTP, TOAD, VMWARE, SQL Developer, MS-VISIO, Tiger VNC, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Essbase/Planning Lead Consultant

Responsibilities:

• Was responsible for creating, building, testing and documentation of reports for Co-operate reporting purposes and also for all the business units.
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units, assigning and assisting users with tasks for functioning of Hyperion suite of products like ESSBASE, Planning, generating Reports and Analyzing the data.
• Was responsible for designing and developing of Project Forecast and Revised Budget processes for the business.
• Created Excel VBA base Overlay template for forecast data.
• Worked on different reporting template as per business requirement.
• Worked on maintenance activity like weekly load, daily load and monthly load data files.
• Customized Calc scripts, batch script, rule files for data load.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created PL/SQL stored procedures, functions and triggers.
• Developed interfaces for loading the lookup and transactional data.
• Installed and configured TOAD for Oracle and MS SQL Server.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Performance tuned the ODI interfaces.
• Optimized the knowledge modules to improve the functionality of the process.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Was responsible for building financial reports for VP for Engineering and co-operate using Hyperion Financial Reporting and Scorecard Template.
• Was responsible for maintaining and administering security permissions for users and groups.
• Responsible for EPM systems administration, installation, configuration, performance tuning, back-ups, maintenance and other aspects of the development in the Hyperion Systems (Hyperion Financial Management, FCM, ARM, FDMEE, Hyperion Planning, Essbase, Shared services and EPMA etc.).
• Served as a subject matter expert for development/implementation team for DRM.
• Assist infrastructure personnel to define and document the technical architecture that includes Planning and DRM.
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Involved in Initial configuration of DRM for various Hyperion Target applications.
• Converted ADS files and import metadata from ADS file into DRM.
• Create new bridges for sending metadata to Hyperion applications through EPMA.
• Migration of DRM components from environment to environment.
• Outline Load Utility and Cube Refresh Utility

Environment: Hyperion Essbase 11.1.1.3/11.1.2.2 , OBIEE, EAS, Hyperion Planning 11.1.1.3/11.1.2.2 , ODI, Hyperion workspace 11.1.1.3/11.1.2.2 , Essbase Deployment Services, FDM and DRM.

Confidential, Berlin, CT

Sr. Hyperion Essbase/Planning/DRM Consultant

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for the Regional agencies application and maintenance of the same.
• Implemented the cubes for reports on various scenarios as per business requirement.
• Developed the outlines using the text file method and by using Interface tool ODI.
• Created Hyperion Planning Application for North America and other region.
• Checking Err File for Dimension build as well as data load, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Created Workflow Process for User to submit the data to Approver and after Approval data Move to another layer.
• Worked as an Essbase administrator and created rules and give access privileges to the users.
• Was responsible for administrating the task of maintaining the server, providing user security and application maintenance.
• Implemented EPM applications Essbase11.1.1.3 Planning 11.1.1.3 in Windows server.
• Developed Web Forms using Hyperion planning web client for the users to input accounting changes and other variance explanations data.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Written MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes and maintenance for daily backup.
• Trouble shooting the errors which we face in Essbase, planning, ODI.
• Involved in to maintenance activities like Verifying the new dimensional members which are coming in actual data load daily or monthly, Restoration procedure, security maintenance.
• Maintaining the Planning and essbase objects like, outlines, calc scripts, Maxl scripts, report scripts, Partitions, Substitution variables, location aliases, business rules, run time prompts, global variables, security filters.
• Work on 6 BSO Cube and converted into one ASO Cube.
• Set up users and groups according to the Business Entity and Financial Channel security to users and groups from Hyperion shared services and assigned security to web forms.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: Hyperion Essbase 11.1.1.3/11.1.2.2 c, EAS, EIS, Hyperion Planning 11.1.1.3/11.1.2.2 ,, Hyperion workspace 11.1.1.3/11.1.2.2 , SQL Interface, Toad, SQL server 2005, Essbase Deployment Services.

Confidential, Danbury, CT

Hyperion Essbase/Planning Lead (Dev/Admin)

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for the Regional agencies application and maintenance of the same.
• OBIEE 11g, the Oracle Business Intelligence Server generates queries optimized for each data source, appropriately aggregates them, Web browser via easy-to-use dashboards and reports.
• Implemented the cubes for reports on various scenarios on Actual/Budget/Forecast.
• Developed the outlines using the text file method and by using Interface tool ODI.
• Created Rule files for Data Loading in to the cubes. And for Dimension building as well.
• Checking Err File for Dimension build as well as data load, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Was responsible for handling the administration of BSO/ASO cubes and creating Batch files, rule files using Maxl for data loading..
• Implemented/Installed the EPM applications Essbase 11.1.1.3/9.3.1 /Planning 11.1.1.3/9.3.1 in Windows server.
• Developed Web Forms using Hyperion planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• Work on OBIEE Essbase Reports 11.1.1.3.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Written MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes and maintenance for daily backup.
• Created DRM imports and Exports for Metadata changes.
• Trouble shooting the errors which we face in Essbase, planning, EPMA, ODI and DRM.
• Involved in to maintenance activities like Verifying the new dimensional members which are coming in actual data load daily or monthly, Restoration procedure, security maintenance.
• Maintaining the Planning and essbase objects like, outlines, calc scripts, Maxl scripts, report scripts, LRO's, Partitions, Substitution variables, location aliases, business rules, run time prompts, global variables, security filters.
• Set up users and groups according to the department and maintained security to users and groups from Hyperion shared services and assigned security to web forms.
• Installed and configured Hyperion financial reporting studio, web analysis and Hyperion spread sheet add-in in the client systems.
• Developed some key reports like direct cost P&L summery, Income statement, Net Margin, Balance sheet and Headcount reports by using financial reporting studio.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: Hyperion Essbase 11.1.1.3/9.3.1 , EAS, EIS, Hyperion Planning 11.1.1.3/9.3.2 , Hyperion financial Reporting 11.1.1.3, Hyperion workspace 11.1.1.3, Hyperion web analysis, ODI, MAXL, Essbase Deployment Services.

Confidential, Richmond, VA

Sr. Hyperion Essbase Developer

Responsibilities:

• Worked as an Essbase administrator and created rules and give access privileges to the users.
• Was responsible for Designing and Reporting for forecasting using the Hyperion Intelligence designer 8.3.2.
• Developed the Profit and Loss statements, Balance sheets reports and the Essbase cubes for them.
• Used Hyperion Application Link (HAL) to integrate for data sources to Hyperion planning database.
• Worked on workforce planning and capital application.
• Was responsible to provide data integrity and verification of financial reporting using Hyperion FDM application.
• Worked on workforce planning to handle and forecasting of data for financial expenses.
• Was responsible for reporting using the AS cubes.
• Was able to build the outline using DIM adapter for Essbase.
• Was responsible for handling the administration of BSOcubes.
• Was responsible for creating and maintaining of web data forms and journals using HFM.
• Used Hyperion Planning 9.3.1 to create new web forms to reduce the work load of the user thereby focusing on a Planning, Budgeting and Forecasting.
• Was responsible for building financial reports using Hyperion Financial Report.
• Created new complex calc- scripts for data calculations for reporting purposes and also re-scripted existing calc scripts for more effective calculations.
• Responsible for Data Optimization and performance tuning for Essbase.
• Was responsible for transfer of data from General Ledger (GL) and ERP systems using DRM (Data Relational Management).
• Was responsible for developing dimension build rules, data loading and also maintain calc scripts via Esscmd and Maxl scripts.
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units.
• Created Dashboards for reporting using the Web Analysis.
• Was responsible for leading the team to maintain and development of Essbase cubes.
• Created reports using Web Analysis for financial data.
• Was responsible for providing support for the project team for development until the production.
• Documentation of all the issues which could occur for the users and their respective solutions for reference was been created.
• J D Edwards is the ERP used in the back end and Actual data was pulled from JD Edwards’s table space.

Environment: Hyperion Essbase 9.3.1,DB -2, Hyperion Reports V 9.3, Hyperion Analyzer, Hyperion Integration Services, SQL Server, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX, Windows.

Confidential, Chicago, IL

Hyperion Essbase Developer

Responsibilities:

• Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.
• Gathered requirements and developed a project plan.
• Prepared an optimized data source.
• Developed aggregate storage cubes (ASO) using Essbase 7.1.
• Developed a transparent partition with ASO / BSO cubes to leverage advantages of both technologies.
• Developed rule files for loading data and for dimension build.
• Implemented robust data-access security and user management.
• Automating of cube refresh through MaxL and UNIX Scripts.
• Optimized data loads and calculation scripts and maintained existing Essbase cubes.
• Optimized the applications to reduce runtime.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Maintained the OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing appropriate documentation.

Environment: Hyperion Essbase 9.3, Hyperion Reports 9.3, Hyperion SQR, Hyperion Planning, PL/SQL, SQL Server, Excel Add-in, Windows NT 4.0, Oracle 8i.