Shruti Gupta
Senior Data Analyst
Noida
Summary
Perceptive and Meticulous Senior Data Analyst having 6+ years of experience, accomplished in designing rapid and impactful analysis solutions from large complex datasets in order to help grow business. Advanced understanding of statistical distributions, predictive analytical models, sampling and other analytical techniques. Open and clear communicator with good multitasking skills, organized nature and strong attention to details.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work History
Senior Data Analyst
Bharti Airtel
07.2022 - Current
- Worked on projects like Customer Churn Prediction, Customer Segmentation, Fraud Detection, Campaigns and Demand Forecasting.
- Delivered end-to-end ML solutions from stakeholder discussions to building and maintaining models using large datasets from Hive, Oracle and HDFS.
- Built models based on deep-dive statistical analysis using Python (sklearn, pandas, numpy and matplotlib).
- Skilled in exploratory data analysis (EDA). Did EDA for Cibil Score Analysis of APB customers.
- Created recommendation models (Linear regression, Random Forest Classifier, Decision Tree and Logistic regression) and wrote elastic queries for data validation in Kibana.
- Wrote detailed technical reports and implemented sampling strategies to uncover customers behavior insights.
- Collaborated with marketing team for campaign targeting and impact analysis.
- Drove roadmaps with cross-functional stakeholders.
Senior Data Analyst
Capgemini
10.2021 - 07.2022
- Handling client deals involving checkups on the pricing strategies and licensing agreements using Tableau.
- Maintaining facts and figures of the onboarded clients using excel and identifying probable improvements for upcoming clients.
- Generation of future pricing sheets for every onboarded client with us based on analysis using python.
Data Analyst
Amdocs
02.2019 - 10.2021
- Produced monthly reports using PowerBI and advanced Excel functions like Vlookup, Index, Match, Pivot table and graphs.
- Developed database objects, including CTEs, views and materialized views using SQL to handle large dataset.
- Created shell scripts on UNIX platform to extract & process data for reporting.
- Took initiative to automate manual reports using python in order to reduce time consumption for reports generation, making all other deadlines meet irrespective of increased work.
- Developed complex dashboards, stories and graphs on tableau to monitor & track key performance indicators.
- Generated ad-hoc reports to evaluate specific business requirements.
- Developed plans as per market requirement after detailed analysis.
Education
B-Tech - Computer Science
IEC Institute of Engg. & Technology
08.2014 - 05.2018
High School - PCM
DAV Public School
04.2013 - 04.2014
Skills
- SQL
- Kibana
- Python
- Statistical Analysis
- ELK
Predictive Modeling
HDFS
Jira
BMC Remedy
Tableau
Hive
Interests
Painting, Travelling
Timeline
Senior Data Analyst
Bharti Airtel
07.2022 - Current
Senior Data Analyst
Capgemini
10.2021 - 07.2022
Data Analyst
Amdocs
02.2019 - 10.2021
B-Tech - Computer Science
IEC Institute of Engg. & Technology
08.2014 - 05.2018
High School - PCM
DAV Public School
04.2013 - 04.2014
Similar Profiles
Yacouba SoireYacouba Soire
Inventory Manager at Airtel Burkina, Bharti AirtelInventory Manager at Airtel Burkina, Bharti Airtel
Ranjit PanikarRanjit Panikar
Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)
Jitendra KapdeJitendra Kapde
Global Supply Chain Manager at M/S BHARTI AIRTEL LIMITEDGlobal Supply Chain Manager at M/S BHARTI AIRTEL LIMITED
Shubham BhandariShubham Bhandari
National Account Manager at Bharti Airtel LimitedNational Account Manager at Bharti Airtel Limited
Prashant KashyapPrashant Kashyap
Consultant at TATA CONSULTANCY SERVICESConsultant at TATA CONSULTANCY SERVICES