SUMMARY:

• Experienced in Oracle Enterprise Performance Management suite of applications with success supporting mission - critical technical architectures and guiding software development life cycle within diverse enterprise environments
• Over 9 years’ experience working with consolidation, budgeting and financial reporting applications.
• Talent for analyzing client business requirements and developing solution designs to align applications with established workflows.
• Extensive experience in design, analysis, development and implementation of various applications using Hyperion Essbase, Hyperion Planning 11.1.2.4, Essbase Integration Services (EIS), Hyperion Reporting, Hyperion Analyzer, Interactive Reporting, and Hyperion Planning using Windows, Linux and UNIX environments.
• Excellent experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11x/9.X/7.X, Hyperion Web Analysis, ESSCMD, Maxl, Essbase Spreadsheet add-in, Essbase Query Designer.
• Strong Understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.
• Keen awareness of project management and life cycle development methodologies. Motivational and diplomatic team leader and contributor.
• Full Life Cycle Project Management
• ERP Implementation & Support
• Team Leadership & Mentoring
• Dynamic Client Presentations
• Strategic Planning & Execution
• Hyperion Financial Management
• Continuous Process Improvement
• Oracle EBS
• On- & Off-site Staff Oversight
• Hyperion Planning/Essbase
• OBIEE
• Client & Vendor Relations

TECHNICAL SKILLS:

OLAP: Hyperion EPM Suite 11.1.2.4, Hyperion Essbase and Planning, Hyperion Shared Services System 9 BI+, Essbase Integration Services (EIS), Oracle Data Integrator (ODI)

Databases: Oracle 11g, R12, PL/SQL, MS SQL Server 2000/2005, MS Access, SQL plus

Reporting Tools: Tableau, Interactive Reporting (BRIO/Hyperion Intelligence), Hyperion Financial Reporting, Hyperion Analyzer/Web Analysis, Excel Add-in, Smart View.

PROFESSIONAL EXPERIENCE:

Hyperion EPM Architect

Confidential

Environment: Hyperion Essbase 11.1.2.4(ASO & BSO), Oracle 10.2.0.4, Essbase Spreadsheet Add-In, Windows 2003, Hyperion Shared Services, Web Analysis, Oracle Data Integrator, Hyperion Workforce Planning, Linux env., OBIEE

Responsibilities:

• Built planning applications from scratch for budgeting and planning purposes
• Created end to end property definitions and categories to define the Hyperion Planningmetadata structurefeed from FDMEE for Location hierarchy.
• Developed new Versions and Hierarchies for various dimensions under them.
• Created various property definitions for enabling the member names, parent members, alias properties to begenerated in the export processes.
• Developed numerous custom export processes in FDMEE as per the requirements by the target systems - EBS,HFM, HP inventory and HP Planning/Budgeting applications.
• Modified the configuration, initialization files and the batch processes for these export jobs, by addingperations and assigning new environment variables.
• Alternate version for the department hierarchy has been created, and import/export processes specific tothat have been developed, so that the this hierarchy reflects structural changes.
• Developed code parameters in property definitions to generate Prefixes for the members as per theRequirement.
• Integrated EBS test instance with FDMEE test instance, by creating external connection to the database tables.
• Assist on closing processes, including detailed variance analysis and reporting

Hyperion Planning and Essbase Developer

Confidential

Environment: Hyperion Essbase 11.1.2.3(ASO & BSO), Oracle 10.2.0.4, Essbase Spreadsheet Add-In, Windows 2003, Hyperion Shared Services, Web Analysis, Oracle Data Integrator, Hyperion Workforce Planning, Workspace and Smart View, Web Logic 9.2.3, IIS 6.0.

Responsibilities:

• Partner with internal business and technical teams to define and support business requirements and technical specifications for both new and existing applications
• Provide production support on Hyperion Planning and Essbase including integrations with Oracle G/L and Workday
• Work with the Oracle DBA team to perform Essbase database tuning and streamline backend processes such as backup and recovery on Hyperion servers, platforms and operating systems.
• Recommend and implement enhancements to current Hyperion Planning and Essbase applications to improve application performance and user experience.

Oracle Hyperion Programmer/Analyst

Confidential

Environment: Hyperion Essbase 11.1.1, Essbase Administration Services, Interactive Reporting/Brio, Essbase Integration Services, Excel Add-In, Windows server 2003.

Responsibilities:

• Involved in the installation and deployment of Oracle EPM 11.1 systems in the patch environment which included Shared Services, Essbase Hyperion Financial Management, Hyperion Planning and Web analysis, Financial Reports Hyperion Workspace and Oracle Data Integrator (ODI) and configured the installed products using EPM System Configurator
• Developed outlines, dim builds using various methods, data loads from flat files and Oracle database
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications
• Optimized the database by configuring Sparse and Dense dimensions, restructured the database by adding new members, Data storage & Consolidation properties

Confidential

Hyperion Planning and Essbase Application Manager

Environment: Oracle Hyperion System 11.1.2.1, Oracle Enterprise Performance Management System, Oracle Data Integrator 10.1.3, Smart View, Hyperion Financial Reports, Hyperion Enterprise, SAP BO KPI Dashboards, Data Staging application, Part Search tool, Team Track and Web Time sheet

Responsibilities:

• Handling new client enquiries and acting as the face of the business.
• Upgraded Hyperion System 9.3.3 to 11.1.2.1 and configured all the environments
• Migrated Essbase and Planning applications, Financial reports from Dev to Test, QA and Prod environments
• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users
• Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and Packages and ran preload Business Rules using Oracle Data Integrator
• Share / spread knowledge throughout the Support Team and relevant areas, from development through to support

Hyperion Planning Developer

Confidential

Environment: Hyperion Essbase 9.3.3, Hyperion Planning 9x,, Hyperion Financial reports, Hyperion Enterprise, Smart view, Web logic BEA, Excel Add-in, Web Analysis, Oracle Data Integrator (ODI), HAL, Web analysis.

Responsibilities:

• Involved in the installation and deployment of Oracle EPM 11.1 systems in the patch environment which included Shared Services, Essbase Hyperion Financial Management, Hyperion Planning and Web analysis, Financial Reports Hyperion Workspace and Oracle Data Integrator (ODI) and configured the installed products using EPM System Configurator
• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users data.
• Migrated cubes to different environments using Migrate Wizard in Administrative Services.
• Performed tuning, Optimization using Hour glass design technique.
• Designed and created new server substitution variables thereby narrowing down the management of a single calc script for current and prior month/year.
• Applied system patches and service fixes to upgrade the system from 9.3.1 to 9.3.1.3 and to resolve the issues encountered by Hyperion system 9 bugs.

Confidential

System Analyst

Environment: Hyperion Essbase 9.3.1, Hyperion Financial reports, Essbase Addins, Web Analysis, Oracle Data Integrator (ODI), Web analysis.

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).