- Vaunce Store Analysis and Automated KPI DashboardDesigned and standardized data collection processes, applying K-means clustering to classify Vaunce stores by key attributes. Developed an automated KPI dashboard with 20+ operational metrics from daily POS and app data, leveraging GIS tools to map and analyze trade area demographics and competitive factors.- Customer Persona Development and Personalized Recommendation SystemConstructed customer personas to analyze shopping behaviors, enabling a tailored product recommendation system. Implemented detailed segmentation based on behavior patterns, created key purchasing metrics, and performed trend analysis to support targeted product suggestions.- Recommendation Logic Optimization and Custom Development for ClientsOptimized and maintained recommendation algorithms to enhance performance, and developed customized recommendation logic on a monthly basis for e-commerce clients. Leveraged SQL, AWS (S3), Sourcetree, and Jira for logic development, version control, and issue management.

- Integrated Database Design and DevelopmentPlanned, designed, and implemented integrated databases combining real estate, foot traffic, and credit card data, effectively merging spatial and attribute data to enhance analytical capabilities.- Customer Segmentation and Profiling StrategyConducted in-depth consumer behavior analysis, utilizing clustering and correlation techniques to develop detailed customer profiles by region and product, supporting targeted marketing and strategic decisions.- Data Analysis for Real Estate and Commercial DevelopmentExecuted trade area and location analyses, demand forecasting, and market feasibility assessments to guide real estate and commercial development, optimizing site selection and investment strategy.

- Handled 50+ customer inquiries while maintaining 90% of satisfaction rate- Organized biweekly team activities for 20+ members from diverse backgrounds- Managed relationships with hotels by providing high levels of customer service and account management support- Accommodated special requests by communicating with external partners and related parties

- Educated 20+ youths in facility practices, requirements, and rules- Conducted one on one mentoring session to provide emotional support and personalized guide- Maintained data of youths in the computer system- Planned and encouraged youths to participate in recreational activities