SUMMARY:

• Financial Domain expertise with technology focus.
• Implementation and roll out of multiple Hyperion projects (Hyperion Planning, Essbase, Hyperion Strategic Finance, Hyperion Financial Management) - right from understanding requirements, to design, and build to Go Live.
• Proficiency with Calculation Scripts, Load Rules, Report Scripts, Webforms, Security, ASO, BSO, MDX, MAXL, Planning and Essbase development, administration / migration / installation /upgrade.
• Communicating with IT and business stakeholders (Global Controllers, FP&A Leads, Business SPOCs) by conducting weekly meetings, providing project update dashboards.
• Extensive experience in Hyperion Essbase OLAP design, development, implementation, analysis, reporting and administration.
• Involved in working with PBCS and EPBCS application.
• Involved in setting up and maintaining HFM web Forms, Data Grids, and ICP Transactions.
• Experience and good understanding of HFM Consolidation engine, consolidation process, HFM dimensionality and strong concepts of HFM Rules and security.
• Knowledge of business processes and System Development Life Cycle (SDLC).
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data and Managed End User Process Flow for Plan, Outline Structure, Planning Access, Planning Navigation and was responsible for Calculating Data, Copying Versions, Workflow Management, assigning security and maintenance of web Forms and planning Smart Lists.
• Extensive experience in Administration of Essbase databases, automation process in Window environment using Batch scripting .
• Responsible for technical design documentation of HFM, Planning and Essbase.
• Knowledge of SOX (IT Controls) .
• Responsible for troubleshooting of Existing Essbase/Planning cubes, batch support of existing cubes, problem identification/problem management, resolution and documentation .
• Worked with Finance leadership to understand long and short term strategic goals for financial budgeting, planning, forecasting and projections.
• Experience in large scale, enterprise-wide installation, configuration, server settings, upgrade and backups of Hyperion System 9 products and Oracle EPM System 11 products such as Shared Services, EssBase, Planning, EssBase Integration Services, Web Analysis, Financial Reports, Workspace, HAL, HFM, ODI, on Windows environments.
• Functional and Technical Knowledge of Accounting, Budgeting, Forecasting, Planning and analysis of financial statements (Balance sheet, Owner’s equity, Profit & Loss).
• Migration of Financial Reports Reports, Web Analysis Reports, planning application, Essbase, HSF Application from development environment to test and production environment.
• Developed Reports using Financial Reports and Web Analysis.

SKILLS:

Business Intelligence Tools: Oracle EPM System 11 (Fusion Edition), PBCS, EPBCS, Hyperion Strategic Finance, Hyperion Essbase, Hyperion Planning, FDMEE, Financial Data Management (FDM), Hyperion WorkForce Planning, Hyperion Shared Services, Hyperion Financial Management (HFM), Calculation Manager, Hyperion Business Rules, LifeCycle Management (LCM), Calculation Manager, Calculation Scripts, Data Warehouse, Smart View, BSO, ASO, MDX, Excel Addin, Esscmd, MaxL, Essbase API, Excel VBA, Apache Tomcat, Websphere, Weblogic, Classic and EPMA Application, Excel Macros, Oracle Financial Analyzer, IIS

Reporting Tools: Hyperion Financial Reports, Web Analysis, Interactive Reports

Programming Languages: SQL, VB Script

Database Management Tools: TOAD, Oracle SQL Developer, SQL Programmer, Visual Source Safe, Subversion, SQL Server Management Studio Express

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Essbase/Planning/Developer/Administrator/Architect

Responsibilities:

• Support and development of Hyperion Applications
• Facilitating meetings between important IT and Business stakeholders to drive new enhancements and key initiatives in Hyperion space
• Development of complex allocation related calculation scripts in BSO and ASO cube.
• Involved in requirements gathering, configuration, design, development, and implementation of various
• Hyperion products including FDMEE, Essbase, Planning and DRM, and translated end user requirements
• Into application design specifications.
• Responsible for automation, optimization and performance tuning of Essbase/Planning applications.
• Developed numerous Essbase artifacts such as Load Rules, Calc Scripts, Reports Scripts and Web formsBusiness Rules for Hyperion Planning Applications. Documented business requirements and deployment plan.
• Responsible for migration using LCM.
• Interaction with finance and accounting customers who possessed various levels of business knowledge.
• Assess new Business needs, initiatives and translate them into detailed business requirements specifications.
• Worked closely with IT and finance teams to resolve issues, upgrade, develop, test, and implement financial systems.
• Working with the client to move on premise Hyperion planning to PBCS.
• Worked to convert MAXL scripts into EPM automate.

Confidential, New York, NY

Essbase/Planning/Developer/Administrator/Architect

Responsibilities:

• Support and development of Hyperion Applications
• Maintenance of previous Essbase/planning cubes along with the newly designed cube.
• Designed load rules for Dimension build and data loads.
• Created and maintained the mapping in FDMEE. Responsible for data load in Planning/Essbase through FDMEE.
• Designed new CALC scripts and Report Scripts.
• Administered Budgeting and Forecasting application using EPBCS/PBCS
• Developed Business rules using Calc manager in EPBCS/PBCS
• Created and made changes to the existing MaxL scripts and scheduled the batch script.
• Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation
• Performed optimization of data forms, report scripts, Calc Scripts, business rules.
• Customized aggregation for ASO cube by creating views.
• Developed simple to complex calculation scripts to arrive at the aggregated data for each application based on the functional specifications.
• Developed integration of FDMEE with Oracle EBS.
• Used Jython scripting for open system adaptor integration with FDMEE.
• Planning application was modified to use the drill through functionality using FDMEE.
• Maintained database for optimum performance for using calculation scripts and business rules.
• Assisted the integration of Interactive reporting process along with streamlining of method improvement for data collection and loading processes.
• Created various process automation using MaxL Scripts.
• Involved in performance tuning of database by modifying the cache & essbase.cfg file settings.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
• Acted as a liaison between the technology and business areas of the organization.
• Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan.
• Build Hierarchies, versions using Oracle DRM.
• Responsible for configuring the batch process for automating hierarchy build through Oracle DRM using web batch
• Responsible for blending hierarchies, comparing hierarchies to build alternate hierarchy.

Environment: Oracle EPM 11.1.2.4, Hyperion Essbase, Hyperion Planning, Financial Data Management Enterprise Edition (FDMEE), Web Analysis,Financial Reports, Workspace, Windows 2012 Server, MS SQL server, Weblogic 9.1,ODI, Hyperion Financial Management, Oracle DRM, EPBCS

Confidential, New Haven, CT

Essbase/Planning/HSF Administrator/Architect/ Lead Consultant

Responsibilities:

• Involved in all high-level requirement gathering from FP&A and BGT team to design the Budget Formulation and Execution process using Oracle Hyperion EPBCS.
• Incorporated the functionality of creating and managing budgets into a single managed process using Oracle EPBCS.
• Established the new Development, Testing and Production environments in new EPBCS platform.
• Developed web Forms and Task list and managed workflow for the end users for workforce, capital and other planning applications.
• Created reports in smart view as needed, assisted in user training.
• Developed standard reports which included Balance sheet, Income statement, cash flow reports and Owner’s equity Reports using Hyperion Financial Report.
• Assigned security in EPBCS through Oracle Cloud My services.
• Used the data management in EPBCS for loading data.
• Developed Calc Scripts and business Rules/Calc Manager rules to compute cost allocation as part of the forecasting and budgeting activity.
• Used EPM Automate for automation of nightly jobs.
• Interfaced with, and provided assistance to, end-users, including, Sponsor, Directors, SMEs, other BAs and QA team members, during the requirements gathering phase and user acceptance testing phases of the project.
• Optimized the outline paging in ASO to obtain the optimum balance between memory usage and data retrieval time.
• Optimized Essbase cube amd smart view reporting.
• Oversee data uploads and verification in Hyperion via FDMEE.
• Create and maintain the mapping in FDMEE. Create the validation rules in FDMEE and involved in FDMEE scripting.
• Used drill through functionality in Planning using FDMEE.
• Facilitating meetings between important IT and Business stakeholders to drive new enhancements and key initiatives in Hyperion space. Ensuring adequate SLAs are met, small enhancements, day-to-day troubleshooting activities for critical issues, outage management, triage, liaison with Yale IT infrastructure team for OS and hardware issues, knowledge transfer, installation / upgrade / patching of Hyperion system etc and ensuring application availability and maintenance of Essbase, Planning and HSF applications.
• Assigned security for Hyperion Planning application, Essbase Applications, HSF, Web Analysis, and Financial Reports, using Hyperion Shared Services.
• Responsible for configuring and integrating FDMEE with HFM.
• Responsible for building complete HFM solutions including metadata, rules, Financial Reports, Web forms, Smart view , and security .
• Created the financial model in HSF for consolidation and responsible for model maintenance using ECM and ACM features.
• Essbase DBA Activities (Performance tuning, configuring databases, optimization, Esscmd, MaxL scripts, API, Backup, Outline, Load rules). Responsible for data reconciliation.
• Developed Versions, Hierarchies, Properties, and Property queries, Imports, Blends, Validations and Exports in DRM.
• Developed complex macros in Excel for the end users.
• As an administrator maintain all application metadata, data loads and reconciliations, serves as contact for all user inquiries and work closely with budget and finance team to design and improve reporting processes within the applications for end users.
• Created Excel Macros.
• Created Access VBA for getting data in access front end with oracle backend database
• Responsible for maintaining ASO and BSO database used for analysis, reporting and developing reports.
• Created project plan with weekly milestones and delegated daily tasks to team members in order to meet monthly production release deadlines.
• Administration and maintenance of FDM application.
• Monitor the status of tickets using Service now.
• Developed Excel vba Essbase templates.
• Assigned the users the ability to change business assumptions and immediately view the impact of those changes. In a what-if Hyperion Planning application, a user might need to analyze the affects on a project by changing the projection rates. These what-if and what-next applications combine traditional analysis and operational decision making.
• Created workforce planning cube for Salary planning and headcount planning of the employees.
• Ensuring the entire Yale wide SOX IT controls applicable to Hyperion application are met and documenting process maps for key activities (eg.user access request, user deactivation, segregation of duties, back and recovery process etc).
• Work or liaise with IT Department in ensuring efficient operation of Essbase/Planning application.
• Providing production support for OFA.
• Converted Outline formulas into MDX expressions to be used in ASO (Aggregate storage) database.
• Developed templates for data retrieval from the cube using Excel Addin and smart view.
• Responsible for the installation and deployment of Oracle EPM 11.1.2 system in the Dev environment which included Shared Services, Hyperion Essbase, Hyperion Strategic Finance, Hyperion Planning, and Web analysis, Financial Reports, Hyperion Workspace and Oracle Data Integrator (ODI) and configured the installed products using EPM System Configuration.
• Tuning of Calculation scripts and data load rules for performance optimization.
• Performance optimization by tuning the caches to get a high hit ratio for data cache and index cache.
• Develop business rules in Calc Manager based on historical trends to forecast the estimates to complete cash flow by cost category and program phase by using run time prompts.
• Developed end user training manual and technical design documentation for Planning and Essbase.
• Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
• Defined and documented the steps to migrating applications in the Hyperion Planning, Essbase environments using LifeCycle Management (LCM) in Prod, QA, and Dev.
• Created and maintained EPMA Planning application.
• Involved in building and deploying management reports, troubleshoot and resolve Hyperion system 9/11 related issues, design/code/test/debug etc.
• Involved in cube outline enhancements as per user new requirements.
• Developed standard reports using Financial reporting and internal ad-hoc reports using Web analysis.
• Develop complex reports using “planning details” database connection to display smart list in the Financial reports.
• Ensuring smooth Quarter close activities and continuous interaction with Technical and Finance teams to close issues
• Build Rules files for loading data and metadata into essbase application from flat file.
• Developed batch scripts and scheduled those for complete automation process for night and weekend calculations.
• Migrated the Hyperion Planning and essbase application from the Development environment which was using system 9 to Test environment which was using Oracle EPM 11.1.2.3

Environment: PBCS, Oracle EPM 11.1.2.3/11.2.2.2 , Hyperion Essbase, Hyperion Planning, Hyperion Financial Management (HFM), Financial Data Management (FDM), Web Analysis, OBIEE, Spreadsheet Add-in, Hyperion Application Link, EIS, Financial Reports, Workspace, Windows 2003 Server, Oracle 10g, Weblogic 9.1,ODI, Hyperion Financial ManagementConfidential

Confidential, Melville, NY

Hyperion Essbase/HFM Lead & Implementation Consultant

Responsibilities:

• Experience in using the Hyperion planning Workflow management process and capital expense module.
• Maintain and support HFM and FDM applications including managing system security, data processing, and troubleshooting user issues including Smart View.
• Managed development team through the system development life cycle (SDLC) from start to finish including requirements gathering, system design, implementation, testing, user acceptance and maintenance.
• Develop calculation scripts and member formulas for cost allocation, depreciation, interest and amortization, budgeting and forecasting.
• Converted the BSO cube to ASO cube using the Aggregate storage Conversion wizard from the AAS console.
• Converted the outline Formulas in the BSO cube to MDX numeric expression to make it compatible with ASO.
• Installing the full System 9.3.0.1 products/Upgrade the Hyperion System 9.3.0.1 to 9.3.1 in the development environment which include Hyperion Shared Services, Hyperion Essbase, HFM, Hyperion Planning, Web analysis, Financial Reports, Hyperion Workspace, Hyperion Application Link and configuring the installed products using Hyperion Configuration Utility.
• Responsible for creating Intercompany Partner (ICP) Matching Reports to list the intercompany transactions that are eliminated during consolidation and to help the end users in tracking intercompany transactions for analysis and auditing purposes.
• Responsible for maintaining and troubleshooting FDM mapping and creating import scripts.
• Developed rule files for loading the data into Essbase cube and for dimension building
• Migration of the Security from Production to Development using CSSExportImport Utility.
• Migration of the Essbase Application, Planning Application, Financial Reports, Web analysis Reports from Production to Development.
• Essbase DBA Activities involving cache optimization, Database configuration, Database backups including Hot and cold backup, Calculation script and Business Rules optimization, user setup and provisioning through Shared Services.
• Worked very closely with the business users to gather and analyze the requirements defined by them for the HFM/Essbase /Planning application and to enhance the capabilities of Hyperion for reporting purpose.
• Responsible for writing T-SQL queries for extracting data from MSSQL database.
• Developed consolidation business Rules in HFM to calculate Key metrics such as direct ownership, percent control, current ratio, cash conversion cycles, Debt Ratio, Return on Assets, Return on Equity, Debt-Equity Ration, minority interest, EBITDA and EBIT.
• Developed Business Rules to copy data from one version to another using Run-time prompts
• Created EPMA and Classic planning application.
• Created internal reports using smartview, Financial Reports and web analysis on user request.
• Involved in loading metadata into Hyperion Planning application using DIM and HAL.
• Optimized calculation scripts and data load rules for performance enhancement.
• Responsible for writing MAXL Scripts to automate the data load and calculation scripts.
• Monitor Hyperion Financial Reporting and Web Analysis folder structure from workspace.
• Replicating the upgrade implemented in Development environment to Production Environment.
• Involved in writing documentation for the steps of installation and migration.

Environment: Hyperion System 9.3.1, Hyperion System 9 BI+, Hyperion Essbase, Hyperion Financial Management 9.3.1, Financial Data Management 9.3.1 (FDM), Hyperion Planning 9.3.1, Web Analysis, Spreadsheet Add-in, Hyperion Application Link, EIS,Financial Reports, Workspace,Windows 2003 Server,,Oracle 10g, Weblogic 9.1, DIM, Hyperion Financial Management, Financial Data Management.

Confidential, Boston

Essbase/Planning Administrator

Responsibilities:

• Migration of the Planning Application from Development To Production.
• Assigning the users the ability to create and manage flexible workflows as it pertains to the budgeting and planning process.
• Develop Reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Responsible for building migration strategies, providing disaster recovery support, data validation techniques and UAT testing and training.
• Involved in building web Forms, managing the workflow process, building the task list in Hyperion planning.
• Responsible for Data Warehouse activities and gathering business requirements and transforming them into appropriate specifications for development team.
• Migration of Financial Reports and Web Analysis Reports from Production to Development.
• Migration of the Secuirty from Production to Development using CSSExportImport Utility.
• Involved in writing and modifying outline formulas for the Hyperion Workforce planning.
• Involved in building ad-hoc reports using Production Reporting and Interactive Reporting (Brio).
• Hyperion Production Support during Project Roll out to Production and thereafter.
• Performance optimization of the cube by tuning the caches and dense/sparse configuration.
• Translated end user requirements into application design specifications
• Responsible for creating journal templates in HFM with auditable Debit/Credit adjustments which speed up the close as local transactional systems need not be opened up again for late adjustments.
• Designed, developed and maintained HFM, planning and Essbase applications (Cubes).
• Assigning the users the ability to easily input budget and forecast information using the planning Web Forms.
• Installation and Configuration of the Development server consisting of Hyperion System 9 Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports, Web Analysis and Workspace, HFM.
• Responsible for optimizing the Business rules in HFM by analyzing the subcubes.
• Writing MaxL scripts to automate data load into Essbase database using Rules files.
• Involved in Building HAL Flow Diagrams for loading metadata into planning
• Responsible for Disaster Recovery procedures for the database.

Environment: Hyperion System 9, Hyperion System 9 BI+, Hyperion Essbase 9.0.1, Hyperion Planning 4.1.1, Web Analysis, Spreadsheet Add-in, Hyperion Application Link,EIS, Financial Reports, Workspace,Windows 2003 Server, HP-UX, SQL Server 2000,Apache Tomcat, Hyperion Financial Management.