Lead Distributed Systems Architect & Enterprise ERP Engineer
Founder & Principal Architect at CODCrafters · Remote Worldwide

I design enterprise ERP systems, transaction backends, and offline-first mobile products. Over the past 6 years, I have delivered 91+ Odoo builds and 185+ total projects across Europe, the Middle East, and North America, reducing query response times by over 60% on multi-million row PostgreSQL databases.

• Enterprise ERP & Database Engines: Odoo 15 to 19, Python ORM, PostgreSQL query profiling, PgBouncer pooling, OWL reactive components, and zero-bloat modular architecture.
• Cryptographic Compliance: ZATCA Phase 2 E-Invoicing engine for Saudi Arabia and GCC, implementing ECDSA secp256k1 signing, SHA-256 UBL 2.1 XML hashing, QR code TLV digests, and automated clearance API handshakes.
• Distributed Product Engineering: Offline-first mobile systems on Flutter (Riverpod, Hive, SQLite) syncing with Next.js web applications and REST APIs.
• Lightweight DevOps: Self-hosted developer infrastructure on Linux, Docker, Nginx, and cloud clusters.

• Context: European distributor managing multi-currency parts catalogues, workshop orders, dynamic pricing, and EU VAT rules across split processes.
• Architecture: Odoo 17/18 Enterprise with PostgreSQL and OWL. Designed 15+ custom modules for real-time carrier APIs and optimized ORM query paths.
• Result: Cut core report generation latency by 60%, delivering sub-second response times on heavy concurrent inventory lookups. Automotive case study

• Context: Multi-department hospital running clinical records, billing, pharmacy stock, and insurance claims in disconnected tools.
• Architecture: Centralized Odoo HMS covering patient journeys, lab diagnostic workflows, pharmacy inventory, and automated billing.
• Result: Unified administrative and clinical operations into one database of record with role-based access control. Healthcare case study

• Context: Saudi enterprise requiring automated, tamper-proof electronic invoice clearance under ZATCA Phase 2 mandate.
• Architecture: Native Python and Odoo cryptographic engine generating canonical XML UBL 2.1, ECDSA digital signatures, cryptographic invoice hashing, and TLV Base64 QR encoding.
• Result: 100% compliant real-time API clearance with ZATCA Fatoora portal without third-party recurring SaaS fees.

Freelancers and agencies often juggle separate tools for CRM, tasks, timesheets, and invoicing. CLIVORA combines these into one synchronized workspace on Web and Android.

• Role: Founder and Principal Architect; designed full backend, database schemas, and mobile sync engine.
• Architecture: Flutter mobile client with offline-first local storage (Hive + SQLite) syncing with Next.js web console and REST endpoints.
• Availability: Live at clivora.io and published on Google Play.

• Founder & Principal Architect, CODCrafters (2022 - present)
  Directing enterprise ERP deliveries, performance audits, and custom software engineering for clients across 25+ countries.
• Senior Odoo Spreadsheets & BI Specialist, Plectar, Switzerland (2025 - present)
  Multi-dimensional financial and operational modeling, OWL dashboard engineering, and legacy reporting migrations.
• MS in Software Engineering, Quantic School of Business and Technology, Washington D.C., USA
  Graduating October 2026. Cumulative academic standing: 94.75%, proctored comprehensive exam score: 92%.
• BS in Software Engineering (Distinction), PUCIT, Lahore
  Appointed 3-time University Teaching Assistant for Data Science, Computer Networks, and Object-Oriented C++.
• Research Preprint: Zenodo DOI 10.5281/zenodo.22843765
  Focus on low-latency microservice architecture and transaction routing in enterprise ERP systems.
• Doctoral Research Focus: Actively seeking prospective Ph.D. scholarships and doctoral supervisor alignment in Distributed Systems and High-Concurrency Database Engines for 2026/2027 intake.

My research question comes from a production problem. A mobile ERP client goes offline for hours, keeps writing invoices, tasks and time entries across several related tables, and must reconcile with PostgreSQL later without silently losing or overwriting anyone's work. Last-write-wins loses data, and CRDTs are expensive on a low-end Android phone and awkward for relational rows.

Durable Edge-Outbox Synchronization: Managing Relational Divergence in Intermittent Mobile Enterprise Workloads
Muhammad Usman Khan, Zenodo preprint, September 2026. DOI 10.5281/zenodo.22843765

The paper formalises the sync layer of CLIVORA (240 Dart source files, 90,868 lines, Drift/SQLite at schema version 18):

• A durable transactional outbox. Every mutation gets a UUIDv4 idempotency key scoped to its owner and moves through a six-state automaton (pending, processing, retrying, conflicted, permanently_failed, completed) with exponential backoff capped at eight attempts.
• Cloud reconciliation over a per-user WebSocket channel against PostgreSQL under row-level security, with a 500 ms sliding debounce that collapses bursts of change events into one pass.
• Divergence is staged, never resolved silently. Conflicts land in sync_conflict_entries on the device and crm_sync_conflicts in PostgreSQL, with two deterministic operators, take-cloud and keep-local. Keep-local re-enqueues the local state as a new outbox operation, so every write to the cloud still goes through one authorised path.
• In a seeded microbenchmark of the outbox model (10 trials of 1,000 operations), ingestion through durable SQLite WAL commit averaged 25.1 ms (SD 2.8 ms, p99 31.3 ms), and storage shrank to 9.1% of peak after post-sync tombstone sweeps.

Questions I want to work on in a PhD

• Exactly-once effects across an edge SQLite replica and a server PostgreSQL database, when the network, the app process and the server can each fail mid-operation.
• Conflict detection that understands relational constraints (foreign keys, unique keys, ledger balance) instead of treating rows as independent documents.
• ERP ledgers as a testbed for consistency under partition: which accounting invariants can be kept locally, and which need coordination.

Selected Pull Requests & Contributions:

• zifter/clickhouse-migrations #105: Migrated PyPI release workflow to Trusted Publishing (OIDC).
• progovoy/vmn #173: Added --base option to vmn show command.
• cubrid-lab/sqlalchemy-cubrid #455: Fixed dialect reflection error mapping for syntax errors.
• ehtishammubarik/websieve #47: Preserved code block indentation during page sanitization.

Merged upstream (2026):

• strelov1/freehire #3688: Added Odoo, DuckDB, DeepSeek, DSPy, LiteLLM, SGLang and Mastra to the skills dictionary (3.3k-star job aggregator).
• strelov1/freehire-mcp #11: Added profile, contribute and my_contributions tools to the MCP server for parity with the CLI.
• cubrid-lab/sqlalchemy-cubrid #732: Removed the Python 3.10 asyncio.TimeoutError branch from is_disconnect.
• 00200200/repro-lens #55 and #100: Reproducibility rules R118 (unseeded Polars sampling) and R127 (unseeded Hugging Face dataset shuffle).

In review: SectorLabs/django-postgres-extra #299: prune index_together in PostgresModelState.render for Django 5.1+.

Building a new platform, modernizing an ERP instance, or discussing doctoral research?

Official Portfolio · Email Inquiry · LinkedIn · CODCrafters · Upwork · WhatsApp