Data Analyst, python, SQL
Resume:
Kong Yuwei
Mobile:**-******** E-mail: ac8ljk@r.postjobfree.com
EDUCATION BACKGROUND
National University of Singapore Jan 2018- Present
• Information Systems & Analytics
• Degree: Master of science
Jilin University Sep 2012- July 2016
• Major: Information Management and Information System
• Degree: Bachelor of Science
SKILLS
• Programming languages: Python, SQL, R, Highcharts
• Software: Tableau, Microsoft Office
• Others: Project management
WORKING EXPERIENCE
Outsystems Sep 2018-Present
Data Analyst Intern
• Analyzed commercial and customer behavior data retrieved from internal database and web sources;
• Communicated with multiple departments to figure out which variables are important to be analyzed, the core of the business;
• Investigated additional data and found out the 10% of customers come from the Asia area have the potential to upgrade.
Deloitte May 2018-Jul 2018
Consulting Intern
• Evaluated the data from different data source and successfully formed a scheme to fetch data for developer;
• Collaborated with different departments on the logical relationship between the data;
• Designed the prototype of statement in three days based on the logic between the statements; reporting and review process and more than 90% functions were approved by customer. Beijing Join-Cheer Software Co. Ltd. Jun 2016-Oct 2017 Software requirement analyst
• Communicated with four departments of HR, sales, financial, products on business process requirements;
• Extracted data through ETL and PLSQL, plotted from revenue data of the company to dynamically show changes in revenue per month.
• Clarified a new data structure in order to recognize simply and put into the new software, successfully eliminated the data compatibility and data redundancy between different departments.
• Trained 80-110 clients on how to operate the new system and achieved a good feedback. Complete 3 projects, Converted the old process of working way of financial department into a new simple way, by re-clarifying the data structure to shortened the at least 2-3 weeks reported time and labor cost.
RESEARCH PROJECTS
What kinds of factors affect NBA players’ salary? Mar 2018
• Using Python to web scraping players’ information data from NBA website and preprocessed those data through SQL in variety ways;
• Researched and Classified the factors which will affect players’ salary;
• Statistical analysis through R, finding out the causal factors, then feedback to the team owner to give the guided advice on how much should pay to the existing players. The relationship between Brexit and crime rate Mar 2018- Apr 2018
• Collected the data from UK government website and other third websites, organized the data by Pandas and retained 4.3 GB of data from 11 GB of data after researched;
• Determined an economic model to analyze by testing the results of different model;
• Displayed the results of the analysis and provided another new theoretical basis of influence relationship between Brexit and crime rate.
Visualization of historical data of licensed eating establishments in Singapore Mar 2018- Apr 2018
• Data processing through excel and combine the needed attributes;
• Created a story through Tableau, exploring in four aspects which include spatial aspects, quantitative aspects, statistical aspects, Temporal aspects to find out the insight. For instance, the correlation between the population in a region with the number of eating establishments, etc. COMPETITION
The National College Students' Innovative Entrepreneurial competition Mar 2014- Oct 2015 Won the first prize of the school
• Surveyed and collected the request of students through questionnaire;
• Provided WeChat services for college students to collect and analyze relevant data; EXTRACURRICULAR ACTIVITIES
Minister Students’ Association Union in Jilin College Jun 2014-Jul 2015 Volunteer the Puppet Manchurian Palace in Changchun Apr 2013-May2014 ADDITIONAL INFORMATION
• Languages: English, Mandarin;
• Hobby: Painting, Swimming, Running, Piano;
Contact this candidate