Hi, All. ✏️Welcome to my 🌱portfolio!

Data Engineering

Project Link	Project Description
Sparkify's S3 to Redshift ETL Pipeline	Developing an ETL pipeline to extract JSON logs in S3, staged the data in Redshift staging tables, and transformed it into a star schema analytical database hosted on Redshift for analytics on song play events, users, songs, artists, and time metrics
HR Database Design	Designed and implemented an ETL pipeline to extract employee data from Excel, transform it into a normalized 3NF, and load it into a newly created relational database.Developed SQL scripts to create the database schema with proper data integrity constraints.
Data Modeling with Cassandra	Developed a Python ETL pipeline and applied data modeling with Cassandra to address queries.

Project Name	Skills & Tools	Description
Maven Fuzzy Factory	📚MySQL	Analyze and optimize marketing channels, measure,and test website conversion performance, and use data to understand the impact of new product launches.
Maven Roaster Dashboard	📚Tableau	Designed a dynamic dashboard to track KPI (profit, sale, unit, returns) performance across markets, analyze category profitability, and identify high-value customers
Investigate TMVB Movie Dataset	📚Pandas, Matplotlib, Seaborn	Use Python to clean data, explore and analyze the most popular movie genres and high revenue movies insights.
Bike-share Analysis	📚R, Tableau	Analyze casual rider's usage behavior in different time zones, help marketing teams discover insight that can be used for designing a marketing campaign to convert rider users to members.Create a visualization tableau story to present findings to the marketing team.
1000 Startup Investment Analysis	📚Tableau	guided project from Tableau 20 Advanced Training: Master Tableau in Data Science Course at Udemy_Identified the startups that represent the best investment opportunity by creating an interactive Tableau dashboard.
DataCamp Guided Project	📚SQL, Python	Where I explore and learn the data analysis skills by leverage the DataCamp platforms. Total 5 projects : 1 SQL project, 4 python projects