SUMMARY:

• Over 9 years of experience in all phases of SDLC including design, analysis, development, support, maintenance and implementation of Oracle Enterprise Performance Management (EPM) Solutions.
• Worked extensively on Hyperion Fusion Enterprise Performance Management (EPM) System 11 (v. 11.1.2.3.500 , 11.1.2.2 and 11.1.2.1) and System 9 (v.9.3.1/3) with primary focus on Planning and Essbase.
• Involved in multiple end - to-end Hyperion Planning and Essbase implementations.
• Strong functional experience with great understanding of multiple Financial Processes, Commonly used dimensions, Common Chart of Accounts and experienced in supporting Financial Planning & Analysis (FP&A) teams from various domains.
• Strong experience in Essbase Cube Analysis and Optimization.
• Great understanding of Industry best practices for Planning and Budgeting using Hyperion Planning and Essbase.
• Experienced in creating Calculation scripts, Business Rules (Calculation Manager), Outlines, Member Formulas, MDX scripts, Rules files, ESSCMD and MAXL Scripts.
• Strong experience with ODI in integration, configuration, creating packages, interfaces and troubleshooting.
• Extensive experience in Hyperion Financial Reporting - created numerous simple to complex Financial Reports.
• Extensive experience with using/troubleshooting/installing SmartView and Essbase Excel add-in.
• Well versed in Change management and Version Control processes.
• Great understanding of multiple data sources and experienced in handling sensitive business data/PII.
• Strong experience with SQL Server database, with creating advanced SQL queries and Stored Procedures.
• Detail oriented and resourceful in the completion of projects with an ability to multitask and meet strict deadlines.
• Excellent analytical, problem-solving, troubleshooting and communication skills.

TECHNICAL SKILLS:

OLAP: Hyperion Planning v. 11.1.2.3.500 ,11.1.2.2 and 9, Essbase v.11.1.2.3,11.1.2.1/v.9.3.1/3, ODI, Essbase Studio, FDMEE, Hyperion Financial Reporting v.11, Hyperion Reports v.7

Operating Systems: Windows (2003, 2008), UNIX, LINUX

Databases: MS SQL Server (2003, 2005, 2008), Oracle, MS Access

Server: UNIX, Windows.

Scripting: VBScript, Batch Scripting, Macros, Unix Shell Scripting.

BI Reporting Tools: Smartview, Essbase add-in.

Application Software: MS-Office suite (Excel, PowerPoint, Word, Outlook)

PROFESSIONAL EXPERIENCE:

Confidential, WA

Senior Hyperion Developer

Responsibilities:

• Created a multi-currency Hyperion Planning application (Classic) and all required data load, metadata update processes for a new acquisition of Confidential , Inc.
• Created multiple calculation scripts for Aggregations, Currency conversions, Neutralizations (at rate scenarios) and other Intercompany transactions.
• Using Essbase Studio and SQL Server, created multiple standalone Essbase applications - both BSO and ASO for reporting needs and a process for seamless metadata synchronization between Hyperion Planning and other standalone BSO and ASO Essbase applications.
• Worked with Business to gather Functional specifications and then translated to Technical Design specifications prior to working on development.
• Using ODI, created processes to update multiple dimensions for the Hyperion Planning application from metadata flat files while setting various properties.
• Extensively used IBM Cognos Command Center (ICCC) for automating various tasks, including error logging, archiving and user notification for success and failed scenarios.
• Created multiple processes in the ICCC for Essbase, Planning, ODI, Essbase studio and SQL server using MaxL commands and batch scripting.
• Extensively working on coding, unit testing, debugging and implementation for ongoing weekly enhancements (sprints) to the Confidential Inc. and the new HomeAway Hyperion Planning and Essbase applications.
• Implemented Essbase Maxl encryption for all existing processes.
• Documented all processes created for the new HomeAway Hyperion Planning and Essbase applications.

Confidential, PA

Senior Hyperion Developer

Responsibilities:

• Based on use cases from existing application, created Hyperion Planning and Essbase application (classic) from scratch as a Proof of concept (POC).
• Created Planning web forms for various stress testing forecast models.
• Created Business rules (in Calculation Manager) required for data form calculations.
• Designed Task lists, Planning Units and set up Process management in Planning for the approval process.
• Created data models (load files) for loading data into the Hyperion system.
• Created detailed documentation for the prototype, explaining the dimension build process, data load processes and on using Planning web forms, task lists.
• Created Essbase Load rules to extract data from the relational database into Hyperion Application.

Confidential, CT

Senior Hyperion Consultant

Responsibilities:

• Maintained multiple Hyperion applications - responsible for monthly reporting, security, backups and other Hyperion administration tasks.
• Developed new Hyperion applications to support changes in regional Budget process.
• Worked with multiple Finance teams to resolve periodic data issues.
• Created multiple reports using Hyperion Financial Reporting for senior management reporting for actuals, budget and forecast along with ad-hoc reports in Smartview/Essbase Excel add-in.
• Identified and implemented multiple solutions for optimizing the monthly reporting processes, including modifying Financial reports, Essbase calculation scripts and outlines.
• Created new and modified existing Calculation scripts according to the needs of Financial Planning & Analysis team.
• Created new and modified existing complex esscmd/MaxL scripts for various overnight/background processes for Budget consolidation, resyncing actuals data from SMR to Budget applications.
• Extensively used replicated and transparent partitioning.

Confidential, NY

Senior Hyperion Consultant

Responsibilities:

• Led the team and partnered with Confidential BIS FP&A for building a consolidated Global Planning and Essbase Application, for North America and International projects with hands-on involvement in all phases of the SDLC including Requirement gathering, Design, Development, Testing, Migration to Production, along with detailed documentation and Hypercare Support.
• Worked extensively on translating functional specs to detail design documents and ensured that Industry best practices are followed.
• Created multiple Business Rules, Calculation scripts, Load rules (Data Loads/Dimension builds) for the Consolidated Planning and Essbase application.
• Created multiple business rule sequences to be run from Windows Scheduler as part of the overnight calculation process.
• Using FDMEE, created processes to load data from multiple sources, into Planning/Essbase.
• Created documentation for all the periodic Processes and also created User guide for the new application.
• Managed complex user security through Hyperion Shared Services and through Essbase Filters for individual users and user-groups.
• Performed end-user training for the consolidated Hyperion Planning and Essbase application.
• Created multiple interfaces in ODI to load metadata and build dimensions in Hyperion Planning.
• Partnered with Business Process Owners (FP&A) to document best practices to prevent user errors.
• Worked as Primary contact for all Baseline Activities and application support concerning the BIS Planning and Essbase applications.
• Created and modified existing Business Rules, Macros and Calculation Scripts as needed by the business as part of periodic enhancements.
• Used HP Service Manager to track and update all the incidents and requests. Also created multiple solutions in the team knowledge base for frequent issues faced by the Hyperion applications.
• Created and modified existing Business Rules, Macros and Calc Scripts as needed by the business.
• Created new extracts and modified existing ones from Essbase using Excel with VBA on a periodic basis.
• Supported many audit and SOX control related non-Hyperion applications as a secondary point of contact on a frequent basis.

Confidential

Sr. Hyperion Essbase and Planning Consultant

Responsibilities:

• Coordinated the installation efforts of Hyperion planning suite.
• Act as Single point of contact for Hyperion Planning. Supported and maintained Hyperion Planning, Essbase and Reports. On-Call support 24*7.
• Used Hyperion Financial Reporting to create numerous reports.
• Extensively involved in creating and modifying the Planning components like web forms, planning units, business rules and task lists.
• Extensively worked on creating security for users and user groups from Planning Workspace/Shared services.
• Trained end users to perform their day-to-day tasks in Hyperion, like using task lists, submitting data using web forms, using Hyperion Financial reporting and Smartview.

Confidential

Responsibilities:

• Troubleshoot and resolve anyHyperionSystem related Issues.
• Designed/Modified Outlines, Business Rules, Calculation scripts, Data Forms, MaxL scripts, Rules files as per demand.
• Worked on Metadata development such as building flat file formats for updating Account, Scenario, Entity and other dimensions.
• Identify and implement various Database optimization and performance tuning steps for Essbase cubes for faster retrieval and calculation performance.
• Trained End-Users on process control, reporting methods and using Hyperion performance suite.

Confidential, OH

Hyperion Developer

Responsibilities:

• Worked on trouble-shooting Production issues and provide support to the Essbase Applications, Hyperion Financial Reporting.
• Modified Outlines in Essbase using dimension build rules files.
• Worked with SQL Interface to load the data from the Oracle into Essbase cubes using data load rule files and also from various flat files.
• Set up users, groups according to business departments and assigning security to them in Shared Services/Essbase Administration Services console.