Project Data

Brief introduction about experience

• *.* years of experience, working as a Software Engineer at L&T InfoTech Limited, Mumbai since Feb-2010

• Worked on various development, support and implementation of software applications in Hyperion Systems 9.x & Oracle EPM 11 versions 11.1.1.x and 11.1.2

• Excellent client interfacing, analytical thinking and communication skills.

• Hands-On experience of all major product of Hyperion suite.

• A team player with good analytical and communication skills.

BI Tools Hyperion Essbase9x/11x, Hyperion Planning9x/11x

Reporting Tools Hyperion Financial Reporting, Smart View, Essbase Spreadsheet Add-In, Lumen Soft SSO

Data Loading Tools ODI (ETL tool Oracle data integrator), Cube builder,SAS

Databases Hyperion Essbase, SQL Server 2005,MS Access, Oracle 10G

Operating Systems Windows family

Certified in Oracle Essbase 11 Essentials and earned the credential Oracle Essbase 11 Certified Implementation Specialist.

Project 1

Client Name Travelers USA Team Size 3

Start Date June 2012 End Date Till Date

Description Travelers is a leading Insurance company of US. The purpose of the project was

• To Support the Business Process Facility (BPF)of my Client

• To Support their existing Hyperion Essbase cubes.

• To Support their Existing SSO Models

• To carry out their monthly process.

• Data Loading using rule file.

• For Annual Process rollover of complete System to next year

• Testing was done on all the pre-existing applications and their objects like Outline, Calculation Script, Input Models.

Role & Contribution • Study of their complete BPF.

• For Monthly Process Rollover to Next Months.

• For Yearly Process rollover to Next year.

• Changes and modification of the Essbase Outline as per the requirement.

• Fixing Issues if any with the Essbase Input SSO models.

• Monitoring the complete Re-Calc process and providing the feed to Plan Users.

• Grouping and De-Grouping of Users and provisioning them.

• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.

• Automation of data loading, metadata extraction and building using Maxl.

• Provided hands-on training to the end users and prepared end-user manuals.

Tools & Technologies Hyperion Essbase11x,

Languages & Tools: SAS EG,Maxl, Essbase Excel Add-In,SSO

Database: Hyperion Essbase 11.1.1.3, SQL 2005

Project 2

Client Name DCP Midstream Team Size 1

Start Date Dec 2011 End Date May 2012

Description DCP Midstream is a leading Oil and Gas company of US. The purpose of the project was

• To Support their existing Hyperion Essbase cubes.

• To provide Application maintenance and support.

• Testing was done on all the pre-existing applications and their objects like Outline, Calculation Script, Data Forms, Dimensions and members.

Role & Contribution • Study of the AS-IS Hyperion Applications.

• Monitoring the Backup Process and fixing if any Issues Faced.

• Monitoring the Daily Data Loads process and fixing for any Issues faced.

• Changes and modification of the Essbase Outline.

• Optimize Business Rules for Consolidation and Allocations within existing applications.

• Grouping and De-Grouping of Users and provisioning them.

• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.

• Automation of data loading, metadata extraction and building using Maxl.

• Provided hands-on training to the end users and prepared end-user manuals.

Tools & Technologies Hyperion Essbase9x/11x,

Languages & Tools: Maxl, Essbase Excel Add-In

Database: Hyperion Essbase 11.1.1.3, SQL 2005

Project 3

Client Name DCP Midstream Team Size 6

Start Date June 2011 End Date Dec 2011

Description DCP Midstream is a leading Oil and Gas company of US. The purpose of the project was

• To upgrade their existing Hyperion Essbase cubes and Hyperion Planning applications from version 9.x to 11.1.3.

• To provide Application maintenance and support

• Testing was done on all the pre-existing applications and their objects like Outline, Calculation Script, Data Forms, Dimensions and members.

Role & Contribution • Study of the AS-IS Hyperion Applications.

• Requirement analysis of the issues and prepare scope of work.

• Identify the impact on the different reports (Financial Reports) and behavior of Essbase cubes.

• Changes and modification of the Essbase Outline.

• Optimization of the cube and calc scripts.

• Modifying users or change user roles in Essbase.

• Security Management - Modify roles and privileges by provisioning users and groups at Entity/Account/Custom/Scenario levels.

• Automation of data loading, metadata extraction and building using Maxl.

• Performed upgrading of Essbase cubes .

• Prepare Unit test plan document for validation of different objects like the financial reports, calculation scripts, and Rule files in previous and later versions to identify different errors.

• Provided hands-on training to the end users and prepared end-user manuals.

Tools &Technologies Hyperion Essbase9x/11x,Hyperion planning9x/11x

Languages & Tools: ESSCMD, Maxl, Essbase Excel Add-In, Smartview

Database: Hyperion Essbase 11.1.1.3, SQL 2005

Project 4

Client Name Amkor Team Size 4

Start Date Oct 2010 End Date June 2011

Description Client is a industry leader in tailoring application-specific package design, assembly and test solutions of various electronic products. It’s a strategic contract manufacturing resource for many of the world's leading semiconductor companies. Client was using Hyperion Planning and Hyperion Essbase suite to manage its financial planning, budgeting and reporting requirements. To enhance the planning & budgeting process, “Financial Planning & Analysis” application was implemented using Hyperion Planning 11.1.3 and integrate it with the existing suite of Hyperion applications.

Role & Contribution • Gather and understand the analysis and reporting requirements.

• Created VBA functions to load forecast data using smart View and Excel add-ins

• Created multiple VB scripts and macros to pull actual data and generate trend reports in Excel (using spreadsheet add-in)

• Created multiple VBA macro enabled workbooks in excel add-in to retrieve region data for users

• Provide Security to users through Shared Services.

• Developing Work-Flow management, task list, menus and smart lists.

Tools & Technologies Environment: Hyperion Planning 11.1.1.3

Languages & Tools: Excel Add-In, SmartView, VBA Macros, VB scripts

Database: Hyperion Essbase 11.1.1.3, SQL 2005

Project 5

Client Name Paramount Pictures Team Size 7

Start Date Mar 2010 End Date Sep 2010

Description Our Client is a global producer and distributor of filmed entertainment, with robust and multi-faceted divisions across all areas including digital, home entertainment, network and cable television distribution, studio operations, and consumer products and recreation. A unit of the leading global entertainment content company, Viacom, it’s a part of a family of prominent and respected brands including MTV Networks and BET Networks

Role & Contribution • Understand the requirements phase and existing Hyperion landscape of the client.

• Responsible for creating outlines, dynamic dimension building, making rule files, formatting data and data loading into the cubes from the sources.

• Developed Calculation Script for business processes.

• Involved in Hyperion Essbase cube design.

• Worked closely with customer to understand the reporting requirements.

• Impact analysis of the application due to introduction of new dimension.

• Testing calculation scripts.

• Changes and modification of the Essbase Outline.

• Optimization of the cube and calc scripts.

Tools & Technologies Hyperion Essbase 11.1.3, Hyperion planning 11.1.3

Languages & Tools: ESSCMD, Maxl, Essbase Excel Add-In

Database: Hyperion Essbase 11.1.1.3, SQL 2005

POC 1:

Client Name DCP Midstream Team Size 4

Field Of Study Cube Builder

Description DCP Midstream is a leading Oil and Gas company of US. The purpose of the POC was to try and Build Essbase Cubes using the Cube Builder Utility present in People Tools 8.51 .

Role & Contribution

• Understanding the process and steps involved in building Essbase cubes using Cube Builder.

• Installing Essbase client and applying prerequisites patches.

• Creating the Essbase connections

• Designing the metadata with the help of dimension tree and queries of people-tools.

• Creating dimensions for Essbase Cubes

• Creating Essbase Cube Outlines.

• Building the Essbase Cubes

• Working closely with the Database Team for building up the SQL queries in order to fetch the relevant data from the PeopleSoft Database.

Tools & Technologies Hyperion Essbase 11.1.1.3,

Oracle People Tools 8.51

Database: SQL 2005,Oracle 10G

POC 2:

Client Name Major Engineering and Construction Conglomerate Team Size 2

Field Of Study Introduction OF XBRL

Description Client is leading Engineering conglomerate in India. The Client has Hyperion Financial Management for preparing Independent Financial Statements [“IFS”] and Corporate Consolidated Financial Statements [“CFS”] as per Schedule VI of Indian Companies Act and consolidation of accounts of Subsidiary Companies, Joint Ventures and Associate Companies.

Role & Contribution

• Direct Interaction with the Client for Requirement Gathering Regarding Introduction of XBRL in their existing FR Reports.

• Implemented XBRL Application and gave the POC to the Client

• Study of the Existing Taxonomies

• Mapping of Account Codes from Client’s COA with the Taxonomies members.

• Generation Of Instance Document both in IGAAP and IFRS

• Worked closely with Client to understand the reporting requirements.

• Testing of Reports post XBRL Introduction.

Tools & Technologies Hyperion Finacial reporting Studio 11.1.1.3,

Hyperion Financial Management 11.1.3,XBRL

Database: SQL 2005

Education & Credentials Bachelor of Technology in Computer Science from BPUT, Orissa with 64% marks.

Professional Affiliations Quickly adapted to the Functional and Technical knowledge of the Hyperion Products.

Received Award and affiliations for the Hyperion Upgrade Project as the Best Managed Project of the Year.

Date of Birth 13-May-1985

Nationality Indian

Marital Status Un-Married

Name Passport # Date of Issue Expiry Date Place of Issue Visa Status

Mohammad Rasul Khan G6786221 13/05/2008 12/05/2018 Ranchi Hold H1b Visa

Email Id *******************@*****.***

Mobile 091********

Contact this candidate