Ehab Abdalla

Hi, I'm Ehab

Software Engineer

About Me

I'm a Software Engineer who graduated with a Bachelor of Science in Computer Science from The City University of New York, Queens College in December 2024. I specialize in building backend systems, data pipelines, and full-stack applications.

Education

Bachelor of Science in Computer Science

The City University of New York, Queens College

December 2024

GitHub Contributions

View Profile
 

Certifications

  • CodePath Cybersecurity
  • CodePath Technical Interview Prep

Leadership & Interests

Organizations

  • Code For All
  • ColorStack
  • ALPFA QC
  • DICE
  • Code.ReSolve()

Interests

Other than coding and programming, I'm pretty passionate about music and playing the Guitar. Playing music has taught me patience, focus, and how to work well with others—things I value in everything I do :)

Technical Skills

Languages

7 technologies

PythonJavaC++JavaScriptTypeScriptSQLBash

Professional Experience

My professional journey in software engineering and quality assurance.

Swipe to navigate between experiences

Base Layer logo

Software Engineer

Base Layer

Visit Website
January 2025 - Present
New York, NY

Responsibilities

  • Built large-scale ETL pipelines using Python, Apache Beam, Dataflow, and Pydantic, processing 200–300 million Secretary of State records weekly, and orchestrated Airflow workflows to load those records into PostgreSQL on GCP.

  • Developed FastAPI services handling ~12k requests/day, containerized with Docker and deployed on Google Cloud VMs.

  • Designed and optimized PostgreSQL schemas with SQLAlchemy (indexes, constraints, relationships) to support ~1.2TB of SOS data, reducing average query latency from ~1.4s to ~320ms.

  • Built automated data aggregators deployed as Google Cloud Run Jobs, using Playwright, rotating proxies, subnet-based IP routing, and headless scraping to continuously collect state business data.

Skills & Technologies

Python
Apache Beam
Dataflow
Airflow
PostgreSQL
SQLAlchemy
FastAPI
Docker
Google Cloud
Playwright

Projects

Here are some of the projects I've worked on that showcase my skills and experience.

PPP Data Analyzer image 1

PPP Data Analyzer

Built a containerized ETL pipeline using Python, Docker, PostgreSQL, Playwright, Apache Beam, and FastAPI to ingest, validate, and serve PPP loan data. Designed a lightweight HTML/CSS/JS frontend served via Nginx Alpine for exploring millions of PPP loan records with fast rendering. Integrated a GPT-powered natural-language querying module that converts user questions into optimized SQL for instant data insights.

Technologies Used

PythonDockerPostgreSQLPlaywrightFastAPINginx

Freelance Projects

Custom websites designed and developed for clients with specific business needs.

Projects

Sohaib Photography Website screenshot

Sohaib Photography Website

Client: Professional Photographer

Designed and created a modern responsive photography website for a professional photographer in NYC. The website showcases the photographer's portfolio, provides information about their services, and allows clients to contact him for bookings.

Technologies Used:

Next.jsTailwind CSSTypeScriptResponsive DesignCustom Animations

Get In Touch

Feel free to contact me for any work or collaboration opportunities.

Contact Information

Location

Greater New York City Area

Send Me a Message