Ameen El-Nagar | Data Analyst

Work Experience

Data Analyst - ALFayed

Aswan, Egypt Dec 2022 - Jan 2025

Consolidated 10K+ rows of sales data monthly from 3 branches into a structured format, ensuring 99% accuracy
Implemented a new reporting system using Excel Pivot Tables, reducing processing time by 50%
Generated 50+ monthly financial reports for clients, providing clear insights into sales and profitability
Delivered weekly financial analysis, improving stakeholder decision-making and increasing forecast accuracy by 30%

Mobile App Developer (Part-Time) - First Academy

Aswan, Egypt Jan 2024 - Present

Migrated iOS and Android apps from native development to Flutter, improving maintainability and performance
Designed and implemented a SQL database handling 100K+ records, optimizing data retrieval and analysis speed by 40%
Automated data handling processes, reducing manual data entry errors by 95%

Jan 2023

Created an interactive Excel dashboard tracking 10K+ sales transactions, enabling real-time monitoring of key performance metrics
Leveraged Pivot Tables and Charts to analyze 3 sales regions, identifying trends that increased revenue by 15%
Implemented dynamic filtering with interactive dashboard filters and sliders, enhancing user accessibility and reducing data retrieval time by 40%

Jan 2023

Cleaned and standardized a 7K-row UAE car sales dataset, ensuring 99% data accuracy
Used SQL joins, subqueries, window functions, and Regular Expressions (REGEX) to analyze sales trends and pricing patterns
Optimized queries for efficient data retrieval and performance on large datasets

Apr 2024

Built an interactive Tableau dashboard analyzing 7+ million Airbnb records, uncovering key pricing and demand trends
Cleaned and prepared millions of data points, improving dataset accuracy and visualization clarity
Utilized filters, parameters, and calculated fields to enhance user interactivity and uncover key insights

Bachelor of Commerce - Aswan University - Aswan, Egypt Jun 2021
Accounting Department, English Section