Qian Liu

**** ******* **, *** *****, NV ***** VISA status: Green card

Email: adjkz0@r.postjobfree.com Phone:814-***-****

Education

The Pennsylvania State University--University Park May 2022 B.S. in Applied Mathematics, B.S. in Data Science GPA: 3.48/4.00 (Major: 3.87/4.00) Main Courses: Probability Theory, Fourier Series and Partial Differential Equations, Linear Programs, Linear Algebra, Data Management, Applied Regression Analysis, Numerical Analysis, Game theory, Graph theory, Python.

Technical Skills

Software: Microsoft SQL Server, MongoDB, Minitab, Microsoft Office suite, Photoshop Coding language: Python, R, MATLAB, Mathematica, SQL, LaTeX Work Experience

BiTech Software Technology Company Intern Shanghai, China 2019.5-2019.8

• Participated in the development of an intelligent elderly care system for the local government, which aimed to provide high-quality elderly care service to the people in that region.

• This system improved the life quality of the aged population by reducing the cost and increasing the convenience of dinning, nursing and entertainment for them. The improvement was achieved through optimizing the allocation of resources based on the information collected from the aged population, including their recent physical and mental conditions, family situations, personal preferences, etc.

• Performed data cleansing to the raw data about the elderly population using Python for subsequent data analysis.

• Wrote SQL query to extract key information like age, location, and living status of the aged population from a database and analyzed the data with statistical methods for resource optimization based on the age distribution, population preference, and physical condition of the elderly.

• Extracted and analyzed additional customer information from the database to predict their potential demands, which was aimed to provide the best service for the elderly population in the region. Armani Exchange Sales Las Vegas, NV 2017.12-2018.4

• Collected sales data and customer information through daily sale activities. Managed and analyzed the collected data by Excel to visualize customer preferences and sales details.

• Categorized the analyzed information and carried out promotion plans, which increased the sales by 10%.

• Proposed innovative ways like establishing a membership system, providing credit back, and offering shipping services options, to leverage the sales information collected and maximize the sales that is challenging to reach through the original retail strategy. Projects

Business Database

• Designed a high-speed relational database for small business owners to store their sales data (including the data from buyers, retailers and commodities in stock).

• Maximized the query efficiency by ensuring a concise and consistent structure in the database, and data duplication was avoided as much as possible.

• Wrote queries to create the database from scratch and tested all the functionalities with online business data.

• Wrote proposals and reports about the business database. Honors

Leonhard Euler Memorial Scholarship Award by Department of Mathematics 2020-2021 Trustee Scholarship Award by College of Science 2019-2021 Penn State Academic Grant Award by the University 2019-2021 Organization

Asian Classic Music Club University Park

Performer and Treasurer September 2018-Present