Data Analyst Analysis

SHUBHAM R. CHOUDHARI Data Analyst

Airoli Navi Mumbai,Maharashtra 909-***-**** ******************@*****.** Github Linkdin Course: BE / B. Tech

College : Rajiv Gandhi College of Engineering and Research, Nagpur Year of Passing : Mar 2017 Score : 7.97/10

Languages & Tools: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, MySQL, Excel, Power BI/Tableau, Jupyter Notebook, Google Collab, Advanced Excel, Power Query. Concepts: Data Cleaning, EDA, Data Visualization, Hypothesis Testing, Dashboard Creation Soft Skills: Problem Solving, Communication, Attention to Detail, Teamwork,Presentation, Stakeholder Management Motivated and detail-oriented data enthusiast with a strong foundation in statistics, data analysis, and visualization. Skilled in Python, Power -BI,Excel, and SQL. Eager to contribute analytical skills to derive actionable insights and support data-driven decision-making in a dynamic organization. Skills

Education

Career Objective

1. Black-Friday-Dataset (Link)– Exploratory Data Analysis - The analysis focuses on the "Black Friday Dataset," which comprises sales transactions captured at a retail store using Pandas and Seaborn to identify key factors - Cleaned and transformed data, created visualizations to reveal insights - Tools used: Python, Jupyter Notebook, Google Collab 2. Cricket-SQL-Case-Study (Link) - Contains SQL queries designed to analyze cricket match data stored in a relational database. The queries focus on various aspects of player and team performance, providing insights into batting averages, win percentages, contributions to team runs, and more. used windows function,joins,aggregation Tools used: SQL,MySql 3. Sales Data Dashboard in Excel (Link)- Built an interactive dashboard to track monthly and regional sales trends - Used PivotTables, slicers, charts, and conditional formatting - Tools used: MS Excel,Pivot,Vlookup 4. Credit Risk Analysis (Link)- DAX Calculations for Financial Metrics,Time Series Analysis,Security Features for Sensitive Data and Calculated risk score depending on loan status, Dashboard creation - Tools used: Power BI,DAX 4.

Academic Projects

Certifications

- Google Data Analytics Professional Certificate – Coursera

- Excel for Data Analysis – Cloudy ML

- SQL for Data Science – Cloudy ML

- Python for Data Analysis – Cloudy ML

- Power BI for Data Analysis – Cloudy ML

Internship / Training

Data Analytics Intern at Cloudy ML,Feb, 2023 - July, 2023

- Assisted in cleaning and analyzing sales data using the SQL joins and Aggregate Functions to extract valuable insights.

- Wrote SQL queries for large datasets to extract, clean, and transform data.

- Created dynamic dashboards in Excel and Power Bl, integrating Pivot Charts and Slicers for enhanced visualization and filtering Data Analyst, Starktek, August 2023 - Present

-Removed duplicates, fixed incorrect date formats, and handled missing values

-Calculated monthly revenue, top-selling categories, and return rates.

-Built visuals for KPIs such as Total Sales, Profit Margin, and Customer Segmentation

-Work with Marketing and Sales team optimized discount strategy, Creating Dashboard and manage business users. Team Leader, Tech Mahindra, August 2021 - May 2023 -Working as a Team Leader. Handling a team and helping them to meet the KPI. Handling Escalation and interacting with the clients. Process Executive, Hexaware Technologies, August 2019 - February 2021 -It was a Blended process, Voice / Email. Works for the E-commerce website.Handling the team and improving the performance of the process Associate, Tech Mahindra, February 2018 - June 2019 -Audits and giving the proper feedback to the agents. Interacting with customers through voice calling.

Work Experience

Contact this candidate