- 60% Faster Operational Efficiency
- 10% Reduction in Operational Costs
Client Overview
Our client is a global provider of electronics manufacturing services and solutions. They offer electronics design, production, and product management services to various companies operating in different industries and markets such as automotive and transportation, cloud, computing and storage, and many others. They operate in over 100 locations across 30 countries to ensure the smooth functioning of their business.
Business Challenges and Objectives
- The client was using a 3rd party tool called Travel Management System (TMS) to maintain their operations and track the goods sold and procured.
- The business reporting on this data along with the SAP data was manual and extremely tedious.
- The client wanted TekLink to resolve the issue and build self-service analytics capabilities within the system.
The Solution
- The TekLink Team analyzed the client’s existing framework to identify the modifications required to the system and gaps in the existing system.
- The Team designed and built the solution without changing the existing framework.
- The Team used TMS to manage the data shipments from SAP and non-SAP data sources to track and manage the supply chain.
- The data extracts from the various sources acted as the input to AWS S3 using Talend as the ETL Tool.
- The different data used for the reports are: Sales Order Data, Shipment Data and Deliveries.
- The information was then fed into the Snowflake System to build the foundation for Data Warehouse for analytics purposes on TMS and SAP Data together.
Key Benefits
- The solution provides visibility to the product level details to analyze the TMS Data clearly.
- Reduction in the errors in the report generation due to the elimination of the manual loads in Power BI from TMS and SAP.
- Some of the key metrics from the implementation of the solution are:
- 100% availability of the latest data from TMS daily
- 67% faster processing of the Accounting Cycle
- 60% increase in the operational efficiency
- Time for analysis reduced to 1-hour from the previous 8 Weeks