PROFESSIONAL SUMMARY:

• Having 10+ years of Technical experience in IT industry, involving in design, development implementation and support of various Hyperion applications using Client/Server technology which includes Decision Support System for Hyperion Essbase, Hyperion Planning, HFM, DRM, Oracle Data Integrator, EPMA, FDQM, FDMEE, HSF, ARM, FCM, HTP, PBCS & Hyperion Financial Reporting
• Experienced in setting up Installation & Configuration of system 11x (EPM) Suite of Products such as Shared Services, Essbase, Planning, HFM, DRM, ODI, FDQM/FDMEE, HFR, HTP, HSF, ARM, FCM, OBIEE Workspace & Deployment from Development to Production Servers on Windows, UNIX and Oracle Exalytics Environments
• Experienced in applying Patches and Migration to different instances
• Extensive experience in Application Migration of Articrafts using LCM (Export, Import)
• Experience in Data backups of database and recovery of OpenLDAP, tuning and optimization
• Experience in Essbase Cube Analysis & Design, Essbase database Administration and performed up gradations, Maintenance, database backups, Optimization, load rules, calc script etc
• Experienced in Outline creation, Load rules, Calc - scripts using Essbase
• Rebuilding new applications from existing
• Strong Knowledge on creation of user and Group level security using shared services
• Experience in troubleshooting the tickets
• Monitor all system usage metrics so that additional hardware is expanded in advance of need: RAM, Disk, Processor, etc.
• Experience with day to day support activities with month end and quarter close period and job monitoring activities.
• Excellent interpersonal skills with proficient expression, transmission and interpretation of knowledge and ideas.
• Experienced in knowledge transfer, preparing technical documentation with an aptitude to learn new technologies.

TECHNICAL EXPERIENCE:

BI Tools: Essbase, Planning, HFM, DRM, ODI, FDQM, FDMEE 11.1.2.4 11.1.2. x & 9.3.1

Reporting Tools: Hyperion Financial Reporting, Web Analysis, Excel-Add-ins & Smart View.

Databases: Toad, Oracle 9i,10g, 11g, 12c and MS SQL Server

Operating System: UNIX, LINUX Sun Solaris/ Redhat, WINDOWS Server 2003R2/2008R2/2012

Web App & Web Servers: Oracle WebLogic, Oracle HTTP Servers, IIS Server

Languages/Scripting Tools: C/C++, Shell/Bash

Server Monitoring Tools: Oracle EM 11g/12c

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Admin

Environment: DRM, HTP, HFM, EPMA, ODI, FDQM/FDMEE, HFR, ESSBASE and HSS

Responsibilities:

• Performed upgrade of EPM components from 11.1.2.3. .1.2.4. x
• Responsible for Applying Maintenance release
• Installation and configuration of EPM components and applying latest patches
• Installed DRM 11.1.2.4.347 and upgrade DRM Apps from 11.1.2.3 to 11.1.2.4.347
• Migrate Hyperion Tax Provisioning applications
• Migrate the artifacts from Dev to QA and from QA to Prod.
• Fine tuning and Optimization of environments on various levels
• Trouble shoot issues reported by users

Confidential

Hyperion Admin & Production Support

Environment: DRM, HFM, PLANNING, FDQM/FDMEE, ODI, HFR, ARM, FCM, ESSBASE and HSS

Responsibilities:

• Performed Infiniband Configuration for EPM suite on Exalytics
• Installation and configuration of EPM components and applying latest patches
• External directories configuration (SUN Virtual Directories Services) to Shared Services and WebLogic
• Installed DRM 11.1.2.4.342 and upgrade DRM Apps from 11.1.2.3 to 11.1.2.4.344
• Deployed DRM Analytics and DRM Web Services API for FDMEE integration
• Fine tuning and Optimization of environments on various levels
• Monitoring day to day support activities with month end and quarter close period and job monitoring activities.

Confidential

Hyperion Admin & Infrastructure Production Support

Environment: HFM, FDQM/FDMEE, ODI, ESSBASE, PLANNING, HPCM, DRM, HFR, and HSS

Responsibilities:

• Support for Oracle Managed Cloud Services (OMCS) customers around the APAC/EMEA/US regions for Production and Non Production services requests with SLA
• Manage System Outages and assist to ensure system uptime is available across 24*7.
• Infrastructure and Production support - Server Maintenance like File system Space Management, moving Backups to staging server and Exports.
• Installation and Configuration of EPM Suite of products 11.1.2.3/11.1.2.4 in Windows and Linux Distributed Environments.
• Responsible for coordinating the upgrade project from 11.1.2.1 to 11.1.2.3/11.1.2.4 in multiple projects.
• Applying Maintenance releases and Patches for bug fixes.
• Responsible for performing upgrading to Newer versions 11.1.2.4/11.1.2.3
• Functioning as a point of contact for the Application owners on all Production and Non- Prod related support and maintenance issues.
• Backup and Recovery of Hyperion applications.
• Fine tuning and Optimization of environments on various levels.
• Monitoring the current Production environment servers for performance and stability.
• Responsible for troubleshooting technical issues in the environment, perform RCA and provide solutions and request for Change Management activities (RFC’s)
• Handle Escalation calls with customers

Confidential

Hyperion Admin & Production Support

Environment: Hyperion Financial Management, FDQM, HFR, Workspace and Shared services

Responsibilities:

• Perform Installation & Configuration of system 11x (EPM) Suite of Products such as Shared Services, HFM, FDQM, HFR, Workspace & Deployment from Development to Production Servers
• Accomplish Patching in the Environment
• Maintain metadata (including extracting, loading and updating the metadata structure) and execute Ongoing maintenance of Metadata for HFM
• Create Import Formats, Mappings and custom scripts in FDM
• Perform data loads from FDM to HFM and external sources
• Loading the actual monthly close files into HFM thru FDM Build, maintain and run financial reports in Hyperion Financial Reporting Studio
• Responsible for on-time data loads from data sources to ensure end user reporting availability
• Provision of users/groups for the application access from SS
• Backup and Importing the articrafts from various environments
• Troubleshoot production issues and escalate issues to Oracle as required

Confidential

Hyperion Admin & Production Support

Environment: ODI, Hyperion Planning, Essabse, HFR, Workspace and Shared services

Responsibilities:

• Create Master and Work Repositories
• Create a set of physical, logical data servers, agent and context
• Develop Interface & Packages for the oracle as source & File as technology
• Load the metadata to planning using ODI
• Set up Global Hyperion Security
• Develop the financial reports as per FRB
• Trouble shoot issues reported by user

Confidential

Hyperion Admin & Production Support

Environment: ODI, Hyperion Essbase, Planning, HFR, Workspace and Shared services

Responsibilities:

• Installation, Configuration, Implementation and Support of Hyperion Shared Services, Essbase, Planning, HFR, Workspace and ODI on oracle fusion middleware server
• Backup and Recovery of Hyperion Components
• Exporting & Importing of Master and Work Repositories
• Configuring scheduling agent in package and mail alert utility in ODI
• Creating Interface & Packages for the oracle as source & File as technology
• Accomplish Scheduling of Jobs for scenarios and email alerts in ODI
• Back Recovery using Application to File System and Application to Application system
• Performed daily application and database backup
• Backup and Importing the reports from various environments
• Provision of users/groups for the application access from SS
• Tickets resolution as per client and end user requirement
• Trouble shooting issues reported by User

Confidential

Hyperion Admin & Production Support

Environment: Hyperion Essbase, Excel Add - in, Hyperion Smart view and Shared Services

Responsibilities:

• Designed, Developed and Modified the Outline according to business requirement
• Developed Data Load Rules, Calc Script and Report Script developed and implemented Dimensions and member attributes dynamically maintaining the Outline according to business requirement
• Configuring User directories in shared services
• Automation using batch and Maxl script to allow loading the Excel files and flat files coming from JDE
• Accomplish Patching in the Environment
• Setting up users and groups according to business & assigning security to users, groups, dimensions and webforms
• Creating reports using Essbase Excel Add-In and Smart view as per user requirement specification
• Taking Back-ups daily and validating, checking log files regularly Maintenance and support
• Resolve Production Issues
• Involved in client interaction weekly twice to analyze the problems and to rectify them

Confidential

Hyperion Implementation & Support

Environment: Hyperion Essbase, SS, Planning and HFR

Responsibilities:

• Configure Interface tables to import metadata into Hyperion Planning
• Importing Data and Metadata from Interface tables into Hyperion Enterprise Performance Management Architect
• Responsible for creating web forms, data and metadata loading and export data
• Perform Application Articrafts Migration using LCM
• Provisioning of users/groups for the application access
• Perform day to day monitoring backup jobs as daily maintenance for applications
• Scheduling batches with batch-bursting options to run reports for multiple members and send batch output to multiple users
• Trouble shooting track and record all requests/changes in the ticketing tool
• Providing ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup, and performance monitoring
• Responsible for preparing Change Request document

Confidential

Hyperion Support

Environment: Hyperion Essbase, SS, Planning and HFR

Responsibilities:

• Understand and analysis the requirements provided by the business
• Loading the Master, transaction data into the Essbase OLAP Server from Hyperion Planning
• Checking Err File for Dimension build as well as data load. And if there are any error records exits Correcting and reloading and making sure required Outline Structure build and data load
• Assigned security access to the Users, Groups, dimension members and web forms through Hyperion Planning
• Restructuring and redesigning of existing Essbase cubes
• Updated/ modified the existing Calc Scripts, MaxL scripts, UDA’s, Load Rules and Attribute dimensions as per the requirements of the business analysts
• Involved in deploying of cubes from Development Server to production Server, restoring database by taking regular backup in case of database corrupt or server crash
• Development web forms for the data entry