United States
Data analyst. UCLA Alumni. Majored in statistics and data science. Born in Korea, raised in Malaysia, currently in Los Angeles. Visit my website at kevitat.wordpress.com
- Replenishment & Order Management Optimization: Expanded auto-order workflows to additional regions beyond California into additional regions; improved inventory accuracy by 30% through automation of restock tracking. - Sales Data Analytics & Forecasting: Analyzed 100,000+ SKU-level sales across 30+ stores in 3 states, based on brands and categories, to identify sales risks and high-performing items and forecast demand to support procurement planning. - Data Automation & Process Improvement: Built automated workflows with Python and Excel VBA for cross-system data transfers, item list updates, order uploads, and recurring spreadsheet processes, reducing manual work by 60%. - Cross-Functional Reporting: Developed reports using Excel and Power BI for buyers, merchandise planners, stores, and warehouse teams to monitor delivery performance, order accuracy, and regional inventory issues.
- Business Intelligence & KPI Analysis: Used R web scraping to collect and analyze competitor data in the electric vehicle market, benchmarking peer companies across financial KPIs, strategic focus areas, and market positioning. - Insight Communication: Created dashboards and summary presentations for executive review, highlighting strategic focus areas and efficiency opportunities.
- Data-Driven Marketing & User Engagement Analytics: Collected and analyzed pedestrian traffic data using Google Maps API to identify high-engagement timing and locations for campus activation. - Market Segmentation & Dashboarding: Built Tableau dashboards visualizing user discovery and conversion behaviors, guiding promotional strategy and university-audience targeting.
AP Statistics & SAT tutor
• Planned and conducted weekly training sessions, focusing on teamwork and tactical movement. Led team to semifinals of the regional tournament with win rate of 60%, in contrast to 0% in the previous year.