Aptitive built a custom web service and analytics solution for a global manufacturing and industrial automation company

Client Industry

Manufacturing & Industrial Automation 

Technology Used

Custom Web Services
.Net Frameworks
SQL Server Integration Services
Salesforce.com
Cognos 11

The Challenge

Our client’s point-of-sales application functioned in a silo and required a highly manual process to load and maintain their POS sales information. This lead to data inconsistency and quality issues. These issues prevented our client from meeting corporate reporting needs and lead to 3-4 month delay in distributing sales bonuses to their employees.

Our Solution

Our solution uses custom web services to allow for near real-time, automated integration of data from various sources, processing over 500 distributers and 3000 files per month. Using an ETL process, our solution performs data quality checks on this information, and consolidates it into a centralized data repository. The data is then integrated into an enterprise data warehouse for reporting and analytics on sales and marketing information in a powerful, easy-to-use dashboard.

The Outcome

Our client gained operational cost savings from having an automated solution, clear and accurate insights into their sales performance metrics, and the ability to meet corporate reporting needs.

Our solution resulted in:

  • Robust analytics on sales quantities, parts, sales by customer, and other metrics that meet corporate reporting needs
  • Quick turnaround on sales information for sales commissions
  • Real-time and automated processing
  • Actionable and accurate data on transactions and revenue for key customer accounts

Client Industry

Manufacturing & Industrial Automation

 

Technology Used

Custom Web Services
.Net Frameworks
SQL Server Integration Services
Salesforce.com
Cognos 11