Fix Incorrect SQL Reports & Reconcile Your DataAsaf Dallal
Get the right numbers from the SQL reports your team already relies on. I investigate inconsistent totals, duplicate rows and missing records, then deliver corrected SQL with checks you can rerun.
Bring me a report that needs to add up
Revenue or order counts change after a join.
Two reports disagree because of dates, statuses, filters or grouping.
A recurring report drops records or needs a new business rule.
Your handoff includes
Corrected SQL: a readable query with the key business rules explained.
Validation checks: expected totals and edge cases you can rerun after future changes.
A reconciliation note: what caused the mismatch, what changed and how the repaired result was checked.
Run instructions: the inputs, assumptions and steps needed to use the report.
Proof you can inspect
In the linked fictional demonstration, an item-level join inflated a $390 total to $620. The repair produces five paid orders and $390, with checks for equal-value orders, cancelled orders and customers without paid orders. This is a demonstration, not a client result.
Start with a written brief
Send the query, database type/version, table definitions and a small anonymized sample showing the result you need. I confirm a defined scope, fixed quote, delivery date and acceptance checks before work starts.
Five years of data engineering experience at Mobileye. Communication and handoff are written. AI assistance is used where permitted; the deliverable is checked against the agreed data and expected results.
FAQs
Example work
Contact for pricing
Duration1 week
Tags
SQL
Data Engineer
Service provided by
Asaf Dallal Petah Tikva, Israel
Fix Incorrect SQL Reports & Reconcile Your DataAsaf Dallal
Contact for pricing
Duration1 week
Tags
SQL
Data Engineer
Get the right numbers from the SQL reports your team already relies on. I investigate inconsistent totals, duplicate rows and missing records, then deliver corrected SQL with checks you can rerun.
Bring me a report that needs to add up
Revenue or order counts change after a join.
Two reports disagree because of dates, statuses, filters or grouping.
A recurring report drops records or needs a new business rule.
Your handoff includes
Corrected SQL: a readable query with the key business rules explained.
Validation checks: expected totals and edge cases you can rerun after future changes.
A reconciliation note: what caused the mismatch, what changed and how the repaired result was checked.
Run instructions: the inputs, assumptions and steps needed to use the report.
Proof you can inspect
In the linked fictional demonstration, an item-level join inflated a $390 total to $620. The repair produces five paid orders and $390, with checks for equal-value orders, cancelled orders and customers without paid orders. This is a demonstration, not a client result.
Start with a written brief
Send the query, database type/version, table definitions and a small anonymized sample showing the result you need. I confirm a defined scope, fixed quote, delivery date and acceptance checks before work starts.
Five years of data engineering experience at Mobileye. Communication and handoff are written. AI assistance is used where permitted; the deliverable is checked against the agreed data and expected results.
FAQs
Example work
Contact for pricing