Project Title: Master Data Management System for major Russian Drilling Contractor

The Challenge

The client is a major drilling contractor providing services to the leading Russian and foreign Oil & Gas companies in various projects concerning investigation, drilling, servicing and maintenance of oil and gas wells. The company operates throughout Russia via network of 9 Regional Offices located in key oil production regions – Volga Region, Western and Eastern Siberia. In 2006 the company opened an operations support office in Uzbekistan and thus expanded its activities abroad.

The client information management used data from different systems at branch-offices. The same information stored in different systems was processed in different ways. There was no single master data source for all systems – thus each data modification had to be duplicated in all systems, which was very time-consuming and resulted in data inconsistency. To eliminate this problem the company’s management was looking for a proper Master Data Management (MDM) System to improve corporate information management process. Digital Design has had MDM expertise delivering a similar project for TetraPak - this expertise helped to develop MDM system for the drilling contractor.

The Solution

MDM system developed by Digital Design is a web-application providing role-based access for the system users and single interface for input and modification of the data used by over 20 different systems. Data exchange between MDM system and other applications (external systems) is provided through BizTalk Server 2006 R2. BizTalk Server receives messages from the MDM system via its receipt-port and sends them via send-port to the customer’s external systems – e.g. Assets management, Supply management, Tax & Accounting, HR & Salary etc. Process models are described in BizTalk Server Orchestrations (BTO) terms. BTO enable code implementation isolation from the overall process and make it possible to add "subscriber"-applications with no impact on the BizTalk implementation code. The MDM system provides effective access rights management, change-tracking functionality and versions control.

The MDM system implemented by Digital Design helped the client achieve dramatic increase of the enterprise productivity through consistent, accurate and always available critical business data, substantially reducing time for new data input and efficient access rights management. The solution is flexible enough to receive new application data, as well as get integrated with any new systems to be used by the company’s branch-offices and/or any of its business-partners – both in Russia and abroad.

As soon as the MDM project was finalized the customer felt ready to start the next iteration using BizTalk Server for delivering data from the branch-offices’ accounting (ERP) system to the company’s HQ in Moscow.

Tools and Technologies

SQL Server 2005 (incl. Reporting, Integration and Analysis Services)
BizTalk Server 2006 R2
ASP .NET/ .NET 2.0
Web-Services
OLAP, MDX
XML
COM

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.