Functional Consultant
Techno
Total years of experience :7 years, 5 Months
Nov, 2012 to Till Date
• Techno-Functional Consultant
• Integration of Hyperion planning with HFM and EBS
• Following Hyperion Planning modules are under development phase
o Financial Planning
* Budgeted P&L, Budgeted Balancesheet and cashflow
* KPI
* Variance
o Project Planning
* Project costing based on the project properties
* Workforce allocation/deallocation
o Workforce Planning
* Existing employee and new employee planning
* Workforce cost
o Product Planning
* Curbing Productwise profitability and expenses
April' 2011 - Till Date
Fujitsu Consulting India Pvt. Ltd.,
Noida
As Competency Manager and Sr. IT Consultant,
• Implementing Hyperion Financial Management and Hyperion Planning Projects
• Handling Pre Sales, answering RFP's for clients, creating POC's
IFFCO (Sharjah) & Allanasons (Mumbai), Implementation of Oracle Hyperion Planning, Hyperion Financial Management, Essbase and FDQM, EPMA suite 11.1.2.1 and Integration with Oracle EBS, Demantra and Other Legacy Systems
May, 2011 to Oct 2012
• Techno-Functional Consultant
• Dynamic solution provided to the client who generates statutory reports for Schedule VI and IFRS both along with MIS reporting.
• Designed Hyperion Planning and HFM application using EPMA, which centralizes the deployment process for Hyperion application and ease in data integration between Hyperion applications
• Integration of Hyperion System with Oracle EBS, BAAN, Demantra and other legacy systems using Oracle Financial Data Quality Management and Oracle Data Integrator
• Reports developed using Oracle Hyperion Financial Reports and Dashboards designed using WAS for Management
• Automatic and Systematic approach to monthly consolidation and Budgeting process. Ease in generating Statutory reporting along with drill back functionality to EBS.
• Hyperion all Environment setup for IFFCO and ALLANA.
• Completed ALLANASONS and IFFCO HFM Project with successful Go-Live along-with client satisfaction
• Implemented Financial & Workforce Planning and Budgeting for IFFCO
Workforce planning highlights
o Headcount planning
o New position Planning
o Existing employee planning
o Existing and New employee cost planning
Financial planning model highlights
o Budgeted Workforce costing
o Budgeted P&L, Balancesheet and cashflow
o Rolling forecast
o Variance analysis includes what-if
Bharti Airtel Ltd, Gurgaon - (Bharti Airtel Digital Media Exchange)
December 2010 - April 2011
• Working as a Hyperion Project Lead / Techno-Functional Consultant
• Working as Project Manager to manage and accomplish the project
• Digital media exchange (DMX) is for Bharti's B2C and B2B clients. The project vision is to provide Digital Media based Content marketplace deployed on a managed public and private multi-tenant media cloud, supported by an end-to-end Digital Content Supply Chain (DCSC) . Simultaneously, Reducing time to produce and market the content and connecting content owner to the consumer
• Some of the products involved in the project;
o DMX portal - To provide services to customer by bringing all the different modules under one roof
o OutDu - For Digital Signage
o Cinedigm - For best theater experience, provides high-quality image and sound. Additionally, manages theatre and studios along with encrypted and secure delivery, playback, and reporting.
o Dallet - For media storage management for all the products
o Storenxt - For storing and managing the digital assets
o Aspera - For fastest delivery of contents and ads on any medium
• Role and Responsibilities: o Coordinating with Bharti, ISV's and IBM team
o Conducting demo's of each module for internal team, Bharti and Bharti's client
o Gathering Business requirement from Bharti and converting them for ISV's to deliver module
o Reporting project status dashboard and preparing documents
o Identifying bug's and reporting to Business and ISV's
o Unit testing of module and integration testing product
o Being highly critical project in its nature and scope, achieving client satisfaction and simultaneously managing ISV's
• Working on project to make it a big success
NBN Co, Australia
Implementation of Oracle Hyperion Planning and FDQM suite 11.1.2.0
July' 2010 - April' 2011
IBM India Pvt. Ltd.,
Gurgaon
As Senior Software Engineer,
• Client interaction and Handling end to end implementation of Hyperion Financial Management and Hyperion Planning and Other Technologies.
May' 2010 - July' 2010
Accenture Services Pvt. Ltd.,
Bangalore
As Senior Software Engineer,
• Handling Pre Sales, answering RFP's for clients, creating POC's
• Handling end to end implementation of Hyperion Financial Management projects and managing Hyperion team
May, 2010 to July, 2010
• Techno-Functional Consultant
• Implemented solution based on the Business requirement specification document
• Designing of Hyperion Planning Application and defining the Business Rules
• Developed reports using Oracle Hyperion Financial Reports
• Highlights / Business benefits of Project
o Ease in Trial Balance, Budget and Forecast data loading from Oracle and excel with automatic validation checks along with Drill back from Hyperion to excel for viewing the source data
o Simplified solution for catering Cost Centre planning and budgeting process, further being validated through workflow mechanism
o Deriving Variances between Budget & Actuals, Forecast and Budget, variances between different versions
• Some of the Business rules are as follows,
o Aggregate Actuals
o Aggregate selected Scenario and Version
o Aggregate Forecast Working version for selected Cost Centres
o Clear data for a selected Scenario and Version
o Copy Data (including between Scenarios and Versions)
o Allocate Cost of Sales and Indirect Expense Accounts for Actuals
o Allocate Cost of Sales and Indirect Expense Accounts for Forecast
o Calculation of KPI's
o Trend Analysis Reporting, Balancesheet, Profit & Loss, Cashflow, Cost-centre wise details, Product & Region wise details are few report categories which forms the part of final delivery
o Full Integration with Microsoft active directory
• Documented Application Design document, Test Cases & Scripts and Training Manuals
IBM Idea Cellular Limited, Mumbai
Implementation of Oracle Hyperion Financial Management and FDQM suite 9.3.1
March' 2007 to April' 2010
3i-Infotech Ltd.
Noida
As Executive,
• Handling end to end implementation of Hyperion Financial Ma
• Management projects across INDIA and EMEA region.
• Handling Pre Sales of Hyperion Products like Hyperion Planning, Hyperion Financial Management and Hyperion Financial Data Quality Management
• Creating POC based on the initial discussion with client and answering RFP's
January, 2010 to April, 2010
• Worked as a Techno-Functional Consultant
• Role and Responsibilities: o As the Project/Technical Lead I was interfacing with the client for business requirement gathering and reviewed technical specifications for customizing Hyperion Financial Management and FDQM
o Documented functionality for easy understanding and user training
o To articulate the same Business Requirements to the Technical Team for building the Application
o Solving Project related issues and handling escalations
o Advising and finalizing the best feasible solution to the client's requirements
o Designing of Hyperion Financial Management Application and defining the Business Rules
o Development of real time reports using Hyperion Tools
o Imparting Training to the Business users on the usage of the developed application
• Highlights / Business benefits of Project
o Ease in Trial Balance, Journal and Inter Company data loading from Oracle and excel with automatic validation checks along with Drill back from Hyperion to excel for viewing the source data
o Simplified solution for complex consolidation process for different method such as Holding, Subsidiaries and Associates
o Dynamic solution provided for ease in merger / de-merger of new and old entities
o IFRS Legal Compliance Reporting, Management Reporting and Segmental Reporting
o Automation of complex calculations of Statutory Reserve, Elimination of Minority Interest for holdings within group, Calculation of Minority Interest for outside group, Equity method, cash flow and KPI's
o Trend Analysis Reporting and Dashboards are few report categories which forms the part of final delivery
o Full Integration with Microsoft active directory
o MIS Reporting using HFM Essbase Extended Analytics.
Dar Al-Arkan Real Estate Company, Riyadh, Kingdom of Saudi Arabia
Implementation of Hyperion Financial Management and FDQM 11.1.1.2
June, 2009 to October, 2009
• Worked as a Techno-Functional Consultant
• Achievements: Appreciated by Client and Oracle Corporation, Riyadh
• Role and Responsibilities: o As the Project Lead/ Techno-Functional Consultant interfaced with the client for business requirement gathering and reviewed functional specifications for customizing Hyperion Financial Management 11.1.1.2.0
o Advising and finalizing the best feasible solution to the client's requirements
o Articulated the same Business Requirements to the Technical Team for building the Application
o Coordinated with team members for Specifications Design & Review, Application development and Maintenance, etc
o Designed Hyperion Financial Management Application with defining Business Rules
o Setting up Hyperion environment at client place
• Highlights / Business benefits of Project
o Ease in data loading from Oracle EBS with automatic validation checks along with Drill back from Hyperion to Oracle EBS for viewing the source data
o Simplified solution for consolidation of complex organization structure having cross shareholdings and multiple shareholdings
o Effective and Flexible solution for dynamic organization structure
o Complete records of consolidation process for all periods with all adjustments, eliminations etc
o SOCPA, IFRS Legal Compliance and Management Reporting
o Automation of complex calculations of Statutory Reserve, Elimination of Minority Interest for holdings within group, Calculation of Minority Interest for outside group, Equity method, cash flow and KPI's
o Ability to view and publish Financial Statements in multiple currencies
o Trend Analysis and Comparison through Dashboards
o Integration with Microsoft active directory
o Financial Reports which were developed in final format required for publishing
Alghanim Industries, KUWAIT
Implementation of Hyperion Financial Management and FDQM 9.3.1
February 2008 to October 2008
• AI is a Big name in diversified businesses covering Retail, automobile industries, with HQ situated in Kuwait and also covering different locations all over the world. The objective of the implementation was to have the Consolidated Financials of all its entities spread across globe from a single platform.
• Role and Responsibilities: o Assisted by the Senior Functional Consultant during the project to understand the business requirements
o Interfaced with the client and reviewed functional specifications for customizing Hyperion Financial Management (HFM) and Hyperion Financial Data Quality Management (FDQM) 9.3.1
o Articulated the same Business Requirements to the Technical Team for building the Application
o Advising and finalizing the best feasible solution to the client's requirements
o Coordinated with team members for Specifications Design & Review, Application development and Maintenance, etc
o Delivered admin and user training to Client Handling
o Preparation of Design Document, User & Admin Manual
o Designing of Hyperion Financial Management Application
o Setting up Hyperion environment at client place
Arcelor Mittal, Luxemburg
Data Migration from HFM to Cartesis
October, 2007 to January, 2008
• Client is a leading Steel manufacturing company situated at different locations all over the world. The objective was to migrate data from existing Citrix Environment into Hyperion Financial Management for past years and 3 quarters of current year. The project was delivered by 3i Infotech India
• Role and Responsibilities: o Understanding Data Migration requirements
o Technical lead for Data Migration from Citrix consolidation Application to Hyperion Financial Management Application 9.3.1
o Preparation of Design Document, User & Admin Manual
ANSAL API, New Delhi
Implementation of Hyperion Planning and Budgeting
April, 2007 to August, 2007
• Client is a leader in real estate business deals in construction, renting, construction of Malls and townships. The primary objective was to bring details of Planning & Budgeting of all projects at the reach of management on the fly, so that management can review & control the execution of projects being executed. The project was delivered by 3i Infotech India
• Role and Responsibilities: o Business requirement gathering
o Hyperion Planning 9.2 application design & development
o Dimensional hierarchy
o Calculation scripts
o Input / Output web forms
o Security access
o Excel based reports
o Web Analysis reports
o Technical training - application specific
o Technical support
Lafarge India (Pvt) Ltd
• Lafarge India is a Big Brand in Cement Manufacturing industries in Jamshedpur, INDIA situated at different locations all over the world. The objective of the implementation was to automate the process of different departments from Production, Manufacturing, Time Department, IT and Sales. The project was delivered by Visual Net Technologies
• Role and Responsibilities: o Business requirement gathering
o Design & development of Application
o Data Storage tables, DFD
o Writing Codes
o Building Reports In Crystal Reports
o Technical training - application specific
o Technical support
January' 2006 to February' 2007
VisualNet Technologies Pvt. Ltd.
Jamshedpur
As Trainee Technical Consultant
• Implementing projects based on the user requirements
• Documentation
PROJECTS UNDERTAKEN
EAI (Abu-Dhabi), Implementation of Oracle Hyperion Planning, HFM (Integration), Essbase and FDQM, EPMA suite 11.1.2.1 and Integration with Oracle EBS
• Master of Computer Applications, (2003 - 2006), Uttar Pradesh Technical University with aggregate 72.0%, Lucknow, India o Key Project Undertaken: (Textile Management System was designed to provide customer with the online solution, the application was made available online so that customers from different places could use the technology for their transactions, current information, reports, etc)
• Bachelors of Computer Applications, (2000 - 2003), Makhanlal Chaturvedi Rashtriya Patrikarita Vishwavidyalaya with aggregate 70.0 %, Bhopal, India o Key Project Undertaken: (Library Management System was designed to provide the library and the student with the online solution, where they can retrieve the information regarding books, availability of the books and the queue for the particular books. The system provides online different reports)