Shaolong Fred Xue

Senior Data Analyst @Acumen, Llc

Burlingame, CA, US

Automated employee records management using Excel VBA and Python, reducing weekly processing time by half and improving data accuracy.• Analyzed organizational attrition, creating metrics (e.g, attrition rate, trends by department, location, tenure) and developed Tableau dashboards and Excel reports for executive decision-making.• Led migration of 12 years of historical recruiting data to a new data structure, resolving definition mismatches and ensuring seamless transition using SQL Server.• Scripted quarterly staffing insights report from organization employee database with Python, informing executive directors and enabling more efficient resource allocation.• Overhauled company internal communication networks and channels using Python, identifying inconsistencies across team records and optimizing communication systems.

University of Wisconsin-Madison

Bachelor of Science - BS

University of California, Davis - Graduate School of Management

Master of Science in Business Analytics (MSBA)