Data Analyst Engineering

QING YANG

****.***@************.*** / New York City / 858-***-****

EDUCATION

Northeastern University, Boston, MA 05/2020

M.S. in Data Analytics Engineering, GPA 3.68

Relevant Coursework: Data Mining in Engineering, Data Management and Database Design, Financial Management, Computation and Data Visualization University of California, San Diego, CA 09/2016

B.S. in Mathematics, Minor in Economics

SKILLS

Technical Skills: R, Python, SQL, MySQL, Tableau, Microsoft Office Excel, Outlook, Word, PowerPoint, AMPL, LINGO, Matlab, SPSS, Google Analytics Languages: Mandarin Chinese, English, Japanese (Conversational) WORK & LEADERSHIP EXPERIENCE

CrypotoAlgoWheel, LLC, Newton, MA 08/2020-Present

Data Analyst

• Generated dashboards by using calculation and parameters in Tableau.

• Collected datasets of ticker list, historical trading data using API from Cryptocurrency exchange.

• Conducted backtesting and evaluated trading performance using multiple KPIs.

• Assisted in developing Telegram Chatbot to send market signal alert as needed. Conservice, LLC, San Diego, CA 04/2017-07/2018

Data Analyst

• Performed detailed data analysis and ensured data quality from external source using Microsoft Excel.

• Translated data analysis result into reports for clients and internal departments.

• Obtained raw data from City agencies, converted and loaded into database.

• Enhanced 20% team working efficiency by launching a new database organizing method.

• Led 7 new hires data processing trainings required for daily work. Tebian Electric Apparatus Stock Co., LTD, Shenyang, Liaoning/China. 09-12/2016 Finance Executive Assistance

• Collaborated with other departments to construct expense spending database and kept database updated.

• Troubleshooted financial data discrepancies and decreased error by 30% by auditing financial statements and tax reports.

• Coordinated appointments, meetings and managed correspondence. ACADEMIC PROJECTS

Data Analysis and Visualization for Crime in Chicago Data Mining Team Leader 08-12/2019

• Conducted data mining, data cleaning and data analysis, including data trend and trend growth, using R.

• Generated rich graphics and data visualization of large structured data using ‘ggplot’ in reader friendly format.

• Performed time series forecasting based on data between 2012 and 2018 to predict future crime rates and to identify pertaining key influential factors.

• Verified the accuracy of the prediction models by using 2018’s dataset as validation set. International Car Rental Company Database

Data Management and Database Design Project Leader 01-05/2019

• Designed and Generated the Entity-Relationship Diagram by Toad Data Modeler.

• Loaded data using ETL process in different data sources including XML, MS Excel, CSV, flat files and etc.

• Evaluated and analyzed large data set from multiple Company departments using cross joint.

• Created analyzing report by Power BI and SSRS.

• Improved database update efficiency 37% by creating multiple triggers to car rental database.

Contact this candidate