Project Overview
We are seeking an experienced backend/Odoo integration developer to complete the backend implementation for the Tumaini Orchard ERP decision-making system.
The front-end and Odoo configuration work has already been completed. The remaining work is to set up backend integrations so that the accounting dashboards, Superset reporting environment, VOIP information system, WhatsApp integration, and automated alerts work as designed.
The system is based on Odoo 17 Community and is intended to support accounting, CRM, inventory, sales, customer communication, VOIP reporting, and management decision-making dashboards.
________________________________________
Systems to Be Integrated
Odoo 17 Community ERP
Odoo CRM
Odoo Accounting
Odoo Inventory and Sales
PostgreSQL reporting database
Apache Superset dashboards
Asterisk VOIP hosted on AWS
Airtel Kenya SIP/VOIP connectivity
Meta WhatsApp Cloud API MVP integration
SMTP email alerts
________________________________________
Important Project Materials
A detailed backend integration runbook has already been prepared for this project. The selected contractor will receive the full project runbook document, which includes line-by-line backend setup instructions, copy/paste-ready command blocks, SQL scripts, Odoo integration instructions, Superset setup instructions, Asterisk integration guidance, WhatsApp MVP instructions, and validation checklists.
A private GitHub project environment has also been prepared. The GitHub repository will be shared with the selected project winner and contains the project structure, documentation, starter code, SQL files, ETL script templates, deployment templates, Odoo module skeleton, and configuration examples.
Important: No production passwords, access tokens, SIP credentials, SMTP credentials, or other secrets will be stored in GitHub. The contractor must follow secure secrets management practices.
________________________________________
Scope of Work
1. Backend Infrastructure Setup
Prepare the AWS/server backend environment.
Install and configure required packages.
Set up PostgreSQL reporting database.
Set up schema structure for raw, staging, mart, and audit data.
Configure secure environment variables and deployment folders.
2. Odoo Backend Data Integration
Connect to Odoo 17 Community using XML-RPC, JSON-RPC, or approved database access.
Extract required Odoo data into the reporting database.
Include accounting, invoices, payments, customers, CRM leads, sales orders, products, journals, and inventory-related data.
Build repeatable ETL scripts.
Schedule automated refresh jobs.
3. Accounting Dashboard Backend
Create reporting tables and SQL views for accounting dashboards.
Support dashboards for revenue, receivables, overdue invoices, M-Pesa payments, customer balances, and invoice trends.
Ensure Superset reads from the reporting database, not directly from the Odoo production database.
4. Apache Superset Setup
Install and configure Apache Superset.
Connect Superset to the reporting PostgreSQL database.
Create datasets, charts, and dashboards.
Configure user roles and dashboard access permissions.
Set up HTTPS access through Nginx or equivalent reverse proxy.
5. Asterisk / Airtel Kenya VOIP Integration
Configure Asterisk call detail record capture.
Load CDR/CEL data into the reporting database.
Normalize Kenyan phone numbers.
Match call records to Odoo customers and CRM leads.
Create Superset reporting views for calls, missed calls, call duration, customer engagement, and unmatched calls.
6. WhatsApp MVP Integration
Implement the recommended MVP using Meta WhatsApp Cloud API.
Create or complete a custom Odoo 17 Community WhatsApp integration module.
Support outbound WhatsApp templates for invoices, payment reminders, order confirmations, and delivery updates.
Support inbound WhatsApp webhook processing.
Match WhatsApp messages to Odoo contacts and CRM leads.
Create CRM leads from unknown WhatsApp numbers.
Log WhatsApp messages for reporting and audit.
Expose WhatsApp activity data to the reporting database and Superset.
7. SMTP Alerts
Configure SMTP in Odoo.
Configure Superset email alerts if required.
Support alerts for overdue invoices, low stock, ETL failures, missed calls, and daily finance summaries.
8. Testing and Go-Live Support
Validate Odoo data extraction accuracy.
Validate accounting dashboard figures against Odoo.
Validate Asterisk call reporting.
Validate WhatsApp message sending and receiving.
Validate Superset user roles and dashboard access.
Document deployment steps and final configuration.
________________________________________
Expected Deliverables
Working backend integration environment.
PostgreSQL reporting database with required schemas and views.
ETL scripts for Odoo and related systems.
Apache Superset installation and configured dashboards.
Asterisk call reporting integration.
WhatsApp MVP Odoo integration using Meta WhatsApp Cloud API.
SMTP alert configuration.
Deployment notes and operational documentation.
Updated GitHub repository with clean, documented implementation files.
Final handover checklist and testing results.
________________________________________
Ideal Contractor Experience
Please apply only if you have strong experience in several of the following areas:
Odoo 17 Community development and backend customization.
Odoo XML-RPC / JSON-RPC API integration.
Odoo Accounting, Sales, CRM, Inventory, and Contacts modules.
Python ETL scripting.
PostgreSQL database design, SQL views, reporting schemas, and data marts.
Apache Superset installation, dataset creation, dashboard configuration, and role-based access control.
Linux server administration, preferably Ubuntu on AWS.
Docker and Docker Compose.
Nginx reverse proxy and SSL/Let’s Encrypt setup.
Asterisk PBX, CDR/CEL reporting, SIP trunk integration, and VOIP call reporting.
Experience with Airtel Kenya SIP/VOIP is a plus.
Meta WhatsApp Cloud API integration.
Odoo custom module development for external APIs and webhooks.
SMTP configuration and transactional email alerts.
GitHub-based project workflow, commits, issues, and clean documentation.
Secure handling of environment variables, tokens, passwords, and production credentials.
________________________________________
Preferred Work Style
Follow the provided project runbook carefully.
Use the provided GitHub repository as the working environment.
Commit code and configuration templates regularly.
Do not commit real credentials or secrets.
Create clear notes when changes are made.
Ask questions early when access, credentials, or infrastructure details are missing.
Provide screenshots or test outputs for completed milestones.
________________________________________
Application Requirements
When applying, please include:
Examples of previous Odoo backend or integration projects.
Examples of Superset, PostgreSQL, or analytics dashboard work.
Any Asterisk, SIP, VOIP, or CDR reporting experience.
Any WhatsApp Cloud API or Meta Business API experience.
Your proposed implementation approach.
Your availability and estimated timeline.
Any questions you need answered before starting.
________________________________________
Confidentiality and Security
The contractor must treat all system access, business data, customer data, accounting data, VOIP records, WhatsApp messages, and credentials as confidential.
Production credentials must not be stored in GitHub, shared in chat, or placed inside source code. Environment variables or server-side secret files must be used instead.
________________________________________
Project Goal
The goal is to make the Tumaini Orchard backend systems work as one integrated decision-making platform, where accounting, CRM, sales, inventory, VOIP, WhatsApp, and customer engagement data can be reliably viewed through Superset dashboards and used by management for daily decisions.
... Show more