Reporting System Consolidates Customer Data

App Development & Integration

The Challenge

A large consumer healthcare company was looking for a reporting system to consolidate all point of sale, shipment, and forecast data to provide users a single location to review all customer data. Our team worked with difficult data models where data formats changed month to month, there were huge volumes of data, and user supplied their POS data differently. Transfer methods and frequency of transfer also differed by user, and both fiscal weeks and UPCs required normalization.

The Solution

Aspirant was engaged to fill all the necessary roles for the delivery of the software product and our team leveraged an out-of-the-box solution for data transfer and workflow. We developed cross customer comparisons; a fruitful advertising and promotion strategy; a way to differentiate between forecast and actual data; and a way to define build and burn rates for products. We also updated existing brand level reporting to include customer segmentation.

The Results

  • Creation of a robust platform that leveraged already existing technologies with minimal training.
  • Graphical User Interface provided the user with the ability to map customer UPCs to internal products.
  • Integrations system searched for new files in the repository, then automatically downloaded them before importing into the warehouse.
  • SQL Server Analysis Service was used for reporting through an Excel interface, and SSAS provided data for a web-based portal for brand and customer P&L.
Paul is a senior engagement manager who works closely with peers in other service lines to create solutions for clients in the following areas: business development, sales, resource and vendor management, resource hiring/termination decisions, account management, service line P&L forecasting and management, and specific project delivery. He manages a team of employees and partners across a diverse technology platform from around the world who serve our clients to provide PMO services to Fortune 500, mid-range, and small firms in the United States, Canada, Puerto Rico, the UK, and Northern Europe.

Related posts