Saurabh Gola

·        Organization Name: Tata Teleservices Ltd.

·        Location: - 2 A Old Ishwar Nagar, New Delhi-110063  

·        Time period: - Feb 2003 to Sep 2011

·        

Role and Responsibilities

Receiving and downloading data from different - different sources and all 81 Centers**,** Cleaning and formatting data using by EXCEL.

Cleaning and uploading data in CRM on date and priority basis. Sharing all data disposition with centers heads.

Removing duplicate numbers from Data through MS Access and Excel (Tools and formula).

Updating campaign wise data in CRM. Allocating RSM to Campaign and Data wise.

Creating and updating RSM’ productivity report in Dashboard and Share MIS Dashboard to the seniors.

Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.

Extracting report from CRM ASM productivity report on daily basis sharing MIS to the seniors.

Updating Data Tracker and MIS Dashboard on daily and weekly basis.

Creating Sales & Purchase reports break and log in / log out report

Interacting with client directly through scheduled daily / weekly Business Conversation (Email)

Updating attendance dashboard and sending the sales executive allocating report GM.

Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) are prepared to satisfy the project requirements cost and schedule.

Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation & Scenarios)

Keep the Operation & Finance manager informed of task accomplishment, issues and status.

Prepared Proactive checklist for database & important work to avoid future downtime.

Making Advanced presentation in Ms PowerPoint to present MIS & other related important reports