Developed tools to assist in conversion of over twenty acquired Bank’s data to the Hogan database. These tools consisted of a generalized Front-end that would match and merge data from various input sources to a single input file that would be input to the main conversion program. Also developed macros to extract data from Excel spreadsheets for uploading to the mainframe for input to the conversion process. Developed an Account Number duplicate checking process that would check the acquired Bank’s account numbers against over 100 million account numbers in twelve different input files.