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
- Find possible duplicate data based on what group our user is part of.
- Logging for record of who, when and a process for reversal.
- Create merge procs per category
UI work consisted of using company standards for HTML/CSS
- Welcome wizard with explanation of process at user login
- Display possible duplicates to merge or delete out of system
- Simple description and flow of process