Development of Smart ePIPE for Upstream Department IT Solutions
This initiative focused on creating a comprehensive tool for managing upstream pipeline data, reporting, and visualization.
Problem Statement
Saudi Aramco’s upstream department required a unified GIS based solution to improve pipeline data management, streamline workflows, and integrate advanced visualization tools. Existing solutions lacked customization for upstream operations, necessitating a tailored approach to address challenges like spatial data editing and operational insights.
The biggest challenge was that Arguzo was not utilizing technology properly. Too much of the work was still being recorded manually, which meant that the numbers took a long time to note down and then to be analyzed. Live data was also not available and decisions can only be made after all the required data and been received. This was holding Arguzo back; they knew they could corner more of the market if they had the ability to be more mobile. The work addressed three critical issues for Pharm Ltd.:
- Improve sales and operations and production planning:
The teams focused their efforts on a few of the highest-value S&OP levers in order to review the current planning process, identify gaps in the planning infrastructure and analytically understand demand and supply variability. - Determine the right inventory level:
With hundreds of medications in the market, Pharm Ltd. needed a proper method to predict and manage their inventory. Using a mean absolute percentage analysis (MAPE), the teams defined appropriate levels for raw materials and finished products by mapping actual versus forecasted sales on the most important SKUs. - Optimize the supply chain for perfect order planning:
The diagnostic determined the stressors that affected sales and service levels. The teams focused on resolving issues related to higher-than-normal back-orders and lead times, which stressed the entire supply chain and led to delays in medications reaching consumers.
Technology Stack
- ArcGIS JavaScript API 3.x/4.x for Web GIS
- Dojo 1.x Framework for UI
- J2EE for Backend
- UPDM 2019 or latest
- ArcPY
- ArcGIS Pro
- ArcGIS Server
- ArcGIS Desktop
- Oracle Spatial / ArcSDE
Objectives
- Migrate and enhance existing Smart ePIPE widgets for upstream specific functionalities.
- Introduce GIS data editing capabilities for managing pipeline data with precision.
- Enhance existing modules to include advanced features like recommendations, KPI tracking, and integration with external systems.
Responsibilities
- Migrated and enhanced pipeline management widgets using ArcGIS JavaScript API
- Implemented data validation and editing workflows for GIS features.
- Developed and tested module enhancements for integrity, corrosion, and scraping planning.
Solution
- Agile Methodology: Adopted an iterative approach, allowing continuous updates and feedback.
- Module Enhancements.
- Integrated GIS editing capabilities such as pipeline splitting, merging, and calibration.
- efactored modules like Pipeline Integrity and Corrosion Management to include customized recommendations and reporting features.
- Upgraded APIs and backend queries to support upstream data tables.
- Technology Stack: Used ArcGIS Pro, ArcPY, and Oracle Spatial to ensure robust spatial data management.
Execution and Challenges
Execution:
- Delivered GIS widgets for search, reporting, and visualization, ensuring seamless integration with existing systems.
- Enhanced upstream modules to include map services and improved access control for multiple organizations.
- Built an editing interface with validation rules provided by the client.
Challenges:
- Aligning module upgrades with the client’s strict data governance policies.
- Managing dependencies on third party systems for data integration.
Results and Impact
- Operational Efficiency: Improved pipeline data management workflows, reducing manual interventions by 30%.
- Enhanced Usability: Delivered tools for precise editing and detailed reporting, empowering engineers with actionable insights.
- Scalability: Prepared the solution for future integration with additional upstream assets and workflows.
Key Learnings
- Iterative development allows for accommodating dynamic requirements effectively.
- Comprehensive GIS tools can significantly enhance data transparency and operational control.
- Cross team collaboration is vital when integrating external systems and datasets.
Visuals and Supporting Data
- Screenshots/Diagrams: Included visual examples of GIS widgets, data editing workflows, and module dashboards.
- Metrics: Highlighted improvements in search efficiency and data validation accuracy.
Conclusion
The Smart ePIPE for upstream project successfully addressed the challenges of pipeline data management in Saudi Aramco’s upstream operations. By delivering enhanced GIS tools, editing functionalities, and scalable modules, the project provided a foundation for ongoing operational excellence and future innovation.
Need industry insights? Talk to our specialists for detailed information.
Consulting WP really helped us achieve our financial goals. The slick presentation along with fantastic readability ensures that our financial standing is stable.
