Data Oracle

Dear

It was with great interest that I read your recent posting in the Website

for BI Consultant.

Results-oriented, Talented professional with over 3+ years of visible

achievements in customer-driven industry, Facilitated development of

Business Intelligence/Data Warehouse systems, provided BI expertise,

designed and developed Star Schemas by translating user requirements into

Analytic Solutions . I believe that my qualifications are an ideal match

for this position, and I am confident, I would make a valuable and

immediate contribution to your operations.

The following are highlights of my skills:

. Dedicated IT professional with 4 years of progressive

expertise in design, configuration, development,

testing and implementation of Data warehousing and Business Intelligence

Applications.

. Deep understanding of Information Technology Software Development Life

Cycle (SDLC) methodology and project management principles.

. Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL

Tools and DAC in Banking, Financial, Consumer Goods, and Investment

Banking and Sales & Marketing domains.

. Worked extensively in the analysis and development of Data warehousing

applications using Siebel Analytics 7.x/OBIEE 10.1.3.x.

. Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd)

- three layers (Physical Layer, Business Model & Presentation Layer)

. Experienced in Data Modelling using Dimensional Data Modelling, Star

Schema modelling, Fact and Dimensions tables

and Physical and Logical data modelling in the OBI Administration tool.

. Hands on experience in customizing reports, filters and charts in

Oracle Answers.

. Experienced in usage of Disconnected Analytics and Siebel/Oracle

Delivers for sending alerts via intelligence agents (iBots) to

the dashboards for the end users.

. Executed OBIEE administrative tasks such as OBIEE server

installation, migration and user maintenance.

. Proficient with BI Publisher reports and using various templates to

publish the reports as per user requirements.

. Experienced in writing, testing and implementations of stored

procedures and packages at database level using PL/SQL

. Knowledge in Extracting data from Siebel CRM, Oracle EBS, PeopleSoft,

OLTP that flat files and integration and loading data to OLAP

. Excellent interpersonal and communication skills for efficient client

interaction.

In addition, I offer outstanding organization skills, which haven proven to

be a critical asset in developing, maintaining, and supporting Data

Warehouse & BI solutions. These qualities, combined with my dedication and

tireless work ethic, should enable me to make a positive impact at your

company.

Thank you for your time and consideration.

Sincerely,

Sohaib Arif Qureshi

[pic] [pic]

[pic] [pic]

OBJECTIVE:

About 4 years of experience in Software Analysis, Design, Development and

Testing in Business Intelligence using OBIEE 7.x/8.x/8i/10/11. Have been

involved in major BI/Data warehousing projects as Siebel Analytics

Developer, Have an excellent understanding of Data Warehousing Concepts.

Possess considerable skills in the use of BI tools - OBIEE, Siebel

Analytics 7.7, Informatica Power Center v 4.x, 5.x, 6.x, 7.x and Oracle

RDBMS.

HIGHLIGHTS:

. Dedicated IT professional with 3+ years of progressive

expertise in design, configuration, development,

testing and implementation of Data warehousing and Business Intelligence

Applications.

. Deep understanding of Information Technology Software Development Life

Cycle (SDLC) methodology and project management principles.

. Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL

Tools and DAC in Banking, Financial, Consumer Goods, and Investment

Banking and Sales & Marketing domains.

. Worked extensively in the analysis and development of Data warehousing

applications using Siebel Analytics 7.x/OBIEE 10.1.3.x.

. Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd)

- three layers (Physical Layer, Business Model & Presentation Layer)

. Experienced in Data Modelling using Dimensional Data Modelling, Star

Schema modelling, Fact and Dimensions tables

and Physical and Logical data modelling in the OBI Administration tool.

. Hands on experience in customizing reports, filters and charts in

Oracle Answers.

. Experienced in usage of Disconnected Analytics and Siebel/Oracle

Delivers for sending alerts via intelligence agents (iBots) to

the dashboards for the end users.

. Comprehensive knowledge in Debugging, Optimizing and Performance

Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by

implementing Aggregate navigation, cache management and materialized

views.

. Executed OBIEE administrative tasks such as OBIEE server

installation, migration and user maintenance.

. Proficient with BI Publisher reports and using various templates to

publish the reports as per user requirements.

. Experienced in writing, testing and implementations of stored

procedures and packages at database level using PL/SQL

. Hands on experience on setting up LDAP for OBIEE.

. Proficiency in security management of all aspects of OBIEE (Siebel

Analytics).

. Knowledge in Extracting data from Siebel CRM, Oracle EBS, PeopleSoft,

OLTP that flat files and integration and loading data to OLAP

. Knowledge in Data warehousing development using ETL tools such

as Informatica Power Centre 8.x/7.x/ 6.x and developed Informatica

Mappings and Workflows with Worklets & Tasks using various

Transformations for ETL of data from Multiple Sources to Data Warehouse.

. Knowledge of Data warehouse Application Console (DAC) Architecture

. Excellent problem solving skills with strong technical background having

the ability to meet deadlines, work under pressure and quickly master

new technologies and skills.

. Excellent interpersonal and communication skills for efficient client

interaction.

BUSINESS INTELLIGENCE AND Data Warehouse SKILLS:

Oracle Business Intelligence Oracle BI Answers

(OBIEE)

Oracle BI Interactive Oracle BI Publisher

Dashboards

Oracle BI Administration Tool Oracle BI Delivers

ETL Informatica 8.x/7.x/6.x Siebel Analytics

Oracle Data Integrator CRM Application

Siebel 7.x

SSAS,SSIS,SSRS

Microstrategy

8.x,9.x

INFORMATION TECHNOLOGY SKILLS:

Ability to Apply Technical Solutions to OLAP (Online Analytical Processing)

Business Issues

Business Intelligence Client Need Analysis and Management

Data Analysis / Data Modeling / Data Microsoft Project

Architecture

Microsoft SQL Server 2005 / Oracle 10g/11g Business Impact Analysis

NET Framework C, C++, Core Java, J2EE

WORK EXPERIENCE:

Sr.BI Consultant - Inseyab Consulting

January 2012 - Present:

. Capable of handling Micro Strategy tool Suite (Intelligence Server,

Administrator, Architect, Agent, MDX Adapter/OLAP Provider, Web, and

Narrowcast Server).

. Can design Architecture like creating Schema objects with Micro

Strategy Desktop like simple and compound Facts and Attributes, Fact

extensions, Hierarchies, Transformations.

. Worked in creating and integrating Micro Strategy Reports and objects

(Attributes, Filters, Metrics, Facts, and Prompts) with the data

warehouse.

. Created Data Mart Reports using Complex Filters and Compound Metrics.

. Extensively worked on Micro Strategy Administration that includes

Intelligence Server Administration, configuration of Memory settings,

Performance Monitoring, Assigning Privileges and Job Monitoring etc.

. Configured Enterprise Manager, Object Manager.

. Good knowledge of Micro Strategy Web and Web Administration.

Senior OBIEE Consultant - AbbuSys PVT Ltd.

June 2009 - Present:

. Utilized OLAP (online analytical processing) to analyze clinical

performance data

. Solely responsible for architecting OBIEE solution to analyze data.

. Iterative development of dashboards, Answers requests, charts, pivot

table layouts, dashboard prompts

. Collaborated with end-users and stakeholders to bring form and clarity

to a multitude of data sources which enabled data to be displayed in a

meaningful analytic way

. Built calculated measures to analyze percentage changes of World

Container Port Rankings

. Used repository variables to dynamically modify conversion values for

logical column formulas

. Merged new RPD, dashboard and Answers requests with existing OBIEE

content

. Analysis and design of 100+ reports for OBIEE (Oracle Business

Intelligence Enterprise Edition) / Siebel Analytics

. Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard

Pages and Prompts, and Oracle Delivers iBots

. Analyzed end-user query performance when implementing and tuning OBIEE

. Migration of Repository, in DEV, TEST, UAT and PRODUCTION environments

Junior Siebel Analytics Developer - SalFar Ltd.

June 2008 - May 2009

. Merged new RPD, dashboard and Answers requests with existing OBIEE

content

. Analysis and design of 50+ reports for OBIEE (Oracle Business

Intelligence Enterprise Edition) / Siebel Analytics

. Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard

Pages and Prompts,

PROJECT HIGHLIGHTS:

. Christies(UK) - (On shore)(May 2012 - July 2012)

Worked as a part of transformation team and was involved in the design

phase of OBIEE upgrade from 10g to 11g and now involved in the

development phase of its upgrade.

. Asia Capital PLC(Srilanka) - OBIEE Solution

Worked as a OBIEE Lead in Asia Capital PLC (Brokerage House)

Srilanka and implemented OBIEE 11g on their current Back Office

System, it was a custom solution and has flavour of OBIEE 11g and add-

ons, built custom mappings and built Meta data repository from scratch

to meet the user requirements at the report level.

. Faisal Bank - BI Apps Financials

Worked as a Senior OBIEE Developer and successfully implemented BI

Apps Financials in their EBS system by having done some customization

in their Rpd and Dashboards through OBIEE.

. Christies (UK) - Re - Design Repository

Worked as a Senior OBIEE Developer, created the new stars and

Aggregated Fact through which we can do Effective Reporting against

different Sales, Campaigns, which are authorised in the Christies,

created reports and performed migration from one environment to other.

P&G (UK) - Marketing Campaign History

Worked as a Senior Siebel Developer, created the new measures for Marketing

Campaign through which find out the clients against campaign, created snowflake

schemas where needed and created reports and performed migration from one

environment to other.

Christies (UK) - Valuation

Worked as a Siebel Developer, the purpose of the project is that Christies want

to evaluate different items that have been brought, so for this we have created

different stars and some measures in repository further more created reports that

will display the needed through which Christies can evaluate different items.

BMW (Germany) - Showcase

Implemented BMW Showcase Project as a Consultant. The main idea for the project

is to make reporting Efficient in terms of user perspective without affecting any

of the existing reports, increasing the ETL performance, reduce number of facts

and define Levels where needed We have remove there Extended Facts and created a

new subject Area for the users for efficient reporting.

Christies (UK) - Client Comments

Worked with a Senior Consultant, the purpose of the Client Comments project is

designed to enable the Team Managers to consider the progress of their Team,

employees and life cycle of any Client Comments. The purpose of the Campaign

Management is to provide a detailed functional design of, the to-be marketing

process which will be used for targeting client audience directly within Siebel,

created the new stars for the Siebel Marketing & Analytics (OBI EE) 7.8, designed

and created the meta data repository, security aspects, reports and dashboards,

segmentation requirements, list formats, marketing campaigns.

EDUCATION / CERTIFICATION:

Iqra University

MBA (MIS) 2011- Present

Institute of Business & Technology

Bachelors of Science - Software Engineering

Aptech Global Computer Education

ACCP (Aptech Certified Computer Programmer)

OCS (Oracle Certified Specialist)

Oracle Business Intelligence Foundation 10 Certified

Implementation Specialist.

MCP (Designing a Business Intelligence Infrastructure Using Microsoft SQL

Server 2008)

MCTS (Microsoft Certified Technology Specialist)

.NET Framework 4.0 Web Apps.

ADDITIONAL INFORMATION:

Passport Number& Expiry Date: EF5195461/26th May 2015

Contact this candidate