Created a set of pipelines to effectively integrate data on a single platform while streamlining once time-consuming manual processes like cleaning, deduplication, and data format unification
Helped the client integrate a range of data sources, including sales transaction data residing in an Oracle database, an inventory management system, and Google Analytics
Created pipelines to export data from each source system, transform it, transfer it to Google Cloud Storage, then load into Google BigQuery
Developed an automated mechanism to do a daily poll from Oracle for sales transaction updates
Created use case-specific data marts within BigQuery
Created a set of more than 50 standard reports in Tableau that would automatically draw from the data marts in BigQuery any time new data was loaded into the pipelines