Project Description:
I am looking for a solution to manage voip rates from various providers received in xl (different formats). T
1. Import carrier rates from excel sheets into db
2. Normalize / standardise rates from various providers (I.e. standard prefixes, length etc)
3. Compare rates from 2
4. Produce rates comparison report with ability to export LCR, highest etc (i.e. customer sell base rates)
5. Normalise output (trim, duplicates etc)
6. Apply markup based on set rules (e.g. blanket %, per destination etc)
7. Track rate changes (new routes, rate changes etc..)
8. Target comparison / analysis
Ideally you would have built such a tool and be able to demo.