Data Sales

Muhammad Habib

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

HYPERION CONSULTANT

SUMMARY

• 8 years of experience in IT and Extensive experience design and development

of Hyperion Financial Reporting, Hyperion Essbase & Planning Applications and

knowledge in FDQM,ODI.

• Excellent experience in design, analysis, development and implementation of various

applications in Client/Server environment using Hyperion Essbase 11x/9.X/7.X,

ESSCMD, Maxl, Essbase Spreadsheet add-in.

• Strong database development and business intelligence modeling

capabilities; Essbase calculation script experience.

• Strong Understanding of dense and sparse settings, performed dynamic calculations,

developed, reviewed, and optimized, loading data from various database to cubes.

• Meet with clients to understand business processes and to gather system requirements

with subsequent application design and implementation using best practice

implementation techniques

• Extensive Hands-On experience in design, Development and tuning Essbase database.

Also well versed in Essbase Architecture, Calculation Scripts, Business Rules, Aggregate

Storage Option (ASO), Block Storage Options (BSO), MDX Member calculations,

ESSCMD, MAXL for Batch scripting

• Proficient in software documentation, technical report writing, decisive with strong

leadership qualities, flexible in work schedules

• Strong communication, organizational and interpersonal competencies along with

detail-oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS

OLAP: Hyperion Essbase 9.3.1/11x, Hyperion Planning 9.x/11.x, Hyperion Financial

Management9.3/11.x, Hyperion SharedServices System 9 BI+, Hyperion

System 9 Smart View, Essbase S/V 11.1.2 and Hyperion Financial Reports

11.1.1.3 and 11.1.2.1

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

Books, MS Visio

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

Languages: SQL, PL/SQL

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.

Muhammad Habib

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

PROFESSIONAL EXPERIENCE

ORGANIZATION DESIGNATION DURATION

Tech Lead DWH Business

Intelligence / ORACLE

Wipro Technologies

Jan’13 – Aug’13

HYPERION ESSBASE /

PLANNING/REPORTING

CONSULTANT

Hyperion Financial

Capitol One, Richmond, VA Aug’10 – Jan’13

Reporting /ORACLE

HYPERION ESSBASE /

PLANNING

CONSULTANT

Kroger, Cincinnati, Ohio Hyperion Financial Sep’08 – Jul’10

Reporting /ORACLE

HYPERION PLANNING /

ODI CONSULTANT

Safi Groups Hyperion Financial Apr’07 – Aug’08

Reporting /HYPERION

ESSBASE

ADMINSTRATOR

SYSTEMS ENGINEER/

Dynamic Systems Integration Aug’06 – Mar’07

PROGRAMMER

SYSTEM Jan’05 – Dec’05

ADMINISTRATOR

Inform Chemicals

Muhammad Habib

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

Wipro Technologies, CA.

Environment:

Hyperion Planning and ESSBASE, ESSBASE studio, Oracle, Administration Services, Excel

Add-In, Web Analysis, FR reporting, Smart view, Windows 7

Responsibilities:

Supervised and developed staff of three senior accountants.

Timely preparation of the monthly worldwide consolidation of financial statements and periodic

internal reporting.

Developed new standard monthly review reports that resulted in a tighter operating cost control

and made it.

Led the implementation of the Performance Management System consisting of a new set of

planning, forecasting, and reporting tools allowing a more comprehensive and faster review of

the company's results, effectively

Capitol One, Richmond, Virginia.

Environment:

Hyperion Essbase 11.1.1.3, Essbase Administration Services, Excel Add-In, Web Analysis, Hyperion

Financial Reporting / Hyperion Essbase / Planning Consultant

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports

to design a Hyperion Essbase Cube for Sales Analysis.

• Involved in defining data mart to support Hyperion Essbase and created reports Financial reports and

web Analysis.

• Designed and developed numerous complex Essbase applications with excellent balance of dense and

sparse dimensions.

• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using

ASO option.Also, created BSO application to support Financial Budgeting and Forecasting Application.

• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas

(ASO).

• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel,

Developed Excel reports using the advanced member selection techniques.

• Created Planning Application, which includes web forms, business rules, smart list. Also provided

access to users based upon their role.

• Worked directly with forecasters and planners and helped them in analysis.

• Loaded actuals into Planning Application and consolidated actuals, forecast and budget numbers to

provide a complete financial view.

• Used best practices to optimize calculation time.

Muhammad Habib

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

Kroger - Cincinnati, Ohio

Environment:

Hyperion Essbase 9.3.1, Essbase Administration Services, Hyperion Financial Reporting, Excel

Add-In, Planning, Shared Services, Workspace, Windows server 2003.

Oracle Hyperion Planning / ODI Consultant

Responsibilities:

• Involved in gathering requirements and developing a project plan.

• Developed Batch files and Rules files to upload data from financial system's database

to Essbasecube.

• Created Rule files for multi-dimensional databases.

• Developed Data Loads Rule Files and Member Formulas.

• Optimized Data Loads and Calc Scripts.

• Designed and developed monthly, quarterly and yearly sales Cubes.

• Developed Calc Scripts to calculate various Metrics for the outline.

• Involved in weekly meetings, to discuss current project status.

• Supported Planning Application, which includes web forms, business rules, smart list. Also

provided access to users based upon their role.

• Worked directly with forecasters and planners and helped them in analysis.

• Loaded actuals into Planning Application and consolidated actuals, forecast and budget

numbers to provide a complete financial view.

• Used best practices to optimize calculation time.

Safi Groups – Richmond, VA

Environment:

Hyperion Financial Reporting,Hyperion Essbase 7.1.2, Essbase Administration

Services, Essbase Integration Services, Excel Add-In, Windows server 2003.

Hyperion Essbase Admen

Responsibilities:

Participated in Requirement analysis phase and gathered reports in several format.

• Created complete Essbase database which included Developing Outline & Data load rules,

calculation scripts, and Maxl Scripts for automated outline and data loading. Optimized Outline,

Data load rules and Calculation Scripts

• Developed a multi-dimensional database (MDDB) application using Essbase that stored and

maintained company's financial and marketing data and performed the loading and manipulation

of data into the database using Load Rules files.

• Automated the Essbase Cubes using Maxl and Batch Scripts.

• Optimization and performance tuning for Data Load/Calculations.

• Manipulated data columns to suit Dimension builds, Tested Data load rules, fixed errors from

Muhammad Habib

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

the error log files, resolved issues of data retrieve from Excel

• Maintained cubes and took regular backups.

• Supported Planning Application, which includes web forms, business rules, smart list. Also

provided access to users based upon their role.

• Worked directly with forecasters and planners and helped them in analysis.

• Loaded actuals into Planning Application and consolidated actuals, forecast and budget

numbers to provide a complete financial view.

• Used best practices to optimize calculation time.

• Provided technical guidance and support to end-users about by developing documentations

required.

Dynamic Systems Integration:

Environment:

Essbase 6.5, Essbase 7.1.2, Essbase Administration Services, Essbase Integration Services, Excel

Add-In, Windows server 2003.

Responsibilities:

• Developed Essbase cubes for sales and marketing group at CANON.

• Loaded data using SQL interface.

• Wrote calculation scripts member formulas to calculate Essbase database.

• Wrote Maxl to automate Essbase daily and weekly cube refresh.

• Supported Planning Application, which includes web forms, business rules, smart list. Also

provided access to users based upon their role.

• Worked directly with forecasters and planners and helped them in analysis.

• Loaded actuals into Planning Application and consolidated actuals, forecast and budget

numbers to provide a complete financial view.

• Used best practices to optimize calculation time.

EDUCATION

Master Of Business Administration (USA) Accomplished: June 2012

Bachelors of Business Administration (USA) Accomplished: June 2010

Oracle Certified Professional Accomplished: Feb

2011

Reference available upon request.

Contact this candidate