Oracle SQL PLsql, BI data warehouse ETL OWB, OBIEE

Poonam Dutta

abob0q@r.postjobfree.com

Phn: 974-***-**** / 713-***-****

PROFILE

Poonam has more than seven years of IT industry experience with exposure to

Telecom, BFSI (Banking & Financial Services) and Manufacturing domains.

She has acquired the Oracle Certified Associate (OCA, DBA and application

track), Oracle certified specialist and Oracle certified Professional

Certification (OCP, application track), from Oracle Corporation.

She wishes to grow into a technical architect with ability to lead a team

in software design and development.

PROFESSIONAL EXPERIENCE

. She was working as IT Analyst for TCS till Aug 2012 (for the last five

years).

. She has worked extensively in end to end BI data warehousing projects.

. Have excellent ETL working knowledge. Her Technological Forte is Oracle

warehouse builder (OWB - ETL tool similar to Informatica), Siebel

Analytics and OBIEE.

. She has completed a 6 sigma project in TCS which involved performance

tuning of SQL/PLSQL jobs.

. Prior to TCS, she has worked as a Senior Software Engineer with Satyam

Computer Services Ltd, Hyderabad for two years. She worked on Design,

Development, Support and Maintenance of Business Application Software.

. She has worked on C, SQL, Pl SQL, Pro*C languages. Well versed on

RDBMS (Oracle 10g and Oracle 9i),UNIX, OOPs and UML 2.0 concepts. She

has strong proficiency in developing tools and system applications

using C, SQL, PLSQL and Pro*C on Windows and UNIX Platforms.

. She had been a conscious user of Satyam's ISO 9001 quality procedures

and QMM++, while executing her projects. She has gained good domain

knowledge of Financial Services and Banking.

. She had received multiple outstanding performance awards from Satyam

as well as appreciations from Clients.

Projects:

Tata Consultancy Services Ltd (Oct 2011 - Aug 2012)

Project: Cummins WSB BI Pune Offshore Duration: (Oct 2011 -

Aug 2012)

Location: Pune, India

Customer: Cummins

Cummins Inc. currently has different regional Enterprise data

warehouses and Data in production. The Objective of this project is to

load the data that comes from the different source system to the data

marts.

The project involves bug fixing activity on the production chains and

also enhancement activities. The enhancement activity includes

creating design for the new features / enhancing existing system,

creating Informatica mappings, creating reports in OBIEE, PL/SQL

procedures, unit testing activities, setting the job chains using

AppWorx. This solution envelops the major business driving data

warehouse which helps users to analyze and take business decision for

future in respect to current/history analysis. It also equips them

with ability to create Adhoc Reports to see the Top most or bottom

most Sales, Customer, Business line, Product etc.This warehouse is

divided into 5 data marts which maintain Sales, Purchasing, Marketing,

Manufacturing etc. The KPIs or Facts used to show the concrete

information to business users in Reporting form.The data marts are

populating with miscellaneous Sources eg. Flat files, External tables,

Oracle Apps system - ODS. The current Rollouts for 5 plants/data marts

done with proper load strategy and error handling. The load was done

with historical and currently running with incremental load logic and

scheduled for few month-end activities too.The ETL task is running

through Pl/Sql & Oracle warehouse Builder and Reporting done by

Discoverer & OBIEE. Above both Oracle Form 10G also involved for DM

maintenance activities.Business users are trained with reporting tool

capability to design their own Adhoc reports on Discoverer or OBIEE.

As team lead, Poonam was responsible for:

. Leading team for all support related activities:

1. Understand user's new requirements & cascade to proper module

2. Analysis of existing system and data flow

3. Data loading and resolve the issues during the data load

4. Design the mappings & create Reports as per user requests

5. Handle the severe incidents/Issues

6. Provide support at Level 3 for Rolled out Data marts.

7. Performance tuning at database level for enhancing the project

delivery

8. Discoverer Administration.

9. Creation of user's Ad -Hoc reports in both discoverer and OBIEE.

10. Access related issues to users in LDAP groups in OBIEE.

11. Taking care of SOX compliant activities (Discoverer Application)

for the Cummins Component Business Unit as a SOX Review Lead..

. Also leading the enhancement team for all CR related activities:

1. Conduct effort estimations as well as design analysis for

various change requests for the project.

2. Preparation of design documents

3. Design and Development of ETLs and other development activities

4. Unit testing

5. SIT

6. Resolving UAT issues

7. Preparation of CCB Change Control Board Meeting

. Customer Communication and attending status calls

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: Oracle Warehouse Builder (OWB), OBIEE Administration Tool,OBIEE answers,SQL Plus, PL/Sql developer, Appworx, Remedy 7

Tata Consultancy Services Ltd (Dec 2010 - Sept 2011)

Project: FBU Productivity Analysis and Duration: (Dec 2010 -

Improvements Sept 2011)

Location: Pune, India

Customer: Cummins

Cummins Filtration Enterprise Data Warehouse (EDW) covers APAC, EMEA

and AMER regions in it. Data received from all the sources from these

regions is put into a central repository. This EDW is built up in the

incremental manner through addition of new sources and/or

functionality as and when necessary. GPS DataMart and WWSAS DataMart

are the major EDW components. Due to this the performance of the EDW

was directly proportional to the performance of these two.

GPS increased in size and functionality over the period of time.

Increase in the amount of data was causing lots of data load issues.

WWSAS has also increased in the size as a result of addition of new

entities over a period of time. Also WWSAS has region wise data loads

those takes place in a sequential manner. Both these have an impact on

data load efficiency and maintenance that goes into it.

In order to improve upon these aspects the initiative undertaken was

to do the RCA for each of the impacting aspect followed by the best

possible option.

As project lead, Poonam was responsible for:

. Project requirement analysis

. Planning and Preparation of Design Documents as per the

requirement document

. Doing the RCA of each component and derive the best possible

solution to improve the performance

. Preparation of Solution design documentation

. Code changes and implementation of the same

. Client Communication and sending the status reports

. Internal Quality Assurance Review for the documents and the

component mappings.

. Development for test plans.

. Unit Testing and Code Testing.

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: Oracle Warehouse Builder (OWB), OBIEE Administration Tool,OBIEE answers,SQL Plus, PL/Sql developer, Appworx

Tata Consultancy Services Ltd (Nov 2008 - Sept 2009)

Project: Personal Demographics Service Duration: (Nov 2008 -

Data Quality Sep 2009)

Location: Pune, India

Customer: British TeleCommunications

The major objective of PDS DQ - 8A and 8B was to generate Operational

and Data Quality Reports from PDS for

- National Back Office i.e. Demographic Admin, Traceline Team,

Birth Notifications Team (Data Quality Reports)

- Subject Access Group (All details)

- NSTS User Group (Service User Death Report)

- PCT Admin Users (Monitoring all GP/ Pharmacy nominations)

As module lead, Poonam was responsible for:

. Primary ownership for 8A Maintenance drops.

. Preparation and Review of the technical documentation

. Preparation and review of Database Deployment document

. Development and deployment of database build.

. Onsite - offshore coordination for 8A defects tracking

. Helping the team in analyzing and resolving the 8A logged Defects,

also involved in analysis and providing its resolution

. Preparation of estimates and Impact analysis for CCN and CDs

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: PL/SQL Developer, SQL Developer, TOAD, HP QC 9.2

Tata Consultancy Services Ltd (Oct 2008 - Nov 2008)

Project: Pilot implementation of Duration: (Oct 2008 -

manufacturing datamart Nov 2008)

Location: Pune, India

Customer: Cummins Turbo technologies

Cummins Turbo Technologies (CTT) provide turbocharger solutions for

medium and heavy-duty diesel engines from 50 - 1200 hp per

turbocharger. It's current range of Holset turbochargers has been

proven on some of the world's most demanding high power applications.

CTT products are found on automotive, off highway, power generation

and marine applications.

This is the first BI initiative taken by the CTT targeting the

Manufacturing function. Major outcome of this to build a Manufacturing

data mart with 21 dashboards generated using ETL and OBIEE Answers and

Dashboards.

The objective is to analyze the manufacturing plant processes and come

up a Business Intelligence System. The manufacturing data is arranged

in Dimension and fact tables using star schema design. Load frequency

is once per day. Audit functionality is designed to track the data

load that takes place during the run.

The KPIs to be built and reported are as follows

Incident Rate

Customer Defects PPM

RFT Assembly %

Scrap $/EU turbo produced

Scrap % of Cost of Sales

Customer Delivery %

Arrears to customers - quantity turbo

Arrears to customers - quantity loose pieces

Supplier Delivery %

EU Turbos (produced)/person/day

Managed expense $/EU turbo produced

Total Freight $/EU turbo produced

Inventory Dollars

Inventory Turns

Training %

Manufacturing Scrap $

Manufacturing Scrap $/EU turbo produced

Premium Freight $

Premium Freight $/EU turbo produced

Overtime $

Overtime $/EU turbo produced

Customer maintenance through forms is in pipeline. These forms will be

used to update/add customer information in datawarehouse.

As module lead, Poonam was responsible for:

. Requirement analysis and understanding the process flow from the

client and onsite team, Suggesting and implementing suitable designs

and getting them approved by the client.

. Preparation of Design Documents for BI ETL Mappings and Reporting

Requirements as per ITPM standards

. Integrating OBIEE with various data sources including flat file

sources

. Development of new ETL Mappings to pull in data from multiple sources

into warehouses using OWB

. Development of custom OBIEE RPD (repository)

. Creation of custom dashboard reports in OBIEE Presentation services.

. Performance tuning of the implemented system.

. Development of new ETL Mappings to meet the analytics requirements.

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: Oracle Warehouse Builder (OWB), OBIEE Administration Tool,OBIEE answers,SQL Plus, PL/Sql developer, Appworx

Tata Consultancy Services Ltd (Apr 2008 - Sep 2008)

Project: Cummins FSBU Product Cost BI Duration: (Apr 2008 -

Solution Sep 2008)

Location: Pune, India

Customer: Cummins, Fuel system business unit, USA

The Cummins Fuel Systems Business provides a strategic advantage to

its customers of engine business by providing market leading

technology in design, manufacturing, and support for its product line.

Cummins Fuel Systems provide world class technology to enable

customers to meet increasing emission requirements while maximizing on

fuel economy and performance. This Project has followed the guidelines

and template as of ITSPM project guidelines.

As module lead, Poonam was responsible for:

. Project requirement analysis

. Planning and Preparation of Design Documents as per the

requirement document

. Development of ETL mappings in OWB to load data from flat file

sources and database sources to the staging and finally to the

Enterprise data warehouse.

. Solution design documentation for various components of the

project.

. Internal Quality Assurance Review for the documents and the

component mappings developed by other team members.

. Development for test plans.

. Unit Testing and Code Testing.

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: Oracle Warehouse Builder (OWB), OBIEE, Oracle answers,

SQL Plus, PL/Sql developer, Appworx

O/S: Sun Solaris

Tata Consultancy Services Ltd (Nov 2006 - Mar 2008)

Project: British Telecom SWIFT Duration: (Nov 2006 -

Mar 2008

Location: Kolkata, India

Customer: British Telecom, Cardiff, UK

SWIFT is an integrated data warehouse for BT Retail, holding customer

details, inventory, billing and revenue data for all Customer and

Business Customers. The database underpins an Integrated Campaign

Management System. The key benefit of SWIFT is that it provides the

requisite system framework to develop propositions, manage customer

relationship and undertake rapid tactical marketing.

The project involved migration of the Enterprise Data Warehouse (EDW)

database which is currently used by Chordiant Marketing System to

Seibel's OLAP database which could then be used by the Siebel e-

Marketing. The data migration was mainly done via Oracle Warehouse

Builder (OWB).

As module lead, Poonam was responsible for:

. Requirements Analysis

. Design and Coding

. Testing and UAT support

Platform/Software:

Languages: SQL, PL/SQL, UNIX Shell Scripts

Database: ORACLE 10g

Tools: Oracle Warehouse Builder (OWB), Siebel Analytics, SQL

Plus, Toad O/S: Sun Solaris

Satyam Computer Services Ltd (May 2004 - Nov 2006)

Project: GLASS Minerva Project Duration: Aug 2006 to

Nov 2006

Location: Secundrabad, India

Customer: GEMB, Austria

GEMB collects the loan amount from customer in form of instalments

within a given period. The customer repays back the amount according

to a mutually agreed repayment schedule. This project aimed to

implement an instalment plan based on a percentage of the current

balance. This means the instalments are calculated each month and can

be variable.

. Involved in the Requirement Collection and Analysis of the project

. Involved in the preparation of Document of Understanding of the

project

. Involved in Coding

. Involve in Testing and UAT support for the first phase of the

project.

Platform/Software:

Languages: Pro*C 8.0.6.3, Pro*C 2.2.3, SQL, PL/SQL

Database: ORACLE 8i, Oracle 9i release 2 (9.2.0.6)

Tools: SQL plus, UNIX Shell, Toad, Edit Plus, Forms 4.5, Forms

6.1

O/S: Sun Solaris 2.6, Linux 3.

Project: GLASS Over Limit Collection Duration: Mar 2006 to

Project July 2006

Location: Secundrabad, India

Customer: GEMB, Austria

One of the major loan products of GEMB Austria is the Cards product.

The customer can withdraw money using the card based on credit limit.

If the customer withdraws more than the credit limit the card is

blocked. The extra amount which the customer has with drawn is called

the Overdraft amount. This over limit amount needs to be collected

back by the bank. The project aims at strengthening the over limit

collection process. In this project a mechanism is implemented to

intimate the customer about the over limit amount and making a manual

or automatic payment arrangement with the customer and also, further

follow-ups.

As team member, her responsibilities included

. Requirement Collection and Analysis of the project

. Preparation of Document of Understanding of the project

. Coding

. Testing and UAT support

Platform/Software:

Languages: Pro*C 8.0.6.3, Pro*C 2.2.3, SQL, PL/SQL

Database: ORACLE 8i, Oracle 9i release 2 (9.2.0.6)

Tools: SQL Plus, UNIX Shell, Toad, Edit Plus, Forms 4.5, Forms

6.1

O/S: Sun Solaris 2.6, Linux 3.

Project: GLASS Bulk Rate Project Duration: Apr 2005 -

Feb 2006

Location: Secundrabad, India

Customer: GEMB, Austria

GEMB Austria borrows money from financial markets at a cost (base

rate) and in turn lends it to its customer at a cost (base rate) plus

margin. Whenever there is an increase or decrease in the market-

lending rate, the bank passes this variation to the customers. As it

is not cost-effective for the bank to pass every small variation in

the lending rates, it is done on a periodic basis. Bulk Rate is the

process of changing the rate of interest and calculation of

installment for the loan agreements as per the change in the borrowing

rate and local government policy. This involves huge computations and

change in data. BRC activity is a complex functionality area in the

Project. This requires two SLAs to be met: On Time Delivery and First

time right.

Poonam performed the role of Module Lead. Her responsibilities

include:

. Coding using SQL and PL/SQL

. Monitor and Execute SQL, PL/SQL and Shell Scripts

. System Testing

. Report generation using SQL and MS excel

. Documentation

. Single point of contact from SATYAM for BRC related

activities/issues

. As it is an ongoing activity, handled and executed several BRC

processes independently, met the SLAs in all the executions and

received Client's special appreciation for the same

Platform/Software:

Languages: Pro*C 8.0.6.3, Pro*C 2.2.3, SQL, PL/SQL

Database: ORACLE 8i, Oracle 9i release 2 (9.2.0.6)

Tools: SQL plus, UNIX Shell, Toad, Edit Plus, Forms 4.5, Forms

6.1

O/S: Sun Solaris 2.6, Linux 3.

Project: GLASS Task Force Project - TF Duration: Dec 2004 - Mar

C1126 2005

Location: Secundrabad, India

Customer: GEMB, Austria

Pan Credit is a product which is used by GE-GECF for its GE Money

Bank, Austria to cater to its lending and leasing business needs. It

provides several facilities such as Higher Purchase, Leasing, Loaning

of various types of business products or assets such as cars,

building, and land.

As per GE Six Sigma process, to improve the quality of the product the

Task Force project was introduced. Under the Task Force, various

enhancements have taken place in the system to make the product better

and efficient.

Poonam worked on the following priority and complex task forces:

. TF C1126: Required a through understanding of the Banking

Operations and the arrears reassessment module which is one of the

complex modules of pan credit application.

Completed the task successfully, got appreciations from Satyam and

also the CIO of GE Money Bank.

. TF C960: Implementation of Reminder Cycle Minimum Arrears Parameter

. TF C747: Default interest-solution approach

Her responsibilities included

. Analysis, preparing of Estimates and Document of Understanding as

per requirements received from Client

. Low Level Design and Coding

. Unit Test case preparation and Unit Testing

Platform/Software:

Languages: Pro*C 8.0.6.3, Pro*C 2.2.3, SQL, PL/SQL

Database: ORACLE 8i, Oracle 9i release 2 (9.2.0.6)

Tools: SQL Plus, UNIX Shell, Toad, Edit Plus, Forms 4.5, Forms

6.1

O/S: Sun Solaris 2.6, Linux 3.0

SKILLS

Technology Experience

Software Languages: C, C++(With Data Structures),

SQL, PL/SQL, Pro*C, Assembly Languages

8085/86,Unix shell script

Database: Oracle 7.1/8i/9i,10g, MS Access

OS Platforms Windows 2K, Sun Solaris 2.6, Linux 3.0

UML with Rational Rose, TOAD, D2K, OWB,

Tools OBIEE/Siebel Analytics, Appworx, Pl/sql

developer

Domain Life Sciences and Health care,Telecom,

Experience Financial Services & International banking,

Manufacturing

CERTIFICATIONS

Oracle PL/SQL Developer Certified Associate (OCA)

Oracle Certified Professional (OCP)

Oracle Certified Associate (Oracle Database 10g Administrator)

Oracle Certified Specialist

EDUCATIONAL QUALIFICATIONS

Degree Institute Board / Year %age

University

B.E. NIST(Berhampur),Ind Biju Patnaik 2003 75

(Computer ia University(

Science) Rourkela),India

XII Deepika CBSE,India 1999 79

School(Rourkela),In

dia

X Deepika CBSE,India 1997 82

School(Rourkela),In

dia

PERSONAL DETAILS

Visa: L2 with Valid EAD

Nationality: Indian

Location: Irving, Texas

E Mail: abob0q@r.postjobfree.com

Contact this candidate