Yu (John) Ye Email & Phone Number

Des Moines, Iowa, United States

• Connected to data sources, imported data, and transformed data for analysis and reporting
• Designed, developed, deployed, and maintained Power BI report solutions
• Wrote and executed ad-hoc queries using SQL Server

Des Moines, Iowa, United States

• Automated financial reports using Excel VBA, macros, and formulas to streamline processes and maximize accuracy, reduced over 90% of project lead time through processes automation
• Produced visualizations to analyze the performances between the company and its competitors using the KPIs metrics
• Translated results into insights to support decision-making, aided with the use of visualizations using Power BI and Python
• Transformed historical dataset to tabular form, making the data ready for consumption in Tableau and Python

Ames, Iowa, United States

• Designed two 30-page Tableau tutorials which include basic and advanced functionality (table calculations, joins, filters, parameters, K-Means Clustering, etc.) to create analytical dashboards
• Mentored 30 students of applying machine learning to solve real-world business problems and developing insights into formulated problems within the business/customer context using SAS Enterprise Miner in the.
• Recorded a step-by-step tutorial on fraud analysis using decision tree model with RapidMiner for MBA students
• Created a tutorial on prescriptive analysis such as Linear Programming using Excel Solver for MBA students

Ames, Iowa

• Collected 1000+ cross-sectional data from research participants using Mturk survey
• Analyzed 1000+ data set using factor, cluster, and correlation analysis using SPSS
• Performed data cleaning, wrangling, and validating the dataset to prepare for analysis
• Presented findings to professors, peers, and practitioners at an international research symposium

Ames, Iowa

• Devised an ambassador recruitment plan to be implemented the first 3 weeks of the semester
• Developed and implemented recruitment and training programs that resulted in a 90% ambassador satisfaction
• Arranged logistical needs (supplies, room setup) for ambassador training with the committee
• Trained 123 students as qualified ambassadors through presentation and situational activities
• Collaborated with the committee to create a recruitment and training plans
• Reviewed feedback from past surveys to determine positive changes for future career fairs

Ames, Iowa

• Served as an event planner, coordinator, and director of the Spring Festival Carnival
• Supervised 25 event staff members to execute an event with over 800 attendees
• Designed performance timeline (light and audio cues) for events
• Solicited feedback from the staff, performers, and guests to identify areas for improvement
• Received “Events of the Year” team award from International Students and Scholars Office and International Student Council

Des Moines, Iowa, United States

• Analyzed social media platform performance and advised the team on strategic opportunities for innovative solutions and improvements to optimize digital presence
• Collected key performance indicators and metrics for the organization’s annual report

Des Moines, Iowa Area

• Utilized CRM to create exhibitor list while assisting group logistics per national trade show as needed
• Assisted events manager and events coordinator in planning and executing 30 national and regional tradeshow and business meetings
• Managed, monitored, and validated trade show expenses to assist managers in making business decisions
• Communicated with external business partners to cooperate warehouse and inventory transition
• Assisted in the events marketing efforts – Provided monthly trade show information to the marketing team for tradeshow web page updates
• Compiled data entry and responsible for daily administrative functions

Guangzhou, Guangdong, China

• Coordinated with event planners in all aspects of the Guangzhou International Building Decoration Fair, which hosted 900,000 visitors
• Assisted on-site management for the Guangzhou International Building Decoration Fair
• Accommodated hotel and transportation arrangement for the vendors
• Worked with the fair’s media promotion and communications

Master'S Degree, Management Information Systems With Business Analytics Certification, 3.73/4.00

Activities and Societies: Data Science Club, Big Data Club, Management Information Club, Marketing ClubCoursework - • Business Analytics.

Bachelor Of Science (B.S.), Event Management & Entrepreneurship Minor With Honors, 3.65/4.00

Activities and Societies: University Honors Student, Minor in Entrepreneurship, ISU After Dark, Student Union Board, Chinese Students and.

Predictive Analytics For Business, Business

Course 1: Problem Solving with Advanced Analytics Course 2: Data Wrangling Course 3: Classification Models Course 4: A/B Testing Course 5.