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