Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic

ZAFAR AFSAR SHAIKH

Aurangabad

Summary

Recent graduate with a strong passion for data analysis, seeking a data analyst position to leverage analytical skills and proficiency in Python, SQL, Power BI, and Excel. Committed to translating complex data into actionable insights that drive informed decision-making within a dynamic team environment.

Overview

1
1
Certification

Work History

Data Analyst Intern

Calm Cloud IT Solutions
Aurangabad
08.2024 - 10.2024
  • Executed data cleaning and preprocessing activities.
  • Collaborated in analyzing and interpreting complex datasets to uncover trends and insights.
  • Designed effective data visualizations to convey insights to team members.

Education

Bachelor of Technology - Computer Science

PES College of Engineering
Aurangabad Maharastra
06-2023

Skills

  • Adv Excel (MS Excel)
  • Structured Query Language (SQL)
  • Python (Programming)
  • Power BI
  • Tableau
  • Statistics
  • Data mining
  • Pandas
  • Matplotlib
  • Numpy
  • Data Visualization
  • Good communication skill
  • Able to work in a team
  • Great problem solving skill

Projects

Analyzing Amazon Sales Data

  • Data Collection & Cleaning: Utilized Python libraries (Pandas) to gather and clean raw sales data, ensuring data integrity and readiness for analysis.
  • Exploratory Data Analysis: Conducted comprehensive EDA to uncover significant trends, outliers, and patterns in sales performance across multiple categories.
  • Data Visualization: Developed dynamic visualizations using Matplotlib and Seaborn to effectively communicate insights to stakeholders.

 Analyzing-Targets-E-commerce-Operations-with-SQL

  • Operational Insights: Analyzed key metrics such as order fulfillment rates, delivery times, and stock levels to identify bottlenecks and optimize processes.
  • Conducted in-depth analysis: to evaluate the achievement of sales and operational targets, identifying opportunities for improvement.
  • Database Optimization: Enhanced query performance by implementing indexing tables, optimizing joins, and restructuring database schemas, achieving a 40% reduction in runtime.
  • Reporting & Visualization: Created automated SQL-based reports and dashboards to track operational KPIs, providing real-time insights for decision-making.

Certification

15/07/2024

data analyst

techminds academy.

2023/02/15

machine learning engineer (AI Analyst)

symbiosis skills and professional university.

Timeline

Data Analyst Intern

Calm Cloud IT Solutions
08.2024 - 10.2024

15/07/2024

data analyst

techminds academy.

2023/02/15

machine learning engineer (AI Analyst)

symbiosis skills and professional university.

Bachelor of Technology - Computer Science

PES College of Engineering
ZAFAR AFSAR SHAIKH