Esraa Allam

Data Analyst | Research Coordinator | Problem Solver

Mansoura, Egypt
+201063755113
esraahassanallam@gmail.com

About Me

I'm Esraa Allam, a Data Analyst Freelancer with a strong foundation in SQL, Excel, Python, and Tableau. I specialize in transforming raw data into clear insights—helping businesses streamline operations, track performance, and make smarter, data-driven decisions.

My journey began in research and project coordination, where I learned how structured systems can multiply productivity. That experience, combined with hands-on data analysis training through the Digital Egypt Pioneers Initiative (DEPI), shaped my approach: blending technical expertise with organizational precision.

We worked on real-world projects that involved cleaning and analyzing large datasets, building dashboards, and generating actionable reports. Through internships and training programs, I developed skills in data visualization, statistical analysis, and problem-solving that allow me to spot patterns and provide meaningful recommendations.

Today, I partner with startups and small businesses to help them move beyond spreadsheets—turning complex data into simple roadmaps that save time, reduce complexity, and support growth.

📊 If you're looking for someone who can bridge the gap between data and decision-making, let's work together to bring clarity to your business.

Unique Selling Point

"I bridge the gap between data and decision-making by combining strong analytical skills with professional presentation design. I don't just find the insights — I turn them into clear, visually compelling reports that drive action."

Education

BSc. of Agricultural Science, Agricultural Biotechnology

Faculty Of Agriculture, Mansoura University

Skills

Excel Python SQL Tableau Power BI Data Analysis Statistical Analysis Linux Bioinformatics Data Visualization Data Cleaning Dashboard Design Project Coordination English (B2)

Work Experience

Data Analysis Intern

July 2025 - Present

Digital Egypt Pioneers Initiative DEPI

  • Currently enrolled in a rigorous 6-month, 160-hour Google Data Analyst Specialist program
  • Actively developing foundational skills in Excel, Python, SQL, Tableau, and statistical analysis to prepare for data cleaning, visualization, and business problem-solving

Research Intern

Sep 2016 - Jun 2020

Advanced Lab 11, Egypt Scholars Ins.

  • Participating in a meta-analysis review that aims to find the relationship between the gut Microbiome and different gynecological cancers using bioinformatics tools
  • Collaborating in collecting data on the ovarian cancer section
  • Analyzing data with Linux

Data Science Trainee

Explore Cycle 4, Nilepreneurs

  • Earned selection among 50 students for this program from hundreds of applicants
  • Ranked among the 15 graduates who successfully completed the program from the initial 50 students

Labs Team Coordinator

Egypt Scholars Inc.

  • Optimized team workflow efficiency by analyzing 7 years of archived data
  • Developed a new data archiving system that doubled productivity
  • Created and delivered online courses with 1000+ participants

Projects

Sales Performance Dashboard

Developed an interactive dashboard to track sales performance across multiple regions, identifying key trends and opportunities for growth.

Excel Power BI SQL
View Project Details

Gut Microbiome Research Analysis

Conducted meta-analysis research exploring relationships between gut microbiome and gynecological cancers using bioinformatics tools.

Python Linux Bioinformatics
View Research Details

Data Archiving System

Designed and implemented a new data archiving system that doubled team productivity by optimizing workflow based on historical data analysis.

Excel Data Analysis Process Optimization
View Case Study

Certificates

Google Data Analytics Professional Certificate

Google (In Progress)

Comprehensive training in data analysis including spreadsheets, SQL, data visualization, and R programming.

View Certificate

Database Fundamentals

Mahara Tech (Sep 2023)

Fundamentals of database design, SQL queries, and database management systems.

View Certificate

Python Programming Basics

Mahara Tech (Feb 2021)

Introduction to Python programming, data structures, and basic algorithms.

View Certificate

My Services

Data Analysis

Transform raw data into actionable insights with comprehensive analysis and visualization.

Dashboard Development

Create interactive dashboards that help you monitor key metrics and make informed decisions.

Data Cleaning & Preparation

Clean, organize, and prepare your data for analysis to ensure accurate results.

Testimonials

"Esraa transformed our sales data into clear, actionable insights that helped us increase revenue by 15% in just one quarter. Her attention to detail and ability to explain complex data in simple terms is exceptional."

Ahmed Hassan

CEO, Retail Solutions Inc.

"Working with Esraa on our research project was a game-changer. Her data analysis skills combined with her scientific background brought valuable insights we hadn't considered. Highly recommended!"

Dr. Sarah Mohamed

Research Director, Egypt Scholars

"The dashboard Esraa created for our team has saved us hours of manual reporting each week. She understood our needs perfectly and delivered beyond our expectations."

Mona Ali

Operations Manager, TechStart Egypt

Ready to Transform Your Data into Actionable Insights?

Let's work together to unlock the power of your data and drive your business forward with data-driven decisions.