Conduct web scraping and extracted tweets related to various topics about the metaverse using the Python Twint packageDevelop a sentiment analysis model to analyze the extracted information of tweets with more than 2000 likes, providing insights into public opinions and trendsBuild an end-to-end analytics pipeline for scraping, loading, and cleaning data using Cron job scheduling, reducing data preparation time by 40%

Wrote complex SQL query to collect 30K customers events data, performed data clean and aggregation into customer unit Conducted RFM to analyze user behavior and identify high-value customers based on their purchasing behaviorApplied neural network model to predict customer purchase decision, and resolved data skew problems in imbalance datasetsWorked with marketing team to send promotion texts and ran regression on the response rate to predict CLTVImproved data extracting efficiency and accuracy by optimizing SQL using map join and subquery, saving computing memory in shuffle stage

Worked on invoices, accounts receivable and bonus calculation based on sales; Constructed depreciation schedules for new facilities, test drive vehicles and maintenance equipment; Assisted in reports on firm’s basic financial condition and forecasted potential risks;Worked on spreadsheet design and data analysis on sales of 5 vehicle models.

Managed inventory cycles, scheduled inventory replenishment and restock; accounting inventory on a weekly basis; Examined supplies to determine inventory shortage;Created detailed report for adjustments, inventory operations and stock levels;Provided positive customer experience and processed customer orders