RISHI SHELLY

Food Inspection Data Warehouse Development and Integration, March 2023

• Worked as part of a team to develop a data warehouse for food inspection data from New York City using Azure SQL Server
• Analyzed source data to identify dimensions and facts for the dimensional data model using ER/Studio
• Created data preparation workflows using Alteryx to transform data into appropriate format for the integration schema
• Loaded data into stage tables following staging guidelines and performed data profiling to ensure accuracy and completeness
• Improved skills in data warehousing, ETL development, data profiling, data modeling, and database design

NYC MVC Vehicle Collisions (Alteryx, Talend, ER Studio, Microsoft Power BI, Tableau), Feb 2023

• Led a team of four professionals to profile, load, and model NYC Motor Vehicle Collisions data using Google BigQuery,
• Alteryx, Talend, and ER Studio
• Designed and implemented a dimensional model for efficient data analysis and querying, identifying key dimensions and facts
• Developed an integration schema to seamlessly connect NYC Motor Vehicle Collisions data with MySQL for easy querying and data access
• Created visually appealing and interactive dashboards using Tableau and Microsoft Power BI Service to address critical business questions
• Effectively utilized the integration schema to extract insights and provide actionable recommendations based on the NYC Motor Vehicle Collisions data

Weather Analysis - Northeastern University, Dec 2022

• Web scraped and collected over 10,000 data points from the National Weather Service and Twitter using Python
• Cleaned and inspected the data in PyCharm and performed data munging using SQL Workbench, including reverse engineering into UML models, SQL queries, use cases, and regular expressions
• Utilized various data visualization concepts such as matplotlib, seaborn, NumPy, Pandas, and KDE plot visualization to create insightful and easy-to-understand data visualizations in Python
• Applied data analysis techniques to uncover trends and patterns in the collected data, such as temperature changes and weather patterns
• Developed expertise in web scraping, data cleaning, data munging, data visualization, and data analysis using Python