Tools Utilized: Python, Pandas, Matplotlib, PostgreSQL, SQLAlchemy, AWS, Airflow
Obtained personal Amazon.com order history stored on AWS S3; wrangled data using Pandas; loaded clean data into PostgreSQL database on AWS RDS and utilized matplotlib in Jupyter to create data visualizations; ETL pipeline was automated using Airflow; moved project onto an EC2 instance to run entirely on the cloud.
Tools Utilized: R, ggplot2, Python, Pandas, MySQL, SQLAlchemy, Socrata, MongoDB, Tableau
Acquired data from Socrata API and performed ETL in Python; persisted clean data into MySQL; used R to create visualizations using ggplot2; loaded transformed data into MongoDB NoSQL database; utilized Tableau to generate additional visualizations.
Tools Utilized: Quandl, Python, Pandas, Matplotlib
Accessed financial data using the Quandl API; performed ETL using Python/Pandas; created visualizations using Matplotlib.



