Collected, verified, and organized data for over 1000 new employees and assisted in the development of an automated payroll calculation tool using Excel macros.Led weekly training sessions, overseeing the end-to-end process, including participation tracking, and result evaluation. Analyzed feedback and performance metrics to propose a training optimization plan, increasing overall employee conversion rate by 10%.Managed the reimbursement and budgeting process for the Talent Development Group, processing over 200 reimbursement claims and ensuring budget adherence within a 5% variance. Conducted a cost-benefit analysis of training activities, leading to a 10% reduction in training costs.

Created algorithms using Python and GIS, employing spatio-temporal clustering and random forest models to pinpoint delivery points, optimizing routes and operational efficiency by integrating heatmap and KDE analyses for peak hours and spatial hotspotsLed a project on pairing over 150,000 bus GPS data with transportation card swipe data, identifying bus stop locations and analyzing passenger drop-off sites with bus travel chain, conducting multidimensional analysis on passenger behavior, station, routes, etc. and suggested improvements

Developed Python scripts for data cleaning, implementing techniques such as mean methods for missing values, Z-score outlier detection, and K-means clustering to standardize anomalies across datasets of over 500,000 records, enhancing data integrity for accurate subsequent analysis and modelingApplied decision tree classification algorithms in an insurance recommendation project, analyzing user characteristics, optimized the model by maximizing information gain through attribute-based splits, achieving a prediction accuracy of 90% for insurance purchase likelihood

Collaborated on strategic analysis with team, analyzed policies and cases and wrote reports for projects like Liupanshui High-speed Railway Station Area and Station Square Research and Planning, and Wenzhou Binjiang Business District Area Industrial Planning Program

Participated in planning discussions and schedule revisions for the Yibin Old City Renovation project