Summary of Skills

Around 4 Yrs of Extensive experience with Data Warehouse and BI methodologies (Kimball - Star, Inmon- Snowflake Schemas), and strong understanding of Relational, Multi Dimensional Database concepts and OLAP Cubes

Extensive experience in Testing data and finding/fixing issues.

Explain Plan, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links Excellent technical skills coupled with outstanding business sense.

Extensive experience in the development of PL/SQL packages using oracle 8i/9i

Profound Knowledge of SDLC and Software Testing Life Cycle. Extensive Knowledge in Manual Testing and Black Box Testing. Participated in Integration, Regression, Performance and System testing.

Self-motivated professional, can work solo or as part of a team in delivering quality and affordable solutions that are customer focused.

DW & BI Tools

OBIEE 10.1.3.x

ETL Tools

Informatica Power Center 8x/7x

Data & Modeling Tools

Visio

Toad 8.5.x/7.x

PL - SQL Developer 5.1.

Programming Languages

& Scripting

PL/SQL

SQL

UNIX Shell Scripting

Harvest, SSH Secure File Transfer Client

Database

Oracle 10G/9.x/8.x/7.x

MS Access

SQL server 2005/2000

Operating Systems

Windows 2000/NT 4.0/98/95/ME/XP

UNIX (Solaris 8)

Professional Experience

Confidential, ( ) - BI Consultant

Projects

Client#1: Confidential,America( )

Carlsbad, CA 92008

Confidential,is the world’s foremost authority on diamonds, colored stones, and pearls.

This Project was for the New Implementation Of the Finance Module of the Oracle BI apps. This Project includes the installation, configuration and execution of out of the box OBIEE Apps.Developed custom datawarehouse to support business helps in decision making process.

Some of the activities / responsibilities include:

• Perform ETL load on the development server.
• Configure DAC for relevant BIAPPS in scope subject area.
• Customization on ETL side to fill the gap for FINANCE Subject area.
• Connect to source PSFT 8.9 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system and customizations to map to the target warehouse.
• Validate Incremental load.
• Clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.
• Develop custom Reports based on client requirement.
• Build metadata in OBIEE which helps users developing reports for strategic decision making.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.2, DAC 10.1.3.4.1, Informatica Power Center 8.6.1, PSFT8.9, Windows 2008, Linux 64 bit, Oracle 11g

Client#2: Confidential, ( ) BIAPPS PROC&SPEND, Finance, Order Management Implementation

1540 Genessee St, Kansas City,

Missouri, MO 64102

Confidential,is a major steel company supplying flat steel products to the building, construction, manufacturing, automotive and packaging industries.

This Project was for the New Implementation Of the Proc&Spend,Order Management, Finance Module of the Oracle BI apps. This Project includes the installation, configuration and execution of out of the box OBIEE Apps.

We did customization on ETL side to get data for 15 reports on sales subject area.

Some of the activities / responsibilities include:

• Perform ETL load on the development server.
• Configure DAC for relevant BIAPPS in scope subject area.
• Customization on ETL side to fill the gap for SALES Subject area.
• Connect to source EBS11.5 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system and customizations to map to the target warehouse.
• Validate Incremental load.
• Clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.
• Develop custom Reports based on client requirement.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.1, DAC 10.1.3.4.1, Informatica Power Center 8.6.1, EBS11.5, Windows 2000, Linux 64 bit, Oracle 10g

Client#3: Confidential, ( )BIAPPS PROC&SPEND Implementation

45999 Center Oaks Plaza, Cube 21 Sterling, VA 2

Confidential,is a provider of clearinghouse and directory services to the global communications and Internet industries.

This Project was for the New Implementation Of the Proc&Spend Module of the Oracle BI apps. This Project includes the installation, configuration and execution of out of the box OBIEE Apps.

Some of the activities / responsibilities include:

• Perform ETL load on the development server.
• Configure DAC for relevant BIAPPS in scope subject area.
• Connect to source PSFT89 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system and customizations to map to the target warehouse.
• Validate Incremental load.
• Clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.2, DAC 10.1.3.4.1, Informatica Power Center 8.6.1, PSFT89, Windows 2000, Linux 64 bit, Oracle 10g

Client#4: Confidential, ( ) BIAPPS HR Implementation. 8 Cambridge Center Cambridge,MA 02142 Confidential, (NASDAQ: AKAM), is a company that provides a distributed computing platform for global Internet content and application delivery.

This Project was for the New Implementation Of the HR Module of the Oracle BI apps. This Project includes the installation, configuration and execution of out of the box OBIEE Apps.

Some of the activities / responsibilities include:

• Perform BIAPPS installation on the development server.
• Prepare BIAPPS configuration files for HR.
• Configure DAC for relevant BIAPPS in scope subject area.
• Connect to source EBS 11.5.10 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system or customizations in source system.
• Validate Incremental load.
• Clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.2, DAC 10.1.3.4.1, Informatica Power Center 8.6.1, EBS 11.5.10, Windows 2000, Linux 64 bit, Oracle 10g

Client#5: Confidential, ( ) BIAPPS Implementation. 4100 Normal Street San Diego, CA 92103

Confidential,132,000 students in pre-school through grade 12 and is the second largest district in California. The student population is extremely diverse, representing more than 15 ethnic groups and more than 60 languages and dialects.

This Project Was for the New Implementation Of the Finance, Proc & Spend, HR Module of the Oracle BI apps. This Projects includes the Modification of the current Oracle BI apps Repository and Dashboards by Customizing the Repository and Dashboards based on the Client Needs. IT includes enhancing the Repository with addition of new Dimensions and Metrics as well as the creation of new Reports Based on the Current Business Objects Reports and Dashboards that was being used prior to the OBIEE Implementation.

Some of the activities / responsibilities include:

• Perform BIAPPS installation on their development server.
• Prepare BIAPPS configuration files for HR and PROC&SPEND.
• Duties involve defining project scope, detailed planning, tracking, change control tracking, and change control & risk management.
• Configure DAC for relevant BIAPPS in scope subject area.
• Connect to source PeopleSoft and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system or customizations in source system.
• Validate Incremental load.
• Develop Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using OBIEE Analytics Server Admin and Web tool.
• During full load clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.1, DAC 10.1.3.4.1, Informatica Power Center 8.6.1,PeopleSoft8.9, Windows 2000 Server,SQL SERVER 2008.

Client#6: Confidential, ( ) 5353 West S Hwy 223 Adrian, MI 49221

Confidential, is the largest U.S. manufacturer of kitchen and bath cabinetry, offering approximately 300 styles in more than 20 lines from our U.S. companies. This segment includes assembled and ready-to-assemble kitchen and bath cabinets; home office workstations; entertainment centers; storage products; bookcases; and kitchen utility products.

This Project Was for the New Implementation Of the Finance Module of the Oracle BI apps. This project involves installation and configuration of BIAPPS as per customer need and perform full and incremental load.

Some of the activities / responsibilities include:

• Perform BIAPPS installation on their development server.
• Prepare BIAPPS configuration files for Finance.
• Configure DAC for relevant BIAPPS in scope subject area.
• Connect to source EBS R12 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system or customizations in source system.
• Validate Incremental load.
• During full load clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.1, DAC 10.1.3.4.1, Informatica Power Center 8.6.1,OracleR-12, Linux 64 bit edition, Toad

Client#7: Confidential, ( )

Confidential,of Massachusetts is committed to providing value, quality, and stability you can count on. SBLI has the largest amount of life insurance in force in the state of Massachusetts. They\'ve continually expanded product offerings in different parts of USA.SBLI has chosen KPI for implementing their finance module on BIAPPS.

Some of the activities / responsibilities include:

• Perform BIAPPS installation on the server.
• Prepare BIAPPS configuration files for Finance.
• Configuring DAC for relevant BIAPPS in scope
• Connect to source EBS 11.5.10 and perform full and incremental load.
• Validate any ETL errors due to data gaps in source system or customizations in source system.
• Validate Incremental load.
• During full load clean up of ETL issues and clean up of reports.
• Sanity check of reports after data load.

Environment:: OBIEE 10.1.3.4, OBI-APPS 7.9.6.1, DAC 10.1.3.4.1, Informatica Power Center 8.6.1,EBS 11.5.10, Solaris 64 bit edition, Toad

Confidential Data Warehouse Developer

Project #1: BOBI, Client: AT&T

Confidential,is one of the largest telecommunications companies in the world. They offer communications products and services ranging from high speed Internet access, wireless, advanced IP and networking solutions, home entertainment and local and long distance service. AT&T\'s research and development teams bring the newest technologies to its customers every day.

Roles & Responsibilities

• Having clear and concise understanding of functional requirements
• Involved in High level design, analysis and implementation.
• Interacting with client & understanding the reporting requirement
• Responsible for Coding and unit testing of mapping.
• Iteratively refines requirements based on feedback from business, development and test teams.
• Proposing Design and solutions for regular enhancements with team
• Debugging error and doing performance testing during UAT phase.
• Running Scripts through etl i during assembly testing.
• Environment: Informatica 8.1.1, Oracle 9i/10g

Project#2: EDW, Client: Confidential,

Generates electricity from diversified fuel sources, including natural gas, lignite/coal and nuclear. TXU Power owns and operates one of the nation’s largest lignite surface mining operations, producing about 23 millions tons of lignite a year. TXU also building power generation from renewable sources by investigating the use of methane gas created in landfills and biomass facilities to produce electricity.

The project is focused on implementing Enterprise Data Warehouse.

Roles & Responsibilities

• Having clear and concise understanding of functional requirements
• Involved in High level design, analysis and implementation.
• Interacting with client & understanding the reporting requirement
• Creating Oracle BI repository and dashboards
• Iteratively refines requirements based on feedback from business, development and test teams.
• Debugging error and doing performance testing during UAT phase.
• Writing & Running Scripts for testing.

• Environment: Informatica 7.1, Oracle 9i/10g, Oracle BI

Trainings undertaken

Oracle 9i: Undergone an intensive training in Oracle 9i PL/SQL programming as a part of project requirement at Capgemini.

Informatica 7.2: Undergone Informatica 7.2 training as a part of project requirement at Capgemini.

Business Objects: Undergone Business Objects Training at Capgemini.