Define - Six Sigma project

1
Improve UATIMNG database performance
Pierre Banroques (GE - sponsor)
Dushyant Mohanty (TCS - sponsor)
Nirav Shah (GB)
Nilesh Talele (BB)
V, Ms. Vijayalakshmi (MBB)
2
Project Selection
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
3
Identifying Project CTQs
Define Step A
Voice of the Customer
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



4
Alignment to Business Big Y
Define
Y
Productivity
Business Big
Database Performance
y2
y3
y1
Industry CTQ
Project CTQ characteristic
Delay (Application Speed)
yB
yC
yA
Execution time of query
y
Measurable
5
Threat Vs Opportunity Matrix
Define CAP
Threat (If we do not change)
Opportunity (If we do change)

• Optimized utilization of database
• Improvement in execution time for _ SQL queries
  Complex business _ reports

• Poor Query execution time for business _ reports
  
• Long wait time for business users

Short Term

• TCS looses credibility due to slow _ database
  response

• Performance improvement will
  
  _ lead to customer satisfaction
• Effective utilization of resource

Long Term
6
Stakeholder Analysis
Define 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
Charter
Define Step B
Business Case (Including High Level Benefit
Analysis)
In 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
Out of Scope
iManage Query tuning
Specific Goal Statement
To reduce average query execution time by 60 on
imanage database by 31-aug-2006.
Specific Problem Statement
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
Define Step B
Charter
Tollgate Review Dates
Resource Plan
General Information
Project Lead (GB/BB) Project Coach
(BB/MBB) Project Champion Team Members
Industry/Function
Shah, Mr. Nirav
Tollgate Date Signoff (xx/xx/xx)
Talele, Mr. Nilesh
Financial Services
Define Measure Analyze Improve Control
17/08/06
Big Y Performance
V, Ms. Vijayalakshmi
21/08/06
23/08/06
28/08/06
31/08/06
Contact Information for Project Lead
6694 0000 Ext 2598
9
COPIS
Define Step C

• GE Business users other stack holders

Start
Stop

• Reduced Query execution time

• Oracle Database
• Query

• Application team
• Business users

• User Reports /Queries execution

• Report Output

Improve UATIMNG database performance
User connected To database through application
User requests for the Report
User log on iManage application
User gets Output of report
Gather Table And Database Statistics
Is delay in Execution?
yes