Bulk CI Ingestion & Hygiene

Bulk CI loads created duplicate and dirty records, polluting CMDB and impacting service mapping.

Configured Import Sets and Transform Maps with deduplication rules, coalesce keys, and data-integrity scripts to prevent dirty data propagation downstream.

• Drove duplicate CI rate down to near-zero on nightly bulk loads.
• Improved service-map accuracy for downstream ITOM dashboards.
• Standardised transform patterns adopted by peer teams.

• Pre-transform onBefore scripts normalising serials and hostnames.
• Reject vs. update policy with quarantine table for exception review.
• Coalesce strategy documented per CI class for future maintainers.