1. Best Practices
1.1. Performance Optimization
1.1.1. Primary Index change on DB: 66 hrs/M; 1575K CPU cycles/M; 3201 Million IO/ M
1.1.2. SQL tuning: 7 hrs/M; 431K CPU cycles/M; 205 Million IO/ M
1.1.3. Outage window shrinked from 1 hr to 5 mins
1.2. Automation
1.2.1. All batch process jobs
1.2.1.1. 160 hrs/ Month saved
1.2.2. Business Critical DataMart status report
1.2.3. BO reports: ~3 hrs daily
1.2.4. Reduced dependency of niche resource on weekend
1.3. Space
1.3.1. Compression (DB)
1.3.1.1. 1.5TB gain in total
1.3.2. Housekeeping
1.3.2.1. 3.5 TB gain in total
1.3.3. Decommission
1.3.3.1. 4785 unused BO reports
1.3.4. Proposal
1.3.4.1. 1.2 TB DB Space
1.3.4.2. Block Level Compression
2. Challenges
2.1. Test Env for Ab Initio not available
2.2. BO servers outdated/ Application Support Expired
2.3. Over utilized BOCS/ NIPNIS servers
3. Then & Now
3.1. THEN
3.1.1. Manual Overload
3.1.2. High Space Consumption
3.1.3. Poor Performance
3.2. NOW
3.2.1. Near Zero Manual Intervention
3.2.2. Controlled Space Consumption
3.2.3. Enhanced & Efficient Performance
4. Pune - KT & Reverse Shadow
5. Service Scope
5.1. Application Operations & Maintenance
5.2. Service Management
5.2.1. Incident Management
5.2.2. Problem Management
5.2.3. Change & Release Management
5.2.4. Service Request Fulfillment
5.3. Database Administration
5.4. Capacity Management
5.5. Environment Management
5.5.1. Config Management
5.5.2. License Management
5.5.3. EME Management
5.6. Access Management
6. Transition
6.1. Boot Camp
6.1.1. Finalized scope, timelines, project plan
6.2. Due Diligence
6.2.1. 4 Days rigorous discussion
6.2.2. Finalized Number of resources
6.2.3. Observed Major Challenges
6.2.4. 4 Days rigorous discussion
6.3. Recruitment (41)
6.3.1. Internal Transfers (22)
6.3.2. References (5)
6.4. Knowledge Management
6.4.1. Acquisition
6.4.1.1. Kolkata & Maastricht - KA & Shadow
6.4.2. Transfer
6.5. Go-Live
6.5.1. Phase 1: 21st Nov 16
6.5.2. Phase 2: 21st Dec 16