Skip to main content

Case Studies

Our case studies provide examples of our work solving business challenges for our clients. Our experience on many types of projects enables us to recommend proven solutions to put your data to work and make your information useful.

Big Data

Case Study #1: Cost Effective Data Archiving and Reporting with Big Data Tools and the Cloud

The Challenge

As the result of an effort to consolidate all existing ERP systems into one SAP solution, our client was under pressure to implement an archival strategy for the legacy data of 18 companies. This legacy data had to be accurately preserved and made readily available, to satisfy compliance, regulatory and operational needs. In addition, the challenges did not end there:

*  Once the SAP system was live, the client would need to shut down the legacy systems within weeks. Delays would lead to the renewal of a costly Transition Services Agreement (TSA) that the client was desperate to avoid

* It was 2016, and the Oil and Gas sector was gripped by one of the worst economic downturns in its history. Like most organizations, funding became scarce, so innovation on a tight budget was paramount.

*  Finally, due to a reduction in workforce combined with the implementation of SAP, our client was keen to limit the amount of change forced onto its staff

Given the pressure of a tight delivery timeframe, reduced budgets and a need for Big Data expertise, the client reached out to Sullexis to help deliver the rapid innovation required.

The Solution

Given our experience with the MapR platform, combined with our knowledge of the open source ecosystem around the platform, we implemented a legacy data archive system centered on the use of:

  • Sullexis’ custom Sqoop extract and load tools
  • Apache Drill
  • The schema free SQL Query Engine for Hadoop, NoSQL
  • Cloud Storage
  • Elastic Search

Sullexis’ custom Sqoop extract and load tools meant that:

  • Structured data objects could be migrated with data types preserved
  • Big tables (>200MM rows) and small tables (<100 rows) could be treated equally
  • Tables with active transactions could be extracted incrementally

Using Drill enabled our client to seamlessly access their legacy ERP data (previously on Oracle and SQL Server) using their existing SQL skillsets and BI tools which featured Tableau, Lumira, MicroStrategy, Spotfire, SSRS,  and Excel.

Driven by a desire to keep costs and timescales to a minimum, Drill’s native support for SQL was utilized. The use of Drill enabled reports to be rapidly converted and executed against the data residing in the MapR FS. This flexible, low-cost solution, meant that the Oracle and SQL Server platforms could be quickly shut down but with zero operational impact to the end users.

To support the search and extract of the clients’ unstructured data, Elastic Search was implemented on the MapR cluster and used to index a range of TIFFs, PDFs, and Text Reports. These were tagged with meta-data and indexed enabling them to be searched for and extracted on an as needed basis.

The Result

Sullexis’ rapid implementation and flexible approach provided a cost-effective legacy data archiving and reporting, on one unified platform that handles structured and unstructured data. Here are some of the outcomes the client experienced:

  • During the extract and load cycle, over 1.2 billion rows of data from nearly 250,000 tables were migrated from various Oracle and SQL Server databases to the MapR FS running in Microsoft Azure
  • Over 100 operational reports were re-directed to run against the new data to support ongoing business needs
  • Several million TIFFs and PDFs were tagged and indexed with Elastic Search
  • Several new data sources were uncovered using our discovery process, but instead of derailing the project, the Sullexis team directly incorporated these additions into the existing scope, taking just a few days to assess, extract and load successfully
  • With MapR being equally at home on Microsoft Azure as AWS, our client’s concern regarding vendor lock-in was eliminated

Finally, with the MapR infrastructure implemented, a foundation for future Big Data use cases was enabled. The client has already addressed an important operational issue by analyzing equipment sensor data. Encouraged by this recent experience, they are now looking to other use cases that support new lines of business and reduce further operational costs.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $1 Billion

Company Profile

This is a North American oil and gas services company that provides well construction, well completion and well services.

Case Study #2: Big Data Analytics Platform for a Fortune 500 Oil and Gas Company

The Challenge

Our client needed to identify chemical concentrations that were present at a given location and point in time. The data was coming from many different sources in widely varying formats that included both structured data (databases), semi structured (spreadsheets), and unstructured data (email, PDF files, Word documents, etc.). The client had previously attempted a classic Enterprise Data Warehouse (EDW) approach. The big variety of the data made using an EDW virtually impossible. The client’s technical team was battling the challenge of EDW design and Extract, Transform, Load (ETL) implementation, rather than being able to focus on the analysis of the data. With the EDW approach, each data source was taking a large amount of time to load: anywhere from 3 weeks to 6 months.

The Solution

To handle the variety of data, our client needed a big data platform. They considered an Open-source Hadoop implementation, but the knowledge and skills required to integrate and deploy the full set of tools was an obstacle. Our client wanted a pre-built application to ingest, analyze, and visualize data without having to write a custom solution built on unsupported Open-source software. They needed a big data platform that was ready to deploy.

The Data Tactics cloud based Big Data Engine (BDE) was leveraged to provide a readily available platform for data discovery and analysis with pre-built integrations and system monitoring.The widely varying data was easily ingested by configuring the BDE data import MapReduce jobs. Out-of-the-box visualizations within BDE provided users with immediate and valuable discovery tools.

The engagement was complete within 45 days:

  • Day 1-4 – Source data analysis
  • Day 5-6 – Data ingest parser development
    • 9 custom parsers (1 MapReduce parser)
  • Day 7 – Data ingestion of 600,000,000 data elements from 20 data sources
  • Day 8-35 – Analytics development
    • Custom SharePoint ingestion and integration to synchronize and index SharePoint data and enable BDE to dynamically pick up modifications in near real time
    • Custom analytics for environmental monitoring highlighting chemical concentrations temporally and spatially
    • Custom application to highlight geolocation of chemical samples
  • Day 36-45 – Data Discovery and Investigation
    • Guided client personnel through solutions so that individuals can immediately and intuitively find all the data associated with an entity of interest
The Result

Sullexis was able to provision, ingest, build, analyze, and provide actionable results to the client in 45 days. By eliminating the 6-month data ingestion process of the classic EDW, users were able to discover new insights within weeks. This is a case where big data delivered value for a wide variety of data without big volume.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $350 Billion
Employees: 85,000

Company Profile

This is a multi-national oil and gas company responsible for the operation of wells, pipelines, offshore platforms, and processing facilities.

Software Used

  • Data Tactics Big Data Engine (BDE)
  • Hadoop Distributed Filesystems (HDFS)
  • Hadoop MapReduce
  • Apache Accumulo
  • Apache Solr
  • Apache Lucene
  • Apache Tomcat
  • Apache Zookeeper

Case Study #3: Big Data Solution to Optimize Logistics for the Largest Environmental Solutions Provider in North America

The Challenge

Our client needed to optimize their logistics in order to better understand truck routes taken by the 21,000 trucks in the company’s fleet. There wasn’t a way to interpret the data coming in from GPS feeds from trucks in the field, making it difficult to understand when a vehicle was stopped or en route. There was a large volume of data that required heavy analytics.

Our client had attempted an Open-source Hadoop implementation, but the knowledge and skills required to integrate and deploy the full set of tools were proving difficult. Our client had also attempted a MapR implementation, but encountered many of the same challenges. They were battling the technology rather than the problem. Our client wanted a pre-built application to ingest, analyze, and visualize data without having to write a custom solution built on unsupported Open-source software. They needed a big data platform that was ready to deploy.

The Solution

It was faster and more cost effective for our client to buy the Big Data Engine (BDE) from Data Tactics. The Data Tactics cloud based BDE was leveraged to provide a readily available platform for data discovery and analysis. The BDE data import tools were easily configured to ingest the required data using pre built MapReduce jobs. The cloud based hosting model provided ample storage and performance of the data. Analytics were implemented using MapReduce jobs operating in near real-time, delivering visualizations that rendered in seconds.

The Result

Sullexis and Data Tactics, working with the client, were able to deploy a big data platform quickly and cost effectively that met all of the requirements to optimize and understand the client’s truck routes within a matter of weeks.

Company Industry
Waste Disposal and Recycling

Company Size
Revenue: $14 Billion
Employees: 43,000

Company Profile

This client is responsible for waste management, comprehensive waste, and environmental services in the United States and Canada.

Software Used

  • Hadoop Distributed Filesystems (HDFS)
  • Hadoop MapReduce
  • Apache Accumulo
  • Apache Solr
  • Apache Lucene
  • Apache Tomcat
  • Apache Zookeeper

Case Study #4: Big Data Analytics Platform for Upstream Oil and Gas Lease Evaluation

The Challenge

Our client had a repeated need to quickly evaluate initial production (IP) of oil, gas, and water from recently drilled horizontal wells in a number of different geographic areas. They had been struggling to do this manually by first downloading production data from IHS and the Texas Railroad Commission (TX RRC), merging it in Excel, and then building pivot tables and charts to undertake the analysis.

Assembling the data was challenging enough, but actually identifying all the wells in the specific geographic area was proving difficult and, on many occasions, inaccurate.

The Solution

The solution leveraged the Data Tactics cloud based Big Data Engine (BDE) to build ingestion routines to IHS and TX RRC so that data could be directly imported on a monthly basis. With the data loaded into BDE, a custom application was written that displayed the Well Header data on the BDE Google Map plug-in. This application enabled the user to ‘rubber band’ an area of interest on the map, capturing all the Well Header data within the region selected. This data was then available for export to a CSV for further manipulation within Spotfire.

The Result

The automated assembly of the data meant that the most up-to-date information was available for analysis. The ‘rubber banding’ directly on the map allowed the user to specifically identify the lease area of interest, eliminating any errors in selecting those wells manually. We were able to develop analytics and visualizations to help this client gain value from their data.

Company Industry
Upstream Oil & Gas

Company Size
Revenue: $2.3 Billion
Employees: 252

Company Profile

This client is an independent oil and gas company based in Houston, Texas engaged in the exploration, development and exploitation of onshore energy resources. They hold large positions in the Permian and Eagle Ford basins.

Software Used

  • Hadoop Distributed
  • Filesystems (HDFS)
  • Hadoop MapReduce
  • Apache Accumulo
  • Apache Solr
  • Apache Lucene
  • Apache Tomcat
  • Apache Zookeeper

Visualization & Analytics

Case Study #1: Analytics for Leading Specialty Industrial Supplier

The Challenge

Our client had an existing Enterprise Data Warehouse (EDW) that was not meeting the business requirements, making it difficult to report on invoices, inventory levels, and purchase orders. The data in the EDW was inaccurate, inconsistent, and incomplete. The performance of the EDW was also a concern. Our client needed faster reports, an improvement in general performance, and required a reduction in downtime associated with refreshing the reporting Data Warehouse.

The Solution

We developed a SQL Server Integration Services (SSIS) package to support the Extract, Transform, and Load (ETL) process to populate a solution in the Microstrategy tool. We incorporated data for customers, products, vendors, sales representatives, and purchase orders. The solution implemented routines to improve the accuracy and consistency of the data. The cleaned, formatted, validated, reorganized, and reliable information enabled improved reporting of invoices, inventory, and purchase orders. Our solution was architected for optimum performance, resulting in faster data refreshes and reports.

The engagement was complete within 90 days and involved:

  • Mapping data sources to target tables
  • Developing SSIS packages
  • Testing packages
  • Matching and validating EDW data against sources to confirm accuracy
  • Conducting user acceptance tests to gain approval from users
The Result

Within three months, raw data was transformed into useful insights for the company. Implementing the new EDW allowed the client to identify issues arising in the operation of the company. This allowed them to focus on the analysis of the information and make better decisions based on data. By converting data into actionable insights, our client was able to make key business decisions.

Company Industry
Industrial Supplies and Distribution

Company Size
Employees: 1,500

Company Profile

This client is a leading specialty industrial supplier of pipe, valves, fittings and related products.

Software Used

  • SQL Server 2012 Database
  • SQL Server Integration Services (SSIS)
  • MicroStrategy

Case Study #2: Analytics Solution for Well Master Data for a Premier U.S. based Oil and Gas Operator

The Challenge

The lack of a single view of well data can lead to delayed projects, underutilized production capacity, missed revenue opportunities, runaway costs, and regulatory noncompliance. Our client was struggling to create a unified view of their well master data. Data existed in Excel spreadsheets used by the engineering team for analysis. As the team grew, it was necessary to create a central data store of master well information populated from internal systems and augmented with publically available well data.

The Solution

We partnered with our client to implement SQL Server Integration Services (SSIS) to import data into a Microsoft Enterprise Data Warehouse (EDW). Industry data from IHS was implemented, which included well header data, well production data, and well test data. Formation data from the North Dakota Industrial Commission (NDIC) was imported as well.

The solution we provided regularly refreshed the data and merged it with internal sources. Our client’s engineering team was able to rely on a consistent and unified source of well data that could be exported from the data warehouse for analysis in TIBCO™ Spotfire©.

The Result

Our client gained a single and accurate view of well data that was consistent and unified, which provided authoritative master data for operational and analytic uses. Internally produced data and publicly available data from IHS and NDIC were able to be merged, allowing a consolidated view.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $1.1 Billion
Employees: 350

Company Profile

This client is focused on the exploration and production of oil and natural gas.

Software Used

  • SQL Server Integration Services (SSIS)
  • C# .NET

Data Integration Services

Case Study #1: Supply Chain Management Solution for a Global Oil and Gas Company

The Challenge

Enforcing supply chain compliance is critical to managing the environmental, health, and safety risks of finished goods. Procurement and Supply Chain Management (PSCM) teams must define purchasing requirements to ensure the integrity of received goods, especially in regulated industries with stringent safety standards. It is essential that trading partners honor these requirements. When these requirements are not met, the PSCM team needs to capture and manage the incidents of noncompliance.

Our client used an application known as the Non-Compliant Incident (NCI) Tracker. This application was hosted on a legacy platform scheduled for decommission within weeks. Our client needed a replacement application to track incidents of noncompliance. The organization’s IT policy stipulated that the application must be deployed to an existing Microsoft SharePoint environment with no customizations.

The Solution

Within 6 weeks, Sullexis delivered a replacement NCI Tracker application that tracked the non-compliant materials being delivered to warehouses, the time needed to resolve issues in materials, and the performance of materials after the issue had been resolved. By using SharePoint’s out-of-the-box functionality, we were able to deploy the solution on existing hardware without additional license cost, meeting the organizations IT requirements. We replicated the previous application, allowing an easy transition for the users.

The Result

We were able to provide our client with a timely solution that enabled business continuity as the legacy application was decommissioned. Our configuration of SharePoint to mimic the legacy NCI Tracker application resulted in minimal business impact for users. We ensured continuity in PSCM’s enforcement of supply chain compliance.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $350 Billion
Employees: 85,000

Company Profile

This client is a global oil and gas company that is focused on the finding and selling of oil based products.

Software Used

  • SharePoint 2010
  • SQL Server Reporting Services 2008

Case Study #2: Marine Logistics Solution for a Global and Oil and Gas Company

The Challenge

This Oil and Gas company’s Logistics department is responsible for coordinating all vessels carrying shipments in the Gulf of Mexico to support projects, drilling, and operations activity. The lease of the vessels is very costly. Projects, drilling, and operations are dependent on timely and accurate deliveries.

Requests to the Logistics team for cargo services were exchanged via email, with no central source of request information. It is a complex task to effectively match cargo requirements to the appropriate and available vessel under lease. The department utilized many manually created reports on a daily basis to manage the intensive cargo planning and scheduling activity. Because there was no single consolidated source of cargo request information or vessel status, our client was unable to achieve timely and accurate deliveries, incurring expensive and unnecessary downtime.

The Solution

In a period of 6 weeks, Sullexis implemented a solution leveraging Microsoft SharePoint that provided a consolidated source of cargo request information and vessel status. This solution was developed using SharePoint’s out-of-the-box functionality with a short development cycle.

The solution allowed for audit traceability, flexible data management, information from a single source, embedded reporting capabilities, and short development time. Custom reports that were created in the solution allowed our client to improve their decision making process by using reliable data.

The Result

By providing a central source of information, the Logistics department was able to focus on effectively matching cargo requirements to the appropriate and available vessel under lease. Having a trusted source of information enabled more time for logistics planning and less time gathering and consolidating data from emails. The additional planning enabled them to more accurately deliver cargo to support their teams in the Gulf of Mexico, reducing the cost of downtime and delays.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $350 Billion
Employees: 85,000

Company Profile

This client is a global oil and gas company responsible for the operation of wells, pipelines, offshore platforms, and processing facilities.

Software Used

  • Microsoft SharePoint 2010
  • Microsoft SQL Server Reporting Services (SSRS) 2008

Case Study #3: Custom Development of a Financial Application for a Premier U.S. based Oil and Gas Operator

The Challenge

The Oil and Gas Industry is entitled to immediately deduct the cost of drilling from federal income taxes. Our client had a custom application to track their federal taxes owed by tracking their drilling cost deductions against profits. The application had inaccurate logic, was not well documented, and was not performing well. The client was unable to complete their end-of-year federal tax return, also preventing them from issuing their annual shareholder report. Inaccurate tax calculations present many risks including possible IRS audits and/or penalties.

The Solution

Our team worked with the tax group to document the business rules for accurate tax calculations. We audited all existed source code to identify flawed logic. We corrected the stored procedures and documented the application. We performed a complete regression test to ensure all issues were resolved and no new issues introduced.

The Result

Our client was able to determine their federal taxes owed, finalize their federal tax return, and release their annual shareholder report. By providing complete documentation and a comprehensive regression test plan of the tax application, we have reduced the risk for our client in future application maintenance activities.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $1.1 Billion
Employees: 350

Company Profile

This client is focused on the exploration and production of oil and natural gas.

Software Used

  • Microsoft Visual Studio 2012
  • SQL Server 2008
  • Visual Basic .NET

Enterprise Asset Management

Case Study #1: Master Equipment List Development for a Global Oil and Gas Company

The Challenge

Our client manages oil and gas operations around the world. They have standardized on Maximo 7 as their Enterprise Asset Management (EAM) platform. Like many asset-intensive organizations, our client implemented an EAM tool to gain visibility and control over capital equipment to optimize maintenance strategies, reduce operating costs, and better manage their workforce and spare parts inventories. Achieving the benefits of an EAM tool relies on a complete and detailed Master Equipment List (MEL), populated with all critical pieces of information – type of equipment, manufacturer, model, serial number, vendor, criticality, spare parts listings. For their operations in the Gulf of Mexico, the MEL data was not complete. Incomplete equipment data was preventing them from realizing the benefits of EAM.

The Solution

The offshore platforms containing the equipment for which we needed data were constructed 5-10 years ago. Because they were offshore platforms, a manual inspection of the equipment was not feasible from a resource, cost, and timeline perspective. We had to find the data by working with other sources of information.

We reviewed and constructed equipment data from over 15,000 documents that included vendor books, data sheets, and purchase orders. We audited 100s of equipment list files contained in the document control system. We retrieved 1,000s of rows of structured data from various engineering systems to locate sources of equipment data. We analyzed over 5,000 change records to ensure all equipment changes since the creation of the original engineering documentation were captured. We normalized, structured, and quality checked the data. We partnered with teams in reliability and maintenance and engineering to verify the data.

The Result

We were able to find and load to Maximo meaningful data on 75+% of the offshore equipment. For organizations like our client’s, with many high value physical assets and operations that need to run 24×7, each failure is disruptive and costly. With an EAM solution powered by reliable equipment data, they are now positioned to reduce asset-related operating costs and reduce downtime by consistently enforcing preventive maintenance strategies. Further, the equipment data is ready to move into the spare parts phase of the project, enabling optimization of the spare parts inventory.

Company Industry
Upstream Oil and Gas

Company Size
Revenue: $350 Billion
Employees: 85,000

Company Profile

This is a multi-national oil and gas company responsible for the operation of wells, pipelines, offshore platforms, and processing facilities.

Software Used

  • Maximo 7

Case Study #2: Enterprise Asset Management Solution for a Global Manufacturing Company

The Challenge

Our client maintained two manufacturing lines for production of its chemical products for worldwide distribution. Demand for their products required them to add a third manufacturing line to increase production. Our client was using Maximo 7 as its Enterprise Asset Management (EAM) solution for all work management activities related to its production operations. Our client needed all maintenance relevant information for the new third manufacturing line added to Maximo.

The Solution

We leveraged location and asset data from other regions to model the equipment data for the new third line and ensure consistency. We grouped the assets by system to create the proper hierarchy of equipment information. We managed the data through a quality assurance process of enrichment, cleansing, and validation to achieve an accurate and complete data set. We loaded the data to Maximo for Locations, Assets, Routes, Attachments, Job plans, and Preventive Maintenance (PM) records.

The Result

All equipment records for Locations and Assets were loaded into Maximo 7 with fully enriched data. Routes, Job Plans, and Preventive Maintenance plans were configured in Maximo to automatically generate work orders according to schedule. With all data fully modeled and loaded to Maximo, our client maintained their enterprise view of their physical assets, including the new third manufacturing line. We have given them the foundation to improve reliability, optimize spare parts inventory, manage their workforce, and run a lean operation.

Company Industry
Chemical Manufacturer

Company Size
Revenue: $700 Million
Employees: 1,500

Company Profile

This client is a fully integrated chemical company with operations around the world.

Software Used

  • Maximo 7

Enterprise Data Strategy

Case Study #1: Enterprise Information Strategy for Upstream E&P

The Challenge

This global exploration and production company drastically consolidated its operating footprint driving the need to reduce management, standardize processes, and update systems to fit the new leaner operation.

The IT organization needed a clear path to re-structure and update the legacy application portfolio, modernize the architecture and infrastructure, and expand the reporting and analytics capability to support the new operational strategy and region restructuring.

Further complicating efforts were widespread data redundancies and duplicative processes across their infrastructure.

The Solution

The team executed a strategy project that produced an Infrastructure and Architecture Optimization Strategy and Execution Roadmap; as well as a Prioritized Roadmap Project Plan that focused on:

  • Data Integration System Implementation
  • Data Reliability and Availability for Reporting & Analytics
  • Information Governance & Quality Process Development and Implementation

This allowed the client to prioritize their time, efforts, and resources to align with the executive team’s strategic and operational targets.

The Result

The IT organization now has a clear future-state framework and capabilities defined for long term execution and a targeted and trackable plan to achieve the improved information environment.

The client is progressing through the road map, and the efforts are already yielding benefits such as: consistent and trusted data that enables better visibility across the business.

Long term benefits are expected in a variety of areas such as: well life cycle performance and profitability, work-over optimization, well and oil field assets in play vs. idle, field cost & time efficiency by rig and crew.

Company Industry
Upstream Oil & Gas

Company Size
$5 Billion in Revenue and 4,000 Employees

Company Profile

Fortune 500 Global Exploration and Production Company including both onshore and offshore assets

Case Study #2: Information Governance Platform for Upstream E&P

The Challenge

This global exploration and production company was in the process of implementing SAP HANA as a replacement for their multiple legacy ERP systems.

The implementation was being hindered due to a lack of standard data and data processes across the regions that would enable consistency while allowing the regions flexibility for region-specific operational activities.

An additional complication was that each region had existing business processes where the tasks and the related data were not in alignment from region to region causing duplication in effort, redundant data, and inefficient use of people and IT infrastructure resources.

The Solution

The team developed a custom Information Governance (IG) model that supported global data standards while providing flexibility for regional customizations.

The Information Governance model defined the following:

  • IG Operating model
  • IG roles and responsibilities for both SAP implementation and long term sustainment
  • Global Data Standards & Polices
  • RACI for both Business Functions & IT
  • Process Workflows
The Result

A shared data and process golden standard was implemented that exposed inefficiencies within regional activities and improvements were made that were leveraged globally and not isolated to just one region.

The client was able to roll out governed and integrated processes that resulted in higher quality of data, greater visibility into business operations, and clear escalation paths, which will allow for future operational improvements.

The client leveraged the model to define working groups for each core operational area who were then tasked with developing the data and process requirements for the global SAP Implementation.

The model is now used by the SAP team for run and maintain operations.

Company Industry
Upstream Oil & Gas

Company Size
$2 Billion in Revenue and 1,400 Employees

Company Profile

Large Independent Global Exploration and Production Company including both onshore and offshore assets

Case Study #3: Multi-Domain Master Data Management for the World’s Leading Oilfield Services Company

The Challenge

Due to acquisitions, our client had over 30 Enterprise Resource Planning (ERP) systems and needed to consolidate on SAP. To prepare for the system migration to SAP, they needed to clean and deduplicate data from the legacy systems. The data spanned 15 domains, including clients, customers, vendors, products, and locations. A Master Data Management (MDM) solution was required to prepare the data and provide a mechanism for ongoing management and governance of the data.

The Solution

As the client was planning to consolidate their ERP solution on SAP, we prototyped the SAP Master Data Management (MDM) solution. After determining the SAP MDM solution did not meet the requirements, we implemented an MDM solution using Profisee Master Data Maestro and Master Data Services (MDS) from Microsoft. This solution was implemented successfully and incorporated all required domains, including support for georeference data. We deployed the solution one domain at a time with each domain requiring an average of 1 to 2 months to achieve a unified, consistent source of data.

Data governance was supported by data approval workflows and map, merge, and survivorship strategies. The solution included harmonization to ensure the data changes in one application are synchronized with all other applications in the landscape who depend on that data.

The Result

We were able to provide the client with a consistent, consolidated view of their data that had previously been spread across a number of repositories. The client is now well positioned for their migration to SAP.

Company Industry
Oilfield Services

Company Size
Revenue: $45 Billion
Employees: 126,000

Company Profile

This client is a leading supplier of technology, project management, and information solutions for the oil and gas industry.

Software Used

  • SAP Master Data
  • Management (MDM)
  • Profisee Master Data Maestro
  • Microsoft Master Data Services
  • SQL Server 2014

Case Study #4: Multi-Domain Master Data Management for a Fortune 500 Oil and Gas Company

The Challenge

Our client faced an unprecedented situation and immediately had to deal with event data from hundreds of sources. They were forced to work quickly to find and create information to assess the situation and guide the response. Due to the immediate nature of the situation, a huge amount of data was created with varying structure. Our client needed a Master Data Management (MDM) solution to correlate, search, and understand the entire data set collected during the response.

The Solution

As none of the current out-of-the-box MDM solutions met the requirements, a decision was made to develop a custom MDM solution. The solution extended the Microsoft analytics technology stack already in use within the organization.

A series of Dimensional Models were developed for each of the 14 types of entities (people, organizations, vendors, etc.) included in the scope. A common Extract, Transform, and Load (ETL) layer was developed to orchestrate the flow of data from the different sources of information into the MDM repository.

A Fuzzy Logic Match and Merge capability was developed, using SSIS native components. This feature was critical to ensure data governance, allowing the Data Stewards to quickly identify related and duplicated data among domains.

The Result

In the wake of this unprecedented situation, we empowered our client with an accurate and consistent set of event data to analyze the situation and guide their response. This solution was implemented successfully and included multiple domains. We were able to provide the client with a consistent, consolidated view of their data. After the MDM repository was completed, it was possible to link related data across domains, enabling the Search component of the project. The Data-stewards from each domain were able to review proposed duplicate and matched data to allow them to make an informed decision over data validity. This information was published to SharePoint, allowing it to be consumed internally and externally.

Company Industry
Oil & Gas

Company Size
Revenue: $350 Billion
Employees: 85,000

Company Profile

This client is one of the world’s leading international Oil & Gas companies. They provide their customers with fuel for transportation, energy for heat and light, lubricants to keep engines moving, and the petrochemicals products used to make everyday items.

Software Used

  • SQL Server 2012
  • SQL Server Integration Services (SSIS)
  • Microsoft Storage Resource Management (SRM)
  • Microsoft SharePoint

Staffing

Case Study #1: Staffing of a Database Migration Project for a Leading National Wireless Carrier

The Challenge

Our client had a business-critical set of applications that were not meeting performance expectations. To compound the issue, the client was forecasting a 10x increase in the volume of transactions over the next year. An application migration was urgently needed. The client’s architecture team determined that a migration of 23 application databases from Microsoft SQL Server to Oracle would resolve the performance issues. This migration would provide a robust and scalable platform for the future.

With the application strategy defined, the next challenge was how to staff the project. The client’s internal teams would lead the initiative, but they needed additional resources with the right skill sets, and they needed them quickly.

The Solution

We partnered with this client to finalize the project and resource plans. We determined the necessary skill sets of the new team members. Sullexis defined a recruiting process to find and select the new team members. Within 4 weeks, we staffed a fully functioning team of nine developers with expertise in both SQL Server and Oracle, ready to execute the application migration.

As this was a sudden addition to the team, the client did not have the office space available for these team members. Sullexis provided the office space for the team to work during the duration of the project.

The Result

Sullexis was able to respond quickly to our client’s request for staffing assistance. We provided a complete team with the right skills for an on-time project start and even provided the working space. With our help, our client was able to complete the application migration successfully with all 23 databases moved to Oracle. The project was completed ahead of schedule and under budget.

Case Study #2: Staffing of High Demand Technical Resources for a Global Oilfield Services Company

The Challenge

Our client needed to migrate their software product to a new technical foundation. This required a team of developers with a sophisticated and in demand skill set. Developers with the requisite skills were scarce and expensive, making it a challenge for our client to find developers to migrate their technology. Given the large scope of the project, the expected duration, and the importance to the business, our client needed help to staff the team.

The Solution

Sullexis defined a recruiting process to identify and provide highly qualified resources. Because of the scarcity of qualified developers to meet the client’s requirements, we created our own training program. We recruited individuals that had proficiency in Java and demonstrated an aptitude for learning new skills. We created a curriculum that was approved by our client to train the resources. To ensure proficiency, we administered a certification test. Our process was able to provide high quality IT experts to assist the client’s team for the full duration of the project.

The Result

We provided a fully qualified team to support our client’s product migration. This client’s product was successfully migrated from Java Swing to an Eclipse Rich Client Platform (RCP) based solution. By implementing a creative recruiting and training strategy, Sullexis was able to meet the requirements for a staff with high demand skills. By training individuals with high aptitude and less experience, we were able to provide our client with qualified developers at a lower cost. For our client, good talent was scarce. We helped them find it.