Back to Projects
backend

Revenue Attribution Engine

Designed an automated attribution pipeline that turns raw transactions into verified, report-ready revenue ownership. The pipeline pulls transactions from MSSQL, fetches related PDFs automatically, extracts business entity names, resolves entities to internal client IDs, and writes validated attributions into reporting tables.

Technologies Used

PythonMSSQLPower BI

Results & Impact

  • Secured and credited 32M+ GHS to the rightful business unit
  • 99%+ attribution accuracy across thousands of daily transactions
  • Reporting cycle shortened from days to minutes
  • Eliminated inter-unit friction caused by incorrect name mappings