This is a loss prevention data model desinged for cutomer to track the fraudulent activities with so much of details across dimensions, it helps clients to save lot of money. I was a sole ETL design and developer for this project, it is ongoing for different clients and successfully implemented to many, had used ODI and SSIS for it along with Oracle database.

Expensed data, aka Billed data, serves as the basis for all spend analysis conducted at a company. Booked data provides insight into how much total Travel spend is occurring. When you combine this information together in a single view, stakeholders can build a picture around the spend gap between on and off platform Travel bookings. The industry refers to this gap as spend leakage.

Outright fraud or mistakes in calculating charges of car service trips by the service provider/s to their corporate clients have led to Deem developing it’s Car service Audit Analytics Engine.

Xbri is a Oracle product internally built using Microstratergy used for loss prevention analysis mainly todetcet the fraudulent loss of revenue for a retail store, ODI is used as a part of data loading tool.