Data Analyst Engineering

Frank Qian Medford Boston MA,***** 573-***-**** ****.***@************.***

Objective: Utilizing Data Analytic skills and Engineering knowledge to innovate and advance business EDUCATION

Northeastern University, Boston, MA Jan 2019 – Now, Graduating Aug 2020 Master of Professional Study in Data Analytics; Concentration of Statistical Modeling (GPA: 3.80/4.0) Missouri University of Science & Technology, Rolla, MO Aug 2015 – Jun 2018 Bachelor of Science in Petroleum Engineering; Minor in Geology WORK EXPERIENCE

Alliance Disposal. South Plainfield, NJ --- Data Analyst Intern May 2020 – Now

● Designed python web scraping program with Selenium and BeautifulSoup; Exported data to Excel format by Pandas

● Reviewed data and classified the tables/measures functions by using multiple queries, views, and procedures in SQL; Developed advanced SQL queries with multi-table join, group functions, subqueries for data analysis Smithsonian Institution. Washington, DC --- Data Analyst Intern Jan 2020 – Apr 2020

● Evaluated and visualized user’s behavior on the Smithsonian learning lab website by leveraging Google Analytics; Reported to The Board of Regents: The Chief Justice, Vice President and three members of the US senate

● Analyzed over 75,000 registrants’ profile and adopted SQL queries for detailed categories analyzing; Interpreted Smithsonian learning lab website user’s data; Performed data cleaning with R and Excel; Identified major user role and built a predictive model for future website users traffic development purpose Triangle Accounting Inc, Cary, NC --- Business Analyst Intern May 2019 – Jul 2019

● Investigated financial statements for J.B. Processing; Led the company to successfully receive a 2-million-dollar asset- based (over 30 million workplaces and equipment) short-term loan based on the statement’s analysis

● Developed marketing strategy to propel an international education program taking advantage of various resources; Communicated with different parties and resulted in company brand promoting to China market Missouri University Science & Technology, Rolla, MO --- Program Interpreter Jul 2017 - Aug 2017

● Worked as an interpreter for the CEMTA summer study program in MST; Enhanced communications between lecturer and program learner; Engaged in English-Chinese interpretation including seminar, field trip, laboratory, and meeting SKILLS

Python (Sklearn, Numpy, Pandas), R, MATLAB, Excel (VBA), SQL, Tableau, Spark, Google Analytics, AWS PROJECTS

Machine Learning Project - House Price Prediction in Iowa Jul 2019 – Aug 2019

● Created house price decision tree in R with multi- iteration process; Trained an initial random forest model; Developed ML learning curve to identify best parameters; the Finalized model has 0.164 RMSE and 0.106 MAE Sustainable Apparel Coalition Communication Channel Development May 2019 – Jul 2019

● Investigate SAC Facebook, SAC website, SAC connect tool, Twitter, Mailchimp, and LinkedIn data; Generate improvement advice by applying R, Tableau, and Python (word clouds, trendline, click rate analysis, etc.) PUBLICATIONS

Research Status and Development Trend of the Numerical Simulation for Detailed Oil Reservoir 8/2017 - China Petrochem (No.11-2017) ISSN-1671-7708 Simulation Technology and Application of the Reservoir Numerical Simulation of Seam Carbonate Reservoir 9/2017 - Petrochemical Technology (No.9-2017) ISSN-1006-0235 ACTIVITIES

● Activities: 2016& 2017 Rolla China New Year Gala Host, Actor & Organizer

● Interests: China Traditional Cross Talk, Presented on New Year Gala; Soccer, High School Soccer Team Captain