PROFESSIONAL SUMMARY:

• Having overall 12.4 years’ of experience in finance and technology and over 8 years of experience with Hyperion Financial Management (HFM), Hyperion Financial Data Quality Management (FDM/ERPi/FDMEE), Essbase, Planning, Financial Close Management (ARM), Hyperion Financial Reporting (HFR), Shared Services and Hyperion Smart View. Experience includes consolidation, financial reporting, data integration, intercompany accounting, budgeting & forecasting, and close process improvement.
• Hands on in Development, Upgrade, migration, Implementation, and Production Support projects of Hyperion suit of Products.
• Participate in system implementation projects (requirements documentation, systems configuration, test documentation/execution, issue identification and resolution).
• Good experience in ETL tools like FDM, FDMEE and ODI
• Experience in performing Migration of applications and its artifacts between different Environments using Lifecycle Management Utility (LCM) utility.
• Very good at Development of FDMEE Applications, Open Interface Adapters, Import Formats, Mapping Tables, Scripting, and areas related to integration with Source and Target Systems.
• Ability to interact effectively with users, business owners, upper management, vendors, and outside consultants during project scoping, requirements gathering, solutions design, build, User Testing, go - live, and production support.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Financial Reporting Studio and Smart-view as per the Client requirements.
• Plan, prioritize, and deliver systems enhancements.
• Having Knowledge on overall Architectural view of HFM, Configuration of Application Settings.
• Customization of all dimensions by using Manage Metadata Module as per requirement.
• Techno Functional proficiency in business modeling and application development.
• Good communication skills and genuine team lead with good organizational self-management skills.
• Excellent Analytical Communication skills and ability to learn new concepts.

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Consultant

Environment: Oracle EPM System 1.1.2.3, HFM and FDM.

Responsibilities:

• Organizing with Business meetings and users for gathering the new business requirement for development.
• HFM Application setup.
• Metadata creating/modifying as per the business request.
• Creating/Modifying Data Grids, Web entry forms, and Smart view templates.
• Creating Member list.
• Creating/modifying the business rules.
• Working on consolidation process.
• Working knowledge in Intercompany elimination, reconciliation and reporting approaches.
• Cash Reconciliations & Payroll Reconciliations also other Balance Sheet Reconciliations.
• Security Setup for new/existing applications.
• Data maintenance (restoring database from back up and Extract/Loading one application to another or one environment to another environment).
• Creating the Journal template
• Cratering Task list - Extended Analytics setup for loading the data from HFM to Essbase.
• FDM Application setup.
• Integrated FDM Applications with HFM Applications by creating Import formats and Locations and data load mappings at all dimension level between FDM and HFM Applications.
• Preparing the Functional and Technical design and user training documents.
• Security Setup for New entities and new news
• Supporting the month close.

Confidential

Hyperion Consultant

Environment: Oracle EPM System 1.1.2.4, HFM and FDMEE, Infra Support.

Responsibilities:

• Organizing with Business meetings and users for gathering the new business requirement for any development and enhancements of project.
• Creating and Developed the Essbase application as per the business requirement.
• Creating/modifying the business rules for data load.
• HFM Application setup.
• Metadata creating/modifying as per the business request.
• Maintain the Hyperion Servers (i.e., Monthly maintenance of Hyperion services and updating security patches for Hyperion Servers).
• Supporting for ad-hoc reports.
• Supporting the user issues.

Confidential

Hyperion Consultant

Environment: Oracle EPM System 1.1.2.4, Planning, Essbase, HFM and FDMEE.

Responsibilities:

• Organizing with Business meetings and users for gathering the new business requirement for any development and enhancements of project.
• HFM Application setup.
• Metadata creating/modifying as per the business request.
• Creating/Modifying Data Grids, Web entry forms, and Smart view templates.
• Creating Member list.
• Creating/modifying the business rules.
• Working on consolidation process.
• Working knowledge in Intercompany elimination, reconciliation and reporting approaches.
• Cash Reconciliations & Payroll Reconciliations also other Balance Sheet Reconciliations.
• Security Setup for new/existing applications.
• Data maintenance (restoring database from back up and Extract/Loading one application to another or one environment to another environment).
• Creating the Journal template
• Extended Analytics setup for loading the data from HFM to Essbase.
• FDMEE Application setup.
• Integrated FDM Applications with HFM Applications by creating Import formats and Locations and data load mappings at all dimension level between FDM and HFM Applications.
• Preparing the Functional and Technical design and user training documents.

Confidential

Hyperion Consultant

Environment: Oracle EPM System 11.1.2.2 &11.1.2.4, HFM, FDMEE, Planning, Essbase, HAL, DMP, ARC Plan, Allocation FP, ODI, EAS, DRM, Smart View, MS Windows Server 2008 R2 and Shared Services.

Responsibilities:

• Innovative business professional with expertise in analyzing business requirements and transforming them into technical solutions.
• Accurately assesses problems and quickly generates a resolution.
• Experienced in building business plans and Requirement gathering and design documentation.
• Techno Functional proficiency in business modeling and application development.
• Coordinated project teams through all phases of the development lifecycle.
• Extensively involved in development of all HFM Components includes Application Profile, Application, Metadata Building, Member Lists, Task Lists, Data Grids, Data Forms, HFM Rules.
• Responsible to manage the data grids and perform the activities such as calculation and consolidation
• Creation of Intercompany Reports
• Developing rules to bring prior year profits to current year profits.
• Created Excel Smart view templates for users to enter required information.
• Involved in Troubleshooting end business user issues related to Smart view, Excel Add-in, Data tie-off issues, cube to cube data transfer issues and consolidation issues.
• Migrating Application from one Environment to another Environment.
• Moving Artifacts from One Environment to other Environment by using Life Cycle Management.
• Applied security levels to users for applications objects and locations within FDM.
• Maintained users and security for FDM and HFM applications using shared services.
• Design data validation, and data loads of Historical Data to Production using FDM
• Creation of Periods and Locations, Import Formats, Created data load rules and data load mapping
• Developing basic rules for Validation of Accounts
• Analyzed business/user requirements to design and develop new Essbase and Planning applications.
• Involved in designing, developing, and modifying outlines in Essbase Application.
• Developed rules file for building dimensions using different build methods and data loading.
• Created and examined all the Standard and Attribute dimensions and members in the outline for the optimization.
• Retrieved data using Excel spread sheet add-in to analyze the data.
• For generating reports, used Substitution Variables, and created Report Scripts for analysis.
• Designed budgets and forecast templates using planning web, Business Rules, scripts.
• Documenting changes in new developments.
• Responsible for Weekly backups and participating in server maintenance activities and ensures that all required systems and functionalities are operating well.
• Working on the Incidents, Service Requests, Tasks, and Problem records raised by the users.
• Updating the senior management about the tickets status on daily basis.
• Maintains Hyperion applications in compliance with SOX requirements.
• Preparing the Monthly and Audit security matrix reports for SOX.
• Responsible for the creation and maintenance of Hyperion security using Native Directory and Customer Directory groups.
• Modifying an Existing User’s Security Profile as per the Business Role requirements.
• Creating and Provisioning New Security Groups in Shared Services as per new security requirements.
• Security Admin support for all Hyperion Application and Customization client tolls (HAL, DMP, ARC Plan and Allocation FP)
• Granted the access to business rules and data forms and access to secure dimensions in planning application and Data Relationship Management security.
• Used Filters to control the access of those users and groups to individual data within the database to provide security at the detailed level.

Confidential

Senior Hyperion Techno Functional Lead

Environment: Oracle EPM System 11.1.2.2, ARM, ERPi and SmartView.

Responsibilities:

• Created the setups in ERPi like data load mappings, data load rules, import formats and Locations etc.
• Configuration of system settings for account Reconciliations
• Set up the Due date Reminder Notification to remind Preparer and Reviewer to complete their job without any delays.
• Created Periods for Data load by defining Start, End and Close dates.
• Created Formats to reconcile the data using Account Analysis or Balance Compare method.
• Imported the Currency Rates or Enter the Rates for Periods to book the multi-currency transactions for unreconciled recons.
• Defined Custom Attributes as per the Client Requirement.
• Created Profiles.
• Teams are created to assign them to the Reconciliation.
• Posted Transactions to Adjustments to Source or Subsystem by manually, Importing and Copying Transactions from one Period to another Period.
• Created Filters to allow users to control what records they see in List View, dash board And Report Binder.
• Submitted Recons to next Level as a Preparer
• Approved / Rejected Recon as a Reviewer
• Entered Source System details in ERPi
• Defined Source Adapter details in ERPi.
• Defined Target Application details in ERPi
• Created Import Formats to load data in to ARM.
• Created Locations in ERPi
• Defined, Period Mapping and Category Mapping
• Created Data Load for Data load Rule and Data load mapping
• Created System settings and Applications Settings in ERPi
• Performed UAT and Soft Launch to get feedback from the business users and fine tune the process accordingly
• Used Shared Service console to assign user security access based on their role in the close process.
• Used LCM to move the FCM artifacts from one environment to another.
• Trained users on the dashboard, task submission, task approval and to run system reports. Trained the FCM administrator on FCM maintenance and operations.