Freelance Developer — Platform Migration + Stabilization

Security Intelligence Platform™ (SIP™) Freelance Developer Brief — Platform Migration, Ownership & Stabilization Engagement Type: Fixed Price (Milestone Based) Duration: 3–4 Weeks Location Preference: India (IST overlap required) About the Platform Security Intelligence Platform (SIP™) is a live B2B SaaS platform available at: securityintelplatform.com SIP™ is a structured security diagnostic platform designed for Indian corporate security professionals. Users complete a structured assessment covering ten security domains. The platform evaluates responses, generates scores, applies business rules, invokes an LLM for narrative insights where required, and produces an intelligence report. The platform is already feature complete. This engagement is not for building a new product. The objective is to migrate the existing platform into infrastructure fully owned and controlled by the client, eliminate platform dependencies, fix known defects, and stabilize it for public launch. Ownership Requirement The completed platform must have zero dependency on any proprietary AI development platform or no-code platform. After completion, the client must have full ownership and control of: Source code Git repository Hosting Database Authentication APIs Deployment pipeline Domain Infrastructure Environment variables Documentation The application should be maintainable by any competent React and Supabase developer without requiring any third-party development platform. Current Technology Stack Frontend React TypeScript Tailwind CSS shadcn/ui Backend Supabase PostgreSQL Authentication Edge Functions (Deno) LLM Anthropic API Hosting Existing hosting to be migrated Domain securityintelplatform.com Target Architecture Frontend Existing React codebase No functional rewrite Only changes required for removing platform dependencies Hosting Vercel or another industry-standard hosting platform approved by the client Backend New Supabase project located in Mumbai (ap-south-1) AI Integration Direct Anthropic API integration from Edge Functions No middleware AI platforms No gateway services No platform-specific SDKs Source Control GitHub repository owned entirely by the client CI/CD GitHub to Vercel automatic deployment Milestone 1 — Migration (35%) Deliverable Platform running identically on the new infrastructure with no visible user changes. 1. Git Repository Import the exported codebase into a clean GitHub repository owned by the client. Configure: main branch development branch proper .gitignore README no secrets committed 2. New Supabase Project Create a new Supabase project in Mumbai. Recreate: database schema migrations RLS policies triggers functions indexes storage authentication Migrate all existing production data. Configure all required secrets. 3. Hosting Deploy to Vercel. Configure: environment variables domain SSL redirects Cut over securityintelplatform.com to the new deployment. Acceptance Criteria Domain loads from Vercel Database runs from Mumbai region Complete user journey works Zero dependency on previous hosting platform No previous platform branding anywhere Milestone 2 — Bug Fixes (40%) Bug 1 Critical Report not appearing after 120-second countdown. Developer should verify the existing diagnosis before implementing the fix. Expected outcome: report_ready status updated correctly report_ready_at timestamp stored report appears automatically after countdown timer always completes before navigation Acceptance Five consecutive successful tests. Bug 2 Critical Email OTP interface expects six digits while backend delivers eight digits. Update: OTP length UI validation messaging Acceptance Eight-digit email OTP works successfully. Bug 3 High Priority Replace existing Google authentication implementation with native Supabase OAuth. Acceptance Google sign-in works without any legacy authentication code. Bug 4 High Priority Implement mobile phone OTP authentication. Requirements Indian mobile numbers +91 prefix SMS OTP Mobile login shown as default option Existing email login retained Acceptance Successfully tested using two real Indian mobile numbers. Bug 5 Medium Priority Remove the manual "Build My Report" feature from all non-admin screens. Reports must generate automatically. Acceptance No report generation button visible for standard users. Milestone 3 — Stabilization & Handover (25%) 1. End-to-End Testing Execute the complete production workflow ten consecutive times. Fix all defects identified. 2. Mobile Testing Validate the platform using a real Android device. Correct: layout scrolling responsiveness touch interactions 3. Edge Function Logging Implement structured logging. Every log entry should begin with [SIP] No silent failures. 4. Documentation Provide .env.example deployment guide database migration guide architecture overview troubleshooting guide 5. Knowledge Transfer Conduct one recorded 30-minute handover session covering deployment rollback Edge Function logs database access report troubleshooting Acceptance Criteria Ten successful production test runs Mobile testing completed Structured logging implemented Documentation delivered Knowledge transfer completed Budget Milestone Payment Migration 35% Bug Fixes 40% Stabilization 25% Total Budget: ₹10,000 Fixed Price What We Provide Complete exported codebase Existing database access Domain DNS access Technical brief Kickoff meeting WhatsApp communication during engagement Written acceptance criteria What We Expect Before starting Review and validate every bug diagnosis Identify risks Provide a day-by-day Week 1 implementation plan Highlight any unclear scope before development begins During the project Daily five-line status update Immediate escalation of blockers No unapproved scope expansion Mandatory Skills The developer should have practical experience with React TypeScript Supabase PostgreSQL Supabase Authentication Supabase Edge Functions Deno GitHub Vercel SQL migrations Row Level Security Production debugging Applications Will Be Rejected If They recommend rebuilding the platform instead of stabilizing it. They have no production experience with Supabase Edge Functions. They cannot demonstrate diagnosing and fixing a production issue. They propose moving the platform to another framework without justification. They introduce new platform dependencies that reduce client ownership. How to Apply Please send exactly these three items. 1. Describe one real Supabase Edge Function issue you diagnosed and fixed. Include the symptom your diagnosis the final solution A short paragraph is sufficient. 2. Summarize your experience with React TypeScript Supabase Authentication Edge Functions Vercel deployments 3. Provide your fixed-price quote earliest available start date i dont want dependence on any AI platform Applications missing any of the above will not be reviewed. Security Intelligence Platform™ Structured. Intelligent. Practicable. securityintelplatform.com