Business Excellence Analyst
- Initially I had worked in Order management team for 2 years in BSS Department. Important processes worked in this team are Quotes, Order processing, De-installation of orders, VAF for client BT.I automated a manual work for team auditing which used to take around 2hours for a week initially later it was taking just 2mins to get data Using VBA.
- Later got promoted to a different department BOA –Business operations & Analytics. Over here most important processes I worked on was on APPLE SLA reporting, FLM process, MSS billing over here in this process I used to create Purchase requisition for vendors in order to make their payments weekly. Single handedly transitioned Score card report from China Service delivery manager and was able to work for almost 6 months without any difficulty before handing it onto my backup.
- Again got promotion and moved to a different team within the same department BOA. Over here I am working as Business Excellence Analyst with providing field service reports to different accounts like Dell, Unilever, Andersen and many more. I download files from Business objects to work on day to day basis. After downloading reports on account basis, I query each and every call in our records that is service console to Analyze whether the technician has met the SLA or not. If he has not met the SLA we would be looking for any customer exceptions from client end.
- The main reason to look into individual call is that to check for tech accuracy and also on SLA perspective. We cannot blindly consider the tech codes because we will never reach the target SLA on day to day basis.
SLA is very much important from client perspective because tech accuracy would be some were in mid-20%. I will look analyze each call so that this would go up-to 90% or more. After analyzing all calls in particular account we will be importing the Excel file onto database to get the final formatted output. Took an initiative of working on most difficult process at present in team which is Dell reporting. Over here the main challenge was there are 20 to 30 databases which are linked to one another and too many excel sheets are connected to these DB’s. There are macros which pull information from various sources and add onto databases. Problem here would be if any error pop’s-up we should be in a position to analyze where is the problem and how can I over come to get out this problem.