�ݺ�ߣ

1.
TCS GE Confidential
Nirav Shah (GB)
Improve UATIMNG
database performance
Dushyant Mohanty (TCS - sponsor)
V, Ms. Vijayalakshmi (MBB)
Nilesh Talele (BB)
Pierre Banroques (GE - sponsor)

2.
TCS GE Confidential
1. Is there a customer impact? Y
2. Is data available or easily to generate? Y
3. Do you know the BIG BUSINESS Y? Y
4. Is the customer willing to provide resources? Y
5. Can the project be done in 2-4 months? Y
6. Is the project translatable to other Customers / Processes? Y
7. Is the project scope within control of the Project Team? Y
8. Is there a benefit to stakeholders? Y
9. Is there a readily available measurement system or process in place? Y
10. Is incremental improvement enough? Y
Project Selection

3.
TCS GE Confidential
Identifying Project CTQsDefine Step A
Customer Sample Comments (VOC) (CTQs)
Pierre
Banroques
(GE Technical
lead)
Queries running on the database are taking more than a
minute on imanage databases.
Execution time of
query
Voice of the CustomerVoice of the Customer

4.
TCS GE Confidential
Alignment to Business Big YDefine
Business Big
y2 y3y1
yB yCyA
Project CTQ:
characteristic
yMeasurable
Industry CTQ
Productivity
Delay (Application Speed)
Execution time of query
Database Performance

5.
TCS GE Confidential
Threat Vs Opportunity MatrixDefine CAP
Short
Term
Long
Term
Threat
(If we do not change)
Opportunity
(If we do change)
 Poor Query execution time for business
_ reports
Long wait time for business users
 TCS looses credibility due to
slow _ database response
 Performance improvement will
_ lead to customer
satisfaction
 Effective utilization of resource
Optimized utilization of database
Improvement in execution time for
_ SQL queries & Complex business
_ reports

6.
TCS GE Confidential
Stakeholder AnalysisDefine CAP
Stakeholder Strongly
Against
Moderately
against
Neutral Moderately
Supportive
Strongly
Supportive
GB (project
team member)
√
PL (Application
Support)
√ X
Pierre
Banroques( GE
Technical lead )
√ X
Business
Stakeholders
√ X
Legend
√: Current State
X: Desired State
Influence Strategy
No Influence strategy followed as all the stakeholders are supportive.

7.
TCS GE Confidential
CharterDefine Step B
Business Case (Including High Level Benefit Analysis) In Scope
Specific Problem Statement
Specific Goal Statement
Out of Scope
iManage is data warehouse application. The application
consists of complex reports access by 30 users
simultaneously. Reports are generating from 'uatimng'
database. Currently database size is 200Gb and
expected to grow to 30% a year.
Generation on complex reports on growing data, user
has to wait more than a minute. On growing business,
database and application requires to capable to
generate report within a minute. By doing this, it will
improve the performance of application & saves users
effort time.
60% reduction of query execution time will enable to
comply the standards to achieve less than a minute.
iManage Databases
iManage Query tuning
To reduce average query execution time by 60%
on imanage database by 31-aug-2006.
Currently iManage application consists of complex reports access by 30 users simultaneously
on UAT database and production database. Generation on complex reports on growing data,
user has to wait more than a minute. Database and application requires to capable to generate
report within a minute.

8.
TCS GE Confidential
Big Y:
Performance
Financial ServicesFinancial Services
Tollgate Review Dates
Project Lead (GB/BB):
Project Coach
(BB/MBB):
Project Champion:
Team Members:
Resource Plan General Information
Tollgate Date Signoff
(xx/xx/xx)
Contact Information for Project Lead:
Define
Measure
Analyze
Improve
Control
Industry/Function:Shah, Mr. NiravShah, Mr. Nirav
Talele, Mr. NileshTalele, Mr. Nilesh
V, Ms. VijayalakshmiV, Ms. Vijayalakshmi
6694 0000 Ext: 25986694 0000 Ext: 2598
17/08/0617/08/06
21/08/0621/08/06
23/08/0623/08/06
28/08/0628/08/06
31/08/0631/08/06
CharterDefine Step B

9.
TCS GE Confidential
Supplier
SSII
Input
(Use nouns)
PP
Process
(Use verbs)
OO
Output
(Use nouns)
CC
Customer
Start Stop
 GE Business
users & other
stack holders
Reduced Query
execution time
Improve UATIMNG database performanceImprove UATIMNG database performance
Oracle
Database
Query
COPISDefine Step C
User Reports
/Queries
execution
Report
Output
User connected
To database through
application
User requests
for the Report
User log on
iManage application
User gets
Output of report
Is delay in
Execution?
Gather Table
And Database
Statistics
yes
Application
team
Business
users

�ݺ�ߣ

Database performance Improvement, a Six Sigma project (Define) by Nirav Shah

Recommended

More Related Content

Similar to Database performance Improvement, a Six Sigma project (Define) by Nirav Shah (20)

Recently uploaded (20)

Database performance Improvement, a Six Sigma project (Define) by Nirav Shah