Projects
Steam Game Database Visualizer (Python, SQL Server)
Python, SQL Server, Power BI — Built queries and dashboards to analyze game trends and engagement. Delivered insights on top genres, publishers, and release patterns to inform content strategy.
Google Trends Data Analyzer
Python — Integrated Google Trends to compare regional interest and market dynamics. Produced visuals and insights supporting marketing decisions.
Database Processing & Visualization
MySQL, SQLite, PostgreSQL, Power BI — Designed ETL pipelines to transfer and process data across multiple database systems. Automated data cleaning and aggregation, then visualized key metrics and trends in Power BI for business reporting.
Custom NLP Script for Data Extraction
Python, NLTK — Developed a Natural Language Processing script to extract structured data from unstructured text, enabling automated data entry and reporting for business documents.
Portfolio Website with Personalized AI Assistant Chatbot
HTML, CSS, JavaScript, OpenAI API, Firebase — Built a personal website with an integrated & Personalized AI chatbot, demonstrating web automation, API integration, and secure deployment.
Small Full‑Stack E‑commerce Demo
Node.js, TypeScript, Express, Prisma (SQLite), Zod, React, Vite, Netlify, Render — End‑to‑end demo with API (products/variants, filtering, validation, seeding, CORS) and a responsive frontend (grid, variant selection, category filter, global cart with animation, simple checkout). Solid DX (one‑command dev, smoke test), documentation (README, DEPLOYMENT, SUBMISSION), SPA routing (Netlify redirects), and environment‑driven API base (VITE_API_URL). Deployed backend to Render (migrate‑deploy) and frontend to Netlify; resolved TypeScript output paths, start commands, SPA 404s, mixed‑content, and CORS.
Public Transport Simulation Analytics
Python (PADE, Eqasim), Pandas — Processed agent-based simulation outputs and evaluated performance with F1-score, accuracy, and efficiency metrics to inform mobility planning.
Neural Network Classification (MLP)
Python, Scikit-learn — Built and evaluated a feedforward neural network with preprocessing and model validation; reported precision/recall and confusion matrix for business interpretability.
Meal Order Builder API
FastAPI, Design Patterns — Implemented Builder and Strategy patterns to construct complex meal orders; exposed endpoints for ordering and cost breakdown.
Payment Processing System
Python, SQLite — Modular payment framework with multiple strategy implementations, transaction logging, and validation.
Smart Home Remote Control
Python, OOP — Command-based interface to simulate smart home device control and automation logic.
AWS Foundational Cloud
AWS — Deployed and managed EC2 instances, configured IAM roles, and implemented basic networking and security policies.
