Tag: Real Estate

  • Request Management System for Real Estate Developer

    Request Management System for Real Estate Developer

    Request Management System for Real Estate Development

    NestJS • TypeScript • Supabase • Email Automation

    About the Project

    A web application for the real estate development industry enabling digitalization and automation of the client request handling process. The system replaced a manual paper-based process, reducing processing time and eliminating errors.

    Industry: Real Estate Development
    Technologies: NestJS, TypeScript, Supabase, EJS, Tailwind CSS
    Timeline: 2025
    Status: Deployed, running in production

    Business Challenges

    The client needed a solution to:

    • ✅ Digitalize the request submission process from end clients
    • ✅ Automatically calculate costs based on a price list
    • ✅ Manage communication between technical department and clients
    • ✅ Track request status in real-time
    • ✅ Generate and send documentation via email

    Technical Solution

    Backend:

    • NestJS 10.x with TypeScript – modular architecture
    • Supabase – PostgreSQL database + storage
    • Multer – file upload handling (up to 10 attachments, 15MB/file)
    • Automatic filename sanitization (Polish character support)

    Frontend:

    • EJS templates – server-side rendering
    • Tailwind CSS – responsive design
    • Dynamic forms with live quote preview
    • Client-side and server-side validation

    Key Features:

    • 📋 Submission form with dynamic request builder
    • 💰 Automatic pricing based on price list (23% VAT)
    • 📎 Multi-file upload with format and size validation
    • 💬 Communication system: client ↔ technical department
    • 📧 Automated email notifications (transactional + alerts)
    • 🔐 Admin panel with authentication
    • 📊 Dashboard with statistics and filtering
    • ✏️ Quote editing with manual price adjustments
    • 🔗 Unique client links (token-based access)
    • 📱 Responsive design (mobile-first)

    Key Achievements

    Performance & Reliability:

    • ⚡ Railway deployment with automatic CI/CD
    • 🔄 Hot reload in development
    • 📈 Scalable architecture
    • 🛡️ Error handling and edge cases

    Business Impact:

    • 📉 ~70% reduction in request processing time
    • ✅ Eliminated calculation errors
    • 📧 Automated email communication
    • 📊 Full process transparency for clients
    • 💾 Centralized database for all requests

    Technical Highlights:

    • 🐛 Debugging and fixing critical bugs (file upload limits, timezone handling)
    • 🔧 Multer configuration optimization for multi-file uploads
    • 🌍 Proper timezone handling (Europe/Warsaw)
    • 🔤 Filename sanitization (NFD normalization for Polish characters)
    • 📝 Workflow status implementation (6 request states)

    Technology Stack

    Backend:
    - NestJS 10.x
    - TypeScript 5.x
    - Supabase (PostgreSQL + Storage)
    - Express Session
    - Nodemailer (SMTP)
    
    Frontend:
    - EJS Templates
    - Tailwind CSS
    - Vanilla JavaScript
    - DataTransfer API
    
    DevOps:
    - Railway (hosting + CI/CD)
    - Git/GitHub
    - npm scripts
    

    Results

    Delivered a fully functional system supporting the complete request lifecycle – from client submission, through technical analysis, to final quote acceptance.

    The application streamlined internal processes, increased client satisfaction through transparency and speed, and eliminated errors from manual calculations.

    The system is in production, handling real client requests for a real estate development company.

    Scope of Work

    • ✅ Business requirements analysis
    • ✅ System architecture design
    • ✅ Full-stack development (backend + frontend)
    • ✅ Email service provider integration
    • ✅ Debugging and performance optimization
    • ✅ Deployment and monitoring
    • ✅ Bug fixing and feature development
    • ✅ Technical documentation

    Get in touch to discuss a similar project for your company.

  • Automated CRM platform for real-time payment monitoring and debt collection

    Automated CRM platform for real-time payment monitoring and debt collection

    Overview
    A custom CRM backend enabling real-time payment monitoring, automated client reminders, and streamlined debt collection for a real estate development company.

    Client

    • Country: Poland

    • Industry: Real estate development

    • Type: Enterprise SME

    • URL: sovo.dev

    Challenge
    “Our finance team was spending too much time reconciling bank statements, chasing overdue invoices, and manually managing client communication. We needed an automated system to monitor payments in real time and enforce consistent debt collection workflows.”

    Solution

    • Delivered a custom CRM with:

      • Real-time bank integration (PSD2-compliant API)

      • Automated detection of delayed or missing payments

      • Configurable debt collection workflows and escalation rules

      • Automated email/SMS notifications to clients

      • Payment tracking dashboard with role-based access

    • Backend: Node.js REST API, PostgreSQL schema design, secure bank API integration, event-driven debt collection engine

    • Frontend: React.js + Tailwind CSS for dashboards and reporting

    • Integrations: Bank API (Open Banking), Twilio (SMS), SendGrid (email)

    • Team: 1 backend engineer, 1 frontend engineer, 1 QA, 1 project manager

    Result

    • 75% reduction in manual payment reconciliation work

    • 40% faster debt collection cycles compared to manual process

    • 95% of overdue clients now receive automated reminders within 24 hours

    • Improved transparency with dashboards, reducing disputes and delays

    Additional Information

    • Key numbers: 1,000+ transactions monitored per month; <200 ms avg. response time

    • Technologies: Node.js, PostgreSQL, secure banking API integration, role-based access control, event-driven workflows

    Process

    • Discovery → workshops with finance/legal teams to map workflows

    • Architecture → API endpoints, workflows, permissions

    • Implementation → iterative sprints, CI/CD pipelines on AWS

    • Validation → staging with anonymized bank data, UAT with finance team

    • Go-live → gradual rollout per project, KPI monitoring

    Client Testimonial

    “The new CRM saves our finance team hours every week. Automated reminders and escalation have improved payment discipline and reduced overdue accounts.”
    — Michał Dachtera, Finance Director, SOVO Development, Media: Click the link