I will write, fix and optimize sql queries for postgresql, mysql or bigquery

Bangladesh

I speak Bengali, English

Data analyst for Excel, SQL and dashboards

Pivotsmith turns messy data into clear answers. I build automated Excel and Google Sheets dashboards, write and optimize SQL (PostgreSQL, MySQL, BigQuery), clean and merge data with Python pandas, and...
About this Gig

Need a query that actually returns the right numbers? I write and fix SQL for analytics and reporting.


What I do

  • New queries from a plain-English question ("monthly revenue by channel with MoM growth")
  • Fix queries that are slow, return duplicates or give wrong totals (the usual cause is join fan-out)
  • Window functions, CTEs, cohorts, retention, funnels, running totals, top-N per group
  • Query tuning: rewrites, index suggestions, EXPLAIN review
  • Converting queries between PostgreSQL, MySQL, SQLite, SQL Server, BigQuery and Snowflake

Every query comes with comments explaining the logic and a sample of its output from your data or a test copy. You won't receive anything I haven't run.


How I work: I use AI-assisted tools for drafting and documentation. I test, verify and take responsibility for every query myself.


I never need write access to production. A read-only user or a sample dump is enough.

Database type:

Relational database

Platform:

BigQuery

•

MySQL

•

PostgreSQL

•

SQLite

Expertise:

SQL

•

DQL

•

Performance

•

Query optimization

My Portfolio