Back to Developers
Mohammad Zaid

Mohammad Zaid

Data Analyst

80 · Excellent

About

Data Analyst skilled in SQL, Python, PostgreSQL, Power BI, and Excel, with hands-on experience transforming retail and e-commerce data into actionable business insights. Built an end-to-end Retail Analytics & ETL Platform with FastAPI, PostgreSQL, Power BI, and DAX, including live deployment and interactive business dashboards. Experienced in data cleaning, EDA, KPI reporting, RFM analysis, Cohort Analysis, and data modeling.

Skills & Expertise (23)

Power BI Advanced
8.5/10
5
Years Exp
Postgresql Advanced
8.0/10
5
Years Exp
Cohort Analysis Advanced
8.0/10
5
Years Exp
RFM Analysis Advanced
8.0/10
5
Years Exp
Data Cleaning Advanced
8.0/10
5
Years Exp
Excel Advanced
8.0/10
5
Years Exp
Pandas Advanced
8.0/10
5
Years Exp
DAX Advanced
8.0/10
5
Years Exp
Python Advanced
8.0/10
5
Years Exp
Power Query Advanced
8.0/10
5
Years Exp
SQL Advanced
8.0/10
5
Years Exp
NumPy Advanced
7.5/10
4
Years Exp
Dashboard Automation Advanced
7.5/10
4
Years Exp
Data Modeling Advanced
7.5/10
4
Years Exp
MySql Advanced
7.5/10
4
Years Exp
A/B testing Advanced
7.0/10
4
Years Exp
Seaborn Advanced
7.0/10
4
Years Exp
MIS Reporting Advanced
7.0/10
4
Years Exp
Matplotlib Advanced
7.0/10
4
Years Exp
MongoDb Intermediate
6.5/10
3
Years Exp
AWS Intermediate
6.0/10
3
Years Exp
Basic Machine Learning Intermediate
6.0/10
3
Years Exp
EDA

Work Experience

Data Analyst

Retail Analytics & ETL Platform

Present - Present

Built end-to-end analytics and reporting on top of a FastAPI/PostgreSQL retail backend, covering orders, payments, refunds, and inventory data. Designed an Executive Dashboard and a Sales Analytics Dashboard in Power BI using DAX measures for revenue KPIs, profit, average order value, and refund rate. Used Power Query to connect, clean, and model PostgreSQL data into Power BI, with slicers for category- and product-level drill-down. Deployed the FastAPI backend with Render and Neon PostgreSQL, providing live Swagger/OpenAPI documentation.

Data Analyst

UK Retail Sales Analysis

Present - Present

Engineered an end-to-end analysis pipeline on 1M+ UK e-commerce transactions, reducing data processing time by ~60% through automated Python scripts. Applied RFM segmentation to classify 100K+ customers into behavioural tiers; found that 68% of revenue originated from the top 20% of customers. Conducted Cohort Analysis revealing a 45% drop in customer retention after month 2, informing a re-engagement campaign at the 6-week mark.

Data Analyst

Customer Behavior Analysis

Present - Present

Built a complete analytics workflow — Python-based EDA and cleaning, SQL querying, and Power BI dashboarding — to analyze customer shopping behavior. Wrote SQL queries in PostgreSQL for aggregation, joins, and filtering to identify top-performing categories and correlations. Designed an interactive Power BI dashboard with KPIs, trend charts, and slicers for stakeholder self-serve reporting.

Data Analyst

Mobile Sales Dashboard

Present - Present

Designed a multi-page Power BI dashboard analysing ₹769M in mobile sales data across 10+ brands, 20+ cities, and 5 payment methods; identified metro-city and payment-channel revenue patterns.

Education

Bachelor of Technology in Computer Science - BBD University

2020 - 2024 · Afghanistan

Senior Secondary (Class XII, BSEB)

- 2020 · Afghanistan

Secondary (Class X, CBSE)

- 2017 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Not Open to Relocation