Master Data

Project Description	A major oil and gas corporation funded a maintenance initiative to migrate all their asset data into SAP. Data would have to be collected from different historical and current formats for all their terminals across Canada, cleaned, and organized into a SAP hierarchy before importing.
Business Benefits	Ability to manage all assets across the country with a single Master Data Management system Cost efficiencies due to being able to sort and purchase by cost centers Engineering and risk efficiencies due to being able to assign maintenance plans and costs to each asset
Toolset	Microsoft Excel, MindMap, SAP
Methodology	1) Perform data collection of all historical and current asset records for all sites across Canada 2) Identify hierarchical SAP structure 3) Perform cleaning of all historical and current data into one unified database 4) Sort all assets into their hierarchical SAP structures 5) Migrate all data into the new SAP structure