Here’s some stuff I made recently.
Data Analytics | Data Engineering | Data Science | Product
SpotifySync | Data Engineering
Developed an end-to-end data pipeline using Airflow to load Spotify's API data for Global Top 50 playlist into PostgreSQL. Leveraged Python, Docker, and DAGs for seamless data management.
Link to Repository
Food Delivery | Data Analysis
Designed and executed advanced data cleaning techniques on a real-world food delivery app database, enhancing data quality and insights. Leveraged SQL, Python, and Tableau for efficient processing, analysis and visualization.
Link to Repository
E-commerce Sentiment Analysis | Data Science
Extracted valuable insights and conducted sentiment analysis on a real-world e-commerce dataset, exploring customer behavior, product trends, and platform performance. Utilized Python (Pandas, NumPy), NLTK (NLP), and SQL.
Link to Repository
DFF Data Warehouse | Data Engineering
Designed and implemented an MS SQL Server data warehouse, utilizing SQL queries and advanced data modeling techniques (dimensional modeling, star schema) to enhance retail profitability through a robust foundation for data storage and retrieval.
Link to Repository
TraverCity – A Travel Recommendation System | Data Science
TraverCity is a travel recommendation system that leverages exploratory data analysis (EDA) and a combination of supervised and unsupervised machine learning models, providing valuable insights for strategic planning.
Link to Repository
Exploring COVID-19 Journey of India | Data Analysis
Uncovered in-depth insights into India's COVID-19 scenario through data analysis, empowering informed decisions and strategic responses for effective pandemic management. Utilized Python and SQL.
Link to Repository
Point of Sale System | Data Engineering
Optimized Point of Sale (POS) system performance through ETL techniques and advanced database concepts on AWS EC2 instance using MariaDB, Clustering, JSON integration and MongoDB NoSQL database.
Link to Repository
Global Well Being Forecast | Data Science
Predicting happiness scores worldwide by employing advanced statistical models, exploratory data analysis, and various regression analyses to understand the complex interplay between factors affecting happiness.
Link to Repository
Destination Bryan | Product Management
Comprehensive product canvas designed to revamp Destination Bryan travel website through in-depth stakeholder assessment, user research, and strategic UI/UX design, enhancing the overall customer experience.
Slide Deck