Dan Luo Email and Phone Number

• Automated data analytics workflows for consumer insights reports and created 60+ visualizations using Tableau Prep Builder and Tableau to analyze 3K+ survey responses across 370+ fields, ultimately achieving an 85% time reduction in report creation• Compiled 2 monthly consumer insights reports and analyzed consumer behavior, integrating 55+ Excel charts and 100+ cross-tables into PowerPoint; delivered presentations to 180+ colleagues, enhancing product decisions and marketing strategies• Conducted 7 market reviews and competitor analyses by collecting and synthesizing primary and secondary market data, performing data analysis with R, and presenting implications to senior leadership, influencing three key strategies• Utilized a bottom-up approach to evaluate market value within a niche segment of the medical device sector, scrutinizing 30+ organizations globally and facilitating investment decisions totaling $5 million

• Designed and distributed academic surveys to 1000+ students to investigate their academic needs and concerns• Conducted analysis, visualized data in Tableau, and created strategic report to address 7 academic concerns• Worked with cross-functional teams of 20+ faculty members and student organizations, increasing student engagement by 25%

• Conducted 192-hour tutoring for 60+ students, reviewed knowledge points, and explained exercises• Took the initiative to collect feedback and suggestions from students, communicating with professors on how to improve students’ learning efficiency, compiled and improved teaching plans• Earned all As on teaching quality evaluations, was invited to give speeches at seminars held by Academic Success Center

• Cooperated with staff and 14 other team leaders to design the procedures for the opening ceremony for freshmen • Helped newly incoming international freshmen adapt to college life and answered their life and academic questions via emails and zoom meetings • Organized international students to participate in the three-day online opening ceremony, held seminars with 15 students on the topics including culture shocks, language barriers, and available student resources on campus

• Lowered acquisition cost by 66% for one campaign on DXY.cn with quick campaign revision by analyzing performance data • Communicated with 21 healthcare professionals (HPCs) and carried out 2 offline campaigns across the country with the team by managing 10+ Excel tables such as customer relationship management, channel marketing budget, and social media posting schedule• Troubleshot 6 major IT problems with the India regional team, completed 16 Conflict of Interest Forms with the sales department, processed 11 purchase orders for the team• Participated in 15+ meetings with external agencies to brainstorm campaign content raising HPCs’ awareness about healthcare products

• Collected 100+ business clients’ information on platforms like National Enterprise Credit Information Publicity System and created summary reports for the vice president • Assisted 6 loan officers to prepare, analyze and approve 30+ financial loan requests and completed total loans of ¥5 million• Created and periodically updated 4 static dashboards with Excel and PowerPoint to access the banking performance in terms of customer types, total loans & deposits, net charge-off rate, and operating expenses (actual&target)