SAP BW Consultant

Project: Nestle Change Management Team
Company: Tech Mahindra (Previously Satyam Computer Services Ltd)
Client: Nestle Globe
Role: Team Member
Team Size: 12
Environment: SAP BW 3.5, SAP BI 7.0
Duration: Apr'09 - Aug'10
Description: Incident management team works on Incidents raised by production and preproduction
monitoring team during failure of daily loads, Requests raised by Onsite team to perform Adhoc
activities, Preparation of Quality check list for the weekend activities, Follows the SLA and
reaching the average KPI of 95% in IM and RM resolution.
Role:
* Involved in analysis and resolution of tickets.
* Performed re-initialization of business area in case of inconsistency in data targets.
* Carried out pre-manual and post manual actions for transports.
* Created and modified process chains.
* Monitored incidents like invalid characters, Time limit exceeded, Key value exist, SID Error, etc.
* Worked on performance aspects like deactivation & initial filling of aggregates, data package size adjustments, etc.
* Edited data in PSA as required and Reconstruct the data requests from PSA in case of data load failure.
* Attended market calls regarding the issues in the Data loads whenever required.

Project: Nestle Globe Production Monitoring Team
Company: Mahindra Satyam
Client: Nestle Globe
Role: Team Member
Team Size: 20
Environment: SAP BW 3.5, SAP BI 7.0
Duration: Oct'07 - Mar'09
Description: Production monitoring team monitors daily data loads from R/3 systems, SEM-BPS, APO. Need to
monitor the BW and SEM-BPS production boxes of three Zones AMS, AOA and EUR. Follow the SLA
of 95% of Report availability every week. Update the status of Reports to Onsite BW team and
markets providing all the technical details.
Role:
* Monitored data loads (Master data & Transaction data) from various source systems like R/3, CRM, SEM and APO by
means of process chains.
* Supported, optimized and revamped Scheduling and Monitoring system.
* Performed below operations in data targets:
o Reconstructing the data requests from PSA in case of data load failures.
o Roll up of data from Info Cubes to Aggregates, Compression, by having the correct and up-to-date data.
o Analysis of Performance of the system (Checking for Deadlocks and Lock waits)
* Identified and analyzed issues related to data loading performance - Ticket Resolution.
* Attending the Market calls regarding the issues in the Data loads whenever required.
* Ensured Week end activities - Scheduling and rescheduling of process chains as part of the PTMAs (Post Manual Actions
Suggested by the Change Management Team).
* Ensured that reports will be available as per SLA.