Niraj Pashandu

Web-Based Database Management System

Solo Full-Stack Developer at Angel Care Hospital (2023-11 – Present)

Web-Based Database Management System

• Designed and built a full-stack hospital management application end-to-end, PHP/MySQL backend through frontend UI, independently deploying it on the University of Windsor's MyWeb hosting platform.
• Diagnosed a critical booking-system failure by isolating a schema mismatch between a renamed database column and a legacy SQL INSERT statement, restoring core functionality within 2 hours.
• Enabled PHP error reporting and verified database connectivity via phpMyAdmin to systematically troubleshoot application-layer failures rather than relying on user-reported symptoms.
• Implemented secure authentication and role-based access control, protecting sensitive patient and staff records across 4 user roles.
• Owned the complete application lifecycle: development, deployment, database integration, testing, and post-launch troubleshooting, for a system supporting 10+ records/users.

Database Lead, Team Project at Patient Management System (2024-04 – Present)

Healthcare Microservices Platform

• Architected the relational database layer for a multi-user healthcare records system, designing 14 relational tables with primary key, foreign key, and CHECK constraints to enforce data integrity across patient, appointment, and staff records.
• Modeled entity relationships via ER diagramming, mapping 6 core entities to support scalable patient registration and appointment workflows alongside a team of 3 developers.
• Authored and validated SQL queries against the schema to support core CRUD operations, reducing integration errors during team testing by 20%.
• Documented the database schema, SQL scripts, and implementation process in a technical reference guide, streamlining handoff and presentation prep for the project team.
• Collaborated with teammates building Spring Boot microservices, Docker containerization, and AWS deployment to align the database layer with the system's broader architecture.

Frontend Developer, Team Project at Fashion4U (2023-02 – Present)

E-Commerce Website

• Built responsive frontend interfaces using Bootstrap's grid system and CSS media queries, ensuring consistent usability across 3 device breakpoints.
• Collaborated with a team of 4 to integrate frontend components with a PHP/MySQL backend, supporting account creation, product ratings, and persistent cart/wishlist functionality.
• Diagnosed and resolved XAMPP server configuration issues and UI/navigation bugs pre-deployment, preventing 3 launch-blocking defects.
• Partnered cross-functionally to launch an end-to-end e-commerce platform spanning account management, shopping cart, and catalog systems.

Bachelor of Computer Science in Computer Science – University of Windsor (2024-05)