Supply Chain Management and Data Warehousing solution for a global manufacturing company.

Company is a global developer, manufacturer and supplier of printing solutions and products. It has more than sales offices located globally, manufacturing centers in different continents and products sold in nearly 200 countries around the world.

Challenge

To ensure that global market expansion and diversification of its business units was successful the customer realized that it needed detailed, accurate and timely information for strategic planning and decision making, and improved data flow between its corporate offices and the thousands of retail partner outlets that carry and sell its printers globally.

Solution

• Standardization of the company's corporate information systems by introducing a flexible and robust tool to access its data warehouse.
• iGlades developed a sales and inventory application to access its cloud-based Data Warehouse to ensure that the company's sales representatives had timely and immediate access to up-to-date information.
• Through effective use of optimization and collaborative technologies in merchandising and inventory control the client was able to create real, differential customer value.

Benefits

• Quick and easy access to information critical for making business decisions.
• Identified sales opportunities.
• Reduce its operating costs by 20 percent.
• Improve supply chain management system by partnering with suppliers that provide parts at competitive prices.
• Increased profitability by 30 percent.

Technologies used:

• Data Warehouse - Amazon Redshift
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x