CASE STUDY
Managing External Network Connections for an Oil & Gas Company
CLIENT:
Large Oil & Gas Company
EMPLOYEES:
10,000+
INDUSTRIES:
Oil & Gas
SERVICES:
MDM Implementation Service
MDM Solution Support Service
PLATFORMS:
Master Data Management
DATA DOMAINS:
Asset
ABOUT:
CHALLENGE:
Many companies face the never-ending challenge of monitoring and improving critical cybersecurity infrastructure with network connections. For the oil and gas industry, the challenges are heightened in that companies must allow external connections into their network to process their product (e.g., monitoring oil rig platforms). Data must be tracked to create, certify, recertify, and retire connections globally.
This case study is about a company with whom the current process had business users utilizing front-end forms for data submission, allowing duplicate and inaccurate data to be entered. The forms were also limited in the data collection of a network connection, resulting in inaccuracies or incomplete certifications of a network connection. IT had to manually reconcile spreadsheets weekly to account for the poor data quality. For compliance and internal efficiency reasons, this company desired a system that could track the certification, recertification, and retirement of all external network connections, store metadata information such as firewall access points, and attach vital documentation via an automated process.
Questions?
Schedule a free call with a senior solution architect,
not a sales person, to answer questions,
provide a second option, or help you take the right next step.
SOLUTION:
What we delivered:
D3Clarity’s objective was to migrate all external and internal network connection data, workflows, and front-end user forms to a strategic data management system.
An approach was taken to implement a master data management (MDM) solution. D3Clarity mapped a complex multi-step manual certification process involving five unique business unit teams into a data model consisting of master and reference data to capture all relevant data points concerning a connection. Data validation was added to ensure data integrity and compliance with regulations. The system enabled the external network connection task force team to store additional data elements, including the controls catalog.
Integrating the corporate notification and approval system allows a fully automated system to contribute to the corporation’s auditing protocols. Data transparency was increased for data stewardship through self-tracking, follow-up email notifications, and process automation.
All users are now mandated to facilitate all external network connection requests (e.g., new connection requests, update business contact requests, retire connection requests, and recertification requests) through the new MDM solution.
How we delivered:
In summary, the external network solution has brought significant benefits to this organization, addressing their need for compliance and internal efficiency in managing external network connections:
- Modernized Data Management Process: Our solution has modernized the customer’s data management process, ensuring compliance and enhancing internal efficiency in managing external network connections.
- Enterprise-Level Data Storage Solution: We successfully developed and implemented an enterprise-level data storage solution tailored to the customer’s needs. This solution allows for the efficient storage and management of external network connection data acquired through an automated certification process.
- Streamlined Workflow Processes: Our solution includes streamlined workflow processes for the entire external network connection lifecycle, featuring front-end data entry forms, automated notices for initiation, modification, and retirement of connections, and security access for data stewardship and maintenance.
- Cost Avoidance Benefit: Implementing our solution has resulted in a significant cost avoidance benefit of $3.6 million per year, which would otherwise have been incurred if the external network task force team had to continue manual remediation of external network connection certifications.
- Single Trusted Repository: The customer now benefits from having a single trusted repository of every external network certification request, improving data accuracy, accessibility, and overall management efficiency.
- Full Visibility and Reporting: Our solution enables the organization to achieve complete visibility into the external network connection data flow lifecycle, facilitating quick identification and reporting on the certification process status.
- Connection Status Tracking: The business now has the capability to track the status of each connection from request to retirement, along with clear ownership of each step in the connection process, enhancing accountability and oversight.
RESULTS:
Deliverables:
- Single trusted repository of every external network certification request
Business Value:
- The solution fully supports the external network connection data flow life cycle process and allows the organization to identify and report on the certification process quickly
The solution delivered by D3Clarity met the customer’s immediate needs and provided a robust framework for continued efficiency, compliance, and data management excellence in managing external network connections.
I’ve been working with D3Clarity since 2017. They've helped us migrate over our very first application from Azure to AWS and have been with us since. They have a very knowledgeable & professional staff that have helped us in our digital migration from our on-prem data centers to the AWS cloud.
Anthony Raiti
Director of Cloud Operations
Avis Budget Group
D3Clarity provided us with invaluable insights, visualizations, topography maps and tools to help us make better decisions with our cloud infrastructure.
Greg Falconer
CEO
iVitaFi
We selected D3Clarity to architect and migrate our Customer Services application to AWS and I can confidently say that their services are “top notch.”
Kavita Singh
Functional Manager, Customer Services Apps
Payless Car Rental
D3Clarity went above and beyond. They are great to work with and create long lasting relationships!
Tam Anderson
Program Manager
Independent Publishing Coop
Great partnership with D3Clarity!
Kevin Acker
System Architect
Wisconsin Department of Employee Trust Funds
D3Clarity’s experience with multiple MDM vendors, helped make the implementation a success.
Gary Daniell
Director of Engineering
AGDATA
every size. every industry.
Recent Case Studies
D3Clarity was asked to help a very large client in the oil and gas industry with a digital data transformation
Assisted in the establishment of the Enterprise Data Governance Framework
TALK TECH WITH DATA DAVE
PODCAST
RECENT BLOG POSTS
Choosing the Right Master Data Management Platform
