SUMMARY:

• Total 8+ years of experience in IT Industry and 8 years of experience in Infrastructure, Analysis, Designing, Deployment, Testing, Upgration/Migrations, Reporting, Administration and Support of enterprise - wide Business Intelligence / DWH using Hyperion Products Suite.
• Having Strong Experience in working with Hyperion Essbase 6.5/7.1/9.3.1/11. x,Hyperion Planning 9.x/11.x,Hyperion Financial Reporting 9.x/11.x.
• Expertise in configuring Active Directories and SSO through Shared Services
• Expertise in creating and maintain new native Users, groups and provisioning through Shared Services
• Expertise in upgrade/migration and applying patches to Oracle Hyperion EPMA 11.x
• Expertise in designing/maintaining planning applications, data sources, plan types, setup dimensions, members hierarchies, member formulas, user defined elements
• Expertise in Loading/Maintaining metadata hierarchy, data, and cube refresh using DIM (Data Integration Management) ODI (Oracle Data Integrator), HAL (Hyperion Application Link), FDQM (Financial Data Quality Management).
• Knowledge on DRM 11.x.
• Developed new Dash boards and adhoc reports for different Business teams using Interactive Reporting.
• Created queries and developed reports using Hyperion Intelligence explorer (Brio/Interactive Reporting.
• Expertise in migrating Hyperion Planning Apps, Artifacts and Security by using LCM Utility 11.x
• Expertise in migrating Business Rules/Calc Scripts, Webforms, Reports and Essbase objects from DEV/SIT/UAT/PROD by using LCM Administrator Utility 11.x and Pre-build Scripts 9.x.
• Knowledge on OBIEE 10.x/11g.
• Administration and maintenance of Hyperion Planning HFM,FDM,DRM, ODI and Essbase ver 11.1.2.1
• Ensure monthly close process runs smoothly in Hyperion Planning, HFM, FDM, DRM, ODI and Essbase.
• Optimizing server side and client side by changing .cfg configuration settings, partitioning, cache settings, fragmentation, dense/sparse configuration settings and calculations.
• Building dimensions, attributes, and shared members using rules files in an Essbase outline by means of several build methods such as generation, level, and parent-child references.
• Loading data through Free-Form loading, rules files, Excel lock, and send techniques
• Defining, creating, and maintaining variations of database exports and loads including exports with and without clears, exports with and without loads, load only, parallel export and loads, validates, and restructures
• Performing application and database recovery in the event of data loss or disaster
• Writing and implementing MaxL and ESSCMD and automating start /stop services and backup/recovery process using batch and shell scripts
• Involved in requirements gathering, design, development, implementation, production testing, and implementation of HFM project.
• Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data.
• Worked on installation, configuration and deployment of Hyperion Financial Data Quality Management, and Hyperion Financial Management.
• Performed data loads using FDM.
• Set up SSO script to handle single sign on for FDQM from HFM, and for drill through from HFM to FDQM.
• Configured users and access rights in FDQM.
• Expertise in various Scheduling tools including Auto Sys
• Integrating various data sources such as Oracle, MS SQL Server, PeopleSoft HR, GL, and MS Access into the staging area
• Familiar with SOX and Change Management procedures and all deployment related activities
• Proficient in software documentation, technical report writing, decisive with strong leadership qualities.

TECHNICAL SKILLS:

Languages: MaxL, ESSCMD, SQL, Shell Script, Batch Scripts,VB, Excel Macros

Operating Systems: Windows 2008 R2, 2003 Server/2000 Professional/XP, IBM AIX 6.x/5.xRed hat Linux 5.x

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, MS Access 7.0/97/2000

Analytical Tools: Oracle Hyperion Essbase 11.x, System 9.x and 7.x/6.5.1, Oracle Essbase Administration Services (EAS) 11.x, AAS 9.x/7.x, Application Manager 6.5.1, and Hyperion Provider Services 11.x/9.x

Analysis Tools: HFM 11.x/9.x, System 9, Oracle Hyperion Planning System 11.x, System 9.x and HBR, FDQM, ODI (Oracle Data Integrator)

Reporting: Oracle Hyperion Workspace EPM system 11.x, 9.x, Hyperion BI+ Financial Reporting, Web Analysis, Hyperion Reports 7.x, Hyperion Analyzer 7.x, Smart view, Hyperion Interactive Reporting,Essbase-Add in and Brio,OBIEE 11g/10.1.3.4, QMR,Hyperion StudioDRM

Integration Tools: ODI 10.x/11g, Informatica, HAL 9.x/7.x, FDM 9.x and EIS 11.x/9.x

Deployment: LCM (Life Cycle Management) Utility11.x

Application Server Architecture: OAS 10.1.3.1, Web Sphere 5.x/6.x, Web logic 11g, 10.x, and Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Marysville, OH

Sr Hyperion Developer

Responsibilities:

• Building new Infrastructure setup of Hyperion products suite on two (Test, Prod) Virtual Servers
• Installing of Oracle Hyperion Planning, Essbase Server, EAS, Shared Services, APS, Web logic Server and HTTP Server on Virtual Windows 2003 Servers
• Installing new Hyperion 11.1.2.2 on windows 2003 virtual server
• Configuring LDAP active directory for new Hyperion system virtual servers
• Acting as a primary support of this project - Handling all activities in all aspects.
• Updating metadata changes as per business requirement in Essbase&Planning
• Designing Databases, Creating outlines, Building Dimensions using Rule Files and Data loading using Rule Files.
• Handling Month end activities and Run the jobs when requested by business.
• Performing ongoing tuning of the Applications, Databases, Outlines, and Calc Scripts etc.
• Migrating all Hyperion Planning Applications, Essbase Applications, objects and security from existing Physical Servers to new Virtual Servers
• Building new Essbase standard - alone applications for new forecasting system
• Implementing backup scripts for Essbase Lvl0, All data and Essbase Applications by writing MAXL and Batch Scripting
• Extracted the data from existing cubes and Loaded into new virtual Essbase cubes without any errors and validated
• Responsible for new Development, Enhancements, Production support and offshore team
• Documenting the steps of Installation, Configuration Migration and designing with screenshots

Environment: Oracle Hyperion Essbase, Planning 11.1.2.2/ 9.3.1 , EAS, APS, Shared Services, Oracle 10g, Web logic 11g and Windows 2003 Server.

Confidential, White Plains, NY

Senior Hyperion Developer/Administrator

Responsibilities:

• Building new Infrastructure setup of Oracle Hyperion EPM11.1.2.0 on distributed environment for existing Confidential
• Designing Databases, Creating outlines, Building Dimensions using Rule Files and Data loading using Rule Files.
• Creation of users and groups and assigning the securities and filters.
• Handling Month end activities and Run the jobs when requested by business.
• Performing ongoing tuning of the Applications, Databases, Outlines, and Calc Scripts etc.
• Installing of Oracle Hyperion EPM System 11.1.2.0 products on Red hat Linux, IBM AIX and Windows 2008 Servers and configuring with Oracle Web Logic 11g application server
• Upgrade existing Hyperion Essbase 9.3.1 to Oracle Hyperion EPM System 11.1.2.0
• Upgrade existing system Hyperion Planning and Essbase 9.3.1 to Oracle Hyperion EPM System 11.1.2.0 for Finance LOB
• Performing multiple installations and configurations, debugging and find out the root cause during Oracle Hyperion EPM Setup
• Support existing multiple Hyperion Environments System 9.
• Extensive Dashboards were built providing easy access to the managers and executives to various reports using Hyperion Interactive Reporting Studio (Brio).
• Developed new Dash boards and adhoc reports for different Business teams using Interactive Reporting.
• Created queries and developed reports using Hyperion Intelligence explorer (Brio/Interactive Reporting.
• Configuring new MSAD active directory for existing and new (Bank of America & Merrill Lynch Users) Users
• Creating a new Groups through Shared Service and assigned privileges for Hyperion Products
• Assigning Filter and Calc access through Shared Service to all groups
• Migrating Multiple Planning Applications, Artifacts and Security from SIT/CIT/UAT to PROD by using LCM Utility
• Scheduling the ODI jobs using ODI scheduler.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Loading the actual monthly close files into HFM through FDQM
• Imported, validated, and exported historical data to HFM using FDM.
• Used Shared Services for implementing HFM Process Management activities. Also designed and developed FDM security (not involving Shared Services).
• Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data
• Migrating Stand Alone Essbase Applications and Objects from SIT/CIT/UAT to PROD by using Migration Wizard and on Server side
• Implementing backup scripts for Essbase Lvl0, All data and Essbase Applications by writing MAXL, Batch and Shell Scripting
• Implementing LCM scripts for Hyperion Planning Applications backup
• Automating back up scripts and Start/stop Hyperion Services on daily and weekly basis.
• Making changes to improve the system performance at Infrastructure Level.
• Coordinate with Project Managers, Business teams to analyze new business requirements
• Creating a new Planning shell applications and modified dimensions as per business requirement
• Performed Planning metadata and loading by using interface tables and ODI 11g
• Making changes to Calc Scripts, MAXL and Business Rules through Calc Manager
• Installed and configured Smart view 11.1.2 and Essbase excel-Add-in 11.1.2 on client machine for data validating and loading input data through web forms
• Trained end - users on Oracle Hyperion EPM11.1.2.0 security through Shared Services and Planning EPMA

Environment: Oracle Hyperion EPM system 11.1.2.0, Hyperion System 9.3.1 ODI 11g, Web Logic 11g, OBIEE 11g, Oracle 11g, RHEL 5.4, Sun Solaris 5.x, IBM AIX 6.x and Windows 2008 R2 Servers, HFM 11.x/9.x,FDQM 11.x/9.x

Confidential, Lebanon, NJ

Senior Hyperion Administrator

Responsibilities:

• Building new Infrastructure setup of Hyperion products suite on two (Test, Prod) Virtual Servers
• Installing of Oracle Hyperion Planning, Essbase Server, EAS, Shared Services, APS, Web logic Server and HTTP Server on Virtual Windows 2003 Servers
• Installing new Hyperion 11.1.2.0 on windows 2003 virtual server
• Configuring LDAP active directory for new Hyperion system virtual servers
• Acting as a primary support of this project - Handling all activities in all aspects.
• Updating metadata changes as per business requirement in Essbase & Planning
• Designing Databases, Creating outlines, Building Dimensions using Rule Files and Data loading using Rule Files.
• Involved in Monthend Close and Consolidation process and responsible for the Dataload
• Gathering Requirements for the COA Changes and Update of the Metadata and UAT.
• Load data to HFM as needed during monthly close process
• Imported, validated, and exported historical data to HFM using FDM.
• Scheduling the ODI jobs using ODI scheduler.
• Managing applications, databases, backups and restore; managing user security in shared services.
• Used Shared Services for implementing HFM Process Management activities. Also designed and developed FDM security (not involving Shared Services).
• Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data
• Handling Month end activities and Run the jobs when requested by business.
• Performing ongoing tuning of the Applications, Databases, Outlines, Calc Scripts etc.
• Migrating all Hyperion Planning Applications, Essbase Applications, objects and security from existing Physical Servers to new Virtual Servers
• Building new Essbase standard - alone applications for new forecasting system
• Implementing backup scripts for Essbase Lvl0, All data and Essbase Applications by writing MAXL and Batch Scripting
• Extracted the data from existing cubes and Loaded into new virtual Essbase cubes without any errors and validated
• Responsible for new Development, Enhancements, Production support and offshore team
• Documenting the steps of Installation, Configuration Migration and designing with screenshots

Environment: Oracle Hyperion Essbase, Planning 11.1.2.2/ 9.3.1 , HFM 11.x/9.x,FDQM 11.x/9.x,EAS, APS, Shared Services, Oracle 10g, Web logic 11g and Windows 2003 Server

Confidential, San Jose, California

Hyperion Administrator

Responsibilities:

• Building a new 2008BUD stand alone Essbase application for Financial Reporting
• Acting as a primary support of this project - Handling all activities in all aspects.
• Updating metadata changes as per business requirement in Essbase&Planning
• Designing Databases, Creating outlines, Building Dimensions using Rule Files and Data loading using Rule Files.
• Handling Month end activities and Run the jobs when requested by business.
• Performing ongoing tuning of the Applications, Databases, Outlines, and Calc Scripts etc.
• Extensive Dashboards were built providing easy access to the managers and executives to various reports using Hyperion Interactive Reporting Studio (Brio).
• Developed new Dash boards and adhoc reports for different Business teams using Interactive Reporting.
• Created queries and developed reports using Hyperion Intelligence explorer (Brio/Interactive Reporting.
• Exporting and importing Business Rules, Cal Scripts, Report Scripts, and Rule Files
• Designing and modifying Cal scripts for existing cubes and the 2008BUD Essbase application
• Loading and executing calculations over development applications
• Exporting Lvl0 data for all production applications
• Making changes to Essbase databases for improving performance during data loading and calculations
• Migrating two Hyperion Planning applications, plan types, artifacts, and security from development to production using the LCM (Life Cycle Management) utility
• Troubleshooting issues during the migration from development to production using the LCM utility
• Creating and assigning roles for new native users through Shared Services

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Financial Reporting, Web Analysis, LCM (Life Cycle Management) Tomcat, Oracle 10g, MaxL, ESSCMD, BAT Scripts, and MS Windows 2003 Server

Confidential, Detroit, MI

Hyperion Developer/Administrator

Responsibilities:

• Building Development, SIT, UAT and PROD Environments
• Installing Hyperion 9.3.1 components on both NT and AIX boxes
• Installing and deployed Hyperion components on Oracle Application Server (OAS) 10.1.3.1.0
• Closely worked with UNIX, Oracle, Windows Admin teams to improve Performance of current system.
• Worked with system monitoring teams to implement solution (Hp Open view, Sys edge) for monitoring of Hyperion services on both Windows and AIX Servers.
• Scheduled Auto stop/start of Hyperion services on weekly basis by using Blade logic and Auto sys.
• Implement backup plan for Hyperion shared services LDAP, Essbase Lvl0 data and Essbase Applications directory (including sec file) by writing MAXL, Batch and Shell Scripting.
• Maintain OBIEE Servers in the part of Expense Reporting Implementation and Deploying.
• Acting as a primary support of this project - Handling all activities in all aspects.
• Updating metadata changes as per business requirement in Essbase&Planning
• Designing Databases, Creating outlines, Building Dimensions using Rule Files and Data loading using Rule Files.
• Handling Month end activities and Run the jobs when requested by business.
• Performing ongoing tuning of the Applications, Databases, Outlines, Calc Scripts etc.
• Exporting and importing Business Rules, Cal Scripts, Report Scripts, and Rule Files
• Designing and modifying Cal scripts for existing cubes and the 2008BUD Essbase application
• Loading and executing calculations over development applications
• Exporting Lvl0 data for all production applications
• Making changes to Essbase databases for improving performance during data loading and calculations
• Migrating two Hyperion Planning applications, plan types, artifacts, and security from development to production using the LCM (Life Cycle Management) utility
• Troubleshooting issues during the migration from development to production using the LCM utility
• Creating and assigning roles for new native users through Shared Services

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Financial Reporting, Web Analysis, LCM (Life Cycle Management) Tomcat, Oracle 10g, MaxL, ESSCMD, BAT Scripts, and MS Windows 2003 Server

Confidential

Hyperion Developer

Responsibilities:

• Setting up new Hyperion system 9.3.1 development and production environments on MS Windows 2003 Virtual Servers (Distributed Environment)
• Setup new MSAD active Directory to CTA USERS/GROUPS through Shared Services on both DEV and PROD Environments.
• Improve the current system performance by changing Planning Application & Essbase Database settings
• Documented step by step Upgration/Migration process for future references.
• Automating the process through Windows Scheduler using MAXL and BAT Scripts for backups of Essbase databases, Lvl0 data, log files, Open LDAP Backup, and Start/Stop Hyperion Services.
• Migrating two Hyperion Planning Applications (FINRPT and BUDPLAN) from existing version 7.1.3 to system 9.3.1 (development environment)
• Exporting and importing native security and Active Directory security from version 7.1.3 to 9.3.1
• Building a new 2008BUD stand alone Essbase application for Financial Reporting
• Exporting and importing Business Rules, Cal Scripts, Report Scripts, and Rule Files
• Designing and modifying Cal scripts for existing cubes and the 2008BUD Essbase application
• Exporting and importing Financial Reports from version 7.1.3 to 9.3.1
• Loading and executing calculations over development applications
• Exporting Lvl0 data for all production applications
• Making changes to Essbase databases for improving performance during data loading and calculations
• Migrating two Hyperion Planning applications, plan types, artifacts, and security from development to production using the LCM (Life Cycle Management) utility
• Troubleshooting issues during the migration from development to production using the LCM utility
• Creating and assigning roles for new native users through Shared Services

Environment: Hyperion 7.1.3, Hyperion System 9.3.1, Workspace, BI+ Financial Reporting, Web Analysis, LCM (Life Cycle Management) Tomcat, MS SQL Server 2005, MaxL, ESSCMD, BAT Scripts, and MS Windows 2003 Server