👋 Hi — I’m Esmail Ebrahim Hamza

Systems Analyst & Full-Stack Developer @ XAIR Informatics
🎓 B.Sc. Information Systems, Sana’a University ’24
📍 Sana’a, Yemen • 📧 esmailebraheem771@gmail.com
LinkedIn • https://github.com/EsmailEbrahim

---

🔭 About Me

I build and operate reliable full-stack systems with a focus on Frappe/ERPNext, modern JavaScript front-ends (Vue.js + Tailwind), and scalable data infrastructure. I enjoy applying DevOps practices (Docker, GitHub Actions) and time-series technologies (TimescaleDB) to improve reliability, observability, and delivery velocity.

---

💼 Current & Recent Work

Systems Analyst & Developer — XAIR Informatics

Nov 2023 – Present

• Implemented TimescaleDB for time-series warehousing and optimized temporal queries.
• Containerized services and standardized environments using Docker & Docker Compose.
• Automated CI/CD and maintenance tasks with GitHub Actions (e.g., automated DB schema dumps and DBML/ERD artifact generation).
• Enforced multi-tenant security using PostgreSQL RLS and set tenant context from backend services.
• Managed PostgreSQL (schema design, backups/restores) and administered via pgAdmin4.
• Deployed and maintained Django, Vue.js, FastAPI apps on Contabo Ubuntu servers; configured Nginx and firewall rules.
• Built BI reports & dashboards (dbt, Metabase, Frappe Insights) and documented DB schemas with DBML.

Remote Developer (Contract) — Ebkar Technology & Management Solutions (Frappe partner)

Apr 2025 – Sep 2025 (Remote)

• Delivered feature development, bug fixes, and version upgrades across POS UI and custom Frappe apps.
• Implemented front-end features using Vue.js + Tailwind CSS and fixed cross-version migration issues.
• Collaborated remotely via Git, performed code reviews, and followed task-based delivery.

Freelance — Restaurant POS & Surveillance Systems

Nov 2024 – Mar 2025 (POS) · Sep 2021 – Present (Surveillance)

• Architected a multi-branch restaurant POS using Frappe & Vue.js (real-time order entry, table management, inventory, sales analytics).
• Programmed, installed, and maintained commercial surveillance camera systems.

---

🚀 Featured Projects

• PSA (Postgraduate Studies Admin System) — Graduation project using Frappe for postgraduate workflows. ▶️ https://github.com/EsmailEbrahim/psa
• Restaurant POS — Multi-branch point-of-sale system (Frappe + Vue.js).
• Custom ERPNext Apps — Domain-specific modules and reports for XAIR Informatics.

---

🛠️ Skills

Languages & Frameworks
Python · JavaScript · Vue.js · Tailwind CSS · Frappe / ERPNext · Django · Flask

Databases & Data Engineering
PostgreSQL · TimescaleDB · PostgreSQL RLS · DBML · SQL · pgAdmin4

DevOps & Deployment
Docker · Docker Compose · GitHub Actions · Nginx · Contabo (Ubuntu server provisioning)

BI & Reporting
dbt · Metabase · Frappe Insights · SQL-powered dashboards

Tools & Processes
Git · Postman · Taiga (Scrum) · Trello · CI/CD · ERD / UML / DFD

---

🎓 Education

B.Sc. Information Systems, Sana’a University (Oct 2020 – Aug 2024)

• Graduated with distinction (GPA: 92.02%)
• Graduation Project: Postgraduate Studies Administration System (PSA) — https://github.com/EsmailEbrahim/psa

---

📜 Certifications

• Frappe Framework Training Bootcamp — FCIT, Sana’a University (2023–2024)
• Web Development with Django & Flask — Technical Leaders College (2023)
• Python Basics — Technical Leaders College (2023)
• Computer Networks & Network Security — Mahara Tech (2022)

---

📊 GitHub Stats

---

🤝 Let’s Connect

• 📧 esmailebraheem771@gmail.com
• 💼 https://www.linkedin.com/in/esmailhamza/
• 🌐 Portfolio: https://esmail-hamza.onrender.com

Open to remote contracts and collaboration — feel free to reach out!