About
Detail-oriented Data Analyst fresher with strong foundation in Python, SQL, Pandas, NumPy, and Power BI. Experienced in end-to-end data projects involving data cleaning, exploratory data analysis, SQL querying, and dashboard development. Demonstrated ability to extract actionable insights from structured datasets and communicate findings visually. Seeking an entry-level Data Analyst role to contribute analytical skills and grow within a data-driven organization.
Skills & Expertise (23)
Work Experience
Data Analyst
City Traffic Analysis Dashboard
Jan 2024 - Apr 2024
Designed and built an end-to-end traffic analysis pipeline covering data ingestion, cleaning, SQL querying, and visualization. Performed feature engineering on raw traffic data to create structured datasets suitable for analysis. Executed SQL queries to identify top congestion hotspots and quantify the impact of weather conditions on traffic flow. Developed an interactive Power BI dashboard with KPI cards, trend lines, and heat maps to enable data-driven traffic management decisions. Reduced manual reporting effort by consolidating multiple data sources into a single automated dashboard.
Data Analyst
Zepto Retail Product Data Analysis
Aug 2023 - Nov 2023
Designed a SQL-based product analytics project using MySQL to explore pricing, inventory levels, and category-level business trends. Cleaned raw data by removing zero-priced and null records, and standardized currency from paise to rupees for accurate financial analysis. Applied advanced SQL techniques including GROUP BY, CASE WHEN, HAVING, and window functions (RANK, ROW_NUMBER) to identify duplicate products and high-discount items. Calculated category-wise estimated revenue, average discount percentages, and price-per-gram metrics, providing actionable insights for pricing strategy. Identified top 5 revenue-generating categories and flagged 3 product groups with abnormally high discount rates for review.
Education
Bachelor of Engineering – Information Science and Engineering - DBIT Institute of Technology, Visvesvaraya Technological University
2022 - 2026 · Afghanistan
Certifications
Data Analyst Job Simulation
Deloitte (Forage) · 2024
IBM Project Management Fundamentals
IBM · 2023
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (23)
Click a skill to find developers with the same skill
