Fictional company Amazing Prime needs to create an automated pipeline that takes in new data, performs the appropriate transformations, and loads the data into existing tables. Code will be refactored to create one function that takes in the three files and performs the ETL process by adding the data to a PostgreSQL database.

Analyzed employee database with PostgreSQL.

Analyzed reviews for Music products on Amazon written by members of the paid, Amazon Vine program looking for potential bias in the reviews. PySpark was used to extract and transform the review data, which was connected to an Amazon Web Service RDS and loaded into pfAdmin.

ETL exercise on combining and cleaning movie data from Wikipedia and Kaggle into PostgreSQL using Python and SQL.

Determining whether paid Amazon Vine Reviews are biased toward positivity compared to unpaid reviews.

pgAdmin Compose Project Example (LasP Team)

FastAPI project for news-feed app

I created my university's database system as a demo using SQL and shared this project on GitHub. This project contains a sample structure and queries for a university database system.

WEBD deliverable repository.

Fictional company Pewlett Hackard needs to determine the number of retiring employees per title and identify employees who are eligible to participate in a mentorship program. Both tasks are accomplished using SQL queries.

A boilerplate project with Docker, Python, Django, Postgres and PgAdmin.

An entity relationship diagram was created using data containing employee information and the data stored into a SQL database.

Backend Application At TatvaSoft

Installer scripts for Ubuntu and derivatives

Tool to deploying databases for a software development environment.

This project featured data engineering and analysis of employee records including the design and implementation of a SQL Database for those records

ETL and Sentiment Analysis of Amazon reviews with AWS, PySpark, postgresql, NLP

An analysis that will provide a list of current employees who are eligible to be enlisted within a mentorship program of a company.