Problem: Unify, eliminate inconsistencies and redundancy, and enrich customer data before loading into SAP ERP.
Data Source: Relational database with more than 1.2 million lines.
Solution: Implement flows and macros to automate processes, define unification rules, consistency and enrichment via regular expressions.
Challenge: Execute the work in very short time (5 weeks), especially considering the entry of a new supplier for enrichment based on external data.