Projects using SQL in PunjabProjects using SQL in Punjab| Enterprise School Management & Digital Assessment System |
Developed and enhanced an enterprise-grade, scalable School Management System designed to streamline academic operations, digital assessments, and institutional reporting. The system was built using Angular (TypeScript) for the frontend, .NET for backend APIs, and MySQL as the database.
Key Features:
Role-Based Multi-User System
Principal dashboard for institutional insights, reports, and monitoring
Teacher portal for generating tutorials, worksheets, and assessments
Student portal for attempting quizzes, submitting responses, and tracking progress
Digital Assessment & Content Management
Tutorial and worksheet assignment to specific classes and sections
Teacher-driven paper/quiz generation and class-level distribution
Student submission workflows with evaluation tracking
Advanced Reporting & Analytics
Student Profile Reports and Master Reports with filtering (class, subject, date range)
Teacher and Student activity history tracking
Performance insights including assigned, completed, and pending work
Export functionality (PDF/Excel) for institutional reporting
Teacher Evaluation System
Configurable assessment forms for teacher performance monitoring
Structured evaluation criteria with result tracking
Complaint & Feedback Management
Built-in complaint portal with categorized tracking (received, satisfied, unsatisfied)
Transparency in issue resolution workflows
Administrative Controls
Student migration between classes/sections
Section and session management
Teacher account and class assignment management
School profile configuration and institutional settings
Learning Resources Module
Centralized access to tutorials and educational content for different classes
Scalability & System Enhancement
Refactored and optimized existing architecture for better scalability
Improved performance and modularization of features
Enhanced user experience across dashboards and workflows SPECTR – Centralized Real Estate Data Intelligence Platform
SPECTR is a centralized data repository platform developed for Stewart Title to unify and provide intelligent access to large-scale property and title data across the United States. It aggregates over 25 million Owner and Lender title policies along with comprehensive data on 140+ million parcels, covering nearly the entire U.S. population.
The platform enables users to efficiently access, analyze, and retrieve critical real estate information including property characteristics, ownership details, addresses, and title policy records. By consolidating fragmented datasets into a single system, SPECTR empowers teams to perform faster research, gain deeper insights, and make more informed, data-driven decisions.
Core Features:
• Centralized repository for 25M+ title policies and 140M+ property records.
• Property data lookup including ownership, address, and parcel details.
• Physical characteristics and attributes of real estate assets.
• Owner and lender title policy information access.
• Unified search and data retrieval system.
• High-scale data aggregation and management.
• Support for real estate research and decision-making workflows.
• Enhanced data visibility across U.S. property records.
My Role:
• Validated data integrity across 25M+ title policies and 140M+ property records using Snowflake, ensuring accuracy within a platform covering 99.9% of the U.S. population.
• Performed API and database validation to verify accurate data synchronization and retrieval across large-scale property and title datasets.
• Executed functional, regression, integration, and data validation testing for property search, ownership records, and title policy workflows.
• Collaborated with Agile Scrum teams to identify and resolve defects early, improving release quality and platform reliability.
• Delivered Sprint Review demonstrations to stakeholders, showcasing completed features and validating business requirements before release. 
