R (Advanced), SQL (Advanced), Python (Intermediate), Excel (Advanced)

YIJUN(CATHIE) QIU

************@*****.*** 217-***-**** 6158 Waterman Blvd., St. Louis, MO, 63112

Proven Data Analytics Intern Helping Companies Translate Their Business Goals to Reality EDUCATION

WASHINGTON UNIVERSITY IN ST. LOUIS St. Louis, MO

Master of Science, Data Analytics and Statistics January 2021 GPA: 3.44/4.00 UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN Champaign, IL Bachelor of Science, Statistics, Minor in Informatics May 2019 GPA: 3.56/4.00 PROFESSIONAL EXPERIENCE

Arch Talents LLC St. Louis, MO

Data Analytics Intern July 2020 – October 2020

Analyzed and predicted global COVID-19 cases data using R and built visualization dashboard in Tableau Developed and implemented Python programs using Pandas, BeautifulSoup packages to automatically fix broken URLs for a large dataset to help clients solving problems and updating database of 23,000 data, achieving 90% accuracy Presented and explained analysis slides to drive key messaging and recommendations for clients on weekly basis InstaHub Philadelphia, PA

Data Science Intern May 2020 – June 2020

Applied machine learning technique of classification on sensor signal data to predict room occupancy with 90% accuracy rate, resulting in 25% less energy use

Created sensor data dashboard that apply business strategy to data analysis and recommendations like providing consumers with useful insights of sensor’s energy use, room activity’s influence Manipulated and analyzed 10 datasets of 45,000 sensor data, interpreting data trends using R to help other teams enhancing product understanding and planning

Tosee Career Beijing, China

Product Analyst Intern July 2019 - September 2019

Performed product analysis on Tosee Career’s course products using SQL, efficiently achieved product function optimization and a 5% increase in sales

Coordinated with team to organize product data and generated analysis report weekly to support decision-making Presented data analysis, data visualization results and provided business recommendations which are successfully implemented in the company

CreditSpectrum Corp. New York, NY

ABS Analyst Intern July 2018 - August 2018

Analyzed and visualized historical REITs market data of US and China to find trends and insights, satisfied client’s needs by presenting prediction results

Applied Monte Carlo Model using VBA to calculate reduction yield and default rate for each security class Conducted Scenario Test and Cash Flow Model to predict the reduction yield and asset pool for credit enhancement measurement

PROJECTS

Cause of Mortality Data Analysis St. Louis, MO

Organized and analyzed 1.1 million U.S mortality data by using Python Decision Tree model, providing key insights for insurance personnel to help making business decisions Built Neural Network model to analyze mortality data to determine death probability, achieving 72% accuracy rate Presented models and developed data visualization by using Tableau and PPT to explain results for multiple audiences Sensors Signal Detection For Occupancy/Vacancy Classification Philadelphia, PA Analyzed 10 large datasets of sensor data to generate important insights of SoLAR sensor like room activity and heatmap to help development team building website datalogger dashboard Proposed solutions to improve sensor detection of room occupancy by building statistical models using R and achieved 90% detection accuracy rate

SKILLS

Computer Skills: R (Advanced), SQL (Advanced), Python (Intermediate), Excel (Advanced), Tableau (Intermediate) Language Skills: English (Fluent), Mandarin (Native)

Contact this candidate