Optimized Inventory with Real-Time Forecasting for Leading Manufacturer
overview
Dril-Quip is one of the world’s leading manufacturers of offshore drilling and production equipment for use in Deepwater applications. It uses a manual process for generating month-end demand forecast. Dril-Quip needs an efficient way to compile the data from three separate systems (Oracle CRM, Backlog and Throughput) to build insightful reports with less effort. By centralizing their data warehouse, Dril-Quip was able to produce actionable demand forecasting and reduce overall costs.
technology used
Amazon Web Services (AWS)
AWS Step Functions
AWS CloudWatch
AWS CloudFormation
Amazon RDS
Amazon S3
AWS Lambda
Amazon Simple Notification Service
Amazon QuickSight
technology used
| Amazon Web Services (AWS) | AWS Step Functions | AWS CloudWatch |
| AWS CloudFormation | Amazon RDS | Amazon S3 |
| AWS Lambda | Amazon QuickSight | Amazon Simple Notification Service |
technology used
| Amazon Web Services (AWS)< | AWS Step Functions |
| AWS CloudWatch | AWS CloudFormation |
| Amazon RDS | Amazon S3 |
| AWS Lambda | Amazon QuickSight |
| Amazon Simple Notification Service | |
challenges
Lack of a centralized project management system strained resource allocation and reduced ROI
Dril-Quip’s process needed multiple resources from different teams to produce the product once every month aka time-consuming manual process to answer business questions. Reports were on excel with undocumented business rules under hidden macros. There was a need to standardize the format of the report for easy consumption and delivery. Needed a solution with minimum IT support and initial capital spending on infrastructure.
solution
One centralized network for increased agility and effortless forecasting
Implemented a demand forecast solution by leveraging AWS services that include S3, RDS, AWS Lambda, QuickSight, Step Functions, SNS, CloudWatch, and CloudTrail. Created an automated data loading pipeline encompassing S3, Lambda, Step Functions, and CloudWatch to process input data stored in S3 bucket. Configured notification services to apprise users through emails on the success or failure of a job.
outcome
Elevated efficiency, overall cost reduction, more accurate demand forecasting
The client has boosted productivity and efficiency by adding accurate demand forecasting. The interactive dashboard in QuickSight provides a rich visual experience to deliver up-to-date reports that reduce processing time from days to minutes. Kept overall infrastructure cost low through AWS pay-as-you-go approach without any long-term commitment.
Dashboard reduced processing time from days to minutes
Increased ROI and productivity with demand forecasting