Assistant Manager, Analytics

Vishal Javakhedkar

Mobile: +91-981*******/995-***-**** ~ E-Mail: ************@*****.***

[pic]

Career Overview

[pic]

< A competent professional with 12 years of experience including Business

Analysis, MIS and Data modeling

< An IIM certified profession with knowledge of SAS and SQL

< Selected as one of Global Employee of Year (2011) in previous

organization Colt Technologies, Gurgaon

Organisational Experience

[pic]

Iqor Services, Noida Since

Aug'12

Assistant Manager, Analytics

Accountabilities:

< Analyse reason of account/phone not getting dialled

< Provide legal team/compliance team inputs on how to reduce customer

complaint

< Recommend staffing/letter strategy to maximise collection and reduce cost

< Keep checking the models on regular basis to make sure probability of

collection is getting updated regularly

< Automate Reports using SAS/SQL

< Prepare adhoc/Regular Reports using SAS/SQL

Colt Technologies, Gurgaon Jan'09

to Aug'12

Lead Analysis, Business Analysis

Accountabilities:

< Mapping business requirements into reporting language and taking end to

end ownership of the delivery

< Act as a relationship manager between Operations and Reporting for smooth

transaction of projects related to reporting requirement

< Identify requirement of system enhancement, agree with stakeholder

< Prepare BRD and download to development team and perform UAT

< Making proposal and presentation for changes in process as and when

required

Projects handled:

1) Built a model to Predict the customer who may leave Company in future

by analysing historical pattern

2) Identify reasons of non SLA compliance of one of the existing process

Colt Technologies, Gurgaon Jan'07

to Dec'08

Reporting Analyst

Accountabilities:

< Preparing daily/weekly/ monthly report, Scorecard, Dashboard and Graphs

< Use Business Object for report preparation and present it as a self

service tool

< Automate the report with the help of SQL, Access and Excel

< Mentor new joiners and make them understand the expectation of their role

< Train colleagues on Excel/Access/Business Object

Computer Sciences Corporation India, NOIDA Jun'06-

Jan'07

Delivery Service Coordinator

Accountabilities:

< Maintaining the data of assets across the world.

< Sending daily, weekly and monthly reports to the clients and interacting

with them on regular basis.

< Imparting training of MS Excel to new joiners.

Teletech India, Gurgaon Sep'05-

Jun'06

Specialist at the Command Centre

Accountabilities:

< Call forecasting, scheduling and Rostering for Airtel processes

< Managing the Real Time and working on Nortel Symposium

< Prepare Billing for Finance Department along with tracking daily

attendance and sending attendance inputs to HR at the end of the month

for salary evaluations

Highlights:

< Achieved appreciation and award in 2nd Month of joining.

Surevin services, Indore Jun'05-

Sep'05

Team Leader for Outbound Call Centre

Accountabilities:

< Handling escalation calls for outbound calls for Idea Cellular Ltd.

< Preparing MIS and performance management reports of the team

< Make sure that Team meats the SLA on day to day basis

Previous Assignments

[pic]

Reliance Info stream Pvt. Ltd., Mumbai Customer Interaction Executive

Aug'03-May'05

Modi Telecom Ltd., Indore Customer Service Associate Feb'02-

Jul'03

Academic Credentials

[pic]

2012 Executive Program in General Management from IIM Lucknow

2008 PGDBA (Marketing) from Symbiosis Centre for Distance Learning,

Pune

2000 B.Sc. from PMB Gujarati Science College, Indore

IT Skills

[pic]

Operating Systems: Windows 97 from Aptech Computers, Indore

Tools: SAS, MS Word, Excel, Access, PowerPoint and

Business Object

Trainings

[pic]

< Six Sigma Green Belt from QAI in 2011

< Business analysis from QAI in 2010

< Got trained and certified in ITILv3 in 2010

< Prince 2 Foundation and Practitioner

< Business analytics from Edupristine

Accolades

[pic]

< Bagged the excellence and champion award for automation and maintaining

high quality

< Bagged the Best Hotline Officer Award from Airtel Indore for the Month of

March 2003

Personal Dossier

[pic]

Date of Birth: 30/08/1979

Address: Plot no 209, H No.3, NitiKhand I, Indirapuram, Ghaziabad

201014.

Contact this candidate