SUMMARY:

• Oracle HFM/DRM/Reports/FDMEE/Hyperion Essbase /SQL Consultant with 7+ years of experience with emphasis on Hyperion application Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment using Hyperion financial management, Hyperion Financial data quality management, Hyperion Financial data quality management Enterprise edition, Hyperion Essbase, DRM (Data Relationship Management) OBIEE and Hyperion Financial Reporting Studio.
• Improve the Accounting team's experience: Maintain & Automate DRM Versions, Hierarchies, Nodes, properties, and formulae.
• I have been involved in ground up implementations of Oracle EPM Products. I have worked in the Financial Service Industries, Banking, Automotive, Retail, Advertising and Entertainment Industries.
• Experience in OLAP design, Analysis, Architecture, Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment using Oracle EPM Suite, Hyperion Financial Management, FDQM/FDMEE, Oracle Hyperion Essbase, Hyperion Reports, Oracle data integrator, Essbase Spread Sheet Add - in.
• Strong experience in full implementation cycles of Hyperion Financial Management products for global corporations and small scale corporations
• Worked on requirement gathering, requirement analysis, BRD (Business Requirement Documents), FRD (Functional requirement document), Development and Design, UAT (User acceptance Testing), End user training and production of applications.
• Developed HFM applications in classic which is sourced from various financial data sources used for client consolidation and reporting needs
• Designed and developed Aggregate and Block storage databases with excellent balance of Dense and Sparse dimensions, developing various OLAP models.
• Experience in Accounting: Balance Sheet, P&L, Fixed Assets, Budgets, Closing, Reconciliations, Journal Entries, Payroll, Banking, Trial Balance, Financial Analysis, Financial Audits, ERP Implementation.
• Strong experience in Hyperion Financial management application, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation of HFM tasks using task flows from workspace.
• Designed metadata, build dimensions from existing Enterprise hierarchy for Historical data, integrate SAP entity, account and custom dimensions
• Strong knowledge in understanding and developing business rules in HFM
• Strong knowledge and experience on development of cash flow statement and automation of cash Flow Statement through business rules as per the client requirement.
• Designed complex security model for HFM and Essbase applications as per client requirements.
• Migrated Classic applications from one environment to other using LCM process and copy application utilities
• Automated the process of data feeds and dimension building of HFM applications FDM feature, example using DRM we use to maintain master data, FDM mappings and to run the export and loading into HFM application we have integrated in FDM to load metadata.
• Very familiar with SDLC process of HFM application process like consolidation process, ICP, Journals, Chart of accounts, financial statements.
• Knowledge of Change management for the System/Infrastructure Changes.
• Maintained the SLA (Service Level Agreement).
• Involved in Life cycle of Hyperion product implementation.
• Designed backup and recovery process for Hyperion Financial Management and FDM applications.
• Strong knowledge and Experience in Developing Business reports, Management with the help of Hyperion Reporting Studio using HFM and Essbase as data source.
• Solid understanding of Multidimensional and Relational database architecture; Extensive knowledge of Planning, budgeting, and forecasting procedures.
• Strong knowledge in financial reports, charts, pivots, dashboards, books, batches, snapshot reports using financial reporting studio.
• Strong Knowledge in migration process of applications from one environment to other using shared services and other back end techniques.

PROFESSIONAL EXPERIENCE:

Senior Hyperion Specialist

Confidential,New York city,NYK

• Create, maintain and update financial reports and forms
• Maintain HFM and FDMEE applications across all active environments (Development, Test and Production)
• Manage consolidations, integrations and perform validations from source systems (EBS - GL Actuals and Treasury Rates) and ensure source data flows downstream as required.
• Develop various reports (Financial Reporting Studio and Smart View) Data grids, web forms, Journals, ICP Reports as needed by Corporate Finance team.
• Perform monthly and daily maintenance of HFM and FDMEE including the execution and monitoring of extract and load processes.
• Working on the TWS job scheduler for automated jobs for daily data load.
• Maintain key processes used to support the consolidation and financial reporting with HFM and other applications
• Manage the metadata CR intake process, Interpret and analyze business requirements submitted on metadata CR's for processing and ensure proper business decision maker approval is captured for metadata updates in DRM.
• Coordinate metadata updates across all the Corporate Hyperion Systems with the other system admin’s.
• Summarize and distribute monthly metadata release report
• Assist in developing project plans for capturing and converting financial information
• Work closely with IT, DBA’s and System engineers for maximizing the performance of the environment.
• Create Mapping files for Entitiy,Accounts,ICP, Currencies and Custom dimensions in FDMEE
• Creating groups in shared services, maintain all security roles and systems access within HFM, FDMEE, Essbase.
• Worked on Inter Company Elimination project to feed the intercompany transactions in Essbase to sync with HFM.
• Developed Cash Flow Statements, Roll forwards, Overrides and CTA.
• Perform training and end-user education of the system functionality as needed.
• Troubleshoot end user issues and Providing technical and functional support to the users in the areas of HFM, FDMEE, HFR and Smartview.
• Worked on Essbase SAP Reconciliation for historical data.
• Responsible for Migrations from Development to QA and QA to Production.

Environment: Hyperion Financial Management 11.1.2.3, FDMEE 11.1.2.3, Hyperion Financial Reporting (HFR) 11.1.2.X, Hyperion Shared Services, Hyperion Essbase, Smart View, IBM Tivoli Workload Scheduler Window Server 2012 R2,MS SQL.

Senior Hyperion Developer

Confidential,Fort Worth, TX

• Implemented end to end solution of HFM used for consolidation purpose and to fulfil reporting needs.
• Improve the Accounting team's experience: Maintain & Automate DRM Versions, Hierarchies, Nodes, properties, and formulae.
• As part of analysis explored various ERP systems as part of analysis and worked on multicurrency as well.
• Lead requirement gathering, design and build activities for application updates, migration, refresh and optimization in DRM
• Support and Optimize DRM metadata integrations with target systems. Research and resolve metadata integration and update issues - using SQL.
• Support to HFM, FDM applications and Smart view reports
• Involving in Month, Quarter and Annual Preclose activities
• Trained users so they could review and validate data in HFM.
• Scheduling tasks for consolidation, Process Management starting, Data loading, Copying and extracting using the EPM Maestro.
• Providing task audit reports to business team for audit in daily using Audit extract utility
• Providing Data Audit reports and security reports such as Users, roles and groups list to business team for audit in monthly
• Managing Metadata, Making Changes like Adding and Removing Members as per Client Requirement.
• Designing New Data Forms, making modifications as per Client Requirement.
• Providing Technical or Functional Solutions and Resolving issues of users.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules
• Designed Business requirements documents based on the analysis of the current business model.
• Designed Technical design document as per the business requirements.
• Developed and deployed classic HFM applications used for consolidation purposes.
• Created and Loaded Metadata for HFM consolidation Actuals and Budget using EPMA to generate variance reports.
• Configured the source and target adapters in HFM from FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Worked on end to end development of automation of cash flow statement starting from gathering requirements to go live.
• Developed new business rules while working on various automation tasks in HFM also modified existing rules as per the business needs.
• Designed ETL required for HFM applications using FDQM/FDMEE (Financial Data Quality Management) to integrate flat file and relational data source to Hyperion financial management applications.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• Created and Modified HFM rules to perform various functions (No Input, Consolidation, Calculation, Currency Translation etc.)
• Integrated Oracle ERP Applications using FDM to integrate data related to financial applications.
• Created Member Lists, Data Grids, Data forms and Security file, Process flow using HFM.
• Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
• Entered Foreign Exchange Rates grids and their entries for Balance Sheet and Income Statement.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Created complex security of the Hyperion applications using Hyperion shared services and HFM security.
• Created reports based on the business user requirement using Hyperion Financial Reporting and Smart View.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of the HFM applications developed and enhanced existing documentation related to HFM applications.

Environment: Hyperion DRM11.1.X, Hyperion Financial Management 11.1.2.X, FDMEE 11.1.2.X, Hyperion Financial Reporting (HFR) 11.1.2.X, Hyperion Shared Services, Smart View, Window Server 2012 R2, Oracle 12.1.2.204

Confidential

• Interacting with users for the enhancements.
• HFM design and development of various components E.g. Member lists, Rules set for enhancements to the application.
• Shared Services administrator - creating security group-class access, provisioning groups and adding users to the groups for load testing for version upgrade. Also worked on User Authentication and Provisioning (Role-Based Authorization) HFM, Reporting and Analysis and Business Rules users.
• Application support activities and Documentation - Build documents for Security setup, Rules logic and Organization structure.
• Providing Support on issues related to HFM and Smart view.
• Preparing project related documents.
• DRM - Preparing automator scripts and running them on the versions for managing properties, Version control.
• Worked on Hyperion Shared Services to list user directories, users, groups, projects, and applications. Also worked on User Authentication and Provisioning (Role-Based Authorization) HFM, Reporting and Analysis and Business Rules users.
• Batch scheduling with Bursting for mailing FR reports to users.
• Managing and editing properties on DRM.
• Automated entire process of dimension building and data loading for all the Hyperion applications using various automation tools like Autosys.

Environment: Hyperion Financial Management 11.1.x,Hyperion DRM, Hyperion Planning 11.1.2, Hyperion Financial Reporting 9.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003, Oracle SQL Developer 2.1, Oracle 10.2