Streamline PostgreSQL Projects with Vollna

Web-only MVP for a social sweepstakes sportsbook (e.g. Fliff, Thrillz) with new added in-app purchases.

The platform allows users to make sports picks using free-to-play and promotional virtual currency (not real-money wagering).

looking for a senior full-stack developer who can own features end-to-end and help us move quickly toward MVP and public launch.

Experience with sports data, gaming, fintech, or sweepstakes mechanics is a major plus.


MVP Scope & Features
1. User-Facing
- User authentication (email + social login optional)
- User profiles & balance display (virtual coins)
- Integrate sports data APIs (odds, schedules, results)
- Develop sports pick/contest logic (pre-game & live if possible)
- Contest entries using promotional currency
- Leaderboards & basic social visibility. Bonuses and prizes for winners
- Results settlement & winnings allocation
- Implement wallet / balance tracking (non-cash)
- Top-up bonus for promotional currency. In-app store for power ups
- Must be US sweepstakes compliant

Admin
- Create/manage contests
- Control odds sources & settlement
- User & balance monitoring
- Manual overrides (MVP-level)
- Ensure performance, security, and compliance-aware architecture

Responsibilities
- Build the full web application end-to-end
- Design and implement a clean, scalable backend
- Integrate a sports data API
- Implement sweepstakes logic (free entry, promo currency, prizes)
- Build simple but effective admin tools
- Deploy to production and hand over documentation

How to Apply

Start your proposal with “SWEEP” so we know you’ve read the full listing.

Include:
- Relevant experience (links/screenshots if possible)
-How you’d approach building this MVP
- Estimated timeline to first usable version

• Describe your recent experience with similar projects

Our Foundation: From Print Authority to Digital Dynasty
For years, EXCITE Vancouver has been the undisputed, tactile guide to the city's most exclusive and discreet adult lifestyle. Our pocket-sized magazine isn't just read—it's collected. It rests in the glove compartments of luxury cars, on the nightstands of penthouse suites, and in the pockets of those who demand exceptional experiences. We have built an unassailable brand authority through:

Elite Distribution: Strategic placement in five-star hotels, VIP events, private clubs, and luxury venues.

Trusted Curation: A reputation for discovering and validating the truly exceptional—from hidden culinary gems to exclusive nightlife and premium adult entertainment.

Established Audience: A dedicated, high-net-worth following that relies on EXCITE as their passport to the city's best.

Now, we are executing our most ambitious vision: to transform this trusted print authority into the world's most exclusive digital ecosystem for elite living.

Our Vision: Building the "Nike" of Elite Lifestyle Access
We are not building another booking app or social platform. We are engineering a new standard. Just as Nike represents the pinnacle of athletic performance and culture, EXCITE will become the global symbol for exclusive access, discretionary service, and curated luxury experience.

This is a paradigm shift. We are moving from static recommendations to dynamic, real-time orchestration of VIP life. Our platform will be the invisible, indispensable layer between the world's most discerning individuals and the exceptional experiences they seek. It will be felt, not seen—a seamless extension of their lifestyle that anticipates needs, opens doors, and delivers flawless execution.

The transformation is already underway. Our existing magazine provides a powerful launchpad: a built-in audience, established partner relationships, and a brand synonymous with quality. We are now recruiting the elite founding team to architect its digital future.

Join the Founding Team: Build the Invisible Engine of Elite Life
We are assembling a compact, world-class "A-team" of founding leaders. This is not a collection of individual contributors, but a unified brain trust of experts who will collaborate intimately to build something extraordinary from first principles. You will be working alongside peers of the highest caliber, where excellence is the baseline and extraordinary outcomes are the daily expectation.

1. Founding Technical Lead / Head of Engineering
The Architect of Invisible Infrastructure

Your Mission: To design and build the mission-critical, high-performance technical foundation that makes the luxury experience feel effortless. You will architect the complex, real-time systems that power seamless member interactions, partner integrations, and concierge orchestration—all while maintaining absolute reliability and discretion.

Core Responsibilities & Systems Ownership:

Design and implement a real-time, event-driven microservices architecture capable of handling millions of orchestrated experiences with zero perceived latency.

Build the Member Preference & Anticipation Engine, a sophisticated system that learns individual behaviors to proactively serve opportunities, not just respond to requests.

Architect the Partner Integration Fabric, a unified API gateway and data sync layer that connects seamlessly with disparate external systems (POS, reservations, CRM) from luxury hotels, restaurants, and clubs.

Own the Global State & Caching Layer to ensure the app delivers a "zero-load-time," offline-capable experience, irrespective of network conditions.

Establish the Security & Privacy Core, implementing end-to-end encryption, granular permission systems, and privacy-by-design to protect our members' discreet data as our highest asset.

Expertise We Require:

10+ years of experience architecting and delivering complex, data-rich platforms (marketplaces, fintech, high-scale social) from zero to scale.

Mastery in system design for real-time applications (WebSockets, SSE, WebRTC) and high-concurrency data systems.

Deep fluency in our core stack: Node.js/Typescript or Go, PostgreSQL, Redis, GraphQL, and deployment on AWS/GCP.

Proven experience building platforms serving multiple distinct user types (e.g., consumers, business partners, internal operators) within a single, cohesive ecosystem.

A demonstrated obsession with performance metrics, observability, and system resilience. You don't just build it; you instrument it, monitor it, and ensure it never fails elegantly.

Collaboration Mandate: You will co-design the core data models with the Product Director and establish the API contracts that enable the Frontend Lead to create magical user experiences. Your partnership with the UX Director is crucial to ensure technical capabilities enable—rather than limit—design innovation.

I’m building an AI-driven assistant to streamline my real-estate workflow and I need it written entirely in Python. The assistant has three core jobs: (1) pull fresh listings, structure them, and publish them to my site; (2) chat in real time with prospects, handling follow-ups automatically; and (3) generate concise market snapshots that I can share with clients or use internally.

Data will arrive from three places—online property databases, local agency feeds, and my own CSV / manual inputs—so the code must ingest APIs and scrape when necessary, normalise everything in a single store (PostgreSQL or a lightweight alternative), and keep the dataset updated on a daily schedule.

On the front end, I want a web-based chatbot that taps into the same knowledge base. It should greet visitors, answer questions about available properties, schedule showings, and note follow-up tasks in a simple CRM table. FastAPI, Flask or Django Channels are all fine as long as conversations feel immediate and the code remains readable.

Please structure the project so I can:

• run a single setup script and have the full environment (virtualenv, dependencies) ready;
• drop new data sources in via config files rather than hard-coding;
• review well-commented Python modules for scraping, NLP (spaCy / OpenAI, whichever fits best), ranking logic, and report generation;
• deploy the chatbot UI to my existing VPS with minimal fuss.

Hand-off items will include the complete repo, a short loom/video walkthrough, and clear instructions for scheduling the sync jobs on Linux cron.

If you’ve connected property APIs before or built chatbots that actually convert, your experience will shine here.

Skills: Python, Web Scraping, Django, Software Architecture, Web Development, Flask, Chatbot, FastAPI

We are taking over an existing Yii2 + Node.js backend project and need a technical review of the current codebase.

This is not feature development. The goal is to validate structure, APIs, standards, and readiness for future automation and MCP server integration.

The repository is already documented with auto-generated technical documents, but we need code-level verification.

You will:

1. Set up the repository locally (no production DB access)
Install PHP & Node dependencies
Review config, env structure, build scripts

2. Validate backend structure
Identify Yii2 modules
Explain application architecture and boundaries

3. API inventory
List all REST API endpoints
Group by module/service
Note auth, versioning, and patterns

4.Standards & quality review
Check PSR-12 adherence
Identify static analysis / linting / tests
Review CI/CD configs (if present)

5.Architecture assessment
Separation of controllers vs business logic
DB access patterns
Redis / queue usage

6.Integration readiness
Assess suitability for:
MCP servers (exposing backend actions as tools)
n8n automation (stable APIs, idempotency, webhooks)

Deliverables
A written technical report (Markdown or PDF) including:
Repo structure overview
Module list
API endpoint count & grouping
Standards & tooling assessment
Risks, gaps, and recommendations
Notes specific to MCP & n8n integration readiness

Constraints
No access to production databases
Review is code-based only
No feature development required

3+ years Yii2 backend experience

Experience reviewing or inheriting existing codebases

Comfortable writing clear technical documentation

• Briefly explain how you would identify all API endpoints in an existing Yii2 codebase?
• When reviewing an existing Yii2 codebase, how do you determine whether business logic is properly separated from controllers? What red flags do you look for?
• If this Yii2 backend needs to be used for workflow automation (e.g. n8n) or exposed as MCP tools, what qualities do you check in existing APIs to ensure they are safe and reliable for automation?

I am looking for an experienced, hands-on full-stack developer to integrate a delivery zone module into my existing admin panel.
Tech stack: React (TypeScript), Material UI, Node.js (REST API).

This is not a new website but a specialised delivery zone module. I already use a similar program whose logic and UI I like. For copyright reasons I cannot upload screenshots here, but I can provide a video demo, detailed screenshots, and, if needed, a download link so you can install the existing software and review its settings. The new module should be functionally as close as possible to that reference (1:1), but implemented with Material UI and integrated cleanly into my current stack.

Goal:
In the admin panel I want to fully manage all delivery areas, including:

Delivery radius: distance in km, minimum order value, delivery fee, “free delivery from”

Delivery zones on a map (polygons): draw, move and edit zones freely on the map

ZIP/district logic: assign multiple ZIP codes/districts to one zone (e.g. 04129 Leipzig – Eutritzsch, Zentrum-Nord, etc.)

Everything should be connected via API to the existing system so that, when an address is entered, the system automatically knows:

whether we deliver there,

which zone (green/yellow/red) the address belongs to, and

which minimum order value and delivery fee apply.

Current state of my system:

There is already a delivery zone system with coloured polygon zones (green, yellow, red).

When customers register/enter their address, the system (Google Maps / API) already checks whether the address is inside the delivery area.

Minimum order values, delivery fees, etc. are not yet synchronised with the admin panel.

The admin panel currently contains only placeholders for ZIP codes, minimum order values, etc.; the logic is not properly controlled from there yet.

Your task:

Extend the admin panel so that all relevant settings (ZIP, zones, minimum order value, delivery fees, “free from”, prepared pickup discount) can be configured there.

Link this data via API to the existing map/zone logic so that frontend, map logic and admin panel are fully synchronised.

Implementation – Admin UI (React + Material UI):
In the admin panel, create a “Delivery Areas” section with:

Toggle: Delivery radius / Delivery zones (only one active at a time)

Radius mode:

Table with rows for:

“Distance up to” (km)

travel/delivery cost

minimum order value

“free delivery from”

Create, edit and delete rows

Delivery zone mode (polygon):

Map view (Leaflet, Mapbox or similar)

Ability to draw, move and edit polygon zones on the map

Zone panel on the right with fields:

zone name

type: manual polygon or ZIP index

ZIP/district list (multiple entries per zone)

minimum order value

delivery cost

“free delivery from” (optional)

prepared field for pickup discount (percentage or “no discount”)

I will provide a reference video, screenshots and, if you wish, access to the existing solution so you can understand the UX and logic in detail.

Backend / API logic (Node.js):

Data models for:

zones (radius + polygon)

ZIP/district assignment

REST APIs to:

create/update/delete zones

list zones

Logic to validate a customer address (ZIP + street + house number):

geocoding: address → coordinates (existing Google Maps integration can be reused)

check if the point lies inside a polygon zone (green/yellow/red)

if not: check radius zones

if a ZIP index is used: match the appropriate ZIP zone

return to the frontend: “deliverable yes/no”, matching zone (including colour), minimum order value, delivery fee and possible discount

The module must be integrated into my existing system. I will explain the current structure and provide access to a test environment so you can inspect the admin panel and current behaviour.

Requirements:

Strong skills in React (ideally TypeScript) and Material UI

Experience with map libraries (Leaflet, Mapbox or similar)

Experience with polygon/geofencing logic (point-in-polygon, radius zones)

Solid experience with Node.js (REST API) and a database (MongoDB, PostgreSQL or MySQL)

Pragmatic mindset and clean results, not just theory

Nice to have:

Experience with food delivery, restaurant or pizza systems

Experience with delivery zones, geocoding or similar features

Budget & process:

Budget: around 300 USD as a fixed price for this module

Time frame: three to four days; a stable, well-designed solution is more important than pure speed

Please only apply if you have built something similar before.

Please include in your proposal:

A short summary of your relevant experience (React, Node.js, maps/polygons)

1–2 examples or screenshots of similar work (if available)

In 3–5 sentences: How would you technically check whether a customer address is inside a delivery zone, and how would you keep this logic synchronised with an admin panel?

AI-Powered Teaching & Preaching App (React Native + AI Integration)
I am building a mobile app (iOS + Android) designed to function as a teaching and preaching assistant—similar to how I personally use AI to prepare sermons, lessons, devotionals, Bible studies, and teaching resources.
This is a well-defined MVP with a larger long-term vision. I am looking for an experienced developer who can build a strong, flexible foundation that can grow over time.
VISION
The goal of this app is to create anything related to teaching and preaching Scripture.
If it can be described in words, the app should be architected so it can be generated by AI.
The system should act as a content-generation engine for pastors, teachers, Bible study leaders, and ministry workers.
SUPPORTED INPUT TYPES
The app must be able to generate sermons and teachings from any of the following inputs:
1. Scripture-Based Input
User enters a Bible passage (example: John 3:16–21)
App generates a complete sermon or teaching from that passage
2. Subject or Biblical Theme
User enters a topic (example: forgiveness, anxiety, faith, church unity)
App identifies relevant Scripture and builds the teaching from it
3. Ideas or Everyday Life Situations
User describes a real-life situation or idea (example: grief, family conflict, burnout, stress at work)
App connects the situation to biblical truth and creates a teaching with Scripture and application
CORE OUTPUT (REQUIRED FOR MVP)
At minimum, the app must generate:
Title options
Introduction
Big idea / thesis statement
3-point sermon or teaching outline
Written-out Scripture (user-selectable Bible translation such as ESV, NIV, NKJV, KJV, etc.)
Explanation/teaching notes for each point
Application points
Conclusion
Small-group discussion questions
Content must clearly separate:
Scripture
Explanation
Application
EXTENDED OUTPUT TYPES (FUTURE PHASES – ARCHITECTURE REQUIRED)
The system must be architected so it can later generate (not required in MVP):
📘 Bible study lessons
📝 Teaching handouts / worksheets
📅 Daily devotionals
📊 PowerPoint / slide outlines
📖 Manuscript-style sermons
🧑‍🏫 Youth lessons
👨‍👩‍👧 Family devotionals
📚 Multi-week teaching series
⚠️ MVP scope is limited to sermon and lesson generation only.
These additional outputs are for future phases and should be supported by a flexible backend and prompt system.
TECH REQUIREMENTS
Frontend
React Native (single codebase for iOS + Android)
Simple, clean UI (speed and usability over design polish)
Backend
Node.js (preferred) or Python
REST API
Database: Firebase, Supabase, or PostgreSQL
AI
Integration with OpenAI or similar LLM API
Clean prompt handling with structured outputs
User Features
Email/password authentication
Save, edit, and reopen generated content
Basic content organization (saved items list)
DELIVERABLES
iOS TestFlight build
Android APK
Backend deployed
Source code
Basic documentation
PROJECT DETAILS
Project type: Fixed price
Budget: $6,000 USD
Timeline: 4–6 weeks (1–3 months max)
Experience level: Intermediate
Location: Worldwide
An NDA and IP ownership agreement will be required before sharing detailed prompts and internal logic.
IMPORTANT EXPECTATIONS
This is a clearly defined MVP
No over-engineering
No unnecessary features
Clean execution and communication are critical
Architecture should allow expansion without rewriting core systems
WHEN APPLYING, PLEASE INCLUDE:
Examples of React Native mobile apps you’ve built
Experience with AI / OpenAI / LLM APIs
Brief explanation of how you would structure the backend
Estimated timeline
Confirmation you can start immediately
👉 Please begin your proposal with the phrase:
“Sermon App Ready”
(This helps filter automated responses.)
WHAT SUCCESS LOOKS LIKE
App generates reliable, structured sermons and teachings
Scripture is accurate, written out, and clearly cited
Content is easy to save, reuse, and edit
MVP is ready for real-world pastors and teachers to use

We're looking for someone to help us move our web apps from Digital Ocean servers to our local workstation. If you’ve got experience managing Linux servers and deploying applications with Nginx, Node.js, Postgres, and Docker, we'd love to chat with you!

PROJECT OVERVIEW
Building a production-grade data warehouse and machine learning prediction platform. The project requires setting up complete infrastructure from scratch including database architecture, ETL pipelines, ML training workflows, API backend, and containerized deployment.

You will be responsible for designing and implementing the full technical stack: data ingestion from multiple external APIs, data transformation and storage, automated ML model training pipelines, and real-time data delivery via API endpoints.

Full project documentation and specifications will be provided to qualified candidates after initial screening.

⚠️ IMPORTANT: PROOF OF WORK REQUIRED
We do NOT accept proposals based on words alone. AI can write convincing proposals better than humans these days. You MUST prove your past work with real demonstrations.

To qualify for this project, you must provide:
1. Live links to projects you have built (not just screenshots)
2. GitHub repositories showing your actual code
3. Video walkthrough or screen recording explaining your past work
4. Detailed explanation of YOUR specific role and contributions
5. References from previous clients (we may contact them)
Proposals without real proof of work will be rejected immediately.

REQUIRED: FULL STACK DEVELOPER SKILLS
Core Technology Stack (MUST HAVE)

Technology Required Experience
Python 3.11+ Advanced - data processing, async programming, type hints
PostgreSQL 15+ Complex queries, indexing, performance tuning, schema design
H2O.ai AutoML Model training, walk-forward validation, probability calibration
Mage OSS Data pipeline orchestration, ETL workflows, scheduling

Infrastructure & DevOps (MUST HAVE)
Technology Required Experience
Docker Containerization, Docker Compose, multi-service deployment
Redis Caching strategies, session management, pub/sub
FastAPI REST API development, WebSocket, async endpoints
Linux/Ubuntu Server administration, bash scripting, cron jobs

Data Engineering Skills (MUST HAVE)
• ETL pipeline development - Extract, Transform, Load from multiple APIs
• API integration - RESTful APIs, WebSocket connections, rate limiting, error handling
• Web scraping - BeautifulSoup, Selenium, handling dynamic content
• Data validation and quality monitoring - completeness tracking, anomaly detection
• Database schema design - normalization, indexing strategies, query optimization

Machine Learning Skills (MUST HAVE)
• Walk-forward validation implementation (time-series cross-validation)
• Probability calibration - isotonic regression, Platt scaling
• Feature engineering for predictive modeling
• Model performance evaluation and metrics analysis

Preferred Additional Skills
• Datadog or similar monitoring/observability platforms
• Nginx reverse proxy configuration and SSL setup
• Telegram Bot API for alert systems
• Git version control and CI/CD workflows

WHAT YOU'LL BUILD
• PostgreSQL database with optimized schema and indexing
• Mage OSS pipelines for automated data collection and processing
• H2O.ai AutoML training pipeline with validation workflows
• FastAPI backend with REST and WebSocket endpoints
• Redis caching layer for performance optimization
• Docker containerized deployment on dedicated server
• Monitoring and alerting system integration

TO APPLY - SHOW YOUR WORK
Your proposal MUST include:
6. Links to live projects or GitHub repos you have built
7. Video or screen recording walking through your past data warehouse/ML projects
8. Specific examples of Python + PostgreSQL + ML pipeline work
9. Your experience with ETL pipelines and data orchestration tools

NO PROOF = NO CONSIDERATION. We will verify all claims.

• Describe your recent experience with similar projects
• Include a link to your GitHub profile and/or website
• What frameworks have you worked with?

I'm looking for a US based freealncer, with at least 3 samples they can provide of similar projects done in the past. I’m launching a new online store and want the entire solution built with Java 17 and Spring Boot, structured as a “service-based monolith” that can be split into microservices later. The core modules should cover catalog, cart, checkout, user accounts, and order management, with clean REST APIs between them. We are open to improvements for the below requirements.

Technology Stack:
● Frontend: React/Next.js
● Backend: Java Spring Boot
● API Gateway: Kong or AWS API Gateway
● Databases: PostgreSQL + MongoDB
● Search Engine: Elasticsearch Cluster
● Message Queue: RabbitMQ or AWS SQS
● Cache: Redis Cluster
● Hosting: AWS (ECS/EKS)

Core Services (7 Services):
1. Product Service: Catalog management, SKU management, 100,000+ products
2. Order Service: Shopping cart, checkout, order fulfillment, multi-vendor routing
3. User Service: Authentication, user accounts, customer preferences
4. Integration Service: ERP, EDI, third-party API connections
5. Payment Service: Elavon or other payment processing integration
6. Search Service: Elasticsearch indexing and advanced filtering
7. Notification Service: Email, SMS, and push notifications

Required Integrations:
● ERP Integration: QFloors or alternative system integration for order management
● EDI Compliance: X12 standards implementation (documents 832 , 850, 855, 856, 997, 810) for 7 EDI-
compliant vendors
● API Connections:
○ MeasureSquare (flooring estimator)
○ Wizart or alternative visualizer technology
○ Elavon payment gateway
○ XGS freight and rl freight and logistics
● Shipping Integration: UPS and FedEx rate calculation and label generation
● AI-Powered Catalog Processing: Automated conversion of PDF and Excel vendor catalogs to CSV
format
● Web Scraping Infrastructure: Automated collection of product images, specifications, and related accessories from vendor websites

Database and Data Management:
● Master product library supporting 45 vendors (7 EDI + 38 non-EDI) , additional vendors to be added
● Automate creating new vendors and managing existing vendors
● Category management for: Carpet Broadloom, Carpet Tile, Sheet Vinyl, Vinyl Plank/Tile, Hardwood, Engineered Hardwood, Laminate
● Advanced filtering system ("Help Me Choose a Floor" tool)
● Multi-tenant architecture foundation for future franchise expansion
● Scalable database design to support future growth beyond 100,000 SKUs
● Industry Standard security for the management of client’s database

User Experience Features:
● Advanced product filtering and search
● Compare tool
● Automate sample order process
● Room visualization tool integration
● Customer reviews and ratings system
● Project information sharing capabilities with the ability to upload project photos
● Comprehensive resource library
● DIY support tools and installation guides
● Mobile-responsive design
● labor resource tool ; zip code-qualified contractor , based on 10+ installation groups/organizations

Order Management:
● Multi-vendor order splitting and routing
● Real-time inventory availability from vendors
● Direct ship model (vendor-to-customer)
● Consolidated tracking and customer communication
● Return and refund processing across multiple vendors
● Industry standard security for the taking and management of customer orders

Technical SEO Implementation:
● Site structure optimization
● XML sitemaps and robots.txt configuration
● Schema markup and structured data
● Page speed optimization
● Mobile optimization
● Canonical URLs and redirect management
● Meta tags and header optimization

Data Migration
Developer will migrate all relevant data from Client's existing WordPress site and drop box, including:
● Product catalogs
● Product categories and taxonomies
● Content and media assets
● Images and digital assets
● image transfer required to visualizer
● Customer data (if applicable and compliant with privacy regulations)

Quality Standards
Developer will deliver the Platform in accordance with:
● Industry best practices for software development
● WCAG 2.1 AA accessibility standards
● GDPR and CCPA compliance requirements
● PCI DSS compliance for payment processing
● Clean, documented, maintainable code
● Comprehensive testing (unit, integration, and end-to-end tests)
● Industry best practices for the security of the Platform

SEO Growth Program:
● Technical SEO maintenance and optimization
● On-page SEO optimization
● Monthly content strategy and recommendations
● Keyword research and targeting
● Competitive analysis
● Link building strategy
● Google Analytics and Search Console monitoring
● Monthly SEO performance reports

PPC Campaign Management:
● Google Ads campaign setup and management
● Creation of Facebook/Instagram & Ads management
● Bing Ads management
● Ad copywriting and creative optimization
● Landing page optimization recommendations
● A/B (multiple variant) testing and conversion rate optimization
● Bid management and budget optimization
● Monthly performance reports and ROI analysis

Skills: Java, JSP, J2EE, eCommerce, PostgreSQL, RESTful, Web Development, Microservices, Spring Boot, REST API

I am looking to commission a commercial-grade, fully optimized ComfyUI generative pipeline. I require a bespoke architecture designed for maximum photorealism, impeccable character consistency, and efficient workflow management.

The Core Project: I need a unified "Master Interface" in ComfyUI capable of generating highly realistic content for 5+ distinct recurring characters. Important Clarification: I do not need all 5 characters in the same image simultaneously. I need a "Profile System" (similar to switching Browser Profiles) where I can switch between Character A, B, or C instantly within the same app, without manually rewiring nodes or locating different model files every time.

Specific Technical Constraints & Requirements:

Dynamic Character Profiling (The "Selector" System):

I require a "Character Selector" (Dropdown menu) in the UI.

Selecting a character must automatically inject that character's specific LoRA, Trigger Words, and Generation Settings into the pipeline.

The system must cleanly separate the "Scene Prompt" (background/action) from the "Character Prompt" (appearance), allowing me to place different characters into the same scenario just by switching the dropdown.

State-of-the-Art Model Integration:

Image: The pipeline must use Flux.1 (Dev) or a high-fidelity finetune (e.g., Chroma/Flux). SDXL is not sufficient for the realism I require.

Video: Integration of Wan 2.2 or Hunyuan Video for Image-to-Video generation.

Refinement: Automated FaceDetailer logic that dynamically links to the currently selected character's LoRA to ensure facial fidelity is perfect.

Usability & Interface:

I require a front-end solution (e.g., SwarmUI or ComfyUI-Easy-Use). I want to operate via dropdowns and sliders, not by dragging wires.

I want to be able to generate both images and videos.

More specifically, an example of what i want to be able to do:
- I want to be able to provide a reference picture of ablack girl dressed in a red dress in front of the Eiffel Tower. I want the pipeline to take our model well known from the LORA, and recreate the same picture, especially in matter of background, with no mistakes and no errors like things missing or distortion in things in the background, and i want my LORA character, for example a white blonde girl to have the same dress as in the original reference picture or maybe i can provide in the workflow something clothes related, like a picture of a black dress, and the generated picture of our LORA character to have the black dress from the reference image instead of the red one in the original picture, but the exact same rest of elements, like same position, same facial expression (if i dont write in the prompt another specific facial expression request), same everything.
-In the case of videos, same as i mentioned above, exact perfect replica but with our model in it.
but also create something from zero, something from scratch, if i write an ideea in the promp.
-utra realistic content generation with high attention to details like skin, wrinkles, strands of hair, eyebrows, eyes, lips etc.
Questions:

Architecture: How do you handle the logic for switching between 5 different LoRAs/Trigger sets? Do you use specific custom nodes (like CR Switch or Impact Pack)?

Hardware: Since I am generating characters one at a time, can this run on a single RTX 3090/4090 (24GB), or does the loaded workflow overhead still require more VRAM?

Cost: Please provide a rough fixed-price estimate for the full setup, including the configuration of the 5 character presets.

I am looking for the absolute best implementation available. Please share examples of complex modular workflows you have architected.

THE PROJECT: Algorithmic Risk Architecture (2-Week Sprint)
We are LaunchPad Enterprise Inc., an algorithmic risk architecture firm specializing in validating and structuring high-growth ventures. We require an elite frontend specialist to build a high-fidelity client dashboard for our institutional investor clients.
This project is a high-intensity, 80-hour sprint over two consecutive weeks (40 hours/week commitment) starting in mid-February.
The aesthetic is CRITICAL: We require a "Modern Luxury" UI, reminiscent of a Swiss watch or private banking interface.
CORE AESTHETIC REQUIREMENTS (The Visual Mandate)
• Palette: Deep Obsidian Black, Champagne Gold, and Platinum White.
• Typography: Editorial Serif for titles, clean Swiss Sans-Serif for data.
• Controls: Skeuomorphic "Audiophile" design (milled aluminum knobs) for interactivity.
• Anti-Style: DO NOT apply generic "Hacker/Matrix" or flat "SaaS Dashboard" styling.
TECHNICAL BUILD MODULES
You will be responsible for creating the following frontend modules, integrating with a completed, high-performance Python API (built by our core logic specialist):
1. The Sentinel Dashboard:
• The Hero Metric: Build the "Capital Insulated" Odometer—a gold, mechanically animated tumbler that visually ticks up to show cumulative risk capital avoided.
• Data Integration: Consume the score data (e.g., the LaunchPad Strength Score) via secure API and display real-time metrics.
2. The Simulation Engine:
• Split-Screen Visualization: Implement an interactive simulation using Three.js/WebGL.
• Function: Visualize Human Analyst Error (turbulent, smoky chaos) versus Algorithmic Precision (a single, razor-sharp gold laser line) as the user controls the "Deal Volume" slider.
3. The Output Engine:
• Document Generation: Architect the system to generate print-ready PDF reports on demand (e.g., the LaunchPad Prospectus and the Greenlight Addendum). The PDF must maintain the high-contrast Black/Gold aesthetic.
TECHNICAL REQUIREMENTS (The Filter)
• Framework: React.js / Next.js (Must be expert level).
• Visualization: Three.js/WebGL is mandatory. Experience with D3.js or GSAP is highly valuable.
• Timeline: Availability for a dedicated 80-hour, 2-week sprint starting in mid-February.
HOW TO APPLY
Submit your proposal, and include links to custom dashboards or interactive 3D visualizations you have personally built. Candidates without relevant Three.js/WebGL portfolio work will not be considered.

• How do you approach UI design to create a feeling of 'weight' and 'luxury' (Obsidian, Gold, Platinum) in a web app?

We’re looking for a high-level full-stack developer to build a secure, modern web application with user accounts, roles, file uploads, and a clean, scalable backend.

This is solo work only — no teams, no agencies, no project managers.
---------------------------------------------------------------------------------------

WHAT YOU’LL BUILD - A production-grade web app with:

1. Secure authentication
2. Role-based access
3. File upload + handling
4. User dashboards
5. Clean backend architecture

You must be able to work independently, make technical decisions, and deliver clean, auditable code.
---------------------------------------------------------------------------------------

REQUIRED SKILLS:

1. React / Next.js
2. TypeScript
3. Node.js (NestJS) or Django
4. PostgreSQL
5. Strong understanding of auth flows + security best practices
6. Ability to plan features without hand-holding
7. Good written communication
8. 2 hours minimum overlap with EST
9. Async only: all communication is written — no calls, no meetings
10. Must complete a 1-hour paid test

No agencies. No teams. No coordinators.
---------------------------------------------------------------------------------------

TO APPLY

Send:
1. GitHub
2. Your preferred stack
3. 2–3 real projects you personally built
4. 20–30 lines of sample code you wrote
5. Your hourly rate

No AI-generated portfolios — commit history will be checked.
If you cannot complete the 1-hour test, do not apply.
---------------------------------------------------------------------------------------

1-HOUR PAID TEST

You will build a minimal app with:
1. Register + Login (hashed passwords)
2. JWT or session-based auth
3. Simple role system
4. Protected route (/dashboard)
5. ZIP + GitHub + short README

We evaluate file structure, clarity, speed, and security hygiene.

We’re looking for an experienced PHP Developer to join our remote team full-time. You’ll build, maintain, and optimize PHP-based web applications and e-commerce platforms, working closely with front-end developers and following best development practices.

Responsibilities:
• Develop, test, and maintain PHP applications
• Integrate front-end components (HTML, CSS, JavaScript, React/Angular)
• Build and maintain RESTful APIs
• Work with databases (MySQL, PostgreSQL, MongoDB, etc.)
• Use Git for version control and collaborate in Agile teams
• Optimize performance, security, and scalability
• Participate in code reviews and basic unit testing

Requirements:
• Strong PHP experience (MVC frameworks required)
• Good knowledge of HTML, CSS, JavaScript, Bootstrap, AJAX
• Database experience (MySQL or similar)
• Familiarity with Docker, CI/CD is a plus
• Experience with APIs (REST/SOAP)
• Clean coding practices (OOP, SDLC)
• E-commerce experience is a plus

Must have a reliable computer and good internet

We are seeking a subject-matter expert with demonstrable experience in deploying and configuring ArkCase (specifically the Community Edition) within a containerised environment. This can be Docker, Podman or Kubernetes.

Key Deliverables & Technical Requirements:

- Deployment Configuration: Provide a YAML file compatible with `podman-compose` or `docker-compose` or Kubernetes to deploy the Arkcase containerised solution.

- Networking/Security: Ensure that Solr and ActiveMQ services (along with anything else required) are inaccessible from outside the container network. Only the ArkCase frontend should be exposed externally.

- Database Agnosticism: The solution must be configured to with any one (1) of the following choice of database backends: MySQL, PostgreSQL, or Microsoft SQL Server. All of these options are available via a dedicated server we have in our environment. You will NOT be deploying an instance of the database in as a container.

- Customisation: If custom JDBC or other drivers are necessary for image builds, deliver a documented `Containerfile` for each required base image.

- Arkcase must communicate with our existing Alfresco deployment.

All of this work should be tested, working and validated via a demo with us, on your own hardware. We may request a Teams call should there be any issues with your delivery or instructions.

IMPORTANT AI NOTICE:
Should should only apply if you have prior experience. Absolutely no use of Artificial Intelligence is allowed. This work is something you should have personal knowledge and experience with. We will immediately terminate the contract if we find that you are using AI in replace for personal knowledge/experience.

• Do you foresee any challenges with this proposals?
• Which do you prefer to deploy in, Podman, Docker or Kubernetes?
• Have you deployed Arkcase before? If so, describe that project and your role in the project.
• Describe your recent experience with similar projects

Develop website in WordPress for our Company . Looking for skilled professional

Full-Stack Developer Needed: Build a Custom Food Community Hub (Non-E-commerce Platform)
1. Project Overview & Core Idea
We are seeking an experienced Full-Stack Developer or development team to build a comprehensive online community platform (Web Application). The core goal is to create a digital space dedicated to connecting local, talented home-cooks and food vendors (Vendors) with regular users (Users).
• Primary Focus: A platform to showcase visually appealing, high-quality home-cooked meals, recipes, and desserts.
• Key Feature: The entire system is built around content submission, display, community interaction, and most importantly, Ratings & Reviews.
Crucial Note for Developers: This is NOT an E-commerce store. There will be absolutely no features for selling, purchasing, online payment processing, shopping carts, or commission collection within the platform. All commercial transactions will occur externally, off-platform.
2. Functional Requirements (Minimum Viable Product - MVP)
The application will feature two main user roles:
A. Dish Vendor / Home Cook (The Seller)
• User registration/login system (Email or Phone Number).
• A dedicated Dashboard for content management.
• Ability to Add/Edit/Delete their listed dishes.
• Each dish listing must include: High-quality image, name, detailed description, category, and Price (Optional, for display only).
• A public Vendor Profile Page to display their bio and all their dishes.
• Ability to clearly display their Contact Information (WhatsApp number, Instagram link) on their dish pages.
B. Visitor / Regular User
• User registration/login system (Required for posting reviews).
• Ability to browse dishes via the Home Page or Categories.
• Advanced Search System (by Dish Name or Vendor Name).
• Ratings & Reviews System (Core Feature): Ability to rate a dish using a star system (1 to 5 stars) and write a comment/review.
• Ability to view the average rating for both the individual dish and the Vendor.
C. Public Interface (General)
• Home Page: Display the newest and highest-rated dishes.
• Detailed Dish Page: Display the image, description, Vendor information, and a prominent section for viewing/adding Reviews and Ratings.
3. Preferred Technical Stack
We prefer a developer with strong experience in Custom Web Development. Please mention your expertise in one of the following stacks:
• Option 1 (Modern): React/Next.js for the Frontend + Node.js (Express) for the Backend.
• Option 2 (Reliable): Laravel (PHP) or Django (Python).
• Database: PostgreSQL or MySQL.
• File Storage: AWS S3 or equivalent for image and media storage.
4. Deliverables & Expectations
We expect the developer to provide the following:
1. Clean and Well-Documented Code with clear file structure.
2. Implementation of Responsive Design principles to ensure cross-device compatibility (Mobile, Tablet, Desktop).
3. Phased delivery, starting with the agreed-upon MVP features.
5. Budget & Timeline
Please submit a Fixed Price Quote for the complete implementation of the Minimum Viable Product (MVP) outlined above, along with your estimated Timeline (in weeks or months).

Skills: PHP, Website Design, Django, eCommerce, HTML, Node.js, PostgreSQL, Full Stack Development

MesoPay – Full Technical Specification & Security Requirements

Software Development Request Document

1. Project Overview

MesoPay is a premium Iraqi fintech application designed for instant domestic transfers and international remittances to Turkey, Jordan, and the UAE.
The platform must reflect reliability, speed, simplicity, and bank-grade security.
Brand colors must follow a premium identity:

Dark Royal Blue (#0E1F40)

Gold (#D9A441)

2. Core Features
A. Authentication

Phone number login

OTP verification

Device binding (account tied to device)

PIN code inside the app

Biometric authentication for transfers

B. KYC Verification

Capture personal information

Upload ID documents (front & back)

Selfie + liveness detection

KYC review dashboard for admins

Return results: pending / verified / rejected

C. Wallet System

Real-time wallet balance

Add balance (top-up)

Withdraw balance to a bank account

Double-entry accounting ledger

Limits based on KYC level

D. Internal Transfers (Domestic)

Instant transfers between users

Search by phone or MesoID

Real-time notifications

Full compliance data stored

E. International Transfers

Supported corridors: Turkey, Jordan, UAE

Automatic FX calculation

Fee calculation

Beneficiary management

Integration with external partners (API + Webhooks)

F. Transaction History

Filters by type

Transaction details

Ledger entries included

G. Notifications Center

Incoming/outgoing transfers

System notifications

Mark-as-read

H. Merchant Dashboard

Merchant profile

View collected payments

Withdrawal requests

Export reports

3. UI/UX Requirements

Premium fintech identity

Full Figma UI/UX delivery

Arabic (RTL) and English support

All core actions reachable within 2–3 taps

Clean layouts, strong hierarchy, minimalistic design

Required Screens:
Splash, Welcome, Phone Input, OTP, Home, Add Balance, Withdraw, Internal Transfer, International Transfer, Beneficiary Setup, Transaction History, Notifications, Profile, KYC, Merchant Dashboard, Settings, Success/Error screens.

4. Mobile App Requirements (Flutter)

Development in Flutter (Android + iOS)

State management: Bloc or Riverpod

Clean Architecture structure

Secure local storage

App integrity checks (anti-root, anti-jailbreak)

Screen recording blocked on sensitive pages

5. Backend Architecture
Recommended Technology Stack

Node.js (NestJS) or GoLang

PostgreSQL (main database)

Redis (cache + rate limiting)

Message Queue: Redis Streams or RabbitMQ

S3 storage for documents

JWT authentication

Separation of services (modular or microservices)

Core Backend Services

Authentication Service

User & KYC Service

Wallet & Ledger Service

Transfer Engine (Domestic & International)

FX & Fee Engine

Notification Service

Fraud & Risk Engine

Admin Panel Backend

6. Database Schema (Key Tables)

users

otp_codes

user_devices

kyc_profiles

wallets

ledger_entries

transfers

beneficiaries

notifications

audit_logs

fraud_flags

merchants

merchant_settlements

7. Transfer Engine Logic
Domestic Transfers

Validate sender & recipient

Check available balance

Perform double-entry ledgering

Create immutable audit log

Capture device + IP + KYC data

Notify both users instantly

Store data for a minimum of 5 years

International Transfers

Get FX rate

Calculate fees

Deduct balance via ledger

Send request to external partner

Update status through partner webhook

Auto-refund on failure

**8. Mandatory Data Requirements

(Domestic + International Compliance)**

Sender Data

Full legal name

Phone number

National ID number

Date of birth

Device ID

IP address during transaction

KYC level

Address (if applicable)

Recipient Data

Full name

Phone number

Country

Account/IBAN (for international transfers)

Transaction Data

Unique Transaction ID (UUID)

Timestamp

Amount

Fees

FX rate

Status

Purpose of transfer

Partner reference (if international)

Risk score

Full ledger trail

Retention Requirements

All records must be stored for 5–10 years

No deletion or modifications allowed

Travel Rule Compliance (for international transfers)

Must include:

Sender name + ID

Recipient name + account

Country of destination

Transfer amount and purpose

9. Highest Security Standards (Bank-Grade Level)
Encryption

TLS 1.3 only

AES-256 encryption

Field-level encryption for sensitive data

Encrypted local storage

Key Management

Hardware-backed keys (HSM/KMS)

Automatic key rotation

Authentication Security

Multi-Factor Authentication (OTP + PIN + Biometrics)

Device binding

Session timeout policies

App Security

SSL Pinning

Anti-reverse engineering

Anti-debugging

Jailbreak/root detection

Integrity checks

Fraud Detection

Behavioral analytics

Velocity checks

Geo-IP anomaly detection

AML red-flag patterns

Suspicious Activity Report (SAR) generation

Audit Logging

Immutable logs

All updates tracked

Combined user + admin log trails

Infrastructure

Private VPC

WAF firewall

Secure CI/CD

Secrets not stored in code

Multi-region backups

DRP with recovery < 60 minutes

10. Admin Panel Requirements
Admin Features

User management

KYC review

Transaction monitoring

AML & fraud dashboard

Transfer control (refund, block, investigate)

FX rate management

System configuration

Exportable reports (CSV/PDF)

11. API Requirements
Authentication

/auth/request-otp

/auth/verify-otp

/auth/refresh

User/KYC

/kyc/submit

/kyc/status

Wallet

/wallet

/wallet/add

/wallet/withdraw

Domestic Transfers

/transfers/internal

International Transfers

/transfers/international

/transfers/quote

History

/transfers/history

Notifications

/notifications

Merchant APIs

/merchant/overview

/merchant/withdraw

Partner Webhooks

/partners/{id}/webhook

Admin APIs

/admin/users

/admin/kyc

/admin/transfers

/admin/reports

12. Required Deliverables from the Software Company

The selected development company must deliver:

Full Flutter mobile apps (Android & iOS)

Complete backend with all services

Admin Panel dashboard

Full Figma UX/UI design

Database schema and ERD

API documentation (Swagger)

Security implementation (bank-grade)

QA testing + penetration testing

Deployment guide + CI/CD

Full source code ownership

13. Final Statement for the Development Company

MesoPay must be built as a bank-grade financial system,
with a non-modifiable ledger, immutable audit logs,
full AML/KYC compliance, Travel Rule support,
and the highest level of encryption and security.
All transaction data—domestic and international—must be stored
for at least 5 years and be fully exportable for regulatory authorities.

Skills: Mobile App Development, Node.js, PostgreSQL, Redis, Blockchain, Backend Development, Security, Database Design, API Development, User Experience Research

MUST BE EXPERT IN GOOGLE MAPS API AND SAMPLES OF PREVIOUS WORK.

Project Title

Google Maps–Based Staging Planner with To-Scale Assets & Editable Layouts

Project Overview

We are building a custom Google Maps–based staging and planning tool that allows operators to place, move, and manage temporary assets (trailers, generators, tents, etc.) on real satellite imagery.

Assets must be rendered to real-world scale, remain geographically accurate at all zoom levels, and support internal layouts (example: sleeping bunks inside a trailer) with color-coded status indicators.

This system will be used for operational planning, deployment staging, and demobilization scenarios.

Core Requirements

1. Map Foundation
• Use Google Maps JavaScript API as the base map.
• Satellite and map views supported.
• Assets must:
• Stay fixed to real-world coordinates.
• Remain correctly scaled at all zoom levels.
• Be draggable to new positions.

2. To-Scale Asset Generation
• Assets are defined by real-world dimensions (feet/meters).
• Example:
• Trailer: 36’ long × 12’ wide
• System must:
• Convert dimensions into geographic polygons (lat/lng).
• Render assets as true-to-scale rectangles or polygons.
• Support rotation (heading/orientation).
• Assets behave like buildings on Google Maps (not pixel icons).

3. Asset Types (Initial Scope)
• Trailers (sleeping, command, storage)
• Generators
• Temporary structures (expandable later)

Each asset must support:
• Name/label (example: “JAX Trailer”)
• Type
• Dimensions
• Orientation
• Status

4. Internal Layouts (Sleeping Trailers)

Sleeping trailers must support internal sub-layouts rendered within the trailer footprint.

Example configuration:
• 36’ × 12’ bunk trailer
• 12 bunks total
• 6 bunks on left side
• 6 bunks on right side
• All bunks currently lower level (future-proof for upper bunks)

Each bunk must be:
• Individually addressable
• Color-coded by status:
• Green – Occupied
• Yellow – Needs Cleaning
• Red – Demobilization
• Editable via UI (click/select bunk to change status)

5. Editing & Interaction
• Click asset → open side panel or modal:
• Edit name
• Edit dimensions
• Edit orientation
• View and manage internal layouts (bunks)
• Drag asset on map → position updates persist.
• Internal layouts reposition automatically when asset is moved or rotated.

6. Zoom-Aware Rendering
• Assets always visible at all zoom levels.
• Internal layouts (bunks) only render at higher zoom levels to reduce clutter.
• Labels scale appropriately with zoom.

7. Data Persistence
• Assets and layouts must be stored in a database.
• Required stored data:
• Asset type, name, dimensions
• Center lat/lng
• Orientation
• Bunk configuration and statuses
• Multiple layouts/scenarios per site preferred (Plan A, Plan B, DEMOB, etc.).

Preferred Tech Stack
• Frontend:
• React or Next.js
• Google Maps JavaScript API
• Backend:
• Node.js / Next.js API routes
• REST or GraphQL
• Database:
• MySQL or PostgreSQL
• Experience with geospatial math (meters → lat/lng conversion) required.

Deliverables
1. Working Google Maps staging planner
2. To-scale draggable assets
3. Internal bunk layouts with color-coded status
4. Editable asset properties via UI
5. Persistent storage of asset positions and states
6. Clean, well-documented code suitable for production expansion

Ideal Freelancer
• Strong experience with:
• Google Maps JavaScript API
• Geospatial calculations
• React/Next.js
• Comfortable building operational tools, not just visual demos.
• Able to think through real-world physical layouts and translate them into map geometry.
• Bonus:
• GIS experience
• Emergency response, logistics, or facilities planning tools

I need someone to help me finish, user test, and connect lovable projects so they are operational.

More info to follow.

*** PROJECT BRIEF: THE CAPITOL WIRE MOBILE APP ***

**STATUS:** The entire backend API, database (PostgreSQL), and server-side notification system (Firebase Admin SDK) are **100% COMPLETE AND DEPLOYED**.

**DEVELOPER'S SOLE TASK:** Build, test, and package the read-only **Mobile Client** (iOS and Android). The only code you need to write is for the front-end interface and the mobile FCM client setup. The forward-facing application name is **"The Capitol Wire"**.

**PROJECT GOAL:** Deliver a zero-friction, cross-platform app (React Native or Flutter). **No user login or sign-up is permitted.**

1. LIVE API SPECIFICATION (FOR CONSUMPTION)

Base URL: TO BE PROVIDED

* **FEED ENDPOINT:** GET /feed (Public access, returns JSON array of 50 recent summaries).
* **DATA:** Each item includes: summary_text, tweet_author, tweet_url, and created_at.

2. FEATURE REQUIREMENTS

A. MAIN FEED VIEW
* Load Data: Must call GET /feed on launch and support pull-to-refresh.
* Action: Tapping a card must open the corresponding tweet_url in the device's web browser.

B. PUSH NOTIFICATIONS (FCM)
* Setup: Integrate the Firebase Client SDK using the files I provide.
* Auto-Subscription: On first launch, the device **MUST** automatically subscribe to the technical FCM topic: **hillpulse_updates**.
* Notification Title: Should be displayed as **"The Capitol Wire"**.
* Tap Action: Tapping the notification must open the app and use the payload's tweet URL to deep-link or open the browser.

3. REQUIRED DELIVERABLES FROM DEVELOPER
1. Full, clean source code repository.
2. Signed production build files: **.apk** (Android) and **.ipa** (iOS) for App Store submission.
3. App uploaded to the app store

4. HANDOFF
I will send the necessary **Firebase Client Config Files** (plist/json) and app assets securely upon confirmation.

We are seeking a skilled backend developer to enhance our existing social network website, primarily built using Java and PostgreSQL. The ideal candidate will have experience working with Java frameworks and a strong understanding of PostgreSQL databases. Your focus will be implementing new features like notifications, comments & reply features, improving performance, and ensuring seamless integration with the frontend. Should also have basic understanding of front end and can handle small front end changes or bugs. If you have a passion for backend development and a keen eye for detail, we would love to hear from you.

I’m building a Shopify app focused on decision intelligence for scaling ecommerce stores.

This is a well-defined MVP with clear scope, architecture, and requirements.

I’m looking for one strong full-stack developer who can execute independently.

Tech stack

- Backend: Node.js (Express / Nest acceptable)
- Frontend: React (Next.js preferred)
- Shopify Admin API
- PostgreSQL (Prisma)
- Simple queue (BullMQ or similar)

Scope (MVP)

- Shopify OAuth + app install
- Billing (Light / Growth / Pro plans)
- Backend APIs (analysis, gating, nudges)
- Dashboard UI (React)
- Weekly background jobs
- App Store–ready MVP

Requirements

- Prior experience building Shopify apps (mandatory)
- Comfortable working alone
- Able to follow a technical spec closely
- Clean, readable code
- No over-engineering

** Minimum 5 years experience
** Fixed price
** Timeline: 2–3 weeks

Please include:

- A Shopify app you’ve built
- Your preferred stack
- Confirmation you can deliver within scope and budget

Payment

- 30% upfront
- 40% after backend core
- 30% after MVP delivery

I have just rolled out Odoo for a small, fast-growing manufacturing company and now need to shape the system so it truly matches our day-to-day operations. Using Odoo Studio, I want to tailor three core modules—Inventory Management, Manufacturing, and Sales—so the platform feels seamless instead of “out of the box”.

The priorities are clear:

• Inventory Management
– Build a set of custom reports that let me track stock levels, valuation, and movements without exporting to spreadsheets.
– Automate routine workflows such as re-ordering and internal transfers, reducing the number of manual clicks the team performs each day.

• Manufacturing
– Adapt the Bill of Materials screen and logic so it captures the exact multi-level BOM structure we use on the shop floor.

• Sales
– Ensure data coming from the customized inventory and manufacturing flows feeds cleanly into quotations and orders (no manual reconciliation).

Deliverables
1. Odoo Studio customizations deployed on our test database, ready for me to validate.
2. A short, recorded walkthrough or live demo showing how each customization works and where to find it.
3. Step-by-step documentation so future updates don’t overwrite the work.
4. Migration-safe code or Studio export files, clearly named and versioned.

Acceptance Criteria
• All configured actions run without errors in Odoo.
• Reports display the requested fields and can be printed or downloaded as PDF.
• Automated workflows trigger on schedule or event exactly once and log the outcome.
• The BOM screen supports our nested components and totals correctly.

If you have hands-on experience bending Odoo Studio to manufacturing needs, let’s get this finished quickly and cleanly.

Skills: Python, Sales, Manufacturing, Software Architecture, ERP, Inventory Management, PostgreSQL, Odoo

AI-Powered Document Knowledge System for Professional Services

Project Overview:
I'm looking for an experienced full-stack developer to build an intelligent document knowledge system for my professional services business. This will be a production-ready MVP that I plan to replicate across multiple professional services businesses once perfected.
The system will ingest business documents (Purchase Orders, Statements of Work, Invoices, Design Documents) and allow natural language querying with contextual understanding across documents, plus automated ontology generation showing document relationships.
Budget: $8,000 - $15,000 USD
Timeline: 6-8 weeks
Project Type: Fixed-price with milestones
________________________________________
What You'll Build
Core Features
1. Document Ingestion Pipeline
• Support for PDF, DOCX, and common formats
• Automatic document classification (PO, SOW, Invoice, Design Doc)
• Metadata extraction (vendors, amounts, dates, project names, PO numbers, etc.)
• Text chunking and embedding generation
• Batch upload and single document upload
2. Natural Language Query Interface
• Chat-based interface for asking questions
• Retrieval-Augmented Generation (RAG) using Claude API
• Semantic search across all documents
• Context-aware responses that understand relationships between documents
• Source citation showing which documents informed the answer
3. Automated Ontology Generation & Visualization
• Extract entities and relationships across all documents
• Generate relationship graph (PO - SOW - Invoice - Design Doc links)
• Interactive visual ontology display
• Auto-update as new documents are added
4. Document Management
• View all uploaded documents
• Search and filter by type, date, amount, vendor, etc.
• Document versioning support
• Ability to edit metadata and relationships manually
________________________________________
Technical Requirements
Required Architecture
Backend:
• Python with FastAPI (or Node.js/Express if you prefer)
• PostgreSQL for structured data storage
• Vector database: ChromaDB for MVP (self-hosted, cost-effective for 1000 documents). Architecture should support easy migration to Pinecone/Weaviate if scaling to larger deployments
• RESTful API design
• Modular architecture that allows swapping PostgreSQL for Neo4j later
Frontend:
• React (preferred) or Vue.js
• Modern, clean UI with Tailwind CSS or similar
• Responsive design (desktop + tablet)
• Real-time chat interface
• Interactive graph visualization (D3.js, Vis.js, React Flow, or similar)
AI/ML Integration:
• Anthropic Claude API for LLM responses
• OpenAI Embeddings API (or Voyage AI) for document embeddings
• Proper prompt engineering for document analysis
Infrastructure:
• Docker containerization
• Easy deployment to cloud VPS (AWS, GCP, etc.)
• Environment-based configuration
• Basic authentication/authorization
Architecture Principles
• Data layer abstraction: Use repository pattern or similar to allow database swapping
• Clean separation: Ingestion, retrieval, and LLM query logic should be modular
• Extensible document types: Easy to add new document types beyond the initial 4
• API-first design: All functionality accessible via API for future integrations
________________________________________
Deliverables
Phase 1: MVP (Weeks 1-4)
• Document ingestion pipeline for all document types
• PostgreSQL schema with proper relationships
• Vector embeddings and storage
• Basic chat interface with Claude API integration
• Document classification and metadata extraction
• Simple web UI for upload and chat
Milestone Payment: 40% of total
Phase 2: Ontology & Refinement (Weeks 5-6)
• Automated ontology generation
• Interactive graph visualization
• Advanced retrieval (hybrid search, metadata filtering)
• Document management interface
• Query history and saved responses
Milestone Payment: 35% of total
Phase 3: Polish & Deploy (Weeks 7-8)
• Complete documentation (architecture, setup, API docs)
• Docker deployment setup
• Testing and bug fixes
• Performance optimization
• Handoff and knowledge transfer session
• Replication guide: Documentation for adapting to other businesses
Milestone Payment: 25% of total
________________________________________
Required Skills & Experience
Must Have:
• 5+ years full-stack development experience
• Strong Python (FastAPI/Flask) or Node.js experience
• Experience with PostgreSQL and database design
• React or Vue.js frontend development
• Experience with LLM APIs (OpenAI, Anthropic, or similar)
• Vector databases and RAG implementations
• Docker and cloud deployment
• Git/GitHub workflow
Highly Desired:
• Previous RAG or AI chatbot projects (please share examples)
• Experience with document processing and NLP
• Graph visualization libraries
• Experience building B2B SaaS applications
• Knowledge of Neo4j or graph databases
• Experience with replicable/white-label products
Nice to Have:
• UI/UX design skills
• Experience with professional services industry
• Prior Upwork Top Rated status
________________________________________
What Success Looks Like
After 8 weeks, I should be able to:
1. Upload 100+ business documents and have them automatically processed
2. Ask natural language questions like "What's the total value of all POs for Vendor X?" or "Show me all invoices related to Project Y that haven't been paid"
3. See an automatically generated ontology showing how all documents relate
4. Deploy this system to another professional services business with minimal modification
5. Hand off to an internal team or another developer for ongoing maintenance
________________________________________
Application Requirements
To apply, please include:
1. Relevant Portfolio: Share 2-3 similar projects (RAG systems, document processing, AI chatbots, or knowledge management tools)
2. Technical Approach: Brief overview of how you'd architect this system
3. Timeline & Milestones: Your proposed breakdown of the 6-8 week timeline
4. Estimated Budget: Your fixed-price quote within the stated range
5. Availability: Confirm you can dedicate sufficient hours/week
________________________________________
Working Together
• Communication: Daily async updates via Upwork; 1 video call per week
• Tools: GitHub for code, Figma for design, your choice of project management tool
• Code Quality: Expect code reviews and adherence to best practices
• Testing: Unit tests for critical components
• Documentation: Clear, comprehensive documentation is essential
________________________________________
Future Scope (Not in Initial Build)
These features may be added post-MVP:
• Multi-user authentication with role-based access
• Neo4j migration for advanced graph queries
• Custom document type templates
• API webhooks for document ingestion
• Advanced analytics dashboard
• Export functionality (reports, data dumps)
• Mobile app
________________________________________
About My Business
I run a professional services business handling projects with multiple vendors, deliverables, and payment cycles. Currently, finding information across POs, SOWs, invoices, and design documents requires manual searching through folders. This system will enable instant knowledge retrieval and relationship understanding.
Once perfected for my business, I plan to offer this as a solution to other professional services businesses (consultancies, agencies, contractors) facing similar document management challenges.
________________________________________
Questions?
Feel free to ask any clarifying questions in your proposal. I'm looking for a collaborative partner who can think through edge cases and suggest improvements, not just execute a specification.
Budget: $8,000 - $15,000 (negotiable based on experience and approach)
Timeline: Start date within 2 weeks of hire
Contract Type: Fixed-price with milestone payments

We are seeking a skilled Laravel/Filament developer to help resolve API errors that have arisen following our database migration to PostgreSQL. You will be responsible for diagnosing the issues, providing solutions, and ensuring that our API functions smoothly with the new database setup. The ideal candidate will have experience with both Laravel and PostgreSQL, and a strong understanding of API development. If you are detail-oriented and can troubleshoot problems efficiently, we would love to hear from you!

We are building Complyra, a RegTech platform that automates AML/TBML workflows through document ingestion, OCR/VLM-based extraction, and LLM risk reasoning. The core architecture is in place, but the product requires a senior engineer to audit, stabilise, and complete the remaining components so we can deliver a reliable beta version to early clients.

This role is hands-on, technical, and requires someone who is confident working with AI pipelines, structured data extraction, and backend platform engineering.

What We Currently Have
• Python/FastAPI backend
• Document ingestion pipeline (OCR + VLM + regex routing)
• Entity extraction workflow
• Initial database schema (Postgres/Supabase)
• Early UI + workflow logic
• Docker-based deployment
• LLM integration for KYB/KYC insights

What We Need You to Deliver
You will take ownership of the engineering effort required to get us to beta. Specifically:

1. Codebase Audit (Initial Engagement)
• Review architecture, pipelines, API structure, and error handling
• Identify missing components, potential failures, and security gaps
• Produce a clear, structured technical improvement plan

2. Stabilisation & Feature Completion
• Fix OCR/VLM routing errors and ensure reliable extraction
• Build or refine KYB/KYC output generation
• Implement robust logging, retries, and monitoring
• Improve database consistency and schema design
• Harden authentication and role-based access
• Improve API performance and error handling

3. Prepare a Beta-Ready Product
• Ensure workflows run end-to-end without breaking
• Add audit trails, change logs, and compliance-grade transparency
• Containerise and ensure smooth deployment
• Advise on scalability, security, and long-term maintainability

Required Technical Expertise
Please only apply if you have verifiable experience with most of the following:
• Python + FastAPI
• OCR pipelines (Tesseract, Textract, or VLM models such as LLaVA, Florence, etc.)
• LLM integration (OpenAI, embeddings, vector search)
• Backend architecture design
• PostgreSQL / Supabase
• Docker + CI/CD
• Secure API development (RBAC, authentication flows, audit logging)

Experience in fintech, regtech, or compliance systems is a strong plus.

Soft Skills / Expectations
• Clear, proactive communication
• Ability to work independently and deliver production-quality code
• Comfortable reviewing an existing codebase and improving it
• Willing to complete a small paid technical test task

Engagement Structure
Stage 1: Paid 3–5 hour audit of the codebase
Stage 2: Implementation of fixes + feature completion
Stage 3: Ongoing support or longer-term engagement (optional)

Budget
Flexible depending on seniority.
We are prioritising quality and reliability over lowest cost.

How to Apply
Please include the following:
1. Your experience with Python/FastAPI and AI/OCR pipelines
2. Examples of similar backend/AI projects (GitHub or code samples preferred)
3. Confirmation that you can perform a short paid test task
4. Your estimated availability over the next 4–8 weeks
5. Your initial thoughts after briefly reviewing our repo (we will share once shortlisted)