Yu (John) Ye

Yu (John) Ye Email and Phone Number

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 @ Venerable
west chester, pennsylvania, united states
Yu (John) Ye's Location
Ames, Iowa, United States, United States
Yu (John) Ye's Contact Details

Yu (John) Ye work email

Yu (John) Ye personal email

n/a
About Yu (John) Ye

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

Yu (John) Ye's Current Company Details
Venerable

Venerable

View
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
west chester, pennsylvania, united states
Employees:
224
Yu (John) Ye Work Experience Details
  • Venerable
    Operations Information Analyst
    Venerable Sep 2021 - Present
    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
  • Farmers Mutual Hail Insurance
    Business Intelligence Intern
    Farmers Mutual Hail Insurance May 2021 - Sep 2021
    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
  • Iowa State University - Ivy College Of Business
    Graduate Research And Teaching Assistant
    Iowa State University - Ivy College Of Business Sep 2020 - Sep 2021
    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 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
  • Iowa State University
    Data Analyst Research Intern
    Iowa State University Aug 2018 - Jun 2020
    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
  • Iowa State University
    Ambassador Coordinator
    Iowa State University Apr 2017 - Oct 2018
    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• 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
  • Iowa State University
    Event And Entertainment Prime Minister
    Iowa State University Aug 2017 - May 2018
    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
  • Iowa Medical Society
    Events & Cme Intern
    Iowa Medical Society Feb 2020 - May 2020
    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
  • Eurofins
    Events Assistant
    Eurofins Apr 2019 - Aug 2019
    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• Organized departmental calendars with tradeshow and event internal deadlines and information
  • China Foreign Trade Guangzhou Exhibition General Corp.
    Event Marketing And Promotion Intern
    China Foreign Trade Guangzhou Exhibition General Corp. May 2018 - Jul 2018
    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

Yu (John) Ye Skills

Leadership Social Media R Spss Public Speaking Socialtable Coordinating Skills Allseated Predictive Analytics R (Programming Language Data Analytics English Adobe Photoshop Jmp Tableau Customer Relationship Management Text Mining Sas Deep Learning Alteryx Natural Language Processing Database Management System Marketing Interpersonal Communication Business Analytics Event Management Time Management Customer Service Business Intelligence Cantonese Canva Relational Database Management System Sql Python Adobe Illustrator Analytical Skills Project Management Machine Learning Mandarin Data Visualization Data Mining Indesign Microsoft Power Bi

Yu (John) Ye Education Details

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

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.