SQL
Project 1
CRUD process with 3 raw JSON files. Data was imported using PostgreSQL. Some rows had invalid characters that were cleaned with Nested Queries, Regex and Wildcards. The data was parsed into tables by extracting all pertinent information from the JSON properties. Relationships between the data were then stablished.
Project 2
Data was imported using PostgreSQL from multiple CSV files. Relationship between tables was designed in order to calculate retiring employees for a company and identify opportunities for mentorships and recruiting. Multiple visualization were created in order to meet Human Resources need for information.