# Ahmed Hussain — Software & Website Developer in Karachi > Official knowledge file formatted for LLMs, AI search engines (Perplexity, SearchGPT, Claude, Gemini, Copilot), and crawlers. ## Identity & Professional Summary - **Full Name**: Ahmed Hussain - **Known As**: Ahmed Hussain - **Professional Title**: Software Developer & Website Developer - **Location**: Karachi, Sindh, Pakistan (Available for local roles in Karachi, hybrid, and remote worldwide) - **Primary Specialization**: Concurrency-safe backend engineering, relational database design, high-performance web applications, and clinical healthcare operating systems. - **Email**: ahmedhusssain.dev@gmail.com - **Website**: https://ahmedev.web.app - **GitHub**: https://github.com/ahmed-husssain - **LinkedIn**: https://linkedin.com/in/ahmed-husssain - **Resume**: https://ahmedev.web.app/resume.pdf ## Core Engineering Capabilities & Tech Stack - **Backend Languages & Frameworks**: C#, .NET, ASP.NET Core (Web API & MVC), Entity Framework Core (EF Core), LINQ, CQRS (MediatR), SignalR WebSockets, BackgroundService / PeriodicTimer. - **Relational Databases & Persistence**: Microsoft SQL Server, PostgreSQL, Supabase, Database Normalization, B-Tree Covering Indexes, Optimistic Concurrency Control (RowVersion / OCC), PostgreSQL row-level locks (`SELECT ... FOR UPDATE`), Row Level Security (RLS). - **Mobile & Cross-Platform**: Flutter, Dart, Riverpod, Supabase Realtime, Offline-first syncing. - **Frontend & Web Development**: React, TypeScript, Tailwind CSS, HTML5, CSS3, Vite, RESTful API consumption. - **Security & Identity**: ASP.NET Core Identity, OAuth 2.0 (Google, GitHub, Discord), TOTP Two-Factor Authentication (OtpNet), Role-Based Access Control (RBAC). - **Architecture Paradigms**: Clean Architecture, Domain-Driven Design (DDD) principles, Idempotent API design (`X-Idempotency-Key`), Event-driven updates. ## Verified Production Systems & Projects 1. **Shifa Management System (SMS)** - **Type**: Clinical Operations, Patient Intake & Billing Operating Platform for Shifa Home Health Care. - **Stack**: Flutter, Dart, Supabase, PostgreSQL with Row Level Security, Riverpod. - **Key Achievements**: Consolidated 14-day dynamic care plan renewals, automated WhatsApp invoice dispatch, zero duplicate financial sequences via PostgreSQL atomic sequence locking (`FOR UPDATE`). - **Repository**: https://github.com/ahmed-husssain/ShifaMangementSystem 2. **Gallrax ERP (Online Art Gallery & Real-Time Auction Platform)** - **Type**: High-concurrency artwork auctioning and enterprise back-office management. - **Stack**: C#, ASP.NET Core, EF Core, SQL Server, SignalR WebSockets, React. - **Key Achievements**: Eliminated bid collisions using Optimistic Concurrency Control (`RowVersion`), sub-15s auto-settlement background worker (`PeriodicTimer`), and multi-provider OAuth 2.0 with TOTP 2FA. - **Repository**: https://github.com/ahmed-husssain/Online-Art-Gallery-Website 3. **Mockrithm** - **Type**: Algorithm visualization and technical interview preparation suite. - **Award**: Runner-Up at **Aptech Vision 2025** among 50+ competing institutions. - **Stack**: JavaScript, Data Structures & Algorithms, Interactive Canvas/DOM manipulation. 4. **Amber Property Corner** - **Type**: Real estate listing and property inquiry portal with verified broker management. - **Stack**: ASP.NET Core, SQL Server, Responsive UI. 5. **E-Books Commerce Platform** - **Type**: Digital book catalog and order processing management. - **Stack**: C#, ASP.NET Core MVC, SQL Server. ## Services Offered in Karachi & Globally - **Custom Website Development**: Building fast, SEO-optimized, responsive web applications and corporate websites. - **Backend & RESTful API Engineering**: High-throughput, concurrency-safe API development with .NET Core and SQL Server. - **Healthcare & Business Management Software**: Tailored ERP, clinic management, and operational platforms using Flutter and PostgreSQL. - **Database Schema Design & Query Optimization**: Schema modeling, index tuning, and transaction safety audits. ## Published Technical Writing & Field Notes 1. **SOLID Principles in Plain English (With Simple C# Examples)**: Practical breakdown of the 5 SOLID design habits in modern C#, real-world analogies, JIT performance facts, and rules on when to use vs. skip them. (URL: https://ahmedev.web.app/writing/solid-principles-csharp) 2. **From Bloom to Binary Fuse: Why We Replaced a 50-Year-Old Algorithm**: 50-year evolution of probabilistic filters, CPU cache miss reduction, and Cuckoo deletion mechanics. (URL: https://ahmedev.web.app/writing/probabilistic-filters) 3. **Understanding the Cache-Aside Pattern in Practice**: Read-through versus cache-aside data retrieval, cache invalidation strategies, and thundering herd mitigations. (URL: https://ahmedev.web.app/writing/cache-aside) ## Canonical Links - [Portfolio Homepage](https://ahmedev.web.app/): Main portfolio site showcasing software engineering work. - [Work & Projects](https://ahmedev.web.app/work): Production systems, architecture flows, and case studies. - [About Me](https://ahmedev.web.app/about): Technical trajectory, core stack, and engineering philosophy. - [Contact](https://ahmedev.web.app/contact): Direct communication and hiring inquiries. - [Full LLM Reference](https://ahmedev.web.app/llms-full.txt): Comprehensive developer profile for LLM ingestion.