Chuchu Yao

San Francisco, CA 713-***-**** addrot@r.postjobfree.com

EDUCATION

Texas A&M University, Mays Business School College Station, Texas Master of Science in Management Information Systems May 2020 Quanzhou Normal University, Mathematics and Computer Science School Quanzhou, Fujian/China Bachelor of Engineering in Information Management and Information System June 2018 EXPERIENCES

We Rock Cancer McLean, Virginia

Data Analyst April 2020 - Now

Conducted database research regarding more than 360 grant, foundation and donor organizations, presented find- ings and recommendations to WRC Founder, Financial Resource Development Chair, and Board of Directors.

• Identify grant and donor processes at philanthropic organizations, analyzed and synthesized findings into ac- tionable recommendations, conducted market research analytics to identify priority opportunities

• Collaborated with grant writers, corporate giving team members to develop and execute fundraising strategies China Construction Bank Shanghai/China

Data Analyst Intern May 2019 - August 2019

Evaluated risks of credit card fraud, suggested and developed credit card fraud management strategies, decreased the average number of fraud cases by 30%, saved $1.5 million in cost.

• Participated in complex statistical modeling development, enhancement to reached a 99.99% data accuracy rate

• Conducted SSIS and Python to perform various ETL operations to deliver data in a presentation-ready format

• Reduced 20% of data error rate by creating risk estimation models and using statistical techniques for hypothe- sis testing to validate data and interpretations

• Worked on advanced SQL queries, created data reports to help business executives in their decision-making

• Collaborated with cross-functional stakeholders to formulate and complete full cycle analysis using agile project management skills

China Academy of Science Institute of High Energy Physics Beijing/China Data Scientist Intern May 2018 - September 2018

Pretreated and analyzed Lustre operation log data, used the Isolation Forest model to do anomaly detection, im- proved detection accuracy rate from 80% to 95%, saved an average of 180 hours of labor each month.

• Specialized Python scripts to implement NLP tasks, resulted in 2.5 million concise and error-free log data

• Identifying opportunities for improvement in data cleansing, manipulating and processing with existing soft- ware applications and frameworks, saved ~70 hours of data processing time

• Visualized analysis results, verified the model accuracy to provide executive information reporting as required

• Proposed solutions to improve system efficiencies, leading to a 15% reduction in operating costs Quanzhou Normal University Quanzhou, Fujian/China

Data Analyst Research Assistant Oct 2017 - Apr 2018 Responsible for collecting, cleaning, labeling and conceptualizing large databases. Created analysis report, coor- dinated with lab researchers, achieved accuracy with a trained model of 95.5% for the sampled dataset.

• Applied machine learning algorithms, visualized analytics results to draw insight into the database. Summa- rized analytics results, published a paper on IEEE international conference on computer and communication PROJECTS

Flights Live Dashboard Project (Dec 2019 - Jan 2020) College Station, Texas

• Developed an interactive web app for “Flights delay & cancelation around U.S” (HTML, Python and SQL)

• Utilized AWS as database, built a live dashboard for business report, extracted business insights from reports Yelp Business Intelligence Project (Feb 2019 - May 2019) College Station, Texas

• Maintained ETL jobs for Yelp data set (SQL, SSIS), wrote BI reports for business analysis (PowerBI)

• Documented entire SDLC, participated and provided technical leadership in all phases of BI projects SKILLS

Programming Languages: Python, R, Spark, HTML, CSS, C, C#, MATLAB Database: Microsoft SQL Sever, Access, MySQL, PostrgreSQL, Oracle, NoSQL, AWS, Azure Analytics: PowerBI, Google Analytics, AdvancedExcel, Tableau, SPSS, JMP, SAS, Visio, SAP, ERP, Saleforce

Contact this candidate