Navjot Singh Dhawan

Designed and developed a feature-rich fintech application offering a comprehensive suite of payment and financial services. Led database schema design and implemented query optimization strategies, resulting in a significant reduction in query execution times and improved system performance.
Undertook a comprehensive codebase redesign and refactoring initiative, enhancing code maintainability, scalability, and overall software quality, which received positive feedback from the development team. Assumed the pivotal role of managing production support, swiftly addressing critical issues and minimizing downtime to ensure seamless and reliable service delivery.
Tech Stack: ReactJS, NodeJS, ExpressJS, PostgreSQL, AWS, Web-Sockets, Firebase

Created an all-inclusive music education app catering to both students and teachers, enabling seamless assignment management, progress tracking, and an immersive learning experience. Led the end-to-end system and architecture design for the backend of the music education app. Worked on defining the overall structure and components of the system to ensure scalability and flexibility. Designed and implemented the APIs necessary for the app's functionality, enabling seamless communication between the frontend and backend.
Designed a robust and efficient database schema to store app data, accommodating various aspects of music education, such as assignments and student progress tracking.
Tech Stack: ReactJS, NodeJS, ExpressJS, PostgreSQL, Hasura, Graphql, Gluestack

Developed a sophisticated 'Data Insights Bot' that leverages data analytics to generate comprehensive reports, providing actionable suggestions and valuable insights from processed data. Streamlining decision-making and data-driven strategies. Designed and implemented data integration mechanisms to seamlessly collect and ingest data from various sources, ensuring data completeness and accuracy.
Designed and implemented the backend APIs that facilitated communication between the frontend user interface and the analytical engine, enabling users to request specific reports and insights. Set up monitoring and maintenance routines to proactively identify and address issues, ensuring the system's reliability and availability.
Tech Stack: ReactJS, NodeJS, NestJS, MySQL s

Developed a comprehensive 'Railway Tender Portal' facilitating the submission, review, and approval of railway tender contracts. Streamlined the intricate process of contract approval, providing a secure and efficient platform for railway authorities and legal approvers. Engineered workflow automation processes that guided contract submissions through various stages of approval, facilitating seamless collaboration among railway authorities and legal approvers. Implemented robust user authentication and authorization mechanisms to ensure secure access and appropriate permissions for different user roles, such as railway officials and legal reviewers.
Designed and developed backend APIs that facilitated seamless communication between the frontend user interface and the backend, enabling users to submit, track, and review tender contracts. Established monitoring and maintenance routines to proactively identify and address issues, ensuring the portal's reliability and availability.
Tech Stack: ReactJS, NodeJS, ExpressJS, PostgreSQL, AWS, Nginx

Developed a user-friendly Computer Hardware Issue Assessment System that empowers users to submit hardware problems for expert evaluation. The system intelligently assesses issues, providing recommendations for either repair or replacement, streamlining computer maintenance decisions. Led the design and implementation of the backend APIs, enabling seamless communication between the user interface and the system's core functionalities.
Designed and maintained a well-structured database schema to store user submissions, hardware issue details, and diagnostic results. Engineered algorithms for intelligent hardware issue assessment, allowing the system to accurately determine whether a hardware problem was repairable or necessitated replacement. Designed and integrated a warranty validation feature that allowed users to validate their warranty status using proof of purchase information.
Implemented validation checks to ensure warranty claims were accurate and aligned with the provided documentation. Worked closely with cross-functional teams to align the project's development with user needs, warranty policies, and overall project objectives.
Tech Stack: ReactJS, NodeJS, ExpressJS, PostgreSQL, AWS, Nginx s