Manager Data

Abhishek Garg

Email: ***************@*****.***

Tel.: +919*********

Objective

Looking to secure a challenging and growth oriented opportunity for harnessing the Experience & knowledge of Oracle Hyperion Planning/ Essabse, FDMEE,HFM,HPCM,Oracle PBCS and support knowledge of application developer and prepare for a bigger role in future in Enterprise Performance Management.

Executive Summary

•Worked in Project in Oracle Hyperion Planning/Essbase & Public Budgeting Cloud Services tool as Techno Functional Consultant .

• Participate in systems analysis and design, includes identifying and documenting the planning process and functional specifications for building planning and budgeting (EPM 11.1.2.x) applications.

•Select the most relevant tools/techniques to meet specific client requirements

•Consult and advise client on building rules and making functional changes to applications in the planning processes.

• Experience in the financial consolidations and close processes, including eliminations.

•Manage acoounts in GAAP, IFRS accounting standards

•Experience in create application, manage ASO & BSO database properties, plan types,exporting and importing metadata and data loading in Oracle Hyperion planning/Essbase.

•Experience in creating Ad Hoc Grids, adding formula, entering and saving plan data in smart view,managing task list,calculation manager, migrating planning application, creating users and assigning roles,provide security in Oracle PBCS.

•Maintain report GAAP and STATUTORY monthly / quarterly financial results for all of Americas lines of business. This will include income statements, balance sheets and Earnings by Source (EBS) in a timely and accurate manner.

•Configuration of FDMEE in the system.

•Good Experience of FDMEE for data loading.

•Experience of DRM,FDMEE for metadata.

•Experience in c++,java profile

Experience

1. Company Name : Transsys Solution Pvt. Ltd. Duration : Nov/2016-Dec/2016

Role : Oracle Hyperion Planning Functional Associate Consultant

Responsibility:

•Participate in systems analysis and design, includes identifying and documenting the planning process and functional specifications for building planning and budgeting applications.

•Gathering the functional and non functional requirements for Hyperion Planning from internal corporate finance team.

•Experience in create application, manage ASO /BSO database properties, plan types,exporting and importing metadata and data loading in Oracle PBCS.

•Experience in creating Ad Hoc Grids, adding formula, entering and saving plan data in smart view,managing task list,calculation manager, migrating planning application, creating users and assigning roles,provide security in Oracle PBCS.

•Worked in profitability & cost management.

•Income statement, balance sheet, Cash flow planning for Budget scenario based on Budget cycle.

•Worked with Hyperion planning to build application used for planning and budgeting activities.

•Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Planning Calculation Scripts.

•Provide user provisioning and security for Hyperion Planning Applications.

•Created Task lists for Planning Users based role in organization.

•Create web forms within Hyperion planning for business users to load the budget data.

Project: KCB

Role :Hyperion Planning Functional Consultant & Oracle PBCS Consultant

2. Company Name : Monotech pvt. ltd.

Type-private

Duration :Dec2015-Oct 2016

Role :Asst. Account Manager

Responsibility :Prepares asset, liability, and capital account entries by compiling and analyzing account information.

Documents financial transactions by entering account information.

Recommends financial actions by analyzing accounting options.

Summarizes current financial status by collecting information; preparing balance sheet, profit and loss statement, and other reports.

Maintains accounting controls by preparing and recommending policies and procedures.

Guides accounting clerical staff by coordinating activities and answering questions.

Reconciles financial discrepancies by collecting and analyzing account information.

Secures financial information by completing data base backups

3.Company Name : N.S. Thermal Energy Pvt. Ltd. Duration : Jul/2012-Oct/2015

Role : Oracle Hyperion Planning Functional Associate Consultant

Responsibility:

•Interact with client and executive level business users within finance and accounting areas for understand functional & non functional requirement.

• Advise client on best practices in planning and building planning applications for business rules, loading data to set up planning scenarios.

•To implement improvements around planning, forecasting, reporting and consolidation processes to optimize efficiency to support corporate strategic development.

•Experience in the financial consolidations and close processes, including elimination.

•Worked in GAAP & IFRS accounting standards as basis on client

•Experience in create application, manage ASO & BSO database properties, plan types,exporting and importing metadata and data loading in Oracle Hyperion planning/Essbase

•Maintain Income statement, balance sheet, Cash flow planning for Budget scenario based on Budget cycle.

•Experience in creating Ad Hoc Grids, adding formula, entering and saving plan data in smart view,managing task list,calculation manager, migrating planning application, creating users and assigning roles,provide security in Oracle PBCS.

•Experience in Hyperion Profitability and Cost Management (HPCM) to find key factor dimensions in Organisation.

•Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Planning Calculation Scripts.

•Provide user provisioning and security for Hyperion Planning Applications.

•Created Task lists for Planning Users based role in organization.

•Imparted training to end users for Hyperion planning application which consists of smart view training, workflow, data forms, task lists, Reports.

•Enhanced various calc-scripts as well as business rules.

•Create web forms within Hyperion planning for business users to load the budget data.

•Designed and developed new reports using Hyperion financial reports as required.

•Create and provisioned the users with necessary roles on application using Hyperion shared services.

•loading data & metadata into hyperion applications via FDMEE.

•Configuration of FDMEE into the system.

Projects :

No. of projects :3

Project Description :Oracle Hyperion implementation with power company,banking company .

Role Description: Hyperion Planning Functional Consultant, Understand Client

functional and Non-Functional Requirements, Create Web forms, Dimensions, validation on web forms, Work Flows,FDMEE application creation, User provisioning, write Business rules and support in Essbase coding.

Skills Used: Hyperion Planning/ Essbase,Oracle HFM,,FDMEE Oracle PBCS, Hyperion Financial Reporting, .

Punj Lloyd

Duration: June- 2011- Aug 2011

Role: Summer Trainee, Finance.

•Understanding the current Indian Exim Policy

•The policy aim at developing export potential, improving export performance, boosting foreign trade and earning valuable foreign exchange by simplification of application procedure for availing various benefits to set in motion the strategies and policy measure which catalyse the growth of exports and to encourage exports through a mix of measures including fiscal incentive, institutional changes etc..

•Developing implications and various business-based scenario-building.

•Formulating recommendation the Corporate department of Punj Loyd about their policy

Education

MBA(Finance/IB) (61%) from MTU, Noida (2010-2012)

BCA(76%) from CCSU, Meerut(2006-2009)

HSC(science) (69%)from SBM, Hapur (2004-2005)

SSC (70%) from SBM, Hapur(2002-2003)

Acheivements

Rated as star performer within the 1st year of joining

Recieved the award for excellent client service

Interests/Strengths

•Possess self motivation, quick learner, finance subject matter expert.

•Willing to learn new tools in EPM(Enterprise Performance Management).

•Can shoulder additional responsibility if given.

•Smartworking, confident.

Personal

•Passport No:N1153305

•DOB: 04/09/1989

•Address:611,srinagar colony,Hapur,U.P.

Professional Reference

Mr. Pramod Kumar Mittal, Director (Finance), Punj loyd

Mr. Aditya Aggarwal,Vice President,Master Card Worldwide

Contact this candidate