ADEEL MOHAMMED

SENIOR OBIEE DEVELOPER

E-mail: acg1cv@r.postjobfree.com Contact no: 009**-*********

SUMMARY

Over 8+ years of Complete Life Cycle or End-to-End (gathering Business Users Requirements,

System Analysis, Design & Data Modeling, Development, Testing) implementation experience of

using OBIEE.

Experienced for 6+ years in the dome of Business Intelligence (OBIEE), and in designing &

developing Business Intelligence solutions.

Installed OBIEE 11.1.1.5 on development and production server.

Upgraded the version from OBIEE 11.1.1.5 to OBIEE 11.1.1.6.

Created CSR (certificate service request) for SSL setup.

Implemented SSL with the user domain name.

Migrated Repository and web catalog from development environment to production environment.

Strong experience in providing end-to-end business intelligence solution by configuring

metadata and building OBIEE Repository consisting of three layers ( Physical L ayer, Business

Model & Presentation Layer).

Proficient in developing OBIEE/Siebel Analytics Time Series Objects, Interactive Dashboards

with Drill-down capabilities using global and local Filters, OBIEE setup (users/group,

access/query privileges), configuring OBIEE/Analytics Metadata objects (Subject Area, Table,

Column), Presentation Services/Web Catalog objects (Dashboards, Pages, Folders, Reports).

Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star

schema and Snowflake schema.

Developed many Reports / Dashboards with different analytics view (Drill-Down/Pivot Table,

Chart, Column Selector, Tabular with global and local Filters) using OBIEE).

Expertise in debugging and optimizing the OBIEE/ Dashboards / Reports.

Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate

navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to

Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling.

Creating, modifying Intelligence Dashboards for OBIEE, and using OBIEE Answers.

Administration of OBIEE and the OBIEE Web Catalog.

Performance tuning using Cache management techniques.

Having knowledge on BI Publisher.

Experience in RDBMS like Oracle 9 & 10g, My SQL and SQL Server and PL/SQL.

Experience in designing ETL process for Data warehousing using ETL tools Informatica power

center.

Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s

and reports generated from Informatica and OBI/Siebel Analytics.

Very strong analytical and presentation skills, problem-solving techniques, proven leadership

qualities with emphasis on individual and team effort backed by excellent communication skills.

Extensively worked on INFORMATICA tools: Designer, Workflow manager and

Workflow Monitor.

Developed different mappings/ mapplets using different transformations.

Worked on Data Extraction, Data Transformation and Data Loading.

Involved in Production Monitoring using Workflow Monitor.

Involved in Unit Testing.

Experience in Development, migration, up gradation and Support environments.

Interacted with the client to discuss the issues.

Technical Skills

BI TOOLS/OLAP : OBIEE 11.1.1.x, OBIEE 10.1.3.X, OBIA 7.9.6.3 (Financial Analytics)

ETL TOOLS : Informatica Power Center 8.x, Informatica 9.x, DAC

DATABASES : Oracle9i/10g, MS SQL Server 05/00, Oracle E-Business Suit

OPERATING SYSTEMS : Windows 98/2000/NT/XP/Vista, Windows server2003/2008,

Linux

APPLICATIONS : MS Word, MS Excel, PowerPoint

Educational Qualification

Bachelor of Technology (B. Tech) in computer science engineering from Jawaharlal Nehru

Technological University, Hyderabad, INDIA.

I have IELTS (general) score as 6.0 bands.

Certification

Oracle Business Intelligence foundation 10 Essentials

Employment Profile

Working as an Oracle BI Consultant with Country House for Information Technology-ADDAR

Group, Saudi Arabia since Apr 2013 to till date.

Worked as OBIEE Consultant With Avenir IT Pvt Ltd. India from Feb 2013 to Apr 2013.

Worked as a Senior Application Consultant with NCS Pte Ltd, Singapore from Oct 2011 to Nov

2012.

Worked as Oracle BI consultant with ABC Online SDN BHD Consulting, deployed to CTOS

SDN BHD, Kuala Lumpur from April 2011 to Sep 2011.

Worked as OBIEE Developer with WIPRO TECHNOLOGIES, India from April 2009 to March

2011.

Worked as ETL Developer with IBM Global Services India Pvt. Ltd. From Nov 2006 to Mar

2009.

I have been to SWEDEN (EUROPE) from Jan 2005 to Aug 2006 for pursuing master’s degree.

Worked as an Assistant Professor in Khader memorial Engineering College, India from Oct 2003

to Dec 2004.

Tawuniya Apr 2013 – till

date Oracle BI Consultant

The establishment of Tawuniya in 1986 was not considered a normal occurrence in the Saudi insurance

market; it was the steppingstone to create a viable insurance industry in Saudi Arabia. Since its early

beginnings, the Company took it upon itself to develop the Saudi insurance industry, setting standards for

optimal insurance services and introducing new products that satisfy client needs, especially in the retail

sector. Over the years, Tawuniya has invested heavily in the development of savvy professional Saudi

insurance employees, thus raising the level of professionalism in the Saudi insurance workforce.

Providing production support.

Oracle BI Application (OBIA) support.

Oracle Business intelligence Enterprise Edition (OBIEE) support.

Informatica power center support.

Datawarehouse Administration console (DAC) support.

OBIEE Administration and development.

Informatica Administration and development.

Oracle BI User creation & granting access .

Support to all Oracle BI users (Phone call and emails) .

Adding newly created GL accounts by Finance department into Oracle BI and running the ETL in

FULL Load mode and fixing the issues during FULL Load.

Monitoring the space in OS level and database level.

Every week Checking and removing the archive log.

Customization of out of the box reports and dashboards according to the client requirement.

Creating new reports and dashboards.

Fixing the issues in informatica, which is causing for task failure in DAC.

Requirement analysis, design and development in Informatica and OBIEE.

Helpdesk request solving.

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, OBIA 7.9.6.3, DAC 10.1.3.4.1, Oracle E-Business

Suit, Linux, TOAD.

Royal Bank of Scotland (RBS) Feb 2013

– Apr2013 OBIEE Consultant

The RBS group is a large international banking and financial services company. From its headquarters in

Edinburgh, the Group serves over 30 million customers in the United Kingdom, Europe, the Middle East,

the Americas and Asia.

Created Reports like LTV Band, Purpose.

Fixed some of the issues in Forbearance Dashboard.

Interacted with testing people for data issues in reports.

Environment: OBIEE 11.1.1.6/11.1.1.5, Linux, TOAD, PL/SQL.

Nanyang Technological University (NTU)

Oct 2011 – Nov 2012

Senior Application Consultant

The business goal of this data warehouse project is to build the data warehouse to cover Personal,

Administration, Academic, Finance and Campus life, with this data warehouse, the users would be able to

access the pre-defined reports, dashboard and at the same time, also have the capability to generate their

own reports. This system would be the single source of truth for users to get data with regards to the five

subject areas. The contents of the data warehouse must be understandable and intuitive to the business

users not merely the developer. The business users need to separate and combine the data in the

warehouse in endless combination like slicing and dicing themselves instead of relying on the developers.

Used Repository Creation Utility (RCU) to create database schemas like MDS and

BIPLATFORM on SQL Server 2008 database.

Installed OBIEE 11.1.1.5 on Development and Production server.

Increased the download limit by editing the instanceconfig.xml file.

Upgrade the version from OBIEE 11.1.1.5 to OBIEE 11.1.1.6.

Created Certificate Service Request (CSR) for SSL setup.

Implemented SSL on both development and production server by using NTU’s certificate.

Provided Training to end users.

Get the database connectivity and design the Physical Layer, Business model and Mapping layer

and the presentation layer in the repository (.rpd).

Creating reports and publishing them in the dashboards using answers.

Customized and developed repository, configured metadata objects (Subject area table column)

and web catalog Objects (Dashboards, Pages, Folders and Reports.)

Add users to the new group and apply the data level security and object level security at the rpd

and Web cat.

Created Academic Reports and Dashboards.

Created LTS for all the subject areas.

Created initialization blocks and set up the repository to get the description of the field from the

database.

Migrated Repository and web catalog from development environment to production Environment.

Used unconstrained filters, column filter prompts and various views such as Pivot tables.

Created Dimensional Hierarchy for Date, and for all other Dimensions, Level based Measures and

Aggregate navigation in BMM layer.

Created sub folders at presentation layer.

Environment: OBIEE 11.1.1.6/11.1.1.5, SQL Server 2008, Windows server 2008 R2, TOAD, PL/SQL.

Matrix Stream Apr 2011

– Sep 2011 Oracle BI Consultant

MS (matrix stream) is an e-media company. They are manufacturing dishes and broadcasting products.

They are selling their products through channel. That is DISTRIBUTORS and RETAILERS. But they are

facing problem to pay compensation between DISTRIBUTORS and RETAILERS. So they implemented

Data warehousing. That is “Project Retail Management Incentive Compensation Analysis”. From this

DWH we developed Report and Dashboards.

Developed reports like Rejected Receiver payment report, co-op add plan report.

Promotional Agreement Review report.

Customer Disconnect Notification report.

Compensation Dash board.

Incentive payment report.

Liberty Mutual

Feb 2010 – Mar2011 OBIEE Developer

Liberty Mutual Insurance is one of the leading insurance companies in US. The Liberty Mutual Insurance

Group of Companies was built to last, with a firm foundation of reliable businesses and a dedication to

continual improvement. This system was built with an objective to help top-level management in

decision-making. The data from different data marts is collected and integrated into a data warehouse.

Responsibilities:

Get the database connectivity and design the Physical Layer, Business model and Mapping layer

and the presentation layer in the repository (.rpd).

Creating reports and publishing them in the dashboards using answers.

Customized and developed repository, configured metadata objects (Subject area table column)

and web catalog Objects (Dashboards, Pages, Folders and Reports.)

Add users to the new group and apply the data level security and object level security at the rpd

and Web cat.

Configured Low Level Security to allow users to view data only according to this requirement.

Involved in the analysis of the existing system reports and modification of the reports, created

new reports based on the user requirements.

Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics

Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.

Performed OBIEE Administration –including creation of users and cache management.

Created hierarchies based on the territory level to territorial level sales and contact reports.

Used unconstrained filters, column filter prompts and various views such as Pivot tables.

Created Dimensional Hierarchy fro Date, Facility and Location Dimensions, Level based

Measures and Aggregate navigation in BMM layer.

Added new Dimensions and Columns to the Subject Areas to full fill the additional

Requirements of the Business Analysts. Mapped the configurations to accommodate for the

territorial hierarchy that were accommodated via chart drilldowns.

Merging Catalogs folders to master catalog using Catalog Manager.

Implemented dynamic dashboard prompts to zoom into particular segments of the business in a

performance-optimized manner.

Developed many Dimensions and Time Series Objects with Security settings for analyzing.

Configured charts, pivot table views, filters, and ticker in user interface.

Developed aggregate fact tables using the content tab.

Configured Repository and session variables to get dynamic reports and dashboards.

Environment: OBIEE 10.1.3.3/10.1.3.4 Oracle 10g/11g, SQL, Windows XP, Windows Services, UNIX,

TOAD, PL/SQL.

TELUS

April 2009-Jan 2010 OBIEE Developer

TELUS Mobility is a Canadian wireless telecommunications provider offering wireless voice, data and

internet services to Business as well as Consumer clients. TELUS Mobility is the Wireless Business Unit

of TELUS Corporation. TELUS Mobility efficiently develops a future friendly wireless solution that is

easy to sell, buy and use and that delivers clear value to its clients, channels, employees and shareholders

Responsibilities:

Working on the Administration tool to configure different layers of Oracle Business Intelligence

repository like Physical layer, Business Model & Mapping layer and Presentation layer

Defining physical joins and logical joins in Physical layer and Logical layer respectively

Implementing Dimensional hierarchies in Business Model & Mapping layer

Working on Aggregations and Fragmentations

Implementing Security, managing Variables and Cache Management

Working on Oracle BI Answers to create the reports as per the client requirement

Creating requests and viewing the results in different views like Tabular, Compound Layout,

Chart and Pivot Table

Developing different brand level Reports, Filters, and Prompts using Oracle BI Presentation

services

Creating various reports to fulfil the marketing needs and customizing the views

Environment: OBIEE 10.1.3.3/10.1.3.4 Oracle 10g/11g, SQL, Windows XP, TOAD, PL/SQL.

Sparrow Hospital

Jan 2008-Mar 2009

ETL Developer

This project for a Hospital Management system to Provide analysis report dealing with usage and

allocation of hospital resources. Designed system to help management to estimate the processes for

admission and discharge times and tracks delay in both the cases. This is helpful for doctors who are busy,

to find all the information about wards and about patients. This Project gone though the all stages, which

are Study, Design, Development, Training and Implementation. Extensively involved in Data Extraction

from Source to target systems using Power Center

Responsibilities:

Worked on extraction data from oracle Database.

Worked on multiple transformations like Source qualifier, Expression, Lookup, Stored procedure,

Update strategy, Filter transformations etc.

Stored procedure transformations are used as source preload and target post load.

Lookup transformations to compare the source and target values and Update strategy

transformations are used for Update or Delete the records

Created test cases, defect logs for mappings and workflows

Used Mapping designer and Mapplets to generate different mappings for different loads .

Implemented Slowly Changing Dimension mapping.

Involved in end to end testing with unit test cases.

Environment: Informatica power center 8.6 Oracle 9i/10g, SQL, Windows XP, TOAD, PL/SQL.

ABN AMRO Bank

Nov 2006-Dec 2007 ETL Developer

ABN AMRO Bank is preparing for the introduction of Basel II, A mandatory international initiative to

enhance capital adequacy in the banking industry. An essential component for Basel II Credit Risk is the

Risk-Weighted Assets (RWA) calculator. AAB have chosen the Fermat product to fulfill this calculator

requirement, adopting a de-centralized implementation approach for each Strategic Business Unit (SBU).

One of the main activities of this implementation is to design and build a Data Pre-Processing Layer that

will accept source file feeds for Reference, Credit, Credit Risk Mitigate (CRM) and Exposure data,

perform the necessary validations and transformations, and load the data into Fermat.

Responsibilities:

Review of DTL Detail design Technical Specification.

Development of mappings and its corresponding session.

Test Cases and other Quality related document .

Used Debugger to test the data flow and fix the mappings.

Created and monitored workflows and task using Informatica Power Center Workflow Manager.

Tuned the workflows and mappings.

Contact this candidate