Yu (John) Ye Email and Phone Number
Yu (John) Ye work email
- Valid
Yu (John) Ye personal email
I am a firm believer that growth happens outside of your comfort zone. I am an outgoing, self-motivated, meticulous, and detail-oriented person with Business Analytics, Business Intelligence, Machine Learning, Deep Learning, Natural Language Processing, Marketing, and Event Management skills. My education and passions lie in making effective use of data to solve complex problems, thereby making fact-based business decisions that yield optimal and robust results. I am always motivated to learn new skills, tools, and analytical techniques. Comprehensive knowledge in data cleaning, data mining, and data visualizing in business applications. ✓ Technical Skills:➤Programming Skills: SQL, Python, R, SAS, VBA➤Tools and Technologies: Tableau, Power BI, Power App, Power Automate, AWS, Microsoft Suites, Git, JMP, SPSS, SAS
Venerable
View- Website:
- venerableannuity.com
- Employees:
- 224
-
Operations Information AnalystVenerable Sep 2021 - PresentDes 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 -
Business Intelligence InternFarmers Mutual Hail Insurance May 2021 - Sep 2021Des 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 -
Graduate Research And Teaching AssistantIowa State University - Ivy College Of Business Sep 2020 - Sep 2021Ames, 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 introduction to business analytics course• 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 -
Data Analyst Research InternIowa State University Aug 2018 - Jun 2020Ames, 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 -
Ambassador CoordinatorIowa State University Apr 2017 - Oct 2018Ames, 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• Supervise and serve as point-of-contact for ambassadors for the duration of the career fair • Schedule shift times and responsibilities for career fair ambassadors and communicate these to volunteers prior to the career fair -
Event And Entertainment Prime MinisterIowa State University Aug 2017 - May 2018Ames, 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 -
Events & Cme InternIowa Medical Society Feb 2020 - May 2020Des 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 -
Events AssistantEurofins Apr 2019 - Aug 2019Des 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• Organized departmental calendars with tradeshow and event internal deadlines and information -
Event Marketing And Promotion InternChina Foreign Trade Guangzhou Exhibition General Corp. May 2018 - Jul 2018Guangzhou, 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
Yu (John) Ye Skills
Yu (John) Ye Education Details
-
3.65/4.00
Frequently Asked Questions about Yu (John) Ye
What company does Yu (John) Ye work for?
Yu (John) Ye works for Venerable
What is Yu (John) Ye's role at the current company?
Yu (John) Ye's current role is Business Data Analyst📈 | Microsoft Certified Power BI Data Analyst Associate | Tableau Desktop Specialist📊 | Certified Google Analytics | SQL | Python | R | Power BI | Power App | Power Automate | VBA | SAS | SPSS.
What is Yu (John) Ye's email address?
Yu (John) Ye's email address is yu****@****ity.com
What schools did Yu (John) Ye attend?
Yu (John) Ye attended Iowa State University - Ivy College Of Business, Iowa State University, Udacity.
What skills is Yu (John) Ye known for?
Yu (John) Ye has skills like Leadership, Social Media, R, Spss, Public Speaking, Socialtable, Coordinating Skills, Allseated, Predictive Analytics, R (Programming Language, Data Analytics, English.
Who are Yu (John) Ye's colleagues?
Yu (John) Ye's colleagues are Rency Varghese, Conor Medwid, Sara Nichols, Andrew Dolata, Jin Yang, Malinda Collins, Fsa, Maaa, Aaron Miner, Cfa.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial