Abhishek Panchal

Full Stack Developer  ·  Data Science & Applications

Summary

Results-driven 3rd-year B.S. student in Data Science & Applications at IIT Madras with hands-on experience building full-stack web applications. Developed production-quality systems using Flask, SQLAlchemy, Redis, and Celery. Proficient in Python, JavaScript, and SQL. Actively solving DSA problems on LeetCode. Passionate about scalable, data-driven software solutions across backend, frontend, and ML domains.

Projects
Placement Portal Jan 2026 – Apr 2026
Flask · SQLAlchemy · Flask-Security · Redis · Celery · React.js · SQLite
  • Engineered a multi-role placement management system (Student, Company, Admin) with role-based access control using Flask-Security-Too and JWT authentication.
  • Built role-gated REST APIs using Flask-RESTful supporting full CRUD on placement drives, applications, and student profiles.
  • Integrated Celery + Redis for async background tasks: automated daily reminder emails and monthly placement reports via SMTP.
  • Implemented Flask-Caching to reduce repeated DB calls on high-traffic endpoints.
  • Designed real-time eligibility engine validating CGPA, branch, year-of-study, and backlogs before allowing students to apply.
  • Built a React.js frontend with dedicated Admin, Student, and Company dashboards with dynamic routing and component-based architecture.
EasyPark – Vehicle Parking App Jul 2025 – Aug 2025
Python · Flask · SQLAlchemy · SQLite · Jinja2 · CSS · JavaScript
  • Built a full-stack parking management system with Admin and User portals supporting real-time spot booking, release, and occupancy tracking.
  • Designed a normalized relational schema (User, ParkingLot, ParkingSpot, Reservation) with cascade delete and ORM relationships using SQLAlchemy.
  • Implemented session-based authentication, dynamic form handling, and flash messaging for a clean user experience.
  • Created an admin analytics dashboard with visual spot-occupancy summaries across multiple parking lots using Chart.js.
  • Handled edge cases: duplicate lot detection, occupied-spot protection, and booking conflict resolution to ensure data integrity.
Education
IIT Madras
B.S. in Data Science & Applications
3rd Year  |  CGPA: 7.31
2023 – Present
Skills
Languages
PythonJavaScriptSQLHTML/CSS
Frameworks
FlaskFlask-RESTfulFlask-SecuritySQLAlchemyReact.jsJinja2
Databases & Infra
SQLiteRedisCelery
Concepts
REST APIRBACMVCAsync TasksORMEmail AutomationCaching
Tools
GitPandasNumPyMatplotlib
DSA & Problem Solving

LeetCode Progress: 36% overall completion

Arrays · Strings · Linked Lists · Trees · Hashing · Two Pointers · Sliding Window

Relevant Coursework

Database Management Systems
Data Structures & Algorithms
Python Programming
Statistics for Data Science
Machine Learning Foundations
Software Engineering