Menu

Abdelrahman Elaref

Data Analyst

|

Data Analytics Expertise

Transforming complex data into actionable business insights through advanced analytics and visualization techniques. I specialize in developing ETL pipelines, interactive dashboards, and comprehensive reporting solutions that help organizations make data-driven decisions.

With strong SQL, Python, and visualization skills, I can extract meaning from your data and present it in ways that drive strategic business growth. My approach combines technical expertise with a deep understanding of business needs to deliver solutions that have real impact.

Python & SQL Data Visualization ETL Development Business Intelligence Dashboard Design Statistical Analysis

Skills

lines

Programming Languages & Databases

  • Python (Data Analysis, Scripting)
  • SQL
  • PostgreSQL
  • MySQL
  • SQLAlchemy

Data Analysis & Visualization

  • Excel (PivotTables, Power tools)
  • Power BI (DAX, Report Design)
  • Machine Learning (Scikit-Learn)
  • Pandas & NumPy
  • Matplotlib & Seaborn

Tools & Other Skills

  • Git & GitHub
  • Jupyter Notebook
  • Docker
  • Database Design
  • ETL Pipeline Development

Work Experience

lines

Data Analyst Intern

Sustainly.tech | Remote
Jul 2025 - Present
  • Climate Risk Assessment: Executed comprehensive climate risk assessments across 8 sectors by integrating data from 15+ sources (financial disclosures, academic research), identifying key physical and transition risk drivers
  • Financial Modeling: Built scenario-based financial models in Python integrating 9 years of historical emissions and financial data, projecting carbon cost exposure ranging from $325M to $2.15B (2030–2060)
  • Agricultural Analysis: Quantified agricultural sector vulnerabilities, revealing it absorbs 82% of drought-related economic impacts and contributes ~20% of global GHG emissions, informing targeted mitigation strategies
  • Risk Simulation: Simulated 9 climate risk pathways, showing 85–91% cost savings under a Net Zero compared to Business-as-Usual, providing actionable recommendations for corporate decision-making
Python Financial Modeling Climate Risk Analysis Data Integration Scenario Analysis

Services

lines
Data Analysis

Data Analysis

Transform your raw data into actionable insights. I specialize in cleaning, processing, and analyzing data to uncover patterns and trends that drive business decisions.

Get in Touch
Data Visualization

Data Visualization

Convert complex data into clear, compelling visual stories. I create customized dashboards and reports that make your data accessible and impactful for stakeholders.

Get in Touch
ETL Processes

ETL & Data Integration

Streamline your data pipelines with effective Extract, Transform, Load processes. I help businesses integrate data from multiple sources into cohesive, reliable systems.

Get in Touch

My Projects

lines

Automated Reporting System

Python ETL Reporting

Reduced manual reporting time by 90% through automation of data processing and report generation.

Sales Analytics ETL

Python PostgreSQL Power BI

Built a robust ETL pipeline processing 20,000+ rows of sales data with interactive Power BI visualization.

Sales Performance Analysis

Python Pandas Visualization

Identified strategies for 15.97% revenue increase through advanced sales data analysis and visualization.

Gemstone Price Prediction

Machine Learning Python Data Science

Developed a ML model to predict cubic zirconia gemstone prices with 97.8% accuracy using physical attributes.

Interactive Dashboard (Coming Soon)

Power BI Data Visualization

An interactive dashboard project showcasing advanced visualization techniques for business intelligence.

0

Years Experience

0

Projects Completed

0

Data Points Analyzed

Education & Certifications

lines
Expected 2027

Bachelor of Artificial Intelligence Engineering

Mansoura University

Studying AI engineering with focus on machine learning, data analysis, and intelligent systems.

May 2025

Data Science Course

ALX and Explore AI

Comprehensive 13 months data science training covering statistical analysis, machine learning, data visualization techniques and real-world projects

August 2024

DataCamp Certified Data Analyst

DataCamp

Professional certification verifying expertise in data manipulation, visualization, and statistical analysis.

Contact

lines

Feel free to contact me for any data analysis projects, consultations, or job opportunities. I'm currently open to remote data analyst positions.