Implemented SDC for Campbells projects

I implemented the Slowly Changing Dimensions (SCD) feature on Campbell's data model, enabling efficient tracking of changes across multiple projects. To achieve this, I:

Designed and developed the SCD feature in SQL

Created a comprehensive report to facilitate easy tracking and verification of changes

Developed a Python script to automate the process

Completed the task within 3 months

Saved over 1000 hours of effort per month (60% reduction in operational costs)

This implementation enabled Campbell's team to efficiently manage changes, ensuring data accuracy and reducing operational expenses.