The Production Services Association had three databases with duplicate data performing three different jobs.
They tasked us with consolidating their data into a single online database. Additionally they wanted us to move their member signup process online, that meant introducing online signup, online payment methods and data management for members.
Our first task was to clean up the data. With 3 different databases containing mismatched data fields, this was no easy task. Some of the data was old, some was just wrong. So before we could move forward we wrote a custom script to compare the databases and compiled a new PostgreSQL database based on rules of priority for the different databases as discussed with the client.
Once this was done, we set up a Rails Admin app to allow direct access to the data through a user-friendly web interface and then built a custom front end to allow users to log in and edit their accounts and find other PSA members, all via the website.
Once this was complete we integrated Stripe payments and enabled new users to pay for their membership online or choose to pay via one of the original payment methods, BACS, cheque or Standing Order Payment.