About
Results-driven entry-level Data Analyst with a strong foundation in SQL, Python, and statistical analysis. Experienced in data cleaning, ETL processes, exploratory data analysis (EDA), and building interactive dashboards using Excel and Power BI. Skilled in translating complex datasets into actionable business insights through data visualization and descriptive statistics. Pursuing MCA from Lovely Professional University with hands-on project experience in MySQL, PostgreSQL, Pandas, NumPy, and Tableau. Seeking to leverage analytical and problem-solving skills to drive data-driven decision-making as an entry-level Data Analyst.
Skills & Expertise (32)
Work Experience
E-Commerce Sales Analysis & Forecasting
Personal Project
Jan 2024 - Jan 2024
Analysed an e-commerce dataset of 100,000+ transaction records using Python (Pandas, NumPy) to uncover sales trends, customer behaviour patterns, and seasonal demand fluctuations. Performed end-to-end ETL pipeline: extracted raw CSV data, cleaned 15% missing values and duplicate rows, and transformed data into analysis-ready structured format. Conducted exploratory data analysis (EDA) and descriptive statistics (mean, median, standard deviation, correlation) to identify top 10 revenue-generating product categories contributing 68% of total sales. Built interactive visualisations using Matplotlib and Seaborn — including heatmaps, bar charts, and time-series line plots — reducing insight interpretation time by ~40%. Applied A/B testing to compare conversion rates between two customer segments, identifying a 12% uplift in purchase rate for targeted promotions. Wrote optimised SQL queries with window functions and CTEs to aggregate monthly KPIs including revenue growth, average order value (AOV), and customer retention rate.
Sales Performance Dashboard
Personal Project
Jan 2024 - Jan 2024
Designed and developed an end-to-end interactive sales dashboard in Excel and Power BI to monitor 6 key business KPIs including monthly revenue, sales growth rate, and regional performance. Cleaned and transformed 5,000+ rows of raw transactional data — removing duplicates, standardising formats, and handling null values — reducing data errors by 30%. Automated KPI calculations using VLOOKUP, SUMIFS, COUNTIFS, and Pivot Tables, cutting manual reporting effort by approximately 3 hours per week. Visualised month-over-month revenue trends with dynamic charts, enabling stakeholders to identify a 22% revenue dip in Q3 and recommend corrective actions. Created a Tableau Public dashboard replicating the Power BI report to demonstrate cross-tool data visualization proficiency.
HR Analytics: Employee Attrition EDA
Personal Project
Jan 2024 - Jan 2024
Performed exploratory data analysis on an HR dataset of 1,470 employee records to identify key drivers of attrition using Python (Pandas, Seaborn). Applied hypothesis testing (chi-square test) to validate that job satisfaction and work-life balance scores were statistically significant predictors of employee churn (p-value < 0.05). Produced 12 visualisations including correlation heatmaps, box plots, and distribution plots; identified that employees with <2 years tenure had 3x higher attrition risk. Summarised findings in a structured analysis report with data-driven recommendations, simulating a real-world business analyst deliverable.
Student Data Management System
Academic Project
Jan 2023 - Jan 2023
Built a console-based student records system managing data for 500+ student entries using MySQL and PostgreSQL as relational backends. Wrote advanced SQL queries including joins, subqueries, GROUP BY aggregations, and indexed lookups — reducing average query response time by 35% through indexing optimisation. Implemented full CRUD operations via JDBC, enforcing data integrity constraints and reducing invalid data entries by 25% through server-side validation. Designed normalised relational schema (3NF) with 6 tables, ensuring zero data redundancy across student, course, and enrollment records.
Education
Master of Computer Applications (MCA) - Lovely Professional University
2024 - · Afghanistan
Bachelor of Computer Applications (BCA) - Quantum University
2021 - 2024 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (32)
Click a skill to find developers with the same skill
