R/Python/SQL/Tableau/ArcGIS/Access/Excel

ZIXUAN(CLEO) ZHOU

Washington DC/315-***-****/English/Mandarin/*******@*****.***/LinkedIn/Plum

EDUCATION

Syracuse University, School of Information Studies(iSchool), Syracuse, NY December 2019 Master of Information Management, GPA: 3.86

Certificate of Advanced Study in Data Science

Courses: Information Systems Analysis, Business Analytics, Database Management, Information Visualization, Data Warehouse, Big Data Analytics, Human Interaction with Computers, IT Project Management Zhejiang Shuren University, School of Management, Hangzhou, China June 2017 Ming Chuan University (Exchange Study), School of Management, Taiwan Bachelor of Business Administration, GPA: 4.0

Leadership: Presidium Assistant of Student Union

Awards: Excellent Leader of Student Union, Scholarship, Merit Student WORK EXPERIENCE

Data Analyst Intern

District Department of Transportation (DDOT), Washington DC June 2019 – Present

• Working on MoveDC and PaveDC Projects

• Cleaning and formatting road closure data for integration into Waze

• Analyzing traffic volumes have been impacted by the coronavirus, preprocessing data using R and Python, comparing hourly/daily/weekly/monthly traffic volumes for important roadway segments to a historical average (2020 vs 2019), creating dashboard using Tableau, and reporting changes of traffic volumes to leadership

• Cleaned and analyzed traffic data, created data visualization using R, Python, Tableau, and ArcGIS, defined priorities of existing CCTV cameras in DC, and suggested where additional cameras should be added based on the traffic condition

• Designed Entity Relationship Diagram and Data Flow Diagram for a new database system using MS Visio, implemented database structure in MS SQL, and imported data into SQL database for ITS (Intelligent Transportation Systems) Team Analyst/Consultant

iConsult Collaborative at Syracuse University, Syracuse, NY February 2019 – May 2019

• Analyzed the existing database, understood the information needs, and proposed solutions for clients

• Designed Entity Relationship Diagram and Data Flow Diagram for a new database system using MS Visio

• Designed and experimented with different user interfaces in MS Access and developed a complex database system to improve operational efficiency

Trainee of Foreign Exchange Trading

Forex Capital Markets (FXCM) – Manhattan, NY July 2016

• Conducted foreign exchange trading by using trading software such as Random Trader EA and mathematical theory such as Fibonacci Sequence and Golden Ration within Wave Theory PROJECT EXPERIENCE

Product Analyst of Product Design Project September 2019 – December 2019

• Designed a platform which systematically manages students' academic, career-pursuing and other personal activities and automatically reminds students, by conducting market research (interview, survey), analyzing collected data, and creating preliminary software prototyping and layout design. Project Link Data Analyst of Big Data Analysis Project February 2019 – May 2019

• Worked on preprocessing data, data visualization, feature engineering and building models to predict house prices for King County by applying Python Spark and several algorithms such as linear regression, random forest, XGboost, and Neural Network. Project GitHub Link

System Analyst of Information System Analysis Project September 2018 – December 2018

• Analyzed registration system between Syracuse University and 2U, then designed a database, user interface and new system to solve the problems within the current system TECHNICAL SKILLS

R, Python, Tableau, Power BI, QlikView, ArcGIS, Google Analytics, MS SQL, MySQL, MS Visual Studio, Microsoft Office (Access, Excel, Visio, Project), Software Development (Lean, Agile, SDLC), SAP, SPSS, Adobe Illustrator

Contact this candidate