Construction Integrity Engine — Real Estate AI System

!DOCTYPE html> Construction Integrity Engine | Real Estate AI | Mahadev Mukherjee
Live Case Study · Real Estate AI · Rust + PostgreSQL

Construction Billing Fraud
Was Costing Crores.
I Built the System That Stops It.

A production-grade Rust/Axum system that tracks boundary wall construction across 120+ plots, detects contractor billing fraud in real time, and auto-credits shared walls. Built for a leading real estate developer in West Bengal. Live. Deployed. Running daily.

120+
Plots Tracked Live
₹0
Fraud Billing Paid Since Deployment
Rust
Zero Runtime Crashes
100%
Audit Trail Automated

Real Estate Developers Lose Crores
to Contractor Billing Fraud.

In large construction projects, contractors bill for the same wall twice — once for each adjacent plot. Without a system tracking shared walls, developers pay double. Manual spreadsheets cannot catch this. I built a system that does.

📋

Double Billing on Shared Walls

Two plots share one wall. Contractor bills both plots for the same wall — pocketing double payment. Impossible to catch manually across 100+ plots.

📊

No Real-Time Progress Tracking

Developers have zero visibility into which walls are done, which are pending, and what percentage of the project is complete — until it’s too late.

🔍

Zero Audit Trail

Manual records can be edited silently. No timestamp, no history, no accountability. A single corrupt entry can misrepresent lakhs in billing.

6 Core Features That Make
Fraud Technically Impossible.

The Construction Integrity Engine runs on Rust — the fastest and most memory-safe systems language — with PostgreSQL for bulletproof data integrity.

Core Engine

Automatic Fraud Detection

Database-level trigger catches billing fraud before it’s recorded. If a contractor tries to bill a shared wall twice — the system blocks it instantly with a FRAUD_ALERT flag.

Smart Billing

Shared Wall Auto-Credit

When two plots share a wall, the system automatically splits credit between both contractors — no manual calculation, no disputes, no overpayment.

Dashboard

Manager Real-Time View

Live dashboard showing project progress %, certified amounts, material consumption by category, and True Total Length across all 120+ plots.

Security

PIN-Gated Edit Controls

Ledger corrections require manager PIN authentication. Every edit is logged with before/after values in a full audit trail. No silent data changes — ever.

Reports

One-Click CSV Export

Complete billing reports, material consumption summaries, and contractor performance data — downloadable as CSV in one click. Accountant-ready.

Evidence

Photo Upload + Approval

Contractors upload photo proof of completed work. Manager approves or flags before payment is certified. Stored directly in PostgreSQL — no third-party dependency.

Built on Production-Grade Infrastructure.

Every technology choice was made for performance, reliability, and zero runtime failures.

Rust Axum 0.7 PostgreSQL 18 Railway.app SQLx 0.7 Tokio Async GitHub Codespaces Tower HTTP Serde JSON BYTEA Photo Storage DB-Level Triggers Cookie Auth Gate

From Spreadsheet Chaos
to Live Production System.

01

Project + Site + Plot Hierarchy

Built the core data model: Projects → Sites → Plots with full boundary wall tracking (North/South/East/West) and automatic perimeter calculation.

02

Contractor Billing Engine

Built the contractor ledger system with work logging, photo upload, material consumption tracking, and certified amount calculation per running foot.

03

Fraud Detection Trigger

Built database-level fraud detection trigger that catches double-billing on shared walls before payment is approved — with automatic FRAUD_ALERT flagging.

04

120+ Plots Onboarded from Site Plan PDFs

Used PyMuPDF to extract plot data from site-plan PDFs. Inserted 120+ plots across 16 blocks with verified N/S/E/W dimensions and complete shared-wall mapping.

05

Security + Full Audit Trail

Added login gate, PIN-gated ledger edits, complete edit history logging, monthly progress views, and manager approval workflow. Zero blind spots.

🔐

Live System — Password Protected

This system is running live with real construction data. Access is restricted to protect client confidentiality.

Request access credentials via the button below — demo available for serious inquiries.

Running Your Real Estate Business
on Spreadsheets?

If your construction project needs fraud-proof contractor billing, real-time progress tracking, and a complete audit trail — I build the Rust/AI systems that make it happen.

Book Free Audit Call →