I cleaned and audited a 1.5 million-record e-commerce dataset using SQL, validating six foreign key relationships across eight tables with zero orphaned records. I also traced 3,345 apparent duplicate customers to a legitimate address-level identifier rule.
In my Android App Market Analysis project, I studied app metadata alongside about 30,000 Google Play Store reviews. Sentiment analysis showed that 68% of reviews were positive, while app size only weakly predicted install counts.
For my Online Retail Data Cleaning project, I processed 525,461 rows and retrieved 2,150 missing product descriptions through StockCode matching. I reached zero missing values and zero duplicates while retaining 78.2% of records.
I also analyzed retail sales to compare revenue and profit across product categories, finding that Accessories had the highest profit margin and Bikes drove roughly 72% of revenue. In a group project, I served as Project Manager for a team of four developing a strategy proposal on how Thai brands can scale without becoming a chain.

