Aspirant Wavestone Logo

Developing a Solution for Data Aggregation and Reporting

App Development & Integration

The Challenge

Due to multiple acquisitions, our client, a major network services company, needed to aggregate and report financial and shipping data stored in multiple Enterprise Resource Planning (ERP) systems, as well as business processes and data structure. To address these problems, our team had to define standard operating processes, perform data normalization, and deduplication. We also had to make sure the system supported different vendors and versions of the ERPs.

The Solution

Our team developed the application with N Tier architecture running on a high availability SQL Server Cluster database. SQL Server Integration Services (SSIS) was used to integrate systems to the data warehouse. This also served as a central repository for transformation maps. The solution included process logging and error reporting. SQL Server Reporting Services (SSRS) was used to build report templates with an integration into a custom portal to manage user access and requests.

The Results

  • Single source of truth for near real-time financial and shipping data.
  • Structured transformation system to onboard additional inbound systems.
  • Data aggregation resulted in a highly available data warehouse consumed by multiple downstream systems.
  • Flexible reporting portal to manage predefined report templates.
Paul offers more than 25 years of experience leading large and small teams to implement complex technology-centric projects. He has successfully executed large-scale global programs and projects, and is able to tenaciously drive projects to completion, while maintaining high-level customer satisfaction and team involvement. As a Principal, Paul is a trusted advisor and leader to clients as well as employees and partners, with a strong focus on working to find practical and sustainable solutions.​

Related posts