Cloud-Based Material Resource Planning

AWS Cloud

Confidential

Amazon S3, Amazon Redshift, AWS Managed Kubernetes, Amazon SageMaker

Confidential

SotaICG

SotaICG is an innovative Data Analytics Agency powered by AI with a focus on the oil and gas industry. SotaICG leverages advanced data analytics and artificial intelligence to drive insights and optimize operations within the energy sector.

SotaICG encountered several significant challenges that required collaboration with SotaTek to address effectively:

• Legacy System: Users were accustomed to the legacy systems in place, making the transition to a new, advanced platform difficult.
• Skill Requirements: The shift to an AI-powered data analytics platform necessitated new skills, potentially diverting focus from the core business activities of the organization.
• High Transformation Costs: The cost of transformation was substantial, raising concerns about the return on investment and the financial viability of the project.
• Data Management Complexity: Efficiently storing and managing large volumes of oil and gas data required robust solutions to handle raw data, data cleaning, and preparation for machine learning models.
• Predictive Model Accuracy: Developing and maintaining accurate predictive models for oil and gas prices and drilling device maintenance demanded sophisticated tools and processes.

To address these challenges, SotaTek implemented a comprehensive solution using AWS technologies:

• S3 and Redshift: SotaTek built a data lake and data warehouse by utilizing S3 for cost-effective storage of oil and gas data files. Once the raw data was cleaned, it was stored in Redshift, making it ready for the machine learning phase.
• AWS Managed Kubernetes with EC2 Spot Instances: This combination provided a powerful and cost-efficient solution for running ETL jobs during the data cleaning phase, ensuring that data was processed efficiently and effectively.
• SageMaker: SotaTek leveraged SageMaker to automate the training of predictive models, such as oil and gas price prediction and drilling device maintenance prediction. Data preparation and model performance evaluation were facilitated through SageMaker Processing jobs, ensuring accurate and reliable predictions.

• Implementation of a scalable data lake using Amazon S3 for cost-effective storage.
• Development of a data warehouse on Amazon Redshift for efficient data processing and analysis.
• Utilization of AWS Managed Kubernetes with EC2 spot instances for running ETL jobs, optimizing costs and performance.
• Integration of Amazon SageMaker for automating predictive model training and enhancing decision-making with advanced analytics.

The collaboration between SotaICG and SotaTek resulted in a highly successful project completion. After the project, SotaICG saw significant improvements in their data management and predictive capabilities. The transition to the AWS-based solution provided a scalable and cost-effective infrastructure, reducing operational costs and enhancing data processing efficiency.

The use of SageMaker enabled accurate and timely predictions for oil and gas prices, as well as maintenance schedules for drilling devices, leading to better decision-making and optimized operations.

Ultimately, the project empowered SotaICG to leverage advanced data analytics, driving innovation and maintaining their competitive edge in the oil and gas industry.