Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic

Sandeep Chaudhary

Bhandup, Mum

Summary

Data Analyst with 3.2 year of data analysis experience in Telecom and e-commerce industry. Proven track record of analysis huge volume of data/automating reports to gain business insight using Excel, tableau, SQL, and statistics.

Overview

5
5
years of professional experience
1
1
Language

Work History

Data Analyst

Reliance Jio
Mumbai
08.2021 - Current
  • Being part of fiber business, worked with customer complaint data /Network monitoring alarm and usage data to drawn insight and support data driven decision
  • Automated Various report on tableau like customer complaint KPI on Realtime basis which help in monitoring and resolving customer complaint faster and saved on an avg 2 Hrs
  • Of time for report generation on excel
  • Build Hive query to identify non usage day during customer complaint in last 30 days which helped in providing validity extension to the customer which saved 3-4 hrs./week
  • Supported Ad hoc report, generating various summarized/graphical report and used advanced excel formula (e.g., Business Hours Calculation/Nos of day between complaint excluding holidays) for crunching customer data
  • In depth understanding of data point in fiber/Airfiber business which help in understanding requirement and translating into actionable insight in faster manner.

MIS Analyst

Valad Info Tech Solution Limited
04.2021 - 08.2021
  • Analyzed Marine inventory dataset to generate insightful outcomes
  • Closely work with business team to understand requirement and get the needful done
  • Prepared progress report on weekly basis and finding insight from the report to accelerate the progress to project deadline on time using Gantt chart
  • Automated various repetitive task using excel VBA which saved time and improved efficacy.

Analyst

Eclerx Service Limited
03.2019 - 11.2019
  • Worked with e-commerce dataset for content enrichment and generating summarized report
  • Used excel various feature for data crunching such as shortcuts/function, building chart and graphs, sorting and filtering dataset and creating dynamic report using pivot table
  • Built MS excel application using VBA to help with process automation e.g.: Collating various files, converting File type.

Education

First Class (CGPI - Electronic and Telecommunication

Lokmanya Tilak College of Engineering
August 2017

Skills

  • Programming Advance SQL, Python
  • Analytical Tool Tableau, Advance Excel
  • Database Apache Hive, MySQL
  • Core Competencies Strong Academic background in Math’s & Stats

Interests

Hobbies & Interest: , Physical Activity, Health related talks

Timeline

Data Analyst

Reliance Jio
08.2021 - Current

MIS Analyst

Valad Info Tech Solution Limited
04.2021 - 08.2021

Analyst

Eclerx Service Limited
03.2019 - 11.2019

First Class (CGPI - Electronic and Telecommunication

Lokmanya Tilak College of Engineering
Sandeep Chaudhary