My role, as a Database Developer and Analyst, was to design and implement a solution for calculating the Asset Retirement Obligation costs for Wells, Pipelines, and Facilities. The system would be required to track each of the entities by interfacing with existing systems and providing a user interface to audit and resolve any issues resulting from the appending and merging of the data from these systems.
Challenges: The existing process used to currently accomplish the calculation was an Excel spreadsheet and was to be the main source of specifications and logic. Some additional information was provided by the stakeholders, but the approach, design, and business logic were not pre-defined.
Primary Accomplishment: This client's ARO process is now fully auditable and reproducable, resulting in less time spent with auditors and a more concise understanding of their regulatory obligations.
This system is in use and is being internally maintained.