We are seeking an experienced Odoo Migration & Customisation Consultant to lead the end-to-end upgrade of our enterprise Odoo environment from version 17 to version 20. This critical engagement requires an expert who combines deep Python/ORM engineering capabilities with functional process knowledge across core business operations. The consultant will conduct an architectural review of all existing custom modules, retire technical debt in favor of native Odoo capabilities, execute clean database and code migrations, configure regional statutory compliance (UAE VAT & E-Invoicing), and provide comprehensive stabilization and hypercare.
Version Migration: Plan, architect, and deliver the technical upgrade and data migration from Odoo 17 to Odoo 20.
Codebase Audit: Review existing add-on modules to classify functionality into Retain, Refactor, or Replace with standard Odoo features.
Custom Module Refactoring: Port custom models, business logic, QWeb templates, and OWL components to comply with v20 framework requirements.
Database Migration: Design and execute schema transformation scripts, dry-run passes, and verification tests to ensure zero data loss.
Finance & Accounting: General ledger, parent account restructuring, automated reconciliations, depreciation schedules, and bank transaction integration.
Sales, CRM & Estimation: Lead management, quotation lifecycles, cost estimation, and commercial approval rules.
Procurement & Inventory: Purchase requisitions, RFQs, vendor evaluations, three-way matching, and groundwork for future inventory rollout.
Projects & Timesheets: Milestone delivery, resource timesheets, task tracking, and professional services billing.
HR & Administration: Employee profiles, leave tracking, administrative workflows, and organizational structures.
UAE Statutory Compliance: Configure and test UAE Federal Tax Authority (FTA) VAT reporting and mandatory E-Invoicing requirements.
Regional Standards (KSA): Support cross-border invoicing compliance and ZATCA integration requirements where applicable.
Security & Permissions: Realign security rules with modern Odoo access domain patterns, ensuring strict multi-company record isolation.
Stakeholder Engagement: Work closely with departmental leads across Finance, Sales, Projects, HR, and Operations to capture delta requirements.
Reporting Gaps: Design and implement high-priority management dashboards, analytic views, and operational reports.
UAT & Knowledge Transfer: Facilitate structured walkthroughs, sign-off sessions, and end-user validation.
Post-Go-Live Hypercare: Provide Tier-3 post-migration hypercare and resolve post-cutover operational issues.
Demonstrated Migration Track Record: Track record of leading complex, multi-version Odoo database migrations and environment upgrades.
Advanced Python & Database Expertise: Python 3.10+, PostgreSQL query optimization, indexing, and complex data migration scripting.
Odoo Framework Mastery: In-depth knowledge of Odoo ORM (model inheritance, recordset operations, computed/stored fields, SQL views, cron workers).
Deep Functional Breadth: Full lifecycle mastery across Finance, Sales, CRM, Procurement, Projects, Timesheets, and HR.
Web Client & Frontend: Working knowledge of modern JavaScript (ES6+), OWL (Odoo Web Library), and QWeb XML templating.
Industry Background: Proven success in consulting, professional services, or complex commercial project environments.
UAE / GCC Alignment: Physical presence in the UAE or substantial prior experience supporting UAE/GCC business operations.
Tax & E-Invoicing: Practical experience with UAE corporate tax/VAT setups and Peppol-compatible electronic invoicing.
Multi-Company Architecture: Experience architecting multi-company, multi-branch, and multi-currency consolidation.
Modern APIs & Tooling: Familiarity with modern Odoo REST/JSON endpoints, Model Context Protocol (MCP), and platform automation.
|
Milestone / Deliverable |
Success Criteria & Target Outcome |
|---|---|
|
Customization Audit Matrix |
Comprehensive catalog of all v17 custom code with documented Retain / Refactor / Deprecate decisions. |
|
Staged Database Dry Runs |
Validated migration passes with zero financial drift across Trial Balance, General Ledger, and Partner Balances. |
|
Regional Compliance Sign-Off |
Successful generation of compliant UAE VAT statements and automated electronic invoices in staging. |
|
Business Stakeholder Acceptance |
Formal functional sign-off from Finance, Projects, Sales, Procurement, and HR on migrated workflows. |
|
Production Cutover & Stability |
Deployment within scheduled downtime window followed by stable, incident-free operations across hypercare. |
The consultant will report directly to the Project Delivery Lead / Technical Architect and maintain structured operational engagement with cross-functional department heads throughout the lifecycle:
Finance & Accounts: Core general ledger, parent accounts, bank reconciliations, VAT/e-invoicing rules.
Sales & Estimation: Pipeline migration, estimation logic, price books, quote workflows.
Procurement: Purchase workflows, vendor management, approval thresholds.
Projects & Operations: Project milestone billing, resource planning, timesheet logging.
HR & Administration: Personnel records, leave tracking, administrative access policies.
Odoo Migration, Odoo Customization, Odoo 17 to Odoo 20 Upgrade, Python, PostgreSQL, Odoo ORM, Database Migration, Custom Module Development, Module Refactoring, JavaScript, OWL, QWeb, XML, Finance And Accounting, General Ledger, UAE VAT, E-Invoicing, ZATCA Integration, Sales, CRM, Procurement, Inventory Management, Project Management, Timesheet Management, HR Management, Multi-Company Architecture, API Integration, REST API, JSON, SQL Optimization, UAT, Technical Architecture, Functional Consulting, System Integration, Post-Go-Live Support