Data Analyst | BI Developer
Email: [email protected] | Phone: 01220470363
Location: Naser City, Cairo
GitHub: github.com/abdelrahmanfaheem | LinkedIn: linkedin.com/in/abdelrahmanfaheem

Description: Leveraging SQL and Python to extract actionable insights from retail data and drive business performance.

Description: Designed and built a comprehensive DWH for a telecom company using SSIS and SQL Server.

Description:

• ETL solution implemented using SSIS.
• Data analysis and visualization with an interactive Power BI dashboard.

Description: Analyzed sales and margin trends for a retail chain, providing actionable insights through Power BI dashboards.

• Hotel Booking Data Analysis Using SQL
• Olympics Data Analysis Using SQL
• Sales Data Analysis Using Python
• Sales Analysis Using Power BI
• Kickstarter Analysis Using Power BI

A dynamic BI Developer and Data Engineer with a proven track record of optimizing business intelligence processes and driving data-driven strategies. Known for delivering impactful insights through scalable solutions and advanced data visualization techniques. Passionate about leveraging analytics to empower decision-making and improve operational efficiency.

Dec 2024 – Present | Cairo, Egypt

• Designed and implemented a Power BI Retail Sales Dashboard, reducing reporting time and enhancing revenue tracking accuracy to increase profit margins.
• Used SQL to extract and analyze retail sales and product data from the Data Warehouse (DWH) to identify trends and insights.
  Technologies: SQL, Python, Pandas, NumPy, Excel, Power BI, DAX

Sep 2023 – Dec 2024 | Cairo, Egypt

• PriceID and Cross FunctionID Project:
  • Analyzed electronic parts' features to identify substitutes for clients facing shortages.
  • Developed a pricing system to offer budget-friendly alternatives, enhancing customer satisfaction.
• Supplier Rank Project:
  • Analyzed product lines to identify and rank suppliers by the lowest prices, optimizing supplier selection and cost efficiency.
    Technologies: SQL, Python, Pandas, NumPy, Excel, DAX

Jun 2023 – Aug 2023 | Mansoura, Egypt

• Conducted growth and sales data analysis, providing actionable insights.
• Built interactive Power BI dashboards for client presentations.
  Technologies: SQL, Excel, DAX, Power BI

• Database and Data Management: Data Warehousing, SQL, MySQL, T-SQL, ETL, SSIS, SSAS, SSRS
• Data Analysis: Data Visualization, Power BI, Excel, Power Query, DAX, Data Storytelling
• Programming: Python (Pandas, Plotly, SciPy), Java

Mansoura University | BSc in Computers and Information
2018 – 2022 | Mansoura, Egypt

• Grade: Very Good (80.8%) | Graduation Rank: 6th Overall
• Graduation Project: Diabetes Management System (With Machine Learning) – Excellent (94.5%)

• Full Stack Intern at DEBI | Nov 2024 – Present

  • MySQL, Database Management, Java, Data Structure, Python, SQLite

• Azure Data Engineer Intern at DEPI | Mar 2024 – Nov 2024

  • Microsoft SQL Essentials, Data Warehouse, Python Programming (Pandas, NumPy, SQLAlchemy)
  • Azure Data Fundamentals, MLOps Tools (MLflow, Hugging Face)
  • Agile Development and Scrum, Business English

• BI ITI Track Training

  • Database, DWH Fundamentals, SQL, SSIS, SSAS, SSRS
  • Microsoft SQL Server Business Intelligence, Microsoft Power BI, Tableau

• Soft Skills and Ideation Bootcamp | Jan 2023

  • Presentation Skills, Teamwork, Communication Skills
  • Basic marketing concepts for startups, including business model creation.