SUMMARY

• Over 8 years of diverse experience in Information technology which includes 5 years of experience in Hyperion Essbase & Planning on various domains and 3+ years in installations, administration and maintenance of Hyperion Suite versions (9.3.3, 11.1.1.x & 11.1.2.1).
• Designed and modified 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, 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 providing round the clock production support.
• Proficient in Installations and Configurations and Post Configurations of Hyperion System Components of Versions 9.x and 11.x (Up to 11.1.2.1) in Distributed Environments.
• Proficient in Installing and Configuring Application Server and Web Servers.
• Experience in Shared Services Configuration, LDAP & MSAD, Configuring Native User Directories & External Directory Servers.
• Excellent Knowledge in Performing Pre - Patch Analysis and Applying Patches.
• Very good understanding and working knowledge on Oracle Data Integrator (ODI).
• Good understanding of PL/SQL, UNIX shell scripting and very strong in performance tuning.
• Handled various database administration & maintenance tasks on Oracle 11g/10g/9i/8i versions.
• Proficient in Migrating Artifacts using LCM (Life Cycle Management) concept across various versions.
• Responsible forPerformance tuning, Monitoring, Backups and Recovery of Essbase cubes.
• Having good communication, analytical and problem solving skills.
• Effective Team Player, an individual contributor and can work with minimum or no supervision.

TECHNICAL SKILLS

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

Tools: Ctrl-M & Redwood batch processing tools.

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Hyperion Analyst/Developer

Responsibilities:

• Designed and developed web forms for the data input as per Business requirement in Hyperion Planning.
• Meta-data management activities in ODI such as setting up the Topologies, creating new models for (flat files, Oracle DB) and reverse engineering.
• Review, analyze and corroborate monthly expenses and payables.
• Involved in migration of planning application from Development to QA to Production.
• Used Business rules for allocation and budgeting in Hyperion Planning.
• 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.
• Involved in Development and performance-tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization.
• Maintain Hyperion Servers; 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.
• Restored database by taking regular backup 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 technical leadership, mentoring and helping those on the team less familiar with Hyperion System to come up to speed.
• Provided support and worked on critical production issues.

Environment: Hyperion Essbase / Planning 11.1.2.1, Oracle 11g, MS Excel 2010, Windows 2008.

Confidential, Atlanta, GA

Hyperion Analyst/Developer

Responsibilities:

• Played an active role in development phases which includes application design, development, and implementation.
• Created BSO applications using transparent partition technique and essential calc scripts.
• 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.1.3/9.3.3 , Excel Add-In, Oracle 10g, MS Excel 2007, Windows XP

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.
• Regularly interacting with the Client and understanding their requirement and generating reports accordingly.
• Involved in production support, scheduling tasks and migration.
• Troubleshooting planning Data forms with user testing.
• Create or Update necessary technical documentation for version upgrade project.
• Log monitoring and resolved the issues.
• Configuration of Hyperion components required during troubleshooting of Hyperion related issues.
• Constantly interacting with the related teams to resolve the issues before it escalates.
• Monitoring the tickets, emails and Essbase console.
• Provided troubleshooting services and assistance to end-users in resolving errors.
• Maintenance of existing cubes and house keeping tasks involving monthly maintenance of databases before finance close.

Environment: Hyperion Essbase Analytical Services 11.1.1.3, Essbase Administration Services 11.1.1.3, Oracle 11g, Hyperion Excel Add-in and Hyperion Application Link 9.2

Confidential

Hyperion Consultant

Responsibilities:

• Played an active role in the Application’s development life cycle.
• Created an ASO application with six custom dimensions using rules files.
• 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 Analytical Services 11.1.1.2, Essbase Administration Services 11.1.1.2Oracle 10g

Confidential

Hyperion Consultant

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 Essbase Analytical Services 9X, Essbase Administration Services 9X, Oracle 10g & Hyperion Excel-Add-in.

Confidential

Hyperion Analyst

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.