SUMMARY

• Over 8 years of diverse experience in Oracle Hyperion technology with development, support and administration experience on Hyperion Suite versions (9.3.3, 11.1.1.x & 11.1.2.x).
• Designed and developed Essbase Outlines, Calculation & Report scripts and Rule files for dimension and data load activities.
• Experience in creation and maintenance of (BSO) and (ASO) Essbase kernels applications.
• Worked on application migration (LCM), backup & restore activities.
• Good knowledge in writing MaxL statements and Automation of application related processes.
• Defining securities and assigning Filters to Users and Groups.
• Good interaction with users and conducted training to Business/End users.
• Extensively worked on understanding the Business requirements of the clients.
• Worked in support roles preparing technical documents, monitoring issue trackers and provided round the clock production support.
• Good understanding of HFM & FDM applications for support and admin related activities.
• Strong knowledge in Installations, Pre & Post Configurations of Hyperion System Components of Versions 9.x and 11.x (Up to 11.1.2.1) in Distributed Environments.
• Very good understanding and working knowledge on Oracle Data Integrator (ODI).
• Proficient in ODI security, Application and Web Server Configuration.
• Experience in Shared Services Configuration, LDAP & MSAD, Configuring Native User Directories & External Directory Servers.
• Excellent Knowledge in Performing Pre - Patch Analysis and Applying Patches.
• Good understanding of PL/SQL, UNIX shell scripting and very strong in performance tuning.
• Performed database administration & maintenance tasks both on Oracle DB & MS SQL Server.
• Responsible forPerformance tuning, Monitoring, Backups and Recovery of Essbase cubes.
• Effective Team Player with good communication, analytical & problem solving skills.

TECHNICAL SKILLS

Reporting Tools: Hyperion Essbase 9x & 11x, Add-In, Hyperion Financial Reporting, Smart View, Hyperion Application Link (HAL) & Oracle Data Integrator (ODI) 10.1.3 & 11g.

Tools: Ctrl-M & Redwood batch processing tools and LightHouse, BridgeClarify, Triole & Remedy issue tracking tools.

Scripting: UNIX shell script, MaxL, ESSCMD & MS Batch scripts.

Database: Essbase OLAP, Oracle 10g &11g, MS SQL Server 2000/2005 & MS Access.

Platforms: Windows XP/2003/2008 & Solaris 10/11 Sparc.

PROFESSIONAL EXPERIENCE

Confidential, Miami FL

Hyperion Developer

Responsibilities:

• Support activities which involve application performance issues, restores & configuration changes, performance tunings & environment services restarts.
• Coordinating with product support for root cause analysis.
• Engage stake holders/ Business users on application issues which need business support & effort.
• Proactive work which includes batch processing & scheduling in Workspace
• Installed and configured Dev, QA and DR environments V 11.1.2.2.503 & 11.1.2.3.502
• Applying OPatch’s to resolve issues on product support advice and RCA’s.
• Carried out lower environment refresh activities as a part of year end activities.
• Coordinating with fellow IT teams to ensure a smooth deployment of any planned change.
• Initiating and coordinating necessary change requests for any deployment or configuration activities.
• Business user interaction and data gathering for future development.
• Host server activities which include JVM settings, Web-logic, IIS & Windows Registry configuration & performance tuning.
• Database activities which include reconfiguration, schema creations, backups & restorations and upgrades support activities’.
• Maintenance of existing cubes and housekeeping tasks involving maintenance of application databases.
• Developed ODI projects which involves data extraction from Essbase & HFM apps, read Excel files, files on secured sftp/ftp servers, database tables and automating build processes.

Environment: Hyperion Essbase & Planning 11.1.2.2 and SQL Server 2008R2.

Confidential, Madison, WI

Hyperion Analyst

Responsibilities:

• Convert existing multi currency Classic planning applications to EPMA.
• Designed and developed web forms for the data input as per Business requirement.
• Meta-data management activities in ODI such as setting up the Topologies, creating new models for (flat files, Oracle DB) and reverse engineering.
• Used Business rules for allocation and budgeting in Hyperion Planning.
• Review, analyze and corroborate monthly expenses and payables.
• Involved in migration of planning application from Development to QA to Production.
• Involved in Unit Testing to test the Web forms and their associated business rules functionality.
• Written MaxL Scripts to automate the process of dimension build and data load.
• Created Users & Groups in Hyperion System 9 Shared Services and given appropriate access to the users for the cubes.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning and optimization of calc scripts.
• Create batch files and Maxl scripts to automate the data load process
• Implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Liaise with Systems and Technology groups to identify and rectify system-user concerns.
• Provide training and support to new and experienced Essbase users.
• Optimized application’s performance by reducing calculation times and database sizes considerably.
• Extracted reports using HFR and Smart View.
• Guiding relevant teams restoring Applications in case of database corrupt or server crash.
• Automated the daily general ledger load into Hyperion, and added extra error checking and automated notification processes, so the team is immediately aware of any data, server or process-related issues. The log files had to be manually checked on a daily basis prior to this change.
• Worked closely and pro-actively with project leadership to identify and resolve key risks with any Hyperion related projects.
• Provided support on critical production issues.

Environment: Hyperion Essbase & Planning 11.1.2.1 and Oracle 11g.

Confidential, Atlanta, GA

Hyperion Analyst

Responsibilities:

• Played an active role in development phases which includes application design, development, and implementation.
• Created BSO & ASO applications using transparent partition technique and essential calc scripts.
• Written MDX queries for ASO outlines.
• Created interfaces in Oracle Data Integrator (ODI) for metadata and data load into BSO cubes.
• Maintain outline, metadata, members and member properties as business requirements change.
• Created Database and optimized the outlines by arranging the Dimensions for data load, calculation time and improving query retrievals.
• Modifying and execution of calculation scripts to aggregate the data with different scenarios.
• Developed MaxL Scripts to automate Essbase tasks like loading data, calculations and backups.
• Designed and created various filters according to user requirement.
• Created users and groups for access rights in applying security and authorization regulations.
• User provisioning on a client requirement basis.
• Involved in development and modification of existing financial and marketing reports which include corporate consolidation reports and financial & planning reports for management.
• Used Hyperion planning for the development of web forms for data entry into Essbase cubes.
• Performing data validation on day-to-day basis during closing period.
• Scheduled & Developed batch scripts for weekly and month end process.
• Intervened in production support issues when required to improve issue turnaround time and system availability to the end users

Environment: Hyperion Planning & Essbase 11.1.2.1 and Oracle 11g.

Confidential, Bolton, MA

Hyperion Analyst

Responsibilities:

• Created planning applications using existing dimensions in EPMA.
• Involved in the development of Essbase cubes & rule files for loading data into the cube.
• Loading metadata & Data into planning applications using Oracle Data Integrator (ODI) and refreshed into Essbase database.
• Developed MAXL scripts that automate the calculation and loading of data and members into Essbase.
• Developed reports as per the given client templates.
• Designed and developed web based data entry forms within Hyperion planning.
• Create user security groups and provisioning.
• Regularly interacting with the Client and understanding their requirement and generating reports accordingly.
• Involved in production support, scheduling tasks and migration (LCM).
• Troubleshooting planning Data forms with user testing.
• Maintenance of existing cubes and house keeping tasks involving monthly maintenance of databases before finance close.
• Create technical documentation for version upgrade project.
• Configuration of Hyperion components required during troubleshooting of Hyperion related issues.
• Constantly interacting with the related teams to resolve the issues before it escalates.
• Provided troubleshooting services and assistance to end-users in resolving any application related issues (Smart View, Data mismatch etc.).

Environment: Hyperion Essbase & Planning 11.1.1.3 and Oracle10g.

Confidential

Hyperion Analyst

Responsibilities:

• Played an active role in the Application’s development life cycle.
• Created an ASO application with six custom dimensions using rules files with MDX formulae.
• Developed MaxL Scripts to automate Essbase tasks like loading data, calculations and backups.
• Created users and groups for access rights in applying security and authorization regulations.
• Regular health checks to maintain business readiness.
• Run/Modify Unix/Linux shell scripts on demand.
• Performance tuning (Cache settings etc) and modifying configuration items on demand.
• Installing Application service patches on Product support advice to resolve variety of issues.
• Server & services restarts on ad-hoc basis.
• Involved in building two additional environments (E2E & DEVM) for development activities.
• Creation of knowledge transfer and process documents for reference.
• Create or Update necessary technical documentation.
• Handling pre & post deployment or release activities.
• Coordinating with various teams during system failure for application restorations.
• Scheduled & Developed batch scripts for weekly and month end process.
• Coordinated with the testing team for a successful sign-off within deadlines.
• Migrated and deployed application successfully into production.

Environment: Hyperion Essbase & Planning 11.1.1.2, Oracle 10g

Confidential

Hyperion Developer

Responsibilities:

• Support activities which involve application performance issues, restores & configuration changes, performance tunings & environment services restarts.
• Coordinating with product support for root cause analysis.
• Engage stake holders/ Business users on application issues which need business support & effort.
• Proactive work which includes batch processing & redesigning calculation scripts to increase performance.
• Installed and configured a pilot environment V11.1.1.2.
• Applying OPatch’s to resolve issues on product support advice.
• Carried out lower environment refresh activities every 6months.
• Coordinating with 3rd party suppliers if required, to ensure issue free environment.
• Initiating and coordinating necessary change requests for any deployment or configuration activities.
• Client user interaction and data gathering for future development.
• Host server activities which include JVM settings, Web-logic, IIS & Windows Registry configuration & performance tuning.
• Database activities which include reconfiguration, schema creations, backups & restorations and upgrades support activities’.
• Defining users and groups for the applications and assigning the access rights and securities.

Environment: Hyperion Suite 9.3.3 & Oracle 10g

Confidential

Hyperion Developer

Responsibilities:

• Created and updated members list using the rules files based on the business requirement study.
• Created flow diagrams in HAL to upload Metadata.
• Loading metadata into Planning application using Hyperion Application Link (HAL) and refreshed into Essbase database.
• Developed Excel Templates for user interface in Essbase database.
• Successfully generated the reports using Excel Add-in and Smart View.
• Involved in migration of application from dev to QA to Prod.
• Involved in regular maintenance of the Essbase Server like cube backup’s, security file back up and file system backup.
• Involved in writing MAXL Scripts to automate the process of data load.
• Developed automation scripts for back up and Refresh of all Production Cubes.
• Created Users & Groups in Hyperion System 9 Shared Services and given appropriate access to the users for the cubes.
• Running the maintenance (consolidation of data and taking the backup) process on a daily basis.
• Designed users input capability to the applications maintained by Filters.
• Regularly interacting with the Client and understanding their requirement and generating reports accordingly.

Environment: Hyperion Essbase Analytical Services 9X, Essbase Admin Services 9X, SQL Server 2000, Hyperion Excel Add-in.