The Objective: Design and deploy a fault-tolerant database architecture to eliminate single points of failure, ensure zero-downtime failover, and optimize performance for mission-critical applications.
The Execution: Architected a secure 3-node PostgreSQL cluster on Linux. Configured Pgpool-II for intelligent connection pooling and read/write query routing, drastically reducing primary server load. Implemented automated health checks and failover mechanisms to ensure instant, zero-intervention replica promotion if the primary node goes down.
0
86
University Resource Hub is a full-stack lab and resource booking platform built for university environments. The system handles real-time availability tracking, conflict-free reservations, automated waitlist promotion, QR-code check-in, no-show handling, training eligibility checks, and role-based access control for students, staff, and admins. Frontend deployed on Vercel, backend on Microsoft Azure with SQL Server.
0
83
Laravel Visitor Personalization Platform
Developed a Laravel-based visitor personalization platform that delivers customized landing pages based on user behavior, traffic source, and campaign rules. The system dynamically displays targeted banners and promotional content while tracking visitor data such as device, browser, IP address, language, and conversions.
An integrated admin dashboard allows marketers to manage campaigns, define personalization rules, monitor performance, and analyze visitor engagement through real-time analytics.
1
216
An imported item’s purchase price is only part of its inventory cost. Transport and other related expenses also need to be allocated accurately.
This Landed Cost Allocation screen is part of the custom ERP import module I developed using VB.NET (http://VB.NET) and Microsoft SQL Server.
It allows users to select an import shipment receipt, allocate each expense across received items, and review the allocated total and remaining difference before finalizing.
In this example, a PKR 22,000 transport expense is distributed across three items in proportion to their base values, with no unallocated balance.
The module supports Base Value, Basic Unit Quantity, and Manual allocation methods, helping businesses handle different costing requirements within an integrated inventory and accounting workflow.
Need a similar import-costing module or an enhancement to your existing .NET business software? Let’s discuss your requirements.
#ERP #VBNet #SQLServer #InventoryManagement #LandedCost
1
1
122
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.
0
130
| 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
0
68
47 News HD - High-Traffic Media & News Portal
Engineered and deployed a dynamic, content-heavy media portal designed to handle high concurrent user traffic and rapid breaking-news updates.
Key Contributions:
Architected a responsive, clean editorial interface for real-time news delivery across desktop and mobile devices.
Optimized Core Web Vitals, dynamic asset delivery, and media caching to ensure instant page load speeds under traffic spikes.
Implemented clean content categorization (Live Updates, Politics, Business, Tech) with structured metadata for enhanced SEO reach.
Tech Stack: PHP, MySQL, JavaScript, REST APIs, Performance Optimization
0
28
