Skip to content
Wasim Rashid

Daily performance & revenue reporting

From raw transaction export to a 10-sheet workbook, on a schedule

Role
Designer and maintainer
Period
2026 – present
Status
Client confidential

Overview

An AI-assisted, scheduled pipeline using Claude, Python and Excel that converts each day's transaction export into a performance and revenue workbook with routing recommendations.

Approach

  1. 01

    What it produces

    A BIN-by-MID matrix, MID and card-scheme performance, revenue tracking, poor-performer flags and routing recommendations.

  2. 02

    Rules before charts

    Standing data rules for field cleaning, metric definitions and correct roll-up of acceptance rates, documented as a repeatable procedure.

Outcome

  • Manual analysis became a repeatable daily process
  • Found and fixed a roll-up error that was understating BIN-level merchant acceptance rates

Technologies

  • Python
  • Excel
  • Claude
  • Scheduled tasks

Next project

Faktura

Open to consulting engagements

Have a payment problem that needs tracing?

Tell me which providers are involved and what is going wrong, or what needs to go live. I will tell you plainly whether I can help.

Tell me
Which providers and markets are involved
Show me
What is failing, or what needs to go live
You get
A plain answer on whether I can help