Case Study: Leading FMCG Company achieves 360° consumer view and improved campaign effectiveness with Xtivia's ELT data standardization solution

FMCG Company - Customer Case Study

The customer, the top FMCG Company operating in 50+ countries, faced poor-quality, non‑standardized consumer data from multiple Asian markets and heterogeneous sources (websites, retail, surveys) and platforms (Oracle, SQL Server, MySQL). XTIVIA was engaged to deliver a data standardization, validation and ELT solution—including a governance framework and a central warehouse called 1‑Consumer Place—to enable consistent collection and validation of third‑party data before use in CRM and BI.

XTIVIA implemented a governance process plus an ELT architecture that lands heterogeneous sources as XML (using PHP), loads via Teradata Parallel Transporter, applies cleansing/standardization (BTEQ/SQL), routes rejections to data stewards, and archives sources for compliance. The result was a single customer view and earlier availability of accurate data for CRM and BI, leading to improved campaign reach and success, more effective targeted marketing, and better product design decisions.