Data Analyst with less than a year in SQL, Power BI & Python
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Junior Data Analyst skilled in transforming raw datasets into actionable insights. Proficient in SQL database engineering, interactive dashboard development in Power BI and Tableau, and Python-based automation. Proven ability to clean complex data and build robust analytical models to support strategic decision-making.
Faculty of Science, Ain Shams University (ASU)
Bachelor of Science (B.S) · Biophysics
August 1, 2021 – June 30, 2025
Digital Hub
Data Analyst Intern
November 1, 2025 – December 31, 2025
India
Hospital Emergency Room Performance Dashboard
June 17, 2026 – Present
Designed a comprehensive four-page healthcare dashboard (Monthly, Consolidated, Patient Details, Insights) tracking patient volume, care delays, and satisfaction metrics. Leveraged advanced DAX calculations and data modeling to map patient flows, identifying high-priority operational bottlenecks and optimizing staff scheduling strategies.
View ProjectCOVID-19 Global Data Analysis
June 17, 2026 – Present
Executed exhaustive exploratory analysis on global pandemic metrics using MySQL, cleansing and converting raw text timestamps into proper DATE schemas. Formulated advanced multi-table aggregations using CTEs and SQL Window Functions (RANK() OVER) to identify and rank historical case surges and recovery rates by territory.
View ProjectCall Center Performance & Analytics Dashboard
June 17, 2026 – Present
Built a dual-view reporting application with an Executive KPI View tracking 5 core service metrics and an Operational Grid View enabling detailed row-level drill-downs and data exports. Utilized Power Query for text parsing and sentiment standardization; implemented Time Intelligence DAX logic to isolate peak call durations and structural response bottlenecks.
View ProjectLayoffs Data Cleaning & Analysis
June 17, 2026 – Present
Constructed a multi-stage data-cleaning workflow in MySQL to eliminate anomalies, handle duplicates via partitions, and resolve null attributes through strategic Self-Joins across 2,000+ corporate records. Developed rolling monthly summaries and multi-level nested CTEs employing DENSE_RANK() to isolate trends in workforce reductions.
View ProjectAutomated Amazon Web Scraper & Price Tracker
June 17, 2026 – Present
Engineered an automated price monitoring tool using BeautifulSoup and Requests to scrape live e-commerce product pages. Developed an end-to-end data pipeline using Pandas to format data and append historical logs into persistent CSV records; configured SMTP automated alerts triggering real-time email notifications upon target price drops.
View ProjectAirbnb Pricing Dashboard
June 17, 2026 – Present
Created an interactive real estate visualization dashboard using Tableau's mapping engine to evaluate short-term rental parameters. Modeled geographic price distributions per zipcode alongside seasonal revenue timelines, delivering insights on optimal property configurations and highest-yielding regional markets.
View ProjectCultural Fit Analysis
The candidate's diverse portfolio of personal projects (e-commerce, healthcare, call center, real estate, global health, corporate layoffs) demonstrates a broad interest in applying data analysis across various industries. This versatility, coupled with a proactive approach to learning and self-improvement through projects, suggests a good cultural fit for a dynamic data-driven environment. The candidate's academic background in Biophysics, while not directly data-related, indicates a scientific and analytical foundation.
Soft Skills & Operational Fit
The candidate's project descriptions indicate a results-driven approach and an ability to translate raw data into actionable insights. The focus on identifying bottlenecks and optimizing strategies suggests a problem-solving mindset. The internship experience, though brief, highlights attention to data quality and integrity, which are crucial for operational roles.