Data Quality Concerns

The overwhelming concerns surrounding unclean data have convinced many companies that a robust and flexible solution is the only way to handle data hygiene issues. A quality data is the foundation on which every company’s strategy is build as well as many by which it is communicated to various stake holders and customers.

A Gartner Inc’s research report has predicted that “Ëœdirty data’ will cause 50 per cent of the insurers to have compromised decision-making assumptions by 2012. Data cleansing (also called as data scrubbing) is the act of detecting and removing corrupt or inaccurate records from a database


Bodhtree’s MIDAS (Multi Industry Data Anomaly Solution) Provides scalable and flexible technique of giving customers the choice to opt for Application Integration, Data Integration, Data Quality and Advanced analytics. MIDAS is becoming popular among the various verticals, because it not only provides customers the data integration and hygiene issues. It also allows organizations to valuable options to seamlessly integrate the solution into various applications.

Data Anomaly issues across the Globe

Companies that can’taddress this unclean data are going to pay heavy price, not only will they lose customers, but industry experts predict a huge law suits stemming from providing wrong data.
According to the Data Warehousing Institute, a US-based organization that provides high-quality education and research in the business intelligence and data warehousing industry, businesses lose more than $600 billion every year due to poor quality data, while direct marketers in Europe spend 195 million pounds annually on incorrectly addressed international mails.
Data Quality: Prime Agenda
The best way for companies to stay ahead by managing their data hygiene issues is to make sure their clean data becomes a goal not only of individual departments but of the corporation as a whole. CIO’S need to make quality data a corporate goal. Quality data needs become fundamental pieces of culture and put it on the same level as other profitability. Quality data creates satisfied customers

MIDAS Addresses data hygiene issues

Organizations across multiple industries can now save millions of dollars wasted on unclean data. Bodhtree’s MIDAS ““ Multi Industry Data Anomaly Solution helps solve data completeness, accuracy and integrity problems. MIDAS integrates across various applications and databases with its proprietary tools.

ï,§ MIDAS offers a viable and convenient options:

““ SaaS (Software as a Service), where in customer data has been transmitted to Bodhtree servers using secure FTP layer. Bodhtree performs data hygiene operations and report back results and enriched data through web based portal.

““ On Premise, where in Bodhtree installs MIDAS at customer premises using data hygiene jump start templates. Jump start templates are set of tools and processes that Bodhtree has built over years of experience in handling critical customer needs. These templates enable faster deployment of solution at customer end.

““ Turn-key Solutions, where Bodhtree’s proven processes would be applied at customer location using customer specific tools. MIDAS process is tool agnostic and can be applied on customer data using any existing toolset that customer owns.

MIDAS ““ Technology

ï,§ MIDAS is open standard based J2EE application which adheres to best industry practices in form of vertical specific pre-canned data / application integration steps, data connectors and reports.

ï,§ SOA & JSR 168 compliant architecture

ï,§ Comes with Role based access control (RBAC) mechanism

ï,§ Inbuilt data connectors for industry leading OLTP / ERP / DSS systems such as:

““ SAP, Oracle EBS, JD Edwards, People Soft
““ Salesforce, SugarCRM, Siebel On Demand
““ Quickbooks
““ EDI Connectors
““ CSV and Excel Files

ï,§ 24/7 support from global delivery centers (GDC)

ï,§ SAP Certified Product

ï,§ Oracle certification in progress

Key Drivers for MIDAS to Conceive
One of the key drivers behind the development of MIDAS is the burgeoning global data cleansing market segment and the unprecedented growth of data generated by individuals that requires constant optimization attention. The market for data cleansing solutions is pegged at $100 billion in the US alone, of which the healthcare sector accounts for about $20 billion, which holds huge potential for solutions like MIDAS.
MIDAS Case Studies
1. MIDAS ““ Data Anomaly Solution

Client Background

The US client is the world’s largest infomercial company, with sales of more than USD 3 Billion, operating in US, Europe, Japan and Autralia, with a customer base of 30 million customers. The marketing channels used by the client are web, 1-800 numbers and kiosks
Business Situation and Challenge

The client had outsourced the entire operations, where order calls are received by tele marketing companies and call centers and deliveries are handled by fulfillment centers. These centers are spread across the world in numerous locations. Orders come through various channels and geographies. Data from these companies are transmitted back to client at pre-defined intervels, and need to be loaded to client ERP and then to Data Warehouse.

The challenge faced by the client was the consolidation of customer records received from different data sources. A clean customer master was essential for the realization value of campaigns run by the client marketing teams.

Bodhtree MIDAS Solution

The customer master contained 30 Million records with anomalies such as incomplete, invalid, incorrect and unstructured data and customer duplicate records. The MIDAS solution provided by Bodhtree helped in elimination of 10 million duplicate records, enrichment of the customer data and mapping of the actual customers to the corresponding sales and inquiry records. MIDAS provided the client a “single version of truth“, which helped the client to calculate the actual realization value of the various marketing campaigns.
2. MIDAS ““ Critical Applications Integration

Client Background

The client is a leading global pharmaceutical company, pioneer in global drug discovery and pharmaceutical sales and has presence in more than 100 countries. It has wholly-owned subsidiaries in the US, UK, Russia, Germany and Brazil; joint ventures in China, South Africa and Australia; representative offices in 16 countries; and third-party distribution set ups in 21 countries. It is the first pharmaceutical company in Asia outside of Japan to be listed on the NYSE.

Business Situation and Challenge

The client has various applications such as SAP, forecasting applications, project management applications and third party .NET applications for stockist data maintenance which are part of their supply chain nodes. There is constant flow of crucial data between these applications. Currently data is being transmitted in different modes right from FTP, customer ABAP coding and custom .NET coding. Since the data transferred between the applications are crucial, any loss of data or delay in transfer will result in a down time in the application processing, which would in turn have a huge impact on the company’s supply chain operations.

Tracking and monitoring the flow of data between the systems was a huge challenge. The use of multiple technologies with out proper coupling for data was not reliable due to the increased instances of failures. Tracking the failures, finding the missing data etc. were non-productive as well as time consuming, apart from the other impacts it had on the business due to the downtime.

MIDAS Solution

Bodhtree’s MIDAS has the ability to integrate data and applications including ERPs. MIDAS was used as an intermediary for data transfer between the applications. MIDAS also provided a real time console for monitoring the status of data being transferred. MIDAS also provided automated critical alerts via and email and sms to the concerned personnel, to ensure timely attention and smooth processing of the applications.

MIDAS helped the client’s applications to integrate seamlessly and made the crucial data transfer flawless. It eliminated the downtime and resource overheads and ensured smooth flow of the supply chain operations.

Visit the Author's website: