Projects @ Svaapta IT-ALLY Solutions

Projects

Portfolios

Projects at Webbrains Technologies Freelance Projects

Tutor Doctor

Tutor Doctor is a leading personalized tutoring service that offers one-on-one, in-home, and online tutoring for students of all ages. The platform provides customized learning plans across various subjects, helping students improve their academic performance through personalized instruction.

Key Features
  • Real-time match schedules.
  • Secure and user-friendly ticket booking system
  • Admin panel for managing matches and events
Technology Stack
  • Backend: Admin panel built using PHP, SuiteCRM, and MySQL.
My Role in the Project

As a Back-End Developer, I contributed to enhancing the platform's performance, reliability, and overall functionality. My key responsibilities included:

  • Complex SQL Query Optimization & Reporting
    • Developed and optimized complex SQL queries for generating detailed reports, ensuring efficient data retrieval and analysis.
    • Implemented customized reporting solutions, allowing the management team to track student progress, tutor performance, and financial insights.
  • Test Case Development & Quality Assurance
    • Designed and wrote test cases to ensure thorough testing of new features, reducing post-deployment bugs.
    • Worked on unit and integration testing, ensuring that all critical components functioned correctly before release.
  • Pre-Production Bug Fixing & Optimization
    • Identified and resolved pre-production bugs, enhancing overall system stability before deployment.
    • Worked on performance optimizations to improve loading times and ensure a seamless user experience.
Skills Used:
PHP Laravel JavaScript jQuery Ajax MySQL HTML/CSS Bootstrap GIT REST APIs API Development
How My Work Has Helped the Site
  • Optimized SQL queries, reducing report generation time and improving database efficiency, leading to faster data insights.
  • Writing test cases helped catch and prevent critical bugs, leading to a more reliable platform with fewer unexpected issues post-release.
  • Addressing pre-production issues ensured a smooth user experience, minimizing disruptions for students, tutors, and administrators.