I will write postgresql queries and odoo reports for sales, pos and inventory

Kenya

I speak English

5 orders completed

The Analyst

I’m a Customer Data and Business Intelligence Analyst experienced in turning raw business data into clear insights that support better decision-making. At Denri Africa, I analyze customer behavior, sa...
About this Gig

Need numbers your system's built-in reports can't give you? I write clear, fast SQL that answers the actual business question.

I specialise in PostgreSQL and Odoo. I write production reports over Odoo's POS, sales and inventory tables: multi-location stock distribution, sales converted by each location's currency, customer name cleaning with regex, and pivot-style summaries by branch, product and period.

What I can do:

  • Write new queries, or fix slow and wrong ones
  • Build CTE-based reports that stay readable
  • Clean and standardise messy fields (names, phones, SKUs)
  • Turn queries into views, CSV or Excel exports, or Google Sheets feeds
  • Explain the logic so your team can maintain it

Works with PostgreSQL, Odoo with database access (self-hosted or Odoo.sh), and other SQL databases on request.

Message me first with your database type, the tables involved and an example of the output you want. Read-only access or an anonymised dump is all I need.

Database type:

Distributed database

•

Hierarchical database

Platform:

MySQL

•

PostgreSQL

Expertise:

Data center

•

SQL

•

Performance

•

Query optimization

My Portfolio