Take A Trial Contact Us

Affymetrix

Affymetrix

Affymetrix

Affymetrix is a pioneer in creating breakthrough tools that drive the genomic revolution. By applying semiconductor technology principles to the life sciences, Affymetrix develops and commercializes systems that enable scientists to improve quality of life. Customers include pharmaceutical, biotechnology, agrichemical, diagnostics, and consumer products companies, as well as, academic, government, and non-profit research institutes. Affymetrix offers an expanding portfolio of integrated products and services, including its integrated GeneChip® platform, to address growing markets focused on understanding the relationship between genes and human health. Affymetrix has almost 900 employees worldwide.

Challenge

  • Manage multiple legacy applications and salesforce.com (Japan and US)
  • Cleanse and merge >100k market leads from legacy applications
  • Fix data quality issues (duplicates vs. actual 3:1; 80% of contacts - accounts 1:1)
  • Hand coding and appliance options inadequate - estimates well outside project window

Solution

  • Profile legacy data
  • Native bi-directional access to salesforce.com
  • Measure and monitor data quality
  • Match, cleanse and transform data

Benefits

  • Delivered 3 month project in 1 with Informatica
  • Eliminated over 22,000 records (10% of redundant customers)
  • Reduced duplicate leads to < 2%
  • Eliminated silos of custom code and shelved light weight “integration in a box” appliances

Next Steps: