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
- Shanghai Maritime University, Shanghai, China
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
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
- Microsoft, Seattle, Redmond, United States
- Point B, Seattle, Washington, United States
- Quantum One, Shanghai, China
- PwC, Shanghai, China
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
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
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
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%
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