About me

Self-Motivated and teamwork-oriented data enthusiast with both the business and data science education background. Adept at analytical pipeline with in-depth knowledge in database and BI system. Familiar with business research methodologies and identifying business problems through data analytics.

Education

• University of Washington, Seattle, Washington

Master Degree in Information Management, Specializing in Data Science & Business Intelligence, GPA 3.7/4.0

Courses: Business Intelligence System, Social Media Data Mining, Machine Learning for Big Data, Marketing Analytics

• Shanghai Maritime University, Shanghai, China

Bachelor Degree in Management Science, GPA 3.6/4.0

Courses: Statistics, Operations Research, Design and Development of Database, Principle of Management Decision Awards: Shanghai Scholarship (2%), Shanghai Outstanding Graduate (2%), TEDxSMU Curator & Organizer

Experience

• T-mobile, Bellevue, Washington, United States

Capstone Proejct Data Scientist, Automation labelling for Application Marketplace, Dec.2019 - Jun.2020


∙ Performed web scraping to gather metadata from multiple application stores and clustered apps based on text analytics using LDA

∙ Built a graph model by NetworkX for clustering users and labelling persona based on user downloading behavior data

∙ Scaled the model based on pySpark, worked with T-mobile team to analyze and improve the model after deploying into production


• Microsoft, Seattle, Redmond, United States

Student Project Team Leader, CDG Security Team, Dec.2019 - Jun.2020


∙ Worked with Microsoft team to analyze the software and hardware secure supply chain and develop Security Control System Assessment for supply chain risks based on NIST Cybersecurity Framework Assessment questionnaire

∙ Designed a Power BI Dashboard to visualize the supply chain dependencies and top risks across different steps of the supply chain


• Point B, Seattle, Washington, United States

Business Intelligence Intern, Jun.2019 - Dec.2019


• Created Process and automated procedure on Dell Boomi and SSIS to load data (ETL) from multiple sources to SQL server

• Created SQL views, designed 5 Tableau dashboards for firmwide financial, sales, staffing and performance monitoring

• Designed and architected the dimensional model of data warehouse according to the business analytics goal


• Quantum One, Shanghai, China

Product Anlyst Intern, Mar.2018 - Aug.2018


• Built a financial fraud detection model based on logistics regression to predict the customer repayment, which was implemented to judgement node in loan review, decreasing the number of overdue customers by 22%

• Monitored and reported product operation status including credit risk, loan approval daily with SQL and pivot table, compiled, maintained and optimized queries to improve the time efficiency by 38%

• Improved loan process and polished mobile user interface based on conversion rate analytics, increasing purchase rate by 23%


• PwC, Shanghai, China

Business Anlyst Intern, Information Management and Advanced Technology Department, Jul.2017 - Dec.2017


• Visualized the personnel capability using Tableau to assist the PM to plan project resources

• Managed backlog item, analyzed business requirement from technical perspective in agile software development environment

• Accomplished scheme design covering preliminary usability testing and designed web user interface mockup in several projects