Gaurav Rautela

• Data analytics and MIS for Operational activities to assist in the strategic achievement of operational goals within the function.
• Produce Daily, weekly and monthly Tracker of Broadband, DTH, Postpaid activation done by Stores and XFEs that will be used by retail leadership to manage performance and productivity.
• Daily walk-in dashboard and Analyzing Conversion Trends.
• Targets calculations of stores and Airtel Friends for incentive and monthly gamification.
• Maintain Daily Data to finalize the scorecard of Daily match day and Monthly gamification.
• Monthly Performance scorecard and Incentive calculations of Stores, Airtel Friends and XFEs as per their achievements.
• Daily dashboard of MIFI Sale and stock management for own Stores.
• Monthly Churn Report, M0-M4 churn trend for All LOBs.
• Providing support to the Business Manager with ad hoc tasks when necessary.
• Provide strong reporting and analytical information support to improve decision making and business performance.
• Performed root cause analysis to diagnose system faults.

As an associate (Dec 2016- May 2019)

• Day to Day Operations of OR & FR stores related Retail Portal.
• Attendance and salary validation part of all OR CROs and FR SMs
• Vendor and Location wise CRO’s hiring and attrition Summary on monthly basis.
• Customers wait time, handling time analysis and report for OR stores
• Manpower balancing for OR stores, Ensuring that ideal and quality manpower are deputed at stores as per their walk-ins.
• Daily tracker of B2B road show stores performance as per the GADs, productivity and web UD logins
• Smart and fast dashboard: - Monthly scorecard of Airtel friends on the basis of their performance of the month.

• Daily tracking of postpaid, prepaid and 3G pack activation done by service centers.
• Project win back MIS on Daily Basis.
• Daily MIS of payment posting done by My Ideas.
• Performance scorecard & Payout of channel Partners.
• Incentive working & Performance scorecard of Field executives.
• Zone Wise Postpaid and Prepaid Query, Request and Complaint (QRC) Tagging Tracker.
• Coordination and Sim stock management for Channel partners.