Ying (Cathy) Wang

Address: Charlotte, NC ***** Cell: 704-***-**** adkhod@r.postjobfree.com

Github: github.com/yingwang131 LinkedIn: linkedin.com/in/yingwang131/ SUMMARY

Over 4+ years of computer science background and 2+ years of business analyst in marketing, operation, and customer support is seeking a full-time job in business analysis and application software where my technical and business skills may be utilized fully to advance growth within the company. Experienced in handling large data and translating mundane data into business KPI and insights. EDUCATION

The University of North Carolina at Charlotte, Master of Science in Computer Science GPA:3.7 12/2020 The University of North Carolina at Charlotte, Bachelor of Science in Data Science GPA:4.0 06/2019 Coursework: Data Analytics and Visualization, Database Systems, Business and Marketing Analytics, Probability & Statistics, Linear Algebra, Object-oriented programming, Cloud Computing, Computer Netwrorking Scholarships & Awards: Dean’s List, Chancellor's List, Alumni Association Scholarship, Morrow International Scholarship SKILLS

Programming Languages: Python, SAS, Java, JavaScript/HTML/CSS Databases: MySQL

Modeling: Linear, Logistic regressions, K-means, Decision Tree,KNN, Random Forest Data Visualization: Advanced Excel (VBA, formulas), Tableau, PowerBI WORK EXPERIENCE

Information Technology Internship, The Clorox Company, Remote, NC 06/ 2020 – 08/2020

• Participated in every stage of software product with PM, Clients, and IT team to quickly understand the business model and product

• Automated existing process using Tableau, Excel to make data easily accessible and increased operational efficiency by 40%

• Developed key performance indicators to measure Inclusion & Diversity success, resulting in a 30% increase in culture satisfaction

• Helped the IT department to optimize the website platform targeted on female employees and increase 18% of DAU of the website Software Developer Internship, Ahold Delhaize, Charlotte, NC 06/2018 – 12/2018

• Designed and implemented unit tests for a mobile application to improve the code coverage rate from 75% to 90%

• Collaborated closely with design teams to make sure the software products are aligned with the client’s expectation

• Implemented integration test to make sure the business progress is aligned with our expectation

• Designed and implemented the platform by React.JS to automatically deliver the test report to the team to save 15% of time Business & Sales Analyst, Education First, Tianjin, China 08/ 2012- 12/2014

• Collected and analyzed user data by using the RFM model to calculate the ratio of each user and keep the most valuable user

• Worked with sales managers to perform product analysis, offers 20% credits for current users, then boost monthly revenue by 30%

• Generated ad-hoc quantitative and qualitative reports through market research, delivered actionable insights for decision making

• Leveraged advanced Excel skill (VBA report automation, what-if-analysis) to analyze 48+ market channels to make more precise cost control and budget estimation

PROJECTS

Clorox Inclusion & Diversity Project: The Clorox Company

• Cleaned data with Numpy and Panda as well as extracting data features, include age, gender, ethnicity, location, etc…

• Launched 3+ Inclusion & Diversity survey to reduce 60% time of finding out the pain points; used PowerBI to compare the previous data to deliver the new strategy

• Analyzed survey text data by using word segmentation, keyword extraction, and sentiment analysis to directly understand the employee ideas to improve the inclusion and diversity working environment

• Developed key matrixes to measure the success of I&D and invented 4 leadership groups [Building community, Awareness, Ambassador, Recruitment focus] to achieve future performance indicators

• Led and organized the team’s daily standup meeting to make sure build and deliver the website and report for the project on time Python Rossmann Store Sales Prediction: Kaggle Competition

• Used Pandas, Numpy, and Matplotlib to visualize and analyze the dataset

• Clustered the stores by applying the K-means model according to their feature matrix

• Trained the linear regression models to make prediction for future sales for the different store clusters

• Implemented the XGboost model to increase the accuracy from 75% to 92%

Contact this candidate