HubSpot Migrations QA Tool

I started working for HubSpot Migration Services in the fall of 2013. HubSpot had just launched their new COS (Content Optimization System) and we had over 10,000 customers on the old CMS system who needed to be migrated over. When my team first started the migration process, we had to review each migration by opening all the pages in their own browser tabs. Then we would compare each page to the original page which was also opened in its own tab. This was a very slow and tiresome process and there were a lot of errors made. A typical migration took about an hour and a half to review. We would also need to keep all of our notes seperate, which made it tedious to send change requests back to the technicians responsible for each migration project. I took it upon myself to build a tool that would allow us to automate a portion of the review process. My tool takes a list of orginal page URLS and their associated migrated page URLS. One at a time the pages are layed out side by side for you to compare. There is a field at the top of the app for you to add any notes. Then you simply click the thumbs up button if the pages match and the thumbs down button if changes need to be made. To make things even easier, I added some shortcut keys that would allow you to click the up arrow on the keyboard to mark the page as "good" and the down arrow to mark them as "bad". Afte each page is reviewd, the next set of pages are automatically loaded in the frame. The urls are stored in two separate tables that can be viewed at any point through out the review process. You can also edit the notes for each page and move them to and from the "good" and "bad" tables at any time. When all the pages have been reviewed, there is an option to create a quick email that included all the URLs that need adjustments and their notes. The email could then be sent off to the technician resposible for the migration. My tool allowed us to drop the average review time down to just 15 mins. This had a dramatic effect on the migration process and managed to complete the entire migration to the new system a year early and without the need to hire any additional employees.