
Adil Shah
Data Analyst | SQL Developer
Hire this person
Send a job offer directly to this candidate
About
Computer Science student at Xidian University with a strong interest in data analytics and business intelligence. Proficient in SQL, Python (Pandas, NumPy, Matplotlib), Excel, and Power BI, and certified through the Google Data Analytics Professional Certificate. Completed hands-on projects on real-world datasets, including job market trend analysis and sales performance analysis.
Seeking a Data Analyst internship to apply analytical skills to real business problems and learn from industry professionals. Available for remote work and able to start immediately.
Experience
Data Analyst (Academic Projects) — Xidian University, Xi'an, China
March 2024 – Present
- Built end-to-end data analytics pipelines in Python (Pandas, NumPy, Matplotlib) analyzing 9,994+ retail records with $11.48M revenue, $286K profit, and 5,009 unique orders.
- Wrote advanced SQL queries using Window Functions, CTEs, and Date Functions to solve complex business problems and uncover operational inefficiencies.
- Cleaned, validated, and engineered derived metrics (Line_Total, Discount_Amount, Net_Revenue, Profit_Per_Line) on real-world datasets.
- Created six professional visualizations to identify loss-making products, regional performance gaps, and monthly revenue trends.
- Analyzed 785,000+ job market records using PostgreSQL joins and CTEs to identify top-paying remote roles and salary trends.
- Documented all projects with reproducible Jupyter Notebooks, README files, and version control via Git.
- Published all work on GitHub for portfolio review, demonstrating cross-tool capability (SQL + Python).
Education
Bachelor of Science - Computer Science - Xidian University (2025-09 - 2029-09)
