Cloud Based Data Integration

Client had data stored in disparate cloud locations such as SmartSheets, Benchling, Microsoft 365 Sharepoint, and Citrix Sharefile. Integrating data sets across platforms was difficult for client staff. We built automated date extract-transfer-load (ETL) routines using Python. Connected through cloud services APIs, and loaded data into local PostgreSQL database tables. From there we built custom analytics and interactive data visualizations to support proactive decision making.