Success at L3 Technologies

Learn how L3 Technologies created 'golden records' which eliminated 90% of Access database dependencies and reduced custom ETL code.

Download Document

Challenges

Fix Data Quality Issues – don’t move bad data
  • As part of their digital transformation and upgrade, the SDS Division replaced MINX, an antiquated-on premise ERP system, with an ERP solution from Infor running in Azure.
  • 3 other systems that are instrumental in running their businessinclude an engineering system containing Parts and Bill of Materials, a Siebel field service application and a CRM solution all needed to be synced and integrated.
  • Infor needed to be populated with existing customer, vendor and parts records. However, current systems contained duplicate customer and vendor entries, incorrect or missing ship to and bill to addresses, telephone numbers and email contacts.
  • A business process for Vendor Parts Matching needed to be designed to keep vendor and internal part numbers in sync.

Strategy

Create “Golden Records” Data Management Strategy
  • Create “Golden Records” which contain Customer, Vendor and Parts data synthesized from the existing 4 mission critical systems.
  • Cleanse, De-dupe and synch records including creating ongoing workflow to maintain accurate information across all business systems.
  • Create ongoing data management strategy to improve sales analytics, reduce inventory on hand, improve customer SLA’s and eliminate manual integration processes.

Outcome

  • Identified and removed unclean, duplicated records accumulated during the prior 25 years from the legacy app.
  • 69% reduction in manual effort to create Golden Records.
  • Eliminated 90% of Access database dependencies.
  • Dramatically reduced necessity to develop custom ETL code and the time to production for the new ERP application
Download Document
Other Case Studies
Success at Gap
Success at Domino's
Success at Sonic Automotive
Success at Lookers Motor Group
Success at Mass Media Corporation

Ready to Take the Next Step?

Contact us or request a demo and we'll show you why Profisee is the fastest growing company in Data Management.