Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Interests
Timeline
Personal Profile
Personal Profile
Generic
Gaurav Sharma

Gaurav Sharma

Data Analyst
FARIDABAD

Summary

VISION & OBJECTIVE: To obtain a challenging and responsible position in the field which will enable me to put into practice developed skills and augment my knowledge to contribute to the growth and development of the organization. Now looking for a Suitable data analyst position with an ambitious company.

Overview

11
11
years of professional experience
5
5
years of post-secondary education
1
1
Certificate
2
2
Languages

Work History

Senior data analyst

Paytail Commerce Pvt Ltd
Gurgaon
11.2021 - Current

Key Responsibilities with Paytail :

  • Make Reports on Power BI on real-time basis for Co-founders, they Can easily take up decision on those reports
  • Helping in reconciliation for NBFC Partners
  • All reports fetch it from DB (MySQL)
  • Make reports on customer support Like Agent productivity reports & Agent engagement reports
  • Make Incentive reports to Merchants as well as FOS team
  • Make SFE reports
  • Make automatic Dashboards on Power BI with help of MYSQL (DB).
  • Investors report for CXO.
  • Work on Power BI, MySQL & Excel

MIS Executive

SRL Limited, SRL Ltd
Gurgaon
10.2017 - 11.2021

I worked with SRL Ltd. (Corporate) under the COO as MIS/Data Analytics from 3rd-Oct-17 to 26th-Nov-2021

Key Responsibilities with SRL Ltd:

Handling North and East region data. Analysis of Data and MIS reports.

Make ad-hoc Dashboard/Data as per requirements.

Make a review presentation every month of all 3 regions for the COO.

Make Budget of all 3 regions team-wise as well as Lab Wise.

Make incentives working for Phlebotomists.

SFE report for sales field team.

Senior Officer

Sun Pharmaceutical Industries Limited
Gurgaon
03.2017 - 09.2017

I have worked with Sun Pharma (CHC Division) as Data Analytics (Sr. officer) in Sales Force Effectiveness from 14-Mar-17 to 25th Sep-17

(on roll of Sun Pharma).

Key Responsibilities with Sun Pharma:

  • Handling all 5 Region of Sun Pharma.
  • Managing SFE application over PAN India.
  • Making Sales reports along with Dashboard with help from sale force tool.
  • Handling primary data.
  • Analysis of Sales data of PAN India, Making reports accordingly.
  • Budget (target) report for quarter of PAN India.
  • Incentive Calculation of ASE.

MIS Executive

M/S GTL Infrastructure Ltd, GTL Infrastructure Ltd
Gurgaon
04.2015 - 03.2017

Description about GTL Infrastructure Ltd: - GTL, a Global group enterprise is a leading infrastructure services company focused on telecom and power

  • The company provides Network Services to Telecom Operators, OEMs, and Tower Companies in telecom segment
  • Handle Billing data of our client Airtel & Aircel.

EB Coordinator, MIS Executive

M/S GTL Infrastructure Ltd
Gurgaon
03.2013 - 11.2014

Key Responsibilities with work in GTL:

  • Team handling
  • Coordinate with EB Boards like BSES, DHBVN, TPDDL, NPCL and PVVNL
  • Taking care of electronic bills.

Accounts Executive

M/S Probus Associates & Consultants Pvt. Ltd
05.2010 - 12.2011
  • Description about PACPL- It’s well-known smaller agency with fewer employees than the larger nationally based private investigations firms, pertaining to health claim, PA claims, Death Claims
  • It is associates with many well-known companies like RGICL, Bharti Axa, Future Generalli, Iffco Tokio, ICICI Lombard, FHPL (TPA), and HDFC life.

Education

BBA - BBA CAM

D.A.V Institute of Management, M.D University
Faridabad
07.2005 - 06.2008

12th - Commerce

Aggarwal Public School - CBSE
Faridabad, HR
04.2004 - 03.2005

10th -

Aggarwal Public School CBSE
Faridabad
04.2002 - 03.2003

Skills

Power BI ,Data Analysis Expressions Functions

undefined

Certification

Microsoft Excel Expert 2019 (MOS 201)

Additional Information

  • Sep'2014 : Received Passion for Action award by GTL for good performance.
  • Jun'2021 : Covid warrior appreciation letter from CEO’s office.
  • Apr'2022 : Received Shining Star award from Paytail Commerce.
  • Sep'2022 : Received Data Science award from Paytail Commerce .

Interests

Interacting with People

Listening to music

Collecting Coins

Reading General Knowledge books and Fiction books

I like chess

Timeline

Microsoft Excel Expert 2019 (MOS 201)

08-2022

Senior data analyst

Paytail Commerce Pvt Ltd
11.2021 - Current

MIS Executive

SRL Limited, SRL Ltd
10.2017 - 11.2021

Senior Officer

Sun Pharmaceutical Industries Limited
03.2017 - 09.2017

MIS Executive

M/S GTL Infrastructure Ltd, GTL Infrastructure Ltd
04.2015 - 03.2017

EB Coordinator, MIS Executive

M/S GTL Infrastructure Ltd
03.2013 - 11.2014

Accounts Executive

M/S Probus Associates & Consultants Pvt. Ltd
05.2010 - 12.2011

BBA - BBA CAM

D.A.V Institute of Management, M.D University
07.2005 - 06.2008

12th - Commerce

Aggarwal Public School - CBSE
04.2004 - 03.2005

10th -

Aggarwal Public School CBSE
04.2002 - 03.2003

Personal Profile

Father’s name: Mr. M. L Sharma.

Date of Birth: 23 -02- 1986.

Marital status: Married.

Permanent Address: House no. 1310, Sec-3 Faridabad (Haryana).

Personal Profile

Father’s name: Mr. M. L Sharma.

Date of Birth: 23 -02- 1986.

Marital status: Married.

Permanent Address: House no. 1310, Sec-3 Faridabad (Haryana).

Gaurav SharmaData Analyst