SUMMARY:

• Oracle EPM Applications. He has an experience of 16+ Years in Oracle EPM (Hyperion) and has strong financial knowledge. He has extensive client facing experience and can easily converts business requirement into a working Hyperion model. He had played lead roles at multiple projects managing a team of 4 to 15 members.
• Requirement Gathering and implementation of consolidation application for big organizations according to US GAAP requirements in FCCS and HFM.
• Conducting workshops with business to finalize consolidation application requirements.
• Designing complex FCCS and HFM applications to implement Balance sheet, Income Statement and Cash flow statements.
• Writing/configuring Non - Controlling interest (Minority interest) calculations both in FCCS and HFM.
• Configuring Movement dimension mappings in FCCS to generate automatic Cash flow statements
• Implementation of Automatic Cash Flow statement (Direct and Indirect method) in HFM.
• Creation of reports for financial ratio from FCCS and HFM.
• Writing custom Equity Pickup calculations in FCCS.
• Configuring different consolidation methods in FCCS.
• Writing complex consolidation rules in HFM to support different consolidation types (Cost Method, Equity Method and Acquisition Method).
• Configuring complex custom Translation and Consolidation sub calculations in FCCS.
• Configuring ownership module in FCCS.
• Writing complex on-demand calculations in FCCS.
• Writing complex consolidation rules in HFM to support standard and custom elimination process.
• Writing complex calculation routines in HFM to support Opening Balance, retained earnings, Prior Year Retained Earning, Equity roll forward; Balancing Entry, CTA, Currency override and custom calculations.
• Writing complex translation routine to support specific translation requirements.
• Creating validation design in HFM to support a smooth close.
• Designing and implementation of review cycle and phase submission for P&L, BS and BS Flow.
• Optimization of HFM rules.
• Writing dynamic Input and No-Input subroutines.
• Writing complex On Demand rules according to custom requirements.
• Managing HFM metadata using EPMA, DRM and Classic.
• Managing FCCS metadata via Classic method.
• Creating Data grids and web forms in HFM.
• Creating, loading member lists to support optimum HFM design.
• Complex security provisioning in HFM and FCCS applications according to SOX requirement.
• Managing journals and Intercompany transactions.
• Sharing data using data synchronization and analyzing data using Smart view.
• Creation and managing FDMEE application to support incremental and full data load in HFM and FCCS using custom scripts.
• End-to-End implementations of FDMEE solutions for data movements from source systems to target applications.
• Creation and managing DRM applications.
• Creating Version/action scripts/ member properties in DRM.
• Creating Export Scripts in DRM for HFM and Hyperion Planning.
• Creating complex validations in DRM application as per business requirements.
• Implementing DRG in DRM application.
• User in FCCS, HFM, SmartView and Reports.
• Requirement Gathering, Designing and Implementing of complex Operation Expense planning application to support budgeting and forecasting requirements in On-Prem EPMA and Classic applications and in EPBCS.
• Designing and Implementing Complex workforce application.
• Designing and Implementing Complex Capex application to support Budget and forecast depreciation and amortization requirement.
• Designing and Implementation Plan types, Web Forms, Security, and Business Rules in Hyperion planning and EPBCS.
• Designing Task list, Workflow, Smart lists, Menus in Hyperion Planning.
• Designing and Implementation of Financial reports according to client requirements.
• Designing database, creating outlines, data loading through rule files.
• Expertise in writing complex calculation scripts.
• Optimization of database, calculation script, restructuring, data loading etc.
• Automating the data load and Dimension Building process using ESSCMD or MAXL.
• Automating the data load and Dimension Building process using ESSCMD, MAXL and EPM Automate.
• Backing Up and Restoring Data.
• Requirement Gathering, Designing and Implementing of complex Enterprise data management cloud solutions (EDMCS) to support metadata management across consolidation (FCCS), Planning (EPBCS) and Oracle Financial cloud application across organization.
• Configurating registration/integration between EDMCS, FCCS, EPBCS and GL (Oracle Financial Cloud).
• Configuring Node Type, Hierarchy Set, Node Sets and Views for FCCS, EPBCS and Oracle Financials in EDMCS application.
• Configuring standard and derived properties in EDMCS.
• Configuring custom validations in EDMCS.
• Configuring data governance in EDMCS across applications.
• Configuring user access in EDMCS.
• Configuring metadata exports from EDMCS to target applications (FCCS, EPBCS and Oracle Financials Cloud) with the help of EPM Automate.
• Creating full strategy and plan for migration from legacy system (Long View) to FCCS, EPBCS, EDMCS and ARCS.
• Finalizing requirements and design of FCCS, EPBCS, EDMCS and ARCS applications.
• Creating metadata, web forms and reports in FCCS and EPBCS.
• Configuring multi-currency application.
• Creating integration (Data Management) to pull data from Oracle ERP (Fusion Cloud) and Long View in to FCCS.
• Configuring EPBCS to fulfill client’s financial, workforce and capex planning requirements.
• Creating EPM Automate batches.
• Helping business in performing complex reconciliation between legacy system and FCCS, between FCCS and EPBCS.
• Configuring full end to end ARCS application to reconcile data between GL and Sub-GL.
• Creating profiles, reconciliation rules, security, data integration, workflow in ARCS.
• User and UAT support for FCCS, ARCS, EPBCS and EDMCS.

PROFESSIONAL EXPERIENCE:

C onfidential

Responsibilities:

• Creating full strategy and plan for migration from HFM to FCCS.
• Finalizing requirements and design of FCCS application.
• Creating metadata, web forms and reports.
• Writing Equity Pickup calculations.
• Writing NCI calculations.
• Creating integration (Data Management) to pull data from HFM (History) and EBS.
• Configuring Consolidation methods and ownership module.
• Creating EPM Automate batches.
• User and UAT support.

Confidential

Responsibilities:

• Requirement gathering and designing of enhancement projects.
• Writing business rules for enhancements.
• Building Cross validation logic in FDMEE.
• Creating HFR reports.
• Maintaining/adding metadata in DRM.
• Support and coordination of testing for enhancements.

Confidential

Responsibilities:

• Requirement gathering and application design of both HFM, FDMEE and DRM.
• Leading a team of 10 Hyperion developer.
• Implementation of HFM, FDMEE and DRM applications.
• Writing business rules in HFM.
• Building Automated Indirect Cash flow statement.
• Support and coordination of SIT and UAT.
• Client Management and status update.
• Requirement gathering and application design of both FCCS and FDMEE.
• Designing and maintaining of metadata in FCCS.
• Implementing ownership module in FCCS for partial consolidation.
• Designing and building FDMEE system
• Building HFR reports and smart view templates for Income statement, Balance sheet and Cash Flow reporting.
• Support and coordination of SIT and UAT.
• Client Management and status update.

Confidential

Responsibilities:

• Requirement gathering and application design of both HFM and planning.
• Analysis of cloud strategy for Hyperion products.
• Writing business rules in HFM and Planning.
• Migration of all Planning BR to EPBCS.
• Designing and building FDMEE system
• Building EPM Automate for automation
• Building HFR reports and smart view templates for Income statement and Balance sheet reporting.
• Support and coordination of SIT and UAT.
• Client Management and status update.

Confidential

Responsibilities:

• Requirement gathering and application design.
• Writing complex business rules as per requirements.
• Metadata management in EPMA
• Implementation of FDMEE to support data load from Open interface table.
• Support and coordination of SIT and UAT.
• Client Management and status update.
• Support and Enhancement of HFM system.

Confidential

Responsibilities:

• Responsible for business requirement and designing of solution.
• Writing complex Calculation scripts and business rule in Opex application.
• Creating Capex application to support budgeting and forecasting of Depreciation and Amortization.
• Designing of user interface (web form, Reports and smart view templates)
• Designing and Implementing planning and Essbase cubes
• Support and coordination of SIT and UAT.
• Client Management
• Mentoring team members from technical prospective
• Responsible for business requirement and designing of solution.
• Writing complex calculation and consolidation rule in HFM and managing metadata in Paragon (excel add in tool).
• Writing complex validations in HFM.
• Implementation of Phase submission to support client requirements.
• Managing SIT and UAT for business sign off
• Status Update and client management.

Confidential

Responsibilities:

• Responsible for gathering business requirement and designing the solution accordingly.
• Translate user requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including developing and testing that culminate in client acceptance of the results.
• Writing complex HFM rules and managing metadata in DRM.
• Responsible for writing complex validations in HFM.
• Creating web forms and task lists accordingly.
• Managing security in HFM.
• Managing ICT reports.
• Data load via FDM through Control-M.
• Running consolidation via auto consol (Customized tool developed using HFM APIs used to run parallel consolidation in HFM)
• Process management in HFM via auto consol.
• Package movement between different environments.
• Responsible for tuning of HFM application.
• Responsible for designing new applications according to the business requirement.
• Responsible for leading a project team in delivering solution to our users.
• Writing HFM rules, creating web forms, task list.
• Creating HFM security.
• Developing Hyperion planning to support budgeting and forecasting.
• Tuning of HFM and planning application.
• Movement of packages between different environments.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Confidential

Responsibilities:

• Responsible for leading a project team.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for all project audits to ensure high quality delivery of solutions to the customer.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Confidential

Responsibilities:

• Understanding existing System technically and functionally.
• Creating replica of existing system for two news LOB in Essbase and planning
• Amending new user requirements in new system.
• Implementation of security system.
• Production Support.
• Writing complex calculation scripts.
• Building data load rules
• Creating Metadata
• Writing SQL for data and metadata load rules.