Customer Data Mapping Project

I need to turn a patchwork of customer records into one coherent dataset. Right now the fields, naming conventions, and formats differ from file to file, so the first step will be to review a sample of everything I supply and sketch a single, authoritative schema. Once the target structure is clear, I want a detailed field-by-field mapping that shows how each original column converts or combines into the new model, including any data-type changes, look-ups, or cleansing rules. A concise spreadsheet that doubles as a data dictionary will work well, and if you can also add a lightweight SQL or Python routine that executes the transforms, even better. The job is complete when I can import all customer records into one table, press run on the script (or follow your documented steps), and see clean, de-duplicated data that matches the mapping document exactly. Experience with ETL workflows, Excel Power Query, SQL, Pandas, or similar tooling will make the hand-off smooth.

Project ID: 39720531