TMS to Web

I developed a NodeJS/React application that has significantly streamlined the data flow between our internal collection database system and the website's collection object pages. The purpose of this application is to speed up and facilitate the process, and I am proud to say that I have achieved this goal. Previously, the workflow used to take between 2 to 3 hours, but my application has trimmed that time down to only 15 - 20 minutes, including images, and 1 to 2 minutes when only data is being pushed. The app pushes recently approved collection objects from TMS, the internal asset management system of the Philadelphia Museum of Art, to Google Firestore. TMS is a MSSQL database, and my app transforms MSSQL tables into JSON in order to import them into FireStore. Finally, the PMA website then consumes the FireStore collections via Google Cloud Functions API. Overall, this application has revolutionized this data flow process and has made it much more efficient and effective.