eCommerce App

Description

Integrated SQL Server LocalDb and Azure-based SQL Server, ensuring reliable data management and scalability across both development and production environments.
Crafted complex SQL queries to manage and display orders, order line items, and product data efficiently, ensuring high performance and responsiveness of the database operations.
Documented the development process and debugging steps using Google Chrome’s developer tools, improving maintainability and providing valuable insights for future enhancements.
Deployed the application on Azure PaaS, optimizing for performance and reliability, and ensuring a scalable solution for growing user demand.
Conducted rigorous testing phases, including SQL data manipulation and front-end interactions, to ensure all functionalities met operational standards and user expectations.

Implemented comprehensive product management functionality, allowing dynamic updates to product details such as MSRP, quantity on hand (QOH), and quantity on backorder (QOB) directly through SQL Server Object Explorer.
Engineered user authentication and registration processes with thorough input validation to enhance security and user experience, preventing the entry of invalid data during user registration and login.
Developed a cart functionality that supports multiple product selections and quantities, integrating session storage to maintain cart state across user sessions for a consistent shopping experience.
Enabled real-time mapping of branch locations using TomTom Map APIs, providing users with geographical insights and enhancing the utility of the platform.