This company wanted to migrate their ETL & data integration processing from one solution to a newer one, and so had an immediate need for custom BI solutions. Intended to serve new, high-volume clients, they required custom reporting and their own internal infrastructure, separate from the databases of smaller clients.

Existing homegrown solutions could not scale sufficiently. Large retailers provide data in their own formats, so the company would need help with coding to import that data.

To them, a successful migration would have to produce complete custom reporting for a new client on the first day of rollout, with basic information formatted in the way their client wanted to see it, including:

• Volume of rebates submitted
• How long it takes to write a check
• The effectiveness of different rebates for different products and campaigns
• The number of products sold vs. the number of rebates redeemed
• How fast rebates are processed per campaign

Other requirements included:

• Proper reconciliation between financial systems and exception reporting on non-balancing accounts
• Improve performance monitoring of tools, including notification of failed data transfers
• The capability to perform year-to-year comparisons on KPI metrics using dashboards