Data Analyst with 1+ years in Power BI & SQL
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented Data Analyst with a Bachelor's degree in Information Technology from Mansoura University, graduating with Distinction (Excellent). Experienced in delivering end-to-end analytical solutions using Power BI, Excel, and SQL. Successfully completed a freelance HR analytics project for Ahram Security Group — a 1,000+ employee organization — delivering dashboards that tracked workforce KPIs, turnover, leave patterns, and manpower forecasts. Passionate about transforming raw data into actionable business insights.
Mansoura University
B.Sc. · Information Technology - Faculty of Computers & Information
August 1, 2019 – June 30, 2023
Ahram Security Group
HR Data Analyst
January 1, 2025 – June 1, 2026
India
Olympia Gym
Data Entry Specialist
January 1, 2025 – June 1, 2026
India
Pizza Sales Analytics Dashboard
January 1, 2024 – Present
• Analyzed 21K+ orders and $817K total revenue, identifying The Thai Chicken Pizza as the top profit driver with $43K revenue. • Engineered a Pareto (80/20) analysis revealing that 5 pizza SKUs generate 100% of cumulative revenue. • Delivered a Revenue Forecast model and customer buying patterns matrix to support menu and pricing strategy. • Built 3 interactive report pages: Overview, Deep Dive Analysis, and Executive Insights with dynamic slicers.
Hospital Analytics Dashboard
January 1, 2024 – Present
• Built a 4-page analytical dashboard covering 243 patients, 500 visits, 400 prescriptions, and $3M total treatment cost. • Analyzed treatment costs by department: Orthopedics and Cardiology each at $0.42M, identifying high-cost service lines. • Delivered patient segmentation by age group, gender, and visit frequency to support hospital capacity planning.
Brazilian E-Commerce Sales Performance Analysis
January 1, 2024 – Present
• Analyzed Olist Brazilian marketplace dataset from Kaggle covering sales performance, shipping, and customer behavior. • Identified top-performing sellers, highest-value customers, and fastest 10 shipping cities using advanced SQL queries. • Performed RFM-based customer segmentation classifying customers as New, Loyal, or At-Risk to support retention strategy.
Fitness Center Analytics Dashboard
January 1, 2024 – Present
• Developed a 4-page Power BI dashboard tracking 100 clients, 20 trainers, $4M revenue, and $1M expenses. • Built an interactive BMI and Calorie Calculator page enabling personalized health tracking for gym members. • Analyzed membership tiers (Platinum, Gold, Silver) with active vs. expired segmentation and monthly trend tracking.
Nashville Real Estate Sales Dashboard (2013-2016)
January 1, 2013 – December 31, 2016
• Analyzed $19B in total property sales across 57K+ transactions covering Single Family, Condo, and Vacant Land categories. • Identified Mount Juliet as the highest avg. price-per-sqft neighborhood ($3,042) while Nashville led in total volume ($14.8B). • Tracked YOY growth trends and sales volatility, revealing a -0.37 YOY growth rate and peak month revenue of $2.156B.
Cultural Fit Analysis
The candidate's projects demonstrate a diverse range of analytical applications (pizza sales, real estate, hospital, fitness, e-commerce, HR), indicating adaptability and a broad interest in different business domains. The target role of 'Data Analyst' aligns well with the candidate's demonstrated skills and project experience. The freelance experience suggests an ability to work independently and deliver solutions, which can be a good fit for project-based or agile environments. The academic background in Information Technology further supports a foundational understanding relevant to data roles.
Soft Skills & Operational Fit
The candidate's project descriptions indicate a detail-oriented approach and a focus on delivering actionable insights, which are valuable for operational fit. The freelance HR Data Analyst role suggests a degree of self-management and project ownership. However, without specific psychometric or communication test results, it's difficult to assess soft skills like teamwork, stress handling, or direct communication clarity beyond what's presented in the resume.