• Designed conceptual data models using Entity Relation Diagrams, Enhanced entity-relationship in Lucid chart with respect to Business Rules
• Developed normalized relational database (3NF) using MySQL Workbench and pgAdmin 4 to avoid redundancy in the database
• Implemented data dictionary, CRUD Operations, complex scripts, Views, Triggers, Stored Procedures, and Privileges leveraging various DB capabilities
• Analyzed the data using Plotly in Python by connecting it MySQL workbench
• Created dataset in Google BigQuery and connected with to Google Data Studio to build dashboard