---

👨‍🎓 About Me

🎓 3rd-year Information Science student at Haramaya University
💡 Passionate about AI Engineering, Frontend Development and Database Systems

• ✅ Built: Ethiopian Airlines DB System – a complete relational database for flights, crew and student discounts
• 🌱 Currently learning: Python, React.js, SQL, MongoDB, AI frameworks
• 📊 Skilled in: Database Design, AI model basics, Responsive UI, JavaScript, React, TailwindCSS, CSS Animations, Flask
• 👯 Open to collaborate on: AI projects, Web Apps, SQL/MongoDB systems, Animated UI projects
• 💬 Ask me about: Python, SQL, MongoDB, JavaScript, React, AI concepts
• 🎯 Goal: Grow into an AI Engineer & Frontend Developer
• 📫 Reach me at: gemachistesfaye36@gmail.com

🌐 My Portfolio

Central hub for all my projects, skills and contact info.

• 💼 Showcase of web apps, dashboards & utilities
• 🖥️ Live demos with interactive UI
• 🛠️ Tech: HTML, CSS, JavaScript, React

▶️ Live Demo: Coming Soon 🚧 (Will be ready in a few weeks)

---

✈️ Ethiopian Airlines DB

A MySQL relational database managing flights, crew and student discounts.

• 🎓 Automated student ID discount
• 🗂️ ERD & 3NF normalization
• ⚡ Advanced SQL queries
• 🛠️ Tech: MySQL, SQL

▶️ Repo / More Info: GitHub Link 🌐

---

🛍️ Abebe-Bookstore

Responsive bookstore web app showcasing Ethiopian books.

• 📚 Browse, search, filter books
• 🖥️ Interactive UI
• 🛠️ Tech: React.js, TypeScript, HTML, CSS

▶️ Live Demo: Live Site 🌐

---

🇪🇹 Ethiopian Events Portal

Interactive portal for Ethiopian festivals with dual calendars and reminders.

• 📅 Festival schedule
• 🔔 Notifications & reminders
• 🛠️ Tech: TypeScript, HTML, CSS

▶️ Live Demo: Coming Very Soon ⚡ (Almost Ready)

---

🌱 HUEPDC Website

Haramaya University Environmental Protection & Development Club website (collaboration).

• 🌍 Responsive design for all devices
• 🎨 Modern UI with animations (Framer Motion)
• 📊 Data visualization with charts
• 📸 Image galleries and contact form integration
• ⚡ Optimized and deployed on Netlify
• 🛠️ Tech: React.js, JavaScript, HTML, CSS, Chart.js, EmailJS

▶️ Live Website: Live Site 🌐

---

📊 E-Commerce Insights Dashboard

Power BI dashboard analyzing e-commerce datasets.

• 📈 Top products, discounts & sales segments
• 🧹 Data cleaning & DAX visuals
• 🛠️ Tech: Power BI, Excel

▶️ Repo / More Info: GitHub Link 🌐

---

⏳ Age-Calculator

Calculates age in years, months and days accurately.

• 🧮 Handles leap years & month boundaries
• 🔢 Validates all date inputs
• 🛠️ Tech: JavaScript, HTML, CSS

▶️ Live Demo: Live Site 🌐

---

🛡️ Smart-PWD

Secure, local-first password generator.

• 🔑 Generates strong passwords
• 🔒 No data leaves browser
• 🛠️ Tech: JavaScript, HTML, CSS

▶️ Live Demo: Live Site 🌐

---

📝 Grade Evaluator

Python/Flask web app converting scores into letter grades.

• ✅ Enter marks → get grade output
• 🖥️ Built with Python & Flask
• 📚 Learning project

▶️ Live Demo: Live Site 🌐

---

📈 Grade Prediction System

Python/ML project predicting student grades based on historical data.

• 📊 Data preprocessing and analysis
• 🤖 Predictive modeling using Python
• 🛠️ Tech: Python, Pandas, Scikit-learn

▶️ Live Demo: Live Site 🌐

---

🏫 10-Academy-Clone

Frontend clone of 10 Academy landing page.

• 🎨 Clean, responsive design
• 🖥️ Interactive sections
• 🛠️ Tech: HTML, CSS, JavaScript

▶️ Live Demo: Live Site 🌐

---

🎓 Summer Bootcamp Projects

Collection of projects completed during the Summer Bootcamp.

• 💡 Includes mini web apps, exercises, and challenges
• 🛠️ Tech: HTML, CSS, JavaScript, Python
• 🌐 Learning-focused projects showcasing skills gained during the bootcamp

▶️ Repo / More Info: GitHub Link 🌐

🧰 Skills & Tools

💻 Languages & Frameworks

🗄️ Databases

⚡ Tools & Platforms

🚀 Currently Learning

📊 GitHub Stats