My Projects
Traffic & Conversion Performance Analysis Personal Project
Comprehensive analysis of website traffic sources, user behavior, and conversion funnels to identify performance bottlenecks and derive data-driven optimization strategies.
Key Features:
- Traffic Analysis: Evaluated traffic sources and mediums to identify high-performing channels and optimize acquisition strategies.
- Conversion Funnel: Mapped customer journey stages to pinpoint drop-off points and improve conversion rates.
- Statistical Analysis: Applied correlation analysis and outlier detection to uncover hidden patterns in user behavior data.
Sparkify Data Warehouse Course Project - 9.5/10
Designed and implemented a comprehensive Data Warehouse for Sparkify, an online music streaming platform, to analyze user behavior.
Key Features:
- ETL Pipeline: Complete Extract, Transform, Load processes for data integration
- Snowflake Schema: Dimensional modeling with star/snowflake schema design
- Power BI Dashboard: Interactive data visualization and analytical reports built with Microsoft Power BI
StackOverflow Survey IBM Data Analyst Capstone
An end-to-end analysis of the 2024 Stack Overflow Developer Survey to uncover key trends in programming languages, databases, cloud platforms, and developer demographics.
Key Features:
- Technology Analysis: Evaluated current and future trends across programming languages, databases, and cloud platforms.
- Insights Generation: Identified JavaScript & TypeScript dominance, PostgreSQL + Redis architecture, and the rise of open-source backends like Supabase.
- Strategic Implications: Recommended cloud-first adoption and upskilling in full-stack JS/TS and data technologies.
E-Commerce Database Design Course Project - 10/10
Comprehensive database design and implementation for an e-commerce platform, featuring ERD design, manual OOP-to-relational mapping, and full-stack application development.
Key Features:
- ERD Design: Complete entity-relationship diagram with normalized database schema
- Manual Mapping: Hand-crafted OOP to relational database mapping implementation
BigData Sentiment Analysis Course Project - 9/10
Large-scale sentiment analysis system built with BigData technologies, featuring distributed data processing and real-time analytics visualization with Power BI.
Key Features:
- BigData Processing: Distributed sentiment analysis using big data frameworks for scalable text analytics
- Sentiment Analysis: Emotion detection and opinion mining using core NLP techniques for accurate sentiment understanding at scale.
- Power BI Dashboard: Interactive visualization of sentiment trends
Social Listening Platform Capstone Project - 9.5/10
Designed and implemented a custom Facebook web scraping engine to collect unlimited public Facebook data without login and without using Facebook official APIs, by reverse-engineering web requests. The crawling system was fully self-developed and comparable in capability to a very small number of global providers such as Bright Data, Apify, and Thordata — among the few companies worldwide offering proprietary Facebook web scraping services at scale.
Key Features: