FMCG Operations System Development

I need a team to build one unified custom web system across three modules — one codebase, one PostgreSQL database, one team. A separate developer handles delivery and order management. Your system connects to theirs via two API endpoints only. Module 1 — Factory & Activations Manufacturing traceability from raw materials to finished goods. QC quarantine workflows. Batch production records with live formula tolerance checking and camera integration. Dual staff confirmation on all stock movements. Field activation management — ambassador stock assignment, mobile logging form, Pesapal reconciliation, commission calculation. Module 2 — Business Intelligence Owner-only financial layer — COGS, margins, supplier confidentiality enforced at database level. Social media content calendar. Media agency and production studio management. Influencer tracking. Owner-initiated WhatsApp and SMS broadcasts. Weekly automated financial report to owner email every Monday. Module 3 — Retail Stores Mall-based stores. Card machine and M-Pesa integration — no cash. Daily stock counts. Till reconciliation that blocks close if payments don’t match sales. Commission pool from verified sales only. GPS-logged sampling forms. Customer WhatsApp and SMS within 60 seconds of purchase with satisfaction rating and reorder button. Mystery shopper management. Risk intelligence with auto-suspend on critical risk. 15-minute owner daily dashboard. Tech Stack Required PostgreSQL with Row Level Security · Laravel or Node.js · React · Unified SSO · PWA · Offline mode for all field forms · GPS geofencing · Daily offsite backups · Africa’s Talking for SMS · SendGrid or AWS SES for email Not In Scope Order management and delivery — handled separately. No customer-facing app. No accounting software. Full 18-section brief and interactive UI prototypes shared with shortlisted candidates after screening questions are answered. SCREENING QUESTIONS 1. Show previous work in at least two of: manufacturing traceability, retail/POS systems, or BI dashboards. Share links and describe your specific role. 2. How would you design PostgreSQL Row Level Security policies so a factory worker, Store Manager at Store 1, Store Manager at Store 2, and the owner each see only their permitted data — enforced at database level, not application layer? Give a concrete policy example. 3. How would you implement the batch record formula tolerance check — specifically what happens at the database and API layer when a weight is out of range and how do you prevent submission without a supervisor override? 4. How would you implement till reconciliation so a Store Manager cannot close the day if card machine total plus M-Pesa deposits don’t match system sales — and what happens when a variance is detected? 5. How would you make the owner financial layer completely inaccessible to all other roles at the database level — and what happens if someone bypasses the application and queries the database directly? 6. Provide a realistic timeline across all three modules, stating what is testable at the end of each phase, and describe how you would coordinate the two API connections with the delivery system developer.