Zum Inhalt springen

    Cookie Settings

    We use cookies to provide you with the best possible experience.

    Zum Hauptinhalt springen
    Rafael Constructions – Digital Construction Infrastructure
    Client ProjectFeatured

    Complete Corporate Platform

    Rafael Constructions – Digital Construction Infrastructure

    React FrontendReact Admin-PanelAI Chatbot

    Technical Architecture

    For Rafael Constructions, we developed a comprehensive digital construction infrastructure as custom software, consolidating all of a construction company's business processes into a single integrated system. The architecture follows a headless CMS approach with a decoupled React frontend and a RESTful API layer managed via a central API gateway. The admin panel implements a component-based architecture with lazy-loaded modules for project management, client communication, and document management. An AI-powered chatbot with Natural Language Processing (NLP) provides contextual answers to customer inquiries and automatically routes qualified leads to the CRM module. The multi-tenant architecture enables the management of multiple construction projects with isolated data silos and granular access rights.

    Data Integrity & Security

    The system implements Row-Level Security (RLS) at the database level, ensuring each user can only access project-related data. All document uploads are secured by malware scanning and content-type validation. Authentication is handled via JWT-based tokens with automatic rotation and a refresh token mechanism. A complete audit log with an immutable, append-only structure ensures the traceability of all project changes. GDPR-compliant data storage with automated management of deletion periods and consent management completes the security concept.

    Scalability

    The platform utilizes edge computing for delivering static assets and server-side rendering for optimal Core Web Vitals. Database sharding by project context enables high-performance management of growing datasets. System automation includes automated build pipelines with CI/CD integration, blue-green deployments, and health check monitoring. This SaaS solution, built to a German Quality Standard, sets the benchmark for digital transformation in the construction industry—custom software that grows with the business.
    Engineering profile
    Industry
    Construction · Turnkey building
    Period
    2024 – laufend
    Role
    System architect, implementation, operations

    Problem

    The developer had no central system for inquiries, project status, documents or client communication. Leads were lost in inboxes, status updates happened over the phone, and documents were scattered across folders and WhatsApp chats.

    Baseline

    Static website without backend, manual quoting in Word/PDF, no structured customer database, no measurable conversion funnel, no audit trail on contract changes.

    Architecture

    Frontend
    Public Site (React SPA)
    Backend
    Edge Functions API
    Data
    Postgres + RLS
    Files
    Storage (Pläne, PDFs)
    Frontend
    Customer Portal
    Frontend
    Admin-Panel (CRM)
    Channel
    Email Pipeline (HTML, tracked)

    Tech stack

    Runtime
    React 18TypeScriptViteTanStack Query
    Data
    PostgresRow-Level SecurityStorage Buckets
    AI layer
    Gemini 2.5strukturierte Outputs
    Infrastructure
    Edge Functions (Deno)Cron JobsCDN-Asset-Pipeline

    Solution

    Frontend

    Conversion-focused public site with structured inquiry form, multi-step lead qualification and data enrichment before submission.

    Backend

    Edge functions for email delivery, PDF generation, GDPR-compliant unsubscribe and signed storage URLs. Stateless, idempotent, structured logs.

    Data model

    Normalized tables for leads, projects, quotes, contracts, documents, audit logs. Row-Level Security separates roles (public, customer, admin) at the DB layer.

    Customer portal

    Authenticated area for project progress, milestones, document download and direct messaging. Eliminates email ping-pong.

    Automation flows

    Trigger
    Inquiry submitted via public form
    Action
    Validation → lead insert → scoring → owner assignment → confirmation email to customer + push to admin
    Result
    Lead in CRM, customer responds in minutes, zero lost leads
    Trigger
    Quote approved by admin
    Action
    Quote PDF generated server-side → stored in bucket → signed link emailed → tracking pixel logs open
    Result
    Delivery in <3 s, visible open status in CRM
    Trigger
    Contract signed by customer
    Action
    Signature hash + IP + timestamp → audit log → project created → portal access activated → onboarding sequence triggered
    Result
    Legally sound, fully traceable contract closure without media breaks

    APIs & integrations

    ServicePurposeMethod
    Resend / SMTPTransactional and marketing emailREST
    Storage BucketsPlans, PDFs, signed URLsS3-kompatibel
    Gemini 2.5Lead classification and reply suggestionsREST + structured output
    Cron SchedulerReminders, reports, cleanupsEdge Cron

    Data flow

    Public form → edge function (validate + enrich) → Postgres (RLS) → realtime push to admin → email pipeline → tracking → reporting view.

    Outcomes & targets

    Strictly separated between verified measurements, declared targets and qualitative observations. No projections, no estimated numbers.

    Measured

    Measurement pending live operation and analysis.

    Targets (planned)
    Inquiry acknowledgement time
    Confirmation < 60 s after submit
    Note: Target for automated inbound acknowledgement.
    Lead ownership coverage
    100 % of leads with owner and status
    Note: Target: no untagged leads in the CRM.
    Observations
    Lead capture
    Every inbound lead is captured in a structured form, assigned to an owner and moves through the same status steps.
    Quote delivery
    Quotes are generated server-side as PDF, stored in a bucket and delivered via signed link. Open status is visible in the CRM.
    Document hand-off
    Plans and contracts flow through the authenticated customer portal with signed storage URLs instead of email attachments or messenger.
    Contract closure
    Signature, IP and timestamp are logged, producing an end-to-end audit trail from lead to active project.

    Outcome

    What used to be a static business card became an operational system: inquiries, quotes, contracts, projects, communication and documents run through one central architecture with clear roles, audit trails and automated hand-offs.

    Interface view

    Real admin and portal views are shown on request under NDA. Anonymised mockups can be added here via CMS.

    Technical learnings

    Designing Row-Level Security into the data model upfront is cheaper than retrofitting it later.

    Idempotent email edge functions prevent duplicate sends on retries — critical for trust.

    Per-mutation audit logs (insert/update/delete) are non-negotiable in regulated industries.

    Related Projects