SUMMARY:

• 10 years of Designing, Developing and Testing of Hyperion Essbase and Planning applications.
• Extensive experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11x/9.3.1/7.X Essbase Integration Server (EIS), Hyperion Reports, Hyperion Analyzer, Hyperion Planning 9.x/11.x, Essbase Spreadsheet Add - in, Essbase Query Designer on Windows 2000/NT4.0 and Unix environments.
• 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.
• Implemented/Installed the EPM applications Essbase 11.1.2/9.3.1 , Planning 11.1.2/9.3.1 in Windows Server 2003,Windows2012 R2.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Up gradations, Maintenance, Database backups, Performance tuning, optimization of BSO Cubes, Dense/Sparse settings, partitioning etc.
• Expertise in Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Financial Reporting Studio, Hyperion Reports, ESSCMD, MaxL, MDX, Excel Add - in, Smart view and Hyperion Financial Management.
• Expertise in end-to-end implementation, migration, production support, installation and configuration, development and support of various projects; including designing, development, coding, and implementation of software applications.
• Expert in the installation, configuration, application administration server settings, and backups, client installations of Hyperion products such as Essbase Planning, Work Space, Shared Services, BI plus, Analyzer and Hyperion Reports on both Windows and Linux environments
• Experience in Migration of artefacts between various environments using LCM and various migration utilities. (Application/security migrations)
• Involved in Upgrading Hyperion applications from 9.3.1 to 11.1.1.3, 11.1.2.1 to 11.1.2.2 and 11.1.1.3 to 11.1.2.3,11.1.2.2 to 11.1.2.4.
• Strong knowledge of architecture of EPM 11.1.2 and oracle data integrator.
• Created ODI Interfaces to update Hyperion Planning/Essbase Metadata and to import Essbase Data and to export data from Hyperion Essbase to File System and relational databases.
• Strong experience in writing custom Essbase Calculations Scripts and complex business rules.
• Experienced in creating/managing/maintaining security for wide range of Hyperion products through Hyperion Shared Services and also have good exposure in managing and configuring MSAD.
• Worked on Dimension Building, Data Loading, Database Optimization, Data partitioning, performed database backups, Dense/Sparse settings.
• Extensive experience in Calc Scripts, Report scripts, and automated the cubes using MaxL and Esscmd.
• Expert in developing application security process, creating users/groups, security profiles and application access to different groups using filters.
• Expert in software installation, configuration, upgrading, testing and migrating of cubes in different environment.
• Experience in performing upgrade, Maintenance, database backups, Performance tuning and Optimization.
• Experience in handling Recovery process in Server/application crashes.
• Developed and delivered ETL scenarios in the context of Services Oriented Architecture SOA
• Worked on Bulk data loading on Oracle EBS environments and involved to resolve the production issues.
• Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
• Gathering requirements from users to develop interfaces and packages.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Strong SQL, PL/SQL ETL/ELT knowledge. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL to move the changed data across multiple environments using DB links.
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
• Has a sound base in tools like Databases (Oracle, SQL, DB2, Teradata and MS Access), ETL (Informatica),ODI, QA etc. & Extensive experience with Essbase administration activities such as database backups, recovery, optimization and performance tuning.

TECHNICAL EXPERTISE:

OLAP Tools: Hyperion System 11/9 BI+, Hyperion Essbase 11.x/ 7.x/6.x, Essbase Administrator Services,Hyperion Shared services,ESSCMD, MaxL, MDX and Hyperion Planning system 11.1.2/9.3.1 /4.x

Databases: Essbase 9.3.1, Oracle 8i/9i/11i, MS Access, SQL Server 2000/2005,DB2, MS Access.Teradata.Pl/Sql

Reporting Tools: BI+, Financial Reporting, Web Analysis, Hyperion Reports, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion smartview

Internet Tools: HTML, DHTML, XML,VB Script, Java Script

Languages: MDX, MaxL, ESSCMD, SQL, Perl, MS SQL, MS Exchange, Shell Scripting, UNIX Scripting DHTML.

Web Servers: Apache Tomcat, Web Logic, Web sphere

ETL Tools: Informatica power center,Oracle data integrator

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Hyperion Developer/Production Support

Responsibilities:

• Setting up Essbase outline as per the business required documents
• Involved in designing and building of cubes and assigning member properties
• Played an active role in all phases of the development lifecycle including requirements gathering and analysis, application design and development, implementation, and maintenance.
• Developed stored procedures to simplify the source data before loading into essbase.
• Involved in writing complex calc scripts as per the business requirements.
• Implementing backup scripts for Essbase Lvl0, All data and Essbase objects by writing ESSCMD’s, MAXL and UNIX Shell Scripting.
• Worked extensively in preparation of monthly forecast of revenues.
• Developed ASO cubes to maintain huge set of data to avoid the retrieval /calculation performance issues as these ASO cubes are the master cubes for GL and PCS information.
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Automating back up scripts and Start/stop Hyperion Services on daily and weekly basis.
• Involved in optimization of outline and calc scripts
• Involved in designing the load rule files for loading data from Excel sheets and flat files
• Involved in designing security filters and assigning them to end users
• Involved in writing Esscmds, MaxL scripts and UNIX shell scripting for automation of Essbase jobs through Autosys scheduler.
• Created Web Forms/Data Forms in Hyperion Planning for users to input forecast, budget, actual, accounting changes and other data.
• Primary responsibility include installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL
• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Extensively involved in production issues.
• Gathering requirements from users/business to develop interfaces, packages, Load plans.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Worked closely with the end users/business and designing the documents to the track changes.
• Coordinated with the on-site and off-shore team and working on service requests as team.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Integrated various source system Oracle GL, Oracle HR and capital expenditure sources to Hyperion Planning using ODI Oracle Data Integrator by creating and complex Interfaces.
• Created complex ETL on Oracle Data Integrator ODI to meet the end user data requirements.
• Crated Interfaces to automate the metadata and data updates for Hyperion Essbase and Planning applications.
• Developed complex Hyperion Business Rules with run time Prompts and substitution variables.
• Worked on various simple and composite web forms in Hyperion Planning application.
• Created projects and placed all the required business rules in the projects. Security Provisioning is provided to the business rules.
• Developed the UNIX shell scripts for auto data loading and monthend rollovers.
• Migrated essbase applications from Sun Solaris to AIX servers
• Involved to loading general ledger feeds from GSAP for the Essbase actual cubes.

Technology/Tools: Hyperion Essbase 11.1.2.3/11.1.2.4 , Hyperion Planning, ODI 11g, OBIEE 11.1.1.5,10.3, DAC 7.9.6, Excel Spreadsheet Add-In, Linux, Shell scripts, Unix Scripting, Autosys, FTP,SFTP, Window Server,PL/SQL, Oracle RDBMS, LDAP/MSAD.

Confidential

Responsibilities:

• Involved in designing, modifying and building of cubes and assigning member properties
• Involved in creating, modifying calc scripts as per the business requirements to solve production issues
• Installation, configuration, troubleshooting and application demo presentations of Hyperion 11.1.2.2 to 11.1.2.4 and Aix platform.
• Migrated essbase applications from Sun Solaris to AIX servers
• Installed and configured Oracle EPMA suite in AIX environment.
• Migrated the all essbase applications and data from 11.1.2.2 version to 11.1.2.4 version.
• Migrated the all security from older version to new version(shared services)
• Developed the Replication and Transparent Partitions for several cubes as per the business requirements.

Confidential, Washington, DC

Lead Hyperion Developer

Responsibilities:

• Was responsible for designing and developing of Project Forecast and Revised Budget processes for the business.
• Involved in designing, modifying and building of cubes and assigning member properties/
• Involved in creating, modifying calc scripts as per the business requirements to solve production issues.
• Involved in optimization of outlines and calc scripts.
• Involved in designing the load rule files for loading data from Excel sheets and flat files.
• Involved in designing security filters and assigning them to end users.
• Involved in writing Maxl scripts for automation of essbase jobs through Autosys.
• Developed the UNIX shell scripts for auto data loading and Month end rollover.
• Created planning applications and data forms to allow the end users to enter data as per the budgeting process.
• Created financial reports and scheduled them as per the business needs.
• Created Static and Dynamic Books Using Hyperion System 9 BI+ Workspace.
• Created Batch Processes to Schedule the Execution of Reports and Books.
• Published and scheduled handful of trending analysis dashboards and reports in Hyperion Workspace for the Strategic Finance team.
• Developed the Replicated and Transparent Partitions for several cubes as per the business requirements.
• Developed batch process in Autosys for different databases/cubes.
• Developed Oracle views to support SQL Drill through functionality for Essbase cubes.
• Developed Shell and Unix scripts for Batch process.
• Loaded actuals into Planning Application and consolidated actuals, forecast and budget numbers to provide a complete financial view.
• Provided 24/7 EssBase technical support, offered suggestions and proposed solutions to resolve issues.
• Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Developed Excel Templates for user interface in Essbase database
• Modified the existing calc scripts, outlines, security, reports and other related programs as the business rules changes.
• Worked on different reporting template as per business requirement.
• Worked on maintenance activity like weekly load, daily load and monthly load data files.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into Data Ware House DWH .
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Oracle data warehouse.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Created and Imported/Exported various Sources, Targets, and mappings in interfaces using ODI Designer and generated scenarios and scheduled as per client requirements.
• Loaded data from different source systems to target warehouse using interfaces with Knowledge modules like LKM, IKM and CKM for data quality check.
• Developed several Interfaces, Packages, Procedures and Scenarios in ODI
• Used most of the transformations such as the Source table joins, using Expression in mapping area, aggregations like SUM, MIN, MAX using in mappings, lookups, Filter, Datasets.
• Customized ODI KM like LKM and IKMs
• Customized calc scripts, batch script, rule files for data load.
• As responsible for maintaining and administering security permissions for users and groups.
• Customization of applications, smart lists, data forms, menus and dimensions where done through workforce planning.
• Involved in day to day Production support, month end and year end process.
• Monthly accounting close- Responsible for running month close jobs to load previous month data.
• Developed batch scripts using MaxL and ESSCMDs and rule files to load data from feeder files.

Technology/Tools: Hyperion Essbase , Hyperion Planning, Hyperion Financial Reporting, ODI, Excel Add-inns, Smartview, Oracle and Microsoft Windows XP.

Confidential, Ohio

Hyperion Developer

Responsibilities:

• 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.
• 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 MaxLscripts 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.
• 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.
• 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.

Technology/Tools: Hyperion Essbase, Planning, Hyperion System (Planning, SmartView, BI+ Workspace, Web Analysis, Interactive Reporting, Financial Reporting,, Essbase (BSO), Excel Spreadsheet Add-In, BI+, Hyperion Reports, Linux, Perl, Shell scripts, Unix Scripting,, Apache Tomcat, FTP, Window Server, ODI,PL/SQL,Oracle RDBMS and LDAP/MSAD