A Promotions Marketing Fulfillment Specialist

The client

A promotions marketing company that provides reward and rebate fulfillment to Fortune 1000 companies

This company wanted to migrate their ETL & data integration processing from one solution to a newer one, and so had 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 home grown 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

What WCI did

We designed, developed, documented, and deployed new ETL processes, data marts, reports, and dashboards for each new project.

Scope of solution

Over an eight-month period, WCI team members worked with the client on various projects. Our work served their Finance, Sales, Operations (Call Center) and IT departments.

The technologies used were ETL and data integration solutions, Oracle, and SQL Server.

Dashboard, Performance Mangement & Scorecarding, Business Intelligence and reporting technologies.

The application, backoffice and related technology was Oracle PL/SQL.

The result

The integration tool migration was successful, complete with documentation and transition to the client's staff.

Data marts developed for new clients and custom reports/scorecards were implemented on schedule for client to go-live. The dashboard proof-of-concept was successful in conveying feasibility for rollout to future clients.

WCI documented all data mart designs, ETL mappings, and process flows and conducted information sessions. Learn about other companies WCI has collaborated with.

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.