Create a process in which our users can standardize their data.
As most companies deal with duplicate data in their system, this would alleviate scheduling issues.
Understanding what made each record a standard record and presenting possible duplicates for each category of standardizing.
This required several SQL scripts per category 1. Find possible duplicate data based on what group our user is part of. 2. Logging for record of who, when and a process for reversal. 3. Create merge procs per category
UI work consisted of using company standards for HTML/CSS 1. Welcome wizard with explanation of process at user login 2. Display possible duplicates to merge or delete out of system 3. Simple description and flow of process