SUMMARY:

• Oracle HFM/DRM/Reports/FDMEE/Hyperion Essbase /SQL Consultant with 8+ years of experience with emphasis onHyperionapplication Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment usingHyperionfinancial management,HyperionFinancial data quality management, HyperionFinancial data quality management Enterprise edition, HyperionEssbase, DRM (Data Relationship Management) OBIEE andHyperionFinancial 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 ofOracle 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 usingOracle EPM Suite,HyperionFinancial Management, FDQM/FDMEE, OracleHyperionEssbase, HyperionReports, Oracle data integrator, Essbase Spread Sheet Add - in.
• Strong experience in full implementation cycles ofHyperionFinancial 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.
• DevelopedHFMapplications 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 inHyperionFinancial management application, metadata preparation, security classes, Member lists, data grids, Web Data forms, journals posting, ICP Eliminations, reports and automation ofHFMtasks 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 inHFM
• 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 forHFM 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 ofHFMapplications 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 ofHFMapplication 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 forHyperionFinancial Management and FDM applications.
• Strong knowledge and Experience in Developing Business reports, Management with the help of HyperionReporting 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, NY

Responsibilities:

• 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 Entity, 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: HyperionFinancial Management 11.1.2.3,FDMEE 11.1.2.3,HyperionFinancial Reporting (HFR) 11.1.2.X,HyperionShared Services, Hyperion Essbase, Smart View, IBM Tivoli Workload Scheduler, Window Server 2012 R2,MS SQL.

Senior HyperionDeveloper

Confidential

Responsibilities:

• Implemented end to end solution ofHFMused 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 toHFM, FDM applications and Smart view reports
• Involving in Month, Quarter and Annual Preclose activities
• Trained users so they could review and validate data inHFM.
• 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 classicHFMapplications used for consolidation purposes.
• Created and Loaded Metadata forHFMconsolidation Actuals and Budget using EPMA to generate variance reports.
• Configured the source and target adapters inHFMfrom FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data inHFMApplication.
• 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 inHFMalso modified existing rules as per the business needs.
• Designed ETL required forHFMapplications using FDQM/FDMEE (Financial Data Quality Management) to integrate flat file and relational data source toHyperionfinancial management applications.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• Created and ModifiedHFMrules 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 usingHFM.
• 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 inHFM/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 theHyperionapplications usingHyperionshared services andHFM security.
• Created reports based on the business user requirement usingHyperionFinancial 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 theHFMapplications developed and enhanced existing documentation related toHFMapplications.

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

HFM /DRM/REPORTS/FDM

Confidential

Responsibilities:

• Improve the Accounting team's experience: Maintain & Automate DRM Versions, Hierarchies, Nodes, properties, and formulae.
• Implemented project in two phases one phase is initial implementation ofHFMapplication and second phase is the enhancements
• During phase1 worked on application implementation, development and production applications as part of this project.
• During phase 2 worked on enchantments of application enhancement such as optimization ofHFM applications and completed all the reporting needs.
• Worked on migration ofHFMapplications from 9.x to 11.x and involved in installation/configuration and migration process for old to new environments.
• Interacted with Business Users for gathering requirements and converted them to technical specs.
• Worked with Various ERP teams related to G/L, A/P and A/R teams to understand the availability of data for various client requirements.
• Created, configured and maintainedHFM and FDM Applications.
• Involved in design and development of Account, Entity, ICP and other dimensions inHFMand FDM.
• Designed standard and custom dimensions using EPMA utilities and used FDM for classic applications.
• Created complex and simple Member Lists for usage in data forms, journals and other data load activities.
• Integrated FDM Applications withHFMApplications by creating mappings between FDM andHFM applications for loading data and metadata.
• Created Import Groups, Import Scripts and Integration Scripts for importing data to the Locations in FDM.
• Created Validation Rules in FDM for ensuring data integrity between source and target systems.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM and HFM
• Performed various maintenance activities like updating metadata, loading data, creating member lists and enhancing application rules.
• Extensively used Smart View for all ad hoc and standard reporting needs.
• Created around 400 production style standard reports using financial reporting and created around 100 sample Adhoc reports for daily reporting needs.
• Applied security levels to users for Application Objects and Locations within FDM.
• Exported data out formHFMapplications and loaded the same to Essbase applications used for all standard reporting needs.
• Automated entire process of dimension building and data loading for all theHyperionapplications using various automation tools like tidal and Autosys.
• Performed detailed documentation of tasks, processes and optimization requirements based on run times during data load and application build, within the project.
• Perform complex security setup for all theHyperionapplications using Shared Services and application proprietary utilities.
• ODI is used as the ETL Tool for all the ETL related activities related to relational database and Hyperionapplications (Essbase and Planning)
• Created end user training guides and trained users on the applications developed

Environment:HyperionFinancial Management 11.1.1.2, Oracle DRM11.1.X,HyperionEssbase 11.1.2,Hyperion Planning 11x,HyperionWorkspace 9.3,Hyperion Financial Reporting 9.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003 and UNIX Servers, Oracle SQL Developer 2.1, Oracle 10.2

ANALYST HFM/DRM

Confidential

Responsibilities:

• 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 theHyperionapplications using various automation tools like Autosys.

Environment:HyperionFinancial Management 11.1.x,Hyperion DRM, HyperionPlanning 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