Customer Data Lake Tool Integration Saved Tool Maintenance Cost for a Global Sustainable Aerospace Major

Client

The client is an industry leader in manufacturing, designing, and delivering aerospace services, products, and solutions to a wide customer base worldwide.

Business Challenges

• Analyse 25-year-old historical and unstructured maintenance and tooling data for trends and improvement recommendations 
• Create improvements in the effectiveness and efficiency of the maintenance and calibration of tools across the plant

Solution Highlights

• Implemented a solution to cleanse and analyze the data being uploaded to the client’s cloud application. 
• Generated an analysis report on the uploaded and analyzed data with the help of the new system to trace the effectiveness and efficiency of the tools across different plants. 
• Helped generate clear and objective reports to help make future decisions with multiple scenarios of tool repair, maintenance, availability, and effectiveness. 
• Technologies used included the following: 
  • SQL Server 
  • PostgreSQL 
  • Javascript, Cascading Style Sheets (CSS)

Business Benefits

• 2Million+ rows of data cleansed for Skywise for analysi