Developed tools to assist in the merging of data from Wells Fargo Bank’s twenty-two states to the Norwest HOGAN Banking System database. These tools consisted of a program that would take a COBOL copybook as input and create a SAS program that would analyze the contents of each field in the file. Developed Excel macros that used OLE to interface with the Extra!3270 emulation program to download mainframe files, modify them with Excel and upload them back to the mainframe.