Oracle Data

Muhammad Habib

Tel: 804-***-**** – ***********@*****.***

HYPERION CONSULTANT

SUMMARY

■ Over 07 years of professional experience in IT of which more than 5 years of expertise in the

area of Data Warehouse and OLAP software systems design and implementation.

■ Strong Technical and Functional experience in Application Architecture, design, analysis,

development and administration of various financial applications in Client/Server environment using

Oracle EPM 11, Hyperion Essbase, Hyperion Planning, Web Analysis/Hyperion Analyzer,

Esscmd, MaxL, MDX and Essbase SpreadSheet Add-In.

■ Demonstrated ability to work as part of a team to analyze complex business requirements and

translate them into business intelligence solutions.

■ Skilled in Architecture design and maintenance of numerous applications of Essbase Cubes

using Block storage (BSO) and Aggregate storage (ASO) Essbase Kernels.

■ Extensive experience in creating, maintaining, and supporting all application objects including

outlines, formulas, calculation scripts, rules files for dimension builds and data loads, caches, and

security profile through Analytical Administration Services (AAS) and MaxL scripts. Also involved

in automation of these procedures using Batch Scripts.

■ Skilled in Optimization and Performance tuning of Essbase application data/metadata

processing, upgrading, testing and migration of cubes in different environment.

■ Hands-on experience creating reports using Essbase Excel Add-In, Hyperion Analyzer, Web

Analysis, Hyperion Reports and Smart view.

■ Expertise in Creation and Maintenance of Hyperion Planning applications, Business Rules,

Web forms, Security Groups and Users etc.

TECHNICAL SKILLS

OLAP: Oracle EPM System 11, Hyperion Essbase 9.3.1/7.X/6.x, Hyperion Planning

3.0/3.3/3.5/4.x/9.x/11.x, Hyperion Financial Management9.3/11.x, Financial

Data Quality Management FDQM 9.3, Oracle Data Integrator(10.1.3.5),

Hyperion Shared Services System 9 BI+, Hyperion System 9 Smart View,

HAL 7.3/7.1, Essbase S/V 11.1.2 and Hyperion Financial Reports 11.1.1.3 and

11.1.2.

Office tools MS Office 2000/XP/2003/2007/2010 - Word, Excel, Power Point, Quick

Books, Peachtree Accounting, MS Visio

Operating Systems: Windows 95/98/2000/2003/NT/XP/7/2008

Languages: C, C++, JAVA, SQL

Web Technologies HTML, XML, Java Script, Servlets, JSP

Database Oracle 11g/10g / 9i / 8i / 7x, MS SQL Server 2000/2005/2008, MS Access,

SQL plus

Reporting Tools Hyperion Financial Reporting, Hyperion Analyzer/Web Analysis, Excel Add-

in, Smart View.

PROFESSIONAL EXPERIENCE

ORGANIZATION DESIGNATION DURATION

Capitol One, Richmond, VA ORACLE HYPERION Aug’10 – present

ESSBASE / PLANNING

CONSULTANT

Kroger, Cincinnati, Ohio ORACLE HYPERION Sep’08 – Jul’10

PLANNING / ODI

CONSULTANT

Safi Hardware Corp HYPERION ESSBASE / Apr’07 – Aug’08

PLANNING

ADMINSTRATOR

SYSTEMS ENGINEER/

Dynamic Systems Integration Aug’06 – Mar’07

PROGRAMMER

SYSTEM Jan05 – Dec’05

ADMINISTRATOR

Inform Chemicals

Capitol One, Richmond, Virginia.

Environment:

Oracle Hyperion System 11.1.2.1, Oracle Enterprise Performance Management System, Oracle

Hyperion Essbase, Hyperion Planning, FDQM, Financial Management, Financial Reporting,

SmartView, Essbase Excel Add-In, Esscmd, MaxL, Weblogic 9.1 and Oracle 10.2.

Oracle Hyperion Essbase / Planning Consultant

Responsibilities:

■ Upgrade Hyperion System 9.3.3 to 11.1.2.1 and configured all the environments

■ Migrate Essbase and Planning applications, Financial reports from Dev to Test, QA and Prod

environments

■ Design and Optimize BSO cubes for data loads, Calc Script and Query retrievals

■ Involved in configuring settings on Production server for optimal performance

■ Performed daily maintenance routine

Muhammad Habib

Tel: 804-***-**** – ***********@*****.***

■ Implemented Clustering on Weblogic server for Essbase, Plannning, FDM, HFM, Analytic

Provider Services and Financial Reports

■ Created Backup Scripts to backup data files and logs files, created and performed Daily,

Weekly and Monthly backup

■ Design, create and implement Web Forms

■ Developed Business rules and attached to the input forms to calculate data on save Option

■ Involved in database and security refreshes in Hyperion Planning

■ Developed Business rules and attached to the input forms to calculate data on save Option

■ Developed MaxL scripts and rules files to work with all database objects including outlines,

formulas, caches, and security profiles; also designed calculation scripts, and batch files to

automate data load and other maintenance procedures like outline modifications

■ Implement Single Sign On(SSO) using Oracle Access Manager(OAM)

■ Involved in database and security refreshes in Hyperion Planning

■ Provided troubleshooting services and assistance to end-users in resolving error, p repared

training material and well-designed documents covering both the functional and technical

aspects of the project

■ Involved in configuring of Product cost thru sales order and production

order using Variant Configuration for MTO, MTS scenario thru Object

dependencies in SAP

■ Involved in configuring Cost Component Structure, Costing Variants

and Complex Overhead Costing sheets in SAP

■ Prepared cutover plan and provided post go-live support

■ Installed and configured FDM ERP Source Adapter for SAP

■ Used FDM ERP Source Adapter for SAP to import data from SAP ECC 6.0 then to drill

through from FDM to SAP to view source data

■ Installation and configuration of Oracle Enterprise Performance Management Suite,

Hyperion Shared Services, Hyperion Essbase, Hyperion Planning, FDQM, Financial

Management and Financial Reports

Kroger - Cincinnati, Ohio

Environment:

Oracle EPM System 9.3.x, Oracle Hyperion Essbase, Hyperion Planning. Shared Services,

Oracle Data Integrator 10.1.3.5, Essbase Excel Add-In, MaxL and SQL Server 2005.

Oracle Hyperion Planning / ODI Consultant

Responsibilities:

Full life cycle development with Hyperion Planning, in creating applications, managing the

application security and system users

Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and

Packages and ran preload Business Rules using Oracle Data Integrator

Developed MaxL scripts and rules files to work with all database objects including outlines,

formulas, caches, and security profiles; also designed calculation scripts, and batch files to

automate data load and other maintenance procedures like outline modifications

Created Calculation scripts for allocations, eliminations and moving the data

Created the Planning Application and refreshed the metadata into the Essbase cubes

Analyzed the HAL routines to understand the current method of loading data into Essbase cubes

Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and

Packages and ran preload Business Rules using Oracle Data Integrator

Automated the execution of Packages for loading data into the Essbase cubes according to the

version, period and Fiscal Year

Participate in developing and implementing process improvements involving the corporate

financial reporting process

Created load rules, windows batch, EssCmd and MaxL scripts

Application development using Hyperion Planning for Performance and Capacity Planning and

creating Web Forms and Business Rules

Automated the execution of Packages for loading data into the Essbase cubes according to the

version, period and Fiscal Year

Safi Hardware Corp – Richmond, VA

Environment: Oracle EPM System 9.3, Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperin

Financial Management 9.3, Oracle Data Integrator 10.1.3, Shared Services, Essbase Excel Add-

In, ESSCMD, MaxL, Oracle 10g

Hyperion Essbase Planning Admin

Responsibilities:

Muhammad Habib

Tel: 804-***-**** – ***********@*****.***

■ Prepared Monthly scorecard reports in Hyperion Analyzer, which detail monthly Revenue,

expenses and Bad debt for consumer and business segments for Analysts to analyze and

forecast

■ Involved in the installation and deployment of Oracle EPM 11.1 systems in the patch

environment which included Shared Services, Essbase Hyperion Financial Management,

Hyperion Planning and Web analysis, Financial Reports Hyperion Workspace and

Oracle Data Integrator (ODI) and configured the installed products using EPM System

Configurator

■ Developed outlines, dim builds using various reference methods, data loads from flat files and

Oracle database

■ Designed ASO/BSO Cubes using Essbase Administrative Services Console.

■ Tuning, optimization of outline, block size, data and index cache settings and partition of the

Essbase DB

■ Used Essbase administration activities such as filter creation, creation of users and creation

of groups and maintenance of Essbase Servers

■ Developed MaxL scripts and rules files to work with all database objects including outlines,

formulas, caches, and security profiles; also designed calculation scripts, and batch files to

automate data load and other maintenance procedures like outline modifications

■ Developed many load rules for loading specific type of data files and for dimension build

■ Involved in retrieving the data into Essbase using load rules files

■ Optimized the database by configuring Sparse and Dense dimensions, restructured the

database by adding new members, Data storage & Consolidation properties

■ Used LOCK and SEND Techniques to load the Data in the cube and calculate the calc scripts

on the fly in MaxL

■ Integrated client data into Hyperion Cubes and was involved in development as well as

administration of Hyperion Planning application and Essbase application

■ Developed many calc scripts for allocations, eliminations, moving the data, calculating

formulae etc depending upon the business case

■ Extensively used ESSCMD to run calc scripts

■ Created budgets and forecasts for the management group

■ Involved in partitioning the Essbase server for optimization and tuning of the Essbase sever

■ Developed various financial reports on Excel Add-In using Essbase Query Designer for

analyzing the data at different levels

■ Involved in creating the ad-hoc and customized reports based on the user requirements using

Excel Add-In

■ Ensured compliance with accounting deadlines

EDUCATION

Master Of Business Administration Accomplished: April 2010

Bachelors of Business Administration Accomplished: June 2005

University of Lahore, Pakistan

Oracle Certified Professional Accomplished: Feb’

2011

Reference available upon request.

Contact this candidate