Brown Account Tagger (BAT)
How "BAT Keys" replaced account numbers when Brown moved their financial system to Workday's cloud product
I was the lead designer on the Brown Account Tagger (BAT) project. With a pending move to the new Workday financial system, Brown had 40,000 active account numbers that needed to be adapted to Workday's transaction attribute tagging paradigm (which does not use account numbers). Other systems that need to integrate with Workday, however, require something that looks like an account number. Thus, BAT Keys were conceived of to act as identifiers that map to a set of transaction attributes. After modeling the BAT database, I wrote many large SQL queries (~500 lines long) to test different BAT Key name generators until a simplified standard was chosen. I then moved on to feasibility testing for Ruby on Rails, DataMapper, and Oracle. I modeled the UX and made the wireframes for the UI. The UI was built by two other developers and a third developer built much of the Linux middleware. Brown's Workday financial system went live in July 2013. I have taken over upgrades and maintenance to all parts of BAT and have much technical debt to pay back. The UI is fairly simple but the rest of the project was massive.
The data model for most of the BAT system. Built in Oracle SQL Developer Data Modeler.
The search tool, which is the customer-facing tool. Built with Rails and Bootstrap. Currently showing one result for each of the three key types for brevity. Multiple results is more typical. Would still like to put the four search types into an accordian when I find time.
A "wireframe" mockup of the search tool which is the customer-facing tool. Built in Dreamweaver.
A "wireframe" mockup of the one-page UI for CRUD maintenance of BAT Keys. Built in Dreamweaver. The end result in Rails and Bootstrap was similar to this but I am not including a screenshot of it because I did not build it (and it also needs more cleanup before it looks as envisioned, fully styled). I will add a screenshot of it if I get a chance to rebuild it myself like I did with the search tool.
