Zhiguang Wang
Glen Cove,NY
Summary
SQL: Extensive experience in writing and troubleshooting SQL queries utilizing with ETL or report development. Excellent in generating rankings, calculating moving averages and running totals, reduplicating data, or performing time intelligence with window functions.
Database: Database Designing, creating PostgreSQL Database, cleaning data in PostgreSQL database.
Python: Importing and Cleaning Data, Data Manipulation, Data Visualization, Data Mining, Data Modeling, Data Analytics.
Excel : VBA and data analysis.
Overview
4
4
years of professional experience
7
7
years of post-secondary education
1
1
Language
Work History
Operation Assistant
World Human Accountability
New York, US, US
04.2018 - 07.2018
- Position.
- WHAO is a non-profit organization with a mission of increasing the awareness of social responsibility by encouraging people to work together to address the most pressing issues.
- My duty is to assist to arrange the events held in UN or elsewhere.
- I also need to prepare the reports of our events or conversations.
CEO's Assistant
CHS Media Co., Ltd
07.2016 - 09.2017
- CHS Media is a productive media company which produced lots of dramas and films in China.
- Worked on the Broadway show producing in New York.
Shanghai LIVIC Filtration System Co., Ltd
Shanghai, China
08.2012 - 04.2015
- Work as a sales representative there, in charge of searching new customers for our products throughout nationwide in China.
- Undergoing a long process of exerting, I held a great deal of customers.
- During this time, I worked with some foreign companies such as Pall, Basf, Honeywell, Wacker etc.
Education
Bachelor of Economics - International Economics and Trade
Kunming University of Science and Technology
09.2008 - 07.2012
Master of Arts - East Asia Studies
St. John's University
09.2017 - 05.2019
Master of Science - Data Science
St. John's University
09.2020 - 05.2022
Skills
Statistical analysis
Machine learning
Data Mining
Data profiling
Data Visualization
Timeline
Master of Science - Data Science
St. John's University
09.2020 - 05.2022
Operation Assistant
World Human Accountability
04.2018 - 07.2018
Master of Arts - East Asia Studies
St. John's University
09.2017 - 05.2019
CEO's Assistant
CHS Media Co., Ltd
07.2016 - 09.2017
Shanghai LIVIC Filtration System Co., Ltd
08.2012 - 04.2015
Bachelor of Economics - International Economics and Trade
Kunming University of Science and Technology
09.2008 - 07.2012