Shashi Kant Verma

Project: School Management System Project: CSA Standard Activities Project: Media Mob Project: NHL Gamification

Description:
A web application designed to streamline administrative tasks for schools, providing efficient access to information for administrators, teachers, students, and parents.

Tech Stack: Nest.js (Backend), React (Frontend), MSSQL (Database)

Key Responsibilities:

• System Architecture: Designed backend architecture, including database schema and API structure.
• API Development: Built RESTful APIs using Nest.js for authentication, data retrieval, and manipulation.
• Database Management: Managed MSSQL, including schema creation, data migration, and performance optimization.
• Security Implementation: Integrated JWT authentication & authorization for secure API access.

Description:
A centralized platform for managing and streamlining postings within the CSA Group, enabling efficient content creation, editing, and collaboration.

Tech Stack: Nest.js (Backend), MSSQL (Database), SSO Integration

Key Responsibilities:

• System Architecture: Designed backend structure, API endpoints, and external service integrations.
• API Development: Built RESTful APIs using Nest.js for authentication, posting management, and data handling.
• SSO Integration: Implemented single sign-on (SSO) for secure user authentication.
• Database Management: Managed MSSQL, including schema design, migration, and performance optimization.
• Automations: Developed cron jobs for scheduling and automating content transitions (Draft → Publish/Expire).
• Security & Access Control: Implemented role-based authentication & authorization for secure data access.

Description:
An online platform connecting clients with companies for project outsourcing, bidding, and management, similar to Upwork.

Tech Stack: Strapi.js (Backend), MSSQL (Database), SSO Integration

Key Responsibilities:

• System Architecture: Designed backend structure, API endpoints, and external service integrations.
• API Development: Built RESTful APIs using Strapi.js for authentication, user profiles, and proposal management.
• Database Management: Managed MSSQL, including schema design, migration, and performance optimization.
• Chat Feature: Developed chat API for real-time communication between clients and companies.

Description:
A prediction and rewards platform for NHL fans to predict match outcomes, earn points, and compete on leaderboards updated weekly, monthly, and overall.

Tech Stack: Next.js (Backend), PostgreSQL (Database), WebJobs

Key Responsibilities:

• Database Management: Designed and optimized PostgreSQL schemas, queries, and relationships for efficient data handling.
• API Development: Built RESTful APIs using Next.js for user rewards, leaderboards, and pick submissions.
• Data Caching: Implemented weekly caching to reduce database load and improve performance.
• WebJobs Automation: Developed web jobs to update game results, leaderboards, and rewards dynamically.