SUMMARY

• me has 9 plus years of Hyperion experience. Extensively worked on Performance Management & Business Intelligence solutions through the complete project lifecycle - from requirements analysis, design, development, support and upgrade solutions to the overall project.
• Very good experience in Design, Analysis, Development and Implementation of various applications using Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, EPMA, ODI, Data Relationship Management, Web Analysis, Hyperion Financial reporting,, ESSCMD, MaxL Smart view, and Excel Add in.
• Created Essbase BSO and ASO applications wif partitions, database outlines rules files, calculation scripts, report scripts, MaxL scripts and ESSCMD for Essbase servers’ administration.
• Involved in planning application creation, metadata loading through ODI, Outlineload.cmd utility, web forms development, business rules association wif forms and security.
• Involved in Financial management applications, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, reports and automation of HFM tasks using task flows from workspace.
• EPMA application creation using application and dimension libraries and shared some dimensions wif Data Synchronization for planning and HFM applications. Application conversion from classic applications to EPMA. Importing Business rules into Calculation manager.
• Effectively managed changes in master data across operational, analytical and enterprise performance management using wif DRM
• Developed and enhanced Hyperion reports using wif Web Analysis, and financial reporting and scheduling the reports from workspace.
• Migration of applications using LCM and regular migration processes.
• Very good experience of Smart view and excel add in.
• Seasoned Project Management Professional, wif outstanding project planning, execution, monitoring and resource balancing skills wif ability to support multiple simultaneous projects.
• He has strong customer relationship to get accurate reporting information and ongoing initiatives.
• Team building skills along wif excellent communication and people management skills.
• Effectively train and prepare manuals for onsite and offshore team members and end users.

TECHNICAL SKILLS

Hyperion: Essbase 11.x/9.x, Planning 11.x/9.x,Financial Management 11.x/9.x, Data Relationship Management 11.1.1.x, Hyperion Shared Services, EIS/Essbase Studio, and EPMA

Reporting tools: Hyperion Financial Reporting 9.x/11.x,Web Analysis, Interactive Reporting, OBIEE 11.1.x/10.x Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View, Hyperion Financial Reporting Studio.

Scripting Languages: Power Shell for Windows, Shell scripting for UNIX, MAXL, MDX, ESSCMD, Perl and VB Script.

Database: MS SQL Server 6.5/7.0, Oracle 9.x,10.x/11.x, MS Access

Operating Systems: Windows 95/98/NT/2000/XP, UNIX AIX

Data Integration Tools: Oracle Data Integrator, Data Integration Management, Financial Data Quality Management.

PROFESSIONAL EXPERIENCE

Confidential, Novato CA

Hyperion Team Lead

Responsibilities:

• As a Hyperion lead, responsible Hyperion system support for Hyperion Planning applications in production, Pre-Production and Development servers for Confidential Financial Users.
• Knowledge of Planning / budgeting / Forecasting / Consolidation processes in RevApp, Workforce Applications.
• Monthly Actual data loads through MaxL and Run Business Rules to consolidate the data during the planning cycles.
• Schedule and run the HFR reports for data retrieval using Financial Reports.
• Loading meta data using ODI mappings. Data retrieval and data load schedule jobs using ODI.
• Tracking problem & preparing the RCA (Root Cause Analysis) documents for high severity tickets.
• Restoring database from backup when database corrupt, created test environments.
• Work wif team members for providing solution to Hyperion Planning applications.
• Providing the swift solutions to the users for smart view issues.
• Providing the user trainings and preparing the user manuals.

Environment: Hyperion System 11.1.2.1 (Essbase, Planning, ODI, and Hyperion Financial Reporting)

Confidential, St Louis, MO

Hyperion Team Lead

Responsibilities:

• Gathering Business requirements, analyzing the existing Hyperion system 9 architecture.
• Working closely wif users on understanding the requirements and working on prototyping.
• Backups for all application of production, Pre-Production and Development servers
• Hyperion 11.1.2.1, 64 Bit components downloads from eDelivery.Oracle.com
• Requested SQL Server DBA to create schemas for individual Hyperion components
• Requested to Windows system administrators to install IIS 7.0 as web server
• Extracted required Zip Files into working folder tan initiated the installation process
• Configured Hyperion components including shared services wif web logic automatic deployment
• Foundation services configured including EPMA for creating EPM system applications
• Migrated Essbase applications from production 9.3.1 test server 11.1.2.1
• Created planning classical application and converted into EPMA applications
• Migrated Planning applications from system 9.3.1 to Oracle epm system 11.1.2.1 Planning
• Fixed installation, configuration and migration issues
• Installed and print server configured for the Hyperion Financial Reporting studio
• Installed excel add in, smart view and web analysis
• Migrated HFR and web analysis reports
• Migrated security from the system 9.3.1 to 11.1.2.1 shared services using import export utility wif the .csv format files
• Applying the patches to fix product bugs for Essbase, planning and HFR
• Working on performance tuning for the data loads and Calc scripts

Confidential, Stamford, CT

Hyperion Support

Responsibilities:

• Involved in production support activities for Hyperion Essbase, Planning and Financial Reports
• Developed, enhanced Hyperion Financial Reports in HFR Studio and scheduled from workspace
• Monitored and maintained production servers of Essbase and Planning
• Created business rules for consolidations such as calculation, translation, allocation etc
• Modified automation scripts for dimension building, data loading and consolidations
• Created security filters and classes for the users according to the user’s request worked on weekly schedule job for de-fragmentation scripts for Essbase performance optimization.
• Provided the security for the users
• Resolved smart view issues for the users.

Environment: Hyperion system 11.x - Essbase, Planning, and Financial Reports

Confidential

Responsibilities:

• Taken Backups for all application of production, Pre-Production and Development servers
• Installed Hyperion system 11.1.1.3 and configured
• Created ASO and BSO applications to migrate from Essbase 6.5
• Analyzed and migrated unix shell scripts of Essbase automation
• Migrated Essbase BSO & ASO cubes from 6.5 to 11.1.1.3 and prepared documents
• According to the Run books created new cubes in 11.1.1.3 and migrated 6.5 cubes for both BSO and ASO cubes.
• Worked on Essbase.cfg settings and optimization
• Worked on Essbase stand alone security migration to shared services 11.1.1.3

Confidential

Team Lead

Responsibilities:

• Backups for all application of production, Pre-Production and Development servers
• Hyperion 11.1.1.3, 64 and 32 Bit components downloads from eDelivery.Oracle.com
• Requested SQL Server DBA to create schemas for individual Hyperion components
• Installed Web logic 9.2 MP3 as web application server and IIS 6.0 as web server
• Extracted required Zip Files into working folder tan initiated the installation process
• Configured Hyperion components including shared services wif web logic automatic deployment
• Foundation services configured including EPMA for creating EPM system applications
• Migrated Essbase applications from production 9.3.1 test server 11.1.1.3
• Created planning classical application and converted into EPMA applications
• Installed ODI 10g and configured master and work repositories
• Created mappings for planning metadata load using as Essbase dimensions as source.
• Automated planning database refresh in ODI to get update in Essbase
• Created package wif combining interfaces to schedule a job,

Environment: Hyperion system 9 to Hyperion Fusion Edition 11.1.1.3, Oracle Data Integrator 10.1.3.5

Confidential

Hyperion Administrator

Responsibilities:

• Effectively managed database components, calc scripts, business rules, Report Scripts,Web forms, data rules, outline changes
• Providing access to the business end users under Planning and Essbase servers
• Create/Test the business rules and calc scripts according to the functionality
• Developing, migrating and modifing Hyperion reports
• Effective perform Data Loads triggered through HAL routines
• Hyperion application services Start/Stop during maintenance
• Created HAL routines for Dimension build,Dataload and Data Extracts.
• User Security Deployment for Reports/Webforms/Excel Add-in
• Task assignment wif in the team.
• Taking care of Hyperion sessions for new joiners in the team.

Environment: Hyperion Essbase 9.3, Analytic Administration services 9.3.0,Hyperion financial Reporting studio,Hyperion Application Link (HAL),Essbase Excel Add-in, Hyperion Shared services, Hyperion Planning 9.3,Windows 2003,Oracle 10gProject#7

Confidential

Hyperion Essbase Developer and Administrator

Responsibilities:

• Requirement gathering and analyze the data base tables to implement planning applications.
• Created Essbase BSO and ASO applications wif transparent partitions.
• Created Hyperion Planning applications and used HAL for dimension building.
• Hyperion Application Link implemented dimension build mappings across all planning applications.
• Created Hyperion Financial Reports wif multiple grids’ connections and created report books and scheduled from the workspace.
• Exporting reports to Excel format and PDF format
• Preparation of Test Cases and Unit Testing.

Environment: Hyperion Essbase, Planning, Hyperion Financial reports, Windows 2000 & Oracle 9iProject#8

Confidential, San Jose, CA

Hyperion Essbase Developer and Administrator

Responsibilities:

• Created Applications and Databases using Essbase Analytics. Involved in Analyzing, Planning and Implementations activities.
• Created Load Rules Files, for dimension building and data loading.
• Created Attribute Dimensions using wif rules files.
• Created Calculation Scripts to customize existing outline member formulas and properties and Controlled the Calculation Process wif FIX Statements and Conditional Calculations wif IF Statements
• Tested Calculation Scripts and started wif Intelligent Calculations settings.
• Developing Report Scripts using wif Report script editor
• Generated Reports using Hyperion Analyzer and Excel Add ins
• Supported the Essbase system. Involved in production support activities such as resolving end users production issues, monitoring and maintaining the Essbase servers.

Environment: Hyperion Essbase7.1.2, Windows, Ms-Office