Project Data Warehouse

Résumé Asif Basha Shaik

Asif Basha Shaik

Email : ****.********@*****.***

Phone : +91 – 995-***-****

Experience Summary

More than 3 years of experience in Business Intelligence and Data Warehousing, & Weblogic/BI

Apps Administration.

5 months Experience in Manual Testing, Before Joining/Shifting Into BI Domain(Excluded from 3

years as I don’t have any record supporting it)

Proficient in Informatica, Data Warehouse Application Console (DAC) and Oracle Business

Intelligence (OBI EE) Administration

Primarily worked in publishing & Service domain.

Good knowledge of Oracle SQL, PL/SQL.

Knowledge of Dimensional Modeling and Data Warehousing concepts.

Excellent analytical and communication skills.

Working on Weblogic & Informatica Administration, with emphasis as Oracle BI Apps Admin.

Currently at client location @Saudi Arabia, for requirement gathering till March 1st.

Technology Experience

Software OBIEE 10g/11g, BI Publisher, Informatica, Data Warehouse Application

Console(DAC), Oracle10g/11g,Weblogic.

Operating System UNIX, WINDOWS.

Programming Languages PL/SQL, ASP.net, SQL, HTML, Shell Script, C, C++,ASP.Net, CORE JAVA,

JavaScript, XML.

Educational Summary

Course Specialization University/Institution Year

Master of Computer Computer Science Osmania University, Hyderabad, India 2009

Application

Bachelor of Science Mathematics Sri Krishna Devaraya University, 2006

Anantapur.

Résumé Asif Basha Shaik

Employment Summary

Employer From To

Infosys Technologies Limited 22th Feb, 2010 Till Date

Résumé Asif Basha Shaik

Employment Summary

Infosys Technologies Limited: 22nd Feb 2010 – Till Date

Project Saudi Railways Organization @ Saudi Arabia

Saudi Railways Organization, Dammam, Saudi Arabia.

Customer

28th Jan 2013 to Till Date

Period

Technology Analysts, BIP

Role

This project includes

Description

Knowledge Transfer from 3rd Party/Client relevant to BIP reports.

After KT taking over of Support activities from 3rd Party.

Enhancement/Upgrade of BI related tools.

Responsibilities Requirement Gathering/KT activities

After KT setting up a team and coordinate between Onsite and

Offshore

Oracle BI Publisher

Development

Tools

Oracle Database 11g

Special Software

Dammam, Saudi Arabia. (Client Location)

Project Location

Project Business Systems Infrastructure Management

Elsevier, A subsidiary of Reed Elsevier, Amsterdam

Customer

7th Nov 2011 to 25th Jan 2013

Period

BI Apps Admin.

Role

This project includes

Description

Designing Architecture for OBIEE 11g for different environment.

Installation and Configuration of OBIEE 11g in High Availability

Architecture with Unix as Operating system.

Implementing of Production Disaster Recovery Environment

Architecture.

Configuring Virtual OHS servers to work with Load balancers and Global

Traffic Managers for active DR OBIEE set up.

Installing Informatica 9.0.1 and configuring Domains for it.

Installing Oracle 11g database client and creating schemas (RCU’s) in the

database.

Résumé Asif Basha Shaik

Installing Data Administration Console Client and Server and Creating

Data warehouse tables in it.

Using Data Guard in Prod DR Architecture

Using Hardware Load balancer which provide High Availability of OBIEE

11g.

Responsibilities Installing Oracle 11g database, Informatica, DAC client and

server, OBIEE 11g.

Configuring Domains for Informatica and OBIEE.

Supporting the development team by migrating the code, both

Web catalog and RPD resolving the administration issues.

Acting as a, Developer and providing resolution to the issues

reported by business in Analytics area.

Designing the Informatica ETL jobs and DAC configuration.

Overall performing BI Admin Role

Informatica, Data warehouse Application Console (DAC), OBIEE Admin

Development

Tool, Catalog Manager

Tools

OBIEE 11g, Informatica 9.0.1, Data warehouse Application Console

Special Software

(DAC), Oracle Database 11g

Hyderabad, India

Project Location

Project Grant WareHouse (GWH)

Elsevier, A subsidiary of Reed Elsevier, Amsterdam

Customer

April 2011 to Oct 2011

Period

Informatica & OBIEE Developer

Role

This project consist of

Description

Requirement Analysis & Validation

OLAP Star Schema Design.

Design, development and testing of Grant Warehouse Reports which are

based on daily transaction.

Pre defined (automated) scheduling of reports

E mail delivery of these reports to the intended recipients

Design, development and testing of Informatica mappings for the different

customized entities.

Résumé Asif Basha Shaik

Responsibilities Involved in Requirement Analysis.

Prepared Technical Design Document and Requirement

Traceability Matrix.

Designed Star Schemas for OLAP.

Developed and Tested Informatica Mappings and OBIEE Reports

Involved in Setting up of Data Administration Console.

Created and Executed Test Scripts for all the reports.

Overall involved in End to End Reporting Life Cycle.

Informatica, Data warehouse Application Console (DAC), OBIEE Admin

Development

Tool, Catalog Manager

Tools

OBIEE 10g, Informatica 8.6.1, Data warehouse Application Console

Special Software

(DAC), Oracle Database 11g

Hyderabad, India

Project Location

Project Weatherford Supply Chain Management (SCM)BI Apps

Weather Ford, USA

Customer

7th June 2010 to 25th March 2011

Period

Informatica and OBIEE Developer

Role

The Weatherford SCM BI Apps is a maintenance project, wherein the data

Description

is to be migrated from JDE to data warehouse and later the OBIEE reports

are tested with the obtained data. In Informatica, we have created

mappings which extract the data from JDE and load it into the warehouse

and test the reports in Oracle Answers by checking whether the data is

populated as per the requirement.

Responsibilities Configured Informatica Mappings

Data Loading

Supported during testing and deployment phase

Prepared Test Plan/Scenario

Done System Integration Testing

Resolved Issues reported by business in Analytics area.

Designed the Informatica ETL jobs and DAC configuration.

Informatica, Data warehouse Application Console (DAC), OBIEE Admin

Development

Tool.

Tools

JDE, Informatica 8.6.1, Data warehouse Application Console (DAC)

Special Software

Résumé Asif Basha Shaik

Hyderabad, India

Project Location

Training Attended

Year Title Location Organized by

2012 Oracle DBA Online Infosys Limited

2011 BI Publisher Hyderabad Infosys Limited

Documents Published

Year Title Type Location

2012 OBIEE DR Invocation Steps Book Of Knowledge (BOK) Internal To Infosys

2012 Up gradation of OBIEE from 11.1.1.5 to 11.1.1.6 Book Of Knowledge (BOK) Internal To Infosys

2011 Creating New Users Creation In OBIEE 11g Internal Tutorial Internal To Infosys

2011 OBIEE 11g High Availability Installation Book Of Knowledge (BOK) Internal To Infosys

2011 Data warehousing Administration Console Setup Internal Tutorial Internal To Infosys

2010 Differences in Frequently Confused Terms of Testing Internal Tutorial Internal To Infosys

Contact this candidate