EXPERIENCE SUMMARY:

15 years of experience in Analyzing, Designing, Developing, Testing, Administering and Maintaining Financial Planning and Management Systems and Data Warehouses for large organizations using Oracle EPM Fusion Edition, Hyperion Planning, Essbase, Hyperion Web Analysis, Hyperion Financial Management (HFM), Hyperion Strategic Finance (HSF), Hyperion Application Link (HAL), Analyzer, Hyperion Essbase Integration Server (EIS), ERP Integrator, Brio/SQR, Hyperion Smart View, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, Hyperion Financial Data Quality Manager (FDM), Hyperion Master Data Management (MDM), Hyperion Data Relationship Management (DRM), De - Mantra, Oracle Data Integrator (ODI), Oracle BI Applications, OBIEE, Hyperion Enterprise, Informatica, Business Objects Xi, SAS, Crystal Reports, SAP, Oracle e-Business Suite, Teradata, IBM DB2, IBM Websphere, BEA Web Logic, MS SQL Server, Oracle, SQL, MaxL, VBScript, Windows, Solaris, HP-UX and AIX.

TECHNICAL SKILLS:

Financial Applications: Oracle EPM Fusion Edition 11.1.2.2, 11.1.2.1, 11.1.1.3, Hyperion Financial Management (HFM) 11.1.2, 11.1.1.3, 9.3.1, 9.2, 9.1, 9.0, Hyperion Strategic Finance (HSF), Hyperion Planning, Hyperion Workforce Planning, Hyperion FDM (Financial Data Quality Management), ERP Integrator, Hyperion Enterprise, Peoplesoft Financials, Oracle e-Business Suite, SAP FI-CO.

Data Warehouse: Oracle EPM Fusion Edition 11.1.2, 11.1.1.3, Hyperion Essbase and Planning 11.1.2, 11.1.1.3, 9.3.1, 9.3, 9.2, 9.1, 9.0, 7.1.5, 7.1.2, 6.5.4, Hyperion Web Analysis, Hyperion Application Link (HAL), Hyperion Analyzer, Hyperion Essbase Integration Server (EIS), Essbase Administrative Server (EAS), Intelligence (Brio/SQR), Hyperion SmartView, Essbase Studio.

Business Intelligence: Oracle BI Applications, OBIEE, Hyperion BI+ Reports, Hyperion Smart View, Hyperion Financial Reporting Studio, Web Analysis, Hyperion Interactive Reporting, SQR Production Reporting, Brio, Business Objects Xi, SAS, Crystal Reports.

Data Management: Hyperion Master Data Management (MDM), Hyperion Data Relationship Management (DRM), Oracle Data Integrator (ODI), ERP Integrator, Informatica, SAP/BW, Essbase Integration Services (EIS), Hyperion FDM (Financial Data Quality Management), Data Stage.

ERP Applications: SAP, Oracle eBusiness Suite, Oracle Demantra, JDE, Peoplesoft.

OLAP Tools: Essbase Administration Services (EAS), Essbase Integration Services (EIS), Hyperion Web Analysis, Hyperion Application Link (HAL), Hyperion Analyzer, Hyperion Intelligence (Brio/SQR), Hyperion SmartView, Hyperion Interactive Reporting (IR).

UNIX: Linux, Solaris, HP-UX, AIX, Shell programming, sed, awk, grep.

Middleware: IIS, Websphere, Weblogic, Apache, Tomcat.

Windows: Windows 2008/2003/2000/ NT/98/95/3.1/DOS.

Databases: Oracle 11g, 10g, 9i, 8.x, 7.x, Teradata, IBM DB2, MS SQL Server 2008, 2005, 2000, 7.0, 6.5

Database tools: SQL, Toad, SQL*Plus, PL/SQL, Teradata SQL Assistant.

Productivity Tools: MS Excel, MS Visio, MS Power Point, MS Project, MS Access. ssd

PROFESSIONAL HISTORY:

Confidential

Oracle EPM, Hyperion Planning, Essbase, Peoplesoft, HFM, DRM & FDM Consultant

Responsibilities:

• Created complex HFM Data Grids, HFM Forms, HFM Reports, HFM Smart-Views and HFM Business Rules for Excel Bulk Data Load, GAAP and IFRS Reporting, Inter-company elimination, Process Control, Cash Flow Calculations, Dual Income Statement with US GAAP Adjustments, Calendar Year Statutory Reporting and Shareholder Statement of Equity using Hyperion Financial Management for Confidential Financial Services. Integrated Oracle DRM, FDM, and FRS with Oracle HFM.
• Designed and developed Hyperion Planning Web Forms, Hyperion Reports, Hyperion Business Rules for Confidential Products, Services, and Service Bookings. Managed Code Development, Testing, and Monthly Releases for Onsite and Offshore Confidential Teams.
• Designed Confidential Gross Margin, Contribution Margin, and Shipped Margin Reports. Designed Incremental Data Load to improve Confidential data load performance.
• Managed Confidential credit Memo and RMA Hierarchy changes in conjunction with Confidential DRM team, MRA team, and IFP team. Designed the Hierarchy Change Management process in Oracle DRM and Hyperion Planning.
• Simplified Security Model, Changed member names to use source system codes, performed Sales Calculations and Judge Changes, managed P&L depth of accounts and implemented process management in order to manage Confidential Product GM Enhancement Schedule.
• Created Confidential Product, Project, Entity, Reporting, Business Unit and Account Hierarchies using Oracle Hyperion DRM. Created Meta-Data scripts for Meta-Data Import, Validation Rules, Verification Rules, and version control using Oracle DRM Import, Auto-Mater and Blender Tools.
• Created FDM processes using FDM Task Workbench to load PeopleSoft Data into Oracle EPM (Hyperion Financial Management) on a periodic basis. Performed Financial Data Management (FDM) Imports, Validations, Exports, and ran Check Reports.
• Designed and developed Data Extract programs to create Data Feeds from De-Mantra Applications into Confidential Hyperion Planning Cubes.

Confidential

Oracle EPM, Hyperion Planning, Essbase, HFM & FDM Consultant

Responsibilities:

• Created Hyperion smart view spreadsheets, Financial Reporting Studio reports and Hyperion reports scripts for data validation, data extracts and data reporting purpose.
• Created sales and cost of sales, service Input for cost of sales, sales expense form, sales division merchandise input form for SGA and expense, consolidated adjustments form, ISG input form for inter-company transactions, corporate administration expense form, salary benefits ratio form, income tax ratio form, inter-departmental charge-back ratio form, monthly dealer overhead ratio form, BSD inter-divisional allocation ratio form, BSD 2-Digit P&L allocation ratio form, and finance adjustment forms using Hyperion Planning Web Forms.
• Created Confidential Americas Hierarchy to accommodate loading of data from Confidential Canada to Confidential USA for Americas reporting. Created Meta-Data update scripts and data load scripts for Confidential Americas Hierarchy.
• Created HAL Flow Diagrams and processes to automate Meta-Data Update and Data Load from Oracle Financials into Hyperion Planning. Handled all process exceptions effectively within the HAL process.
• Created FDM processes using FDM Task Workbench to load Oracle e-Business Data into Oracle EPM (Hyperion Planning and Hyperion Financial Management) on a periodic basis.
• Setup Hyperion Planning, Essbase, and HFM Security using Hyperion Shared Services. Externalized Essbase Security to Shared Services. Setup Users, Groups, and Application Groups in Shared Services. Setup Users, Groups, and Application Groups in Shared Services.
• Performed Financial Data Management (FDM) Imports, Validations, Exports, and ran Check Reports. Setup and updated FDM Control Tables. Setup and configured FDM Locations. Setup FDM batch processing using FDM Batch Loader and created custom FDM scripts to automate the FDM Batch Load process.
• Created Hyperion Essbase MaxL, Esscmd and Outline Loader Scripts for Essbase and Planning Cube Builds, Data Loads and Cube Administration.

Confidential

Oracle EPM, FDM, HFM, Hyperion Planning & Essbase Consultant

Responsibilities:

• Architected, installed, and configured Oracle EPM Fusion Edition Release 11.1.2.1 products on Linux and Windows servers in test and production environments. Installed, configured, and tested Essbase and Planning on Linux Server along with Essbase tools including EIS, EAS, and Essbase Studio Servers. Setup connectivity between Essbase Server, Planning Server, and Oracle Database Server. Installed, and configured Shared Services, Foundation, Reporting Studio on Windows Server. Installed and configured FDM (Financial Data Quality Management) on Windows Server. Managed HSF Entities and Entity Groups on HSF Server.
• Gathered Business Requirements from Finance Department users and created Business Requirements Document for loading Actuals and Budget data from JDE and Oracle eBusiness Suite into Oracle EPM. Created FDM processes using FDM Task Workbench to load Oracle e-Business Data into Oracle EPM (Hyperion Planning and Hyperion Financial Management) on a periodic basis.
• Created HSF Account Structure and projected values for HSF accounts in HSF forecast periods. Created complex customized HSF Reports.
• Installed, configured, and administered Hyperion ERP Integrator and designed data integration between Hyperion planning and Oracle e-Business Suite. Defined ERP Integrator data rules to validate and load data into Hyperion planning. Configured ERP integrator to drill through from Hyperion planning to Oracle GL Data.
• Created FDM Maps for mapping JDE Account numbers in the old system to Oracle EBS Account numbers in the new system. Copied FDM Maps from Test to Prod environment using Hyperion Map Loader. Created FDM Maps for mapping Centers, Locations, Companies, and Markets.
• Created FDM Data Integration import scripts to import data from Oracle eBusiness Suite and JDE data sources. Created custom FDM Visual Basic Scripts to automate the Data Load processes. Created FDM Validation Rules to validate data being loaded.
• Setup FDM batch processing using FDM Batch Loader and created custom FDM scripts to automate the FDM Batch Load process.
• Created Hyperion Essbase MaxL, Esscmd and Outline Loader Scripts for Essbase and Planning Cube Builds, Data Loads and Cube Administration.
• Defined the data integration business needs using FDM, installed, registered, and configured the FDM source and target adapters and developed integration data flows from various source systems using FDM into Oracle EPM.
• Designed and developed Hyperion Planning Web Forms, Hyperion Smart View spreadsheets, Hyperion Reports, HFM Data Grids, HFM Data Forms and HFM Reports.

Confidential

Hyperion Financial Management (HFM), FDM, Planning & Essbase Consultant

Responsibilities:

• Did Business Analysis, Design and Development for the Confidential IT and Finance Departments. Designed and developed complex Business Rules to implement Business Logic Calculations for Hyperion Financial Management (HFM) and Hyperion Planning Applications.
• Designed and developed Hyperion Data Extract programs to extract Financial KPI, Legal KPI, Marketing KPI and HR KPI from Hyperion Financial Management (HFM) and Hyperion Planning Applications.
• Created complex Data Forms for Hyperion Planning Databases and developed and launched complex Business Rules.
• Designed, maintained, and executed complex HFM rules using VBScript and Hyperion Financial Management Rules Editor. Created custom HFM rules for Automatic Reclassifications, Minority Interest Calculations, Luxembourg GAAP Automation, Inter-Company Eliminations, Cash Flow Calculations, Cumulative Translation Adjustments, Operational Calculations and Working Capital Calculations.
• Gathered Business Requirements from Finance Department users and created Business Requirements Document and Design Specification Document for Month-End Financial Close Process. Created an FDM process using FDM Task Workbench to load Oracle e-Business Data into HFM.
• Uploaded FDM Maps for SAP IFRS, GMBH IFRS, UK IFRS, NORTHAMERICA and JDE. Copied FDM Maps from Test to Prod environment using Hyperion Map Loader.
• Created Hyperion Essbase MaxL and Esscmd Scripts and executed Essbase scripts for Essbase ASO and BSO Cube Data Loads and Cube Administration.
• Defined the data integration business needs using Oracle Data Integrator (ODI), identified and declared the sources and targets using ODI Topology Manager, developed integration interfaces and additional components for ODI tasks and integrated those to build ODI package workflows.
• Designed and developed Hyperion Planning Web Forms, Hyperion Smart View spreadsheets, Hyperion Reports, HFM Data Grids, HFM Data Forms and HFM Reports for US GAAP and Luxembourg GAAP Balance Sheet Movements, European and North American Capital Expenditure Input and Calculations, Consolidation and Translation, Cash Flow Calculations and Administration.

Confidential

Hyperion Planning, DRM, HFM, FDM & Essbase Consultant

Responsibilities:

• Did Business Analysis, Design and Development for the Brocade IT and Finance Departments. Prepared Business Requirement Documents and Technical Design Specification Documents for Bro Plan, Rev Plan, and Inv Change Hyperion Planning and Essbase Cubes.
• Designed and developed complex Business Rules to implement Business Logic Calculations for Hyperion Planning. Migrated Hyperion code enhancements from development to test and transitioned to production environments.
• Upgraded Demantra from version 7.1.1 to 7.3.0.1 and applied upgrade patches. Designed and developed customized solutions using PL/SQL procedures, DemantraMethods andDemantra Workflows. ConfiguredDemantrato support the Brocade's Demand Planning Process. Created Demantra integrations to import forecasts from Planning, Marketing, Sales and Finance to enable Sales and Operations Planning.
• Designed and developed Oracle Data Extract programs to extract Sell-Thru and Ending Inventory Data from Oracle e-Business Suite and Hyperion Load Rules to load it into Hyperion Rev Plan Cube.
• Architected, Designed, and Developed Hyperion DRM scripts to automate the periodic updates of Product Hierarchy into Rev Plan Cube representing single source of truth for Product Hierarchy across the Enterprise.
• Performed Hyperion Data Loads and Data Management using Essbase Administration Services and Essbase Integration Services.
• Designed and developed Hyperion Meta-data extract programs to extract Department Hierarchy and Account Hierarchy from Bro Plan Cube in a parent-child format and programs to load these into Hyperion DRM to manage these hierarchies centrally across the enterprise.
• Designed and developed Data Extract programs to create Data Feeds for Consensus, GFF, CAD, and De-Mantra Applications from Hyperion Cubes.
• Performed Hyperion Financial Management Consolidations including Inter-company Consolidations. Extracted data, meta-data, journals, journal templates, rules, member lists, and security from HFM Applications for backup purpose. Managed HFM meta-Data Changes including Account and Entity Hierarchy Changes and loaded into HFM Applications. Managed changes to HFM Rules and Security.
• Designed and implemented Hyperion Planning Security Model. Setup Hyperion Planning Security Groups and Sub-Groups using Shared Services. Assigned Business users to respective Security Groups and did user provisioning at Security Group Level. Implemented the Security Matrix using Hyperion Planning Security Filters and refreshed Hyperion Planning Security Filters.

Confidential

Oracle EPM, DRM, Hyperion Planning & Essbase Consultant

Responsibilities:

• Did Analysis, Design and Development for the Confidential Finance Department using Oracle EPM Fusion Edition 11.1.1.3, Hyperion Planning, Hyperion Essbase, Oracle 10.2, Hyperion SmartView, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, Hyperion Data Relationship Management (DRM), Hyperion Essbase Administration Services (EAS), Hyperion Essbase Integration Services (EIS).
• Installed and Configured Hyperion Data Relationship Management (DRM) 11.1.1.43 Server and Clients. Gathered Business Requirements for Hierarchies to be loaded into DRM. Designed and developed DRM Automator Scripts to load the Confidential Projects, Chart of Accounts, Companies, Departments, Company Codes, Lines, and Channels into DRM. Automated the DRM Hierarchy Load process.
• Integrated Meta-Data changes from OBIEE Repository into Hyperion DRM as a Meta-Data upload process. Loaded data from OBIEE Data Warehouse into Hyperion Planning.
• Installed and configured Hyperion Essbase and Planning. Designed and developed Hyperion Planning Calc Scripts. Setup Hyperion Shared Services and Security.
• Performed Oracle EPM 11 Data Loads and Data Management using Essbase Administration Services and Essbase Integration Services. Designed and developed Drill through Reports using Oracle EPM 11 Essbase Studio.
• Materialized the Essbase aggregate views using one aggregate level from each Dimension and used these views to generate aggregate values in Hyperion Essbase ASO Cubes. Used Dimension Aggregations in Hyperion Essbase as well as Dynamic Calculations to evaluate MDX Expressions against Dimension Members.
• Designed and Developed complex financial reports using Financial Reporting Studio (FRS), Web Analysis, Interactive Reporting and SQR Production Reporting to generate Hyperion Planning and Hyperion Strategic Finance Reports with Actuals, Budget, and Forecast Data.
• Performed DRM Security Administration and User Management.
• Managed Hierarchies, Business Rules, Mappings, and Validations using Hyperion DRM.

Confidential

Hyperion Planning & Essbase Consultant

Responsibilities:

• Did Analysis, Design and Development for the UHG General Ledger Re-organization (GLR) Project using Hyperion Planning, Hyperion Essbase, Oracle 10.2, Hyperion Smart-View, Hyperion Application Link, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, and Hyperion Essbase Administration Services (EAS).
• Did Analysis, Design and Development for allreportingEssbase cubesincluding ERUHG - Enterprise Reporting Confidential - Balance Sheet, Income Statement and Restatement data for all segment for Internal Reporting, ERUHGX - Balance Sheet and Income Statement for External Reporting, ERUHGSY - Statutory Balance Sheet and Income Statement, ERIGXWB - Income Statement for Ingenix Management Reporting, and OPUHCWB - UHC Operational Gross Margin.
• Managed the design, development, and migration processes related to GL GAAP Handoff to Reporting, including technical and business process documentation.
• Designed and developed complex Business Rules to implement Elimination Logic, Allocation Logic, and Calculations for Hyperion Financial Management and Planning. Migrated the code enhancements from development to test and production environments.
• Designed and developed Hyperion Essbase Calc Scripts. Setup Hyperion Essbase and Planning Security using Shared Services. Implemented the UHG Security Matrix to grant appropriate rights to all UHG users and groups.
• Designed Essbase Calc Scripts to implement complex Allocation Logic. Designed Hyperion Planning Web Forms and Reports to display pre-allocation and post-allocation Data.
• Designed and Developed Hyperion Planning Calc Scripts for UHG Hyperion Planning Apps.

Confidential

Hyperion HFM, Planning, DRM & Essbase Consultant

Responsibilities:

• Did Analysis, Design and Development for Confidential IT and Finance Departments using Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Strategic Finance (HSF), Hyperion Essbase 11.x, 9.x, 7.x, Oracle 10.2, 10.1, MS SQL Server, Teradata, Hyperion SmartView, Hyperion Application Link, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, Hyperion Financial Data Quality Manager, Hyperion Master Data Management (MDM), Hyperion Data Relationship Management (DRM), Hyperion Essbase Administration Services (EAS), Hyperion Essbase Integration Services (EIS), Hyperion Planning, Hyperion Performance Management.
• Designed and developed complex Business Rules to implement Elimination Logic, Allocation Logic, and Calculations for Hyperion Financial Management and Planning. Migrated the code enhancements from development to test and production environments.
• Created an FDM process using FDM Task Workbench to load SAP Data using triggers from DTS processes into Confidential Legal, Division, and Segment Hierarchies and to initiate BAM Accounting process.
• Performed Hyperion Essbase Data Loads and Data Management using Essbase Administration Services and Essbase Integration Services. Designed and developed Drill through Reports.
• Created Hyperion Essbase MaxL and Esscmd Scripts and executed Essbase scripts for Essbase ASO and BSO Cube Data Loads and Cube Administration.
• Setup Hyperion Master Data Management (MDM) and Hyperion Data Relationship Management (DRM). Performed DRM Security Administration and User Management.
• Managed Hierarchies, Business Rules, Mappings, and Validations using Hyperion DRM.
• Performed Hyperion Financial Management Consolidations including Inter-company Consolidations for Confidential Legal, Segment, and Division Hierarchies..
• Created complex Hyperion HFM SmartView Spreadsheets for Hyperion Financial Management to SAP Data Comparison with Complex HSV Formulas embedded into the SmartView Spreadsheets.
• Customized Hyperion Financial Management (HFM) Cash Flow Reports, including GAAP cash flow and free cash flow for plant-wise, division-wise, segment-wise, and company-wise cash flow analysis.

Confidential

Hyperion Planning, Essbase & Reporting Consultant

Responsibilities:

• Designed and developed Hyperion Essbase Applications, Databases, Outlines, and Data Load Scripts using Hyperion Essbase Administration Services for Confidential Associate Administration, Talent Planning, Source Effectiveness, Retention, and Openings Management ASO and BSO Cubes.
• Designed and Developed OLAP Models and Data Load processes using Hyperion Essbase Integration Services (EIS).
• Managed complex Reports, Dashboards, and Charts using Hyperion Web Analysis, Hyperion BI+ Interactive Reporting, Hyperion Financial Reporting Studio, and Hyperion SQR Production Reporting.
• Designed a Migration Strategy and trouble-shooted various bugs during System 7x to System 9x Essbase Migration and System 7x to Oracle 9x Migration.
• Performed Oracle Essbase Data Loads and Data Management using Essbase Administration Services and Essbase Integration Services. Designed and developed Drill through Reports using Hyperion Reports.
• Materialized the Essbase aggregate views using one aggregate level from each Dimension and used these views to generate aggregate values in Hyperion Essbase ASO Cubes. Used Dimension Aggregations in Hyperion Essbase as well as Dynamic Calculations to evaluate MDX Expressions against Dimension Members.
• Designed and Developed complex Teradata SQL queries, Teradata Load Scripts, and tuned Teradata Databases using Teradata SQL Assistant and Teradata FastLoad.
• Designed the Security Policy and Setup Hyperion Security at User, Group, and Entity Levels using Hyperion Shared Services.
• Used Report Wizard, Cube Navigator, and Dimension Browser to develop and test Hyperion Analyzer Reports.
• Installed and Configured Hyperion BI+ Reports and Financial Reporting Studio including Hyperion Financial Management Client and Smart-View on Client PC.
• Designed and developed Informatica Load Programs to load data from Teradata to Essbase Cubes and significantly improved Load Times.
• Designed and Developed Essbase Integration Server (EIS) Meta-outlines to load Dimensions and Data into Essbase Cubes.
• Installed and Configured Hyperion BI+ Reports and Financial Reporting Studio including Hyperion Financial Management Client and Smart-View on Client PC.

Confidential

Hyperion HFM, HSF, DRM, SAP, Essbase & Planning Consultant

Responsibilities:

• Did Administration, Analysis, Design & Development for Finance Department using Hyperion Financial Management, Hyperion Strategic Finance, Essbase and Planning Implementation using Hyperion Essbase 9.3.1, 9.2, 9.1, 9.0, Oracle 10.2, 10.1, IBM DB2, Teradata, Hyperion Financial Management 9.3.1, 9.2, 9.1, Hyperion Strategic Finance (HSF), Hyperion SmartView, Hyperion Application Link, Hyperion BI+ Reports, Hyperion Financial Reporting Studio, Hyperion Financial Data Quality Manager, Hyperion Master Data Management (MDM), SAP, Hyperion Performance Scorecard.
• Created Hyperion Essbase Report Scripts using the Hyperion Essbase Report Editor and executed Essbase Report scripts in MaxL or ESSCMD interactive or batch mode for Essbase ASO and BSO Cubes.
• Interviewed Key Users to gather the Business Requirements for the Data Warehouse and Reporting Implementation. Conducted Structured Interviews with Business Users and prepared BRD (Business Requirements Document) for delivering Global Collection, Financial Consolidation, Reporting, and Analysis using Hyperion Financial Management (HFM).
• Created Complex HFM Rules for advanced business calculations in Hyperion Financial Management applications. Designed, maintained, and executed complex rules using VBScript and Financial Management Rules Editor for loading SAP Data.
• Implemented HFM rules for the custom and value dimensions. Created custom Currency Translation rules and custom Consolidation and Elimination rules.
• Managed complex Consolidation Structures and Currency translation with multiple scenarios using Hyperion Strategic Finance (HSF).
• Managed HSF Entities and Templates and stored them on Hyperion Strategic Finance Server.
• Managed HSF Account Changes, Time Period Changes, Scenario Changes and Report Changes using Hyperion Strategic Finance ECM (Entity Change Manager).
• Tuned database performance and wrote rules for dynamic accounts, created translation rules, and created consolidation rules. Trouble-Shooted rules files by writing log data to text files.
• Designed and Developed complex Teradata SQL queries, Teradata Load Scripts, and tuned Teradata Databases using Teradata SQL Assistant, Teradata Fast-Load, Teradata Multi-Load, Teradata Parallel Transporter, and Teradata T-pump.
• Developed and executed test automation strategies and plans. Designed and implemented manual and automated Test Cases and Test Script for Hyperion Financial Management (HFM) and Essbase ASO.
• Setup Hyperion Master Data Management (MDM) and Hyperion Data Relationship Management (DRM). Performed DRM Security Administration and User Management.
• Managed Hierarchies, Business Rules, Mappings, and Validations using Hyperion DRM.
• Created user-defined validations using DRM configuration utility. Administered Organizational Structures, Chart of accounts, Products and Customer relationships using Hyperion DRM.
• Used Essbase Analytic Administration Services to administer Hyperion Essbase.
• Materialized the Essbase aggregate views using one aggregate level from each Dimension and used these views to generate aggregate values in Hyperion Essbase.
• Used Dimension Aggregations in Hyperion Essbase as well as Dynamic Calculations to evaluate MDX Expressions against Dimension Members.
• Did Enterprise-Level Planning for Headcount, Salary, Compensation, Capital Assets, and Depreciation using Hyperion Planning and integrated the Report Plans with Microsoft Excel.
• Architected Hyperion Financial Management (HFM) Reporting Infrastructure including System Infrastructure, Metadata Layer Infrastructure, and Data Acquisition and Data Distribution Infrastructure.
• Performed Hyperion Financial Management (HFM) Design using Smart Dimensions to identify and report on Profitability and Cash Flow including Project, Product Line, Customer Segment, Distribution Channel, and other Dimensions.
• Loaded Metadata and Loaded and Consolidated Financial Data into HFM using Financial Data Quality Management.
• Used Hyperion Planning what-if-scenarios to dynamically consolidate and report on financial budgets, forecasts, and plans.
• Managed dimensions using Hyperion BPM Dimension Library and managed Application Views using Hyperion BPM Application Library. Created, Managed, and Integrated Planning processes using Hyperion System 9 BPM Architect.
• Performed Sales Revenue Planning, Marketing Campaign Planning, and Demand Planning using Hyperion Planning.
• Installed and Configured Hyperion BI+ Reports and Financial Reporting Studio including Hyperion Financial Management Client and Smart-View on Client PC. Enhanced, Developed and Tested HFM Smartview Excel Spreadsheets and HFM Reports for the Finance Department.