Data Analyst, Data Scientist

Weiyao Wang

E: ******@***.*** L: https://www.linkedin.com/in/weiyao-wang-86938013b/

P: 917-***-**** A: 200 Greene St, Jersey City, NJ, 07302 Business-minded data analyst with 3 years’ consulting experience serving top financial service companies, highly skilled in quantitative analysis, machine learning modeling, business intelligence and SQL, Python programming. Relied on as a key advisor to provide data-driven, action-oriented solutions to challenging business problems. Experience

DIA Associates

Data Analytics Consultant serving American Express Oct 2017 – April 2020 Accounts Development Strategy Planning

● Designed and automated global reporting system to enhance reporting capabilities, data integrity and reporting efficiency which decreased 75% production time.

● Developed Python algorithms to simulate portfolio segmentation and built KNN models to allocate accounts to optimize costs and achieve capacity balance.

● Predicted customer future spending and projected full year targets for key business partners by building time series models with PySpark.

Card Referral Trigger Model Design

● Profiled customer referral behaviors and performed customer segmentation analysis with SQL/Hive.

● Provided suggestions on marketing target prioritization based on Lorenz Curve model to optimize marketing budgets.

● Identified key trigger points that significantly lead to referral behaviors and built weekly trigger models for mailing offers which achieved more than 100% lift in new acquisition number in mid-campaign review.

● Conducted A/B testing to measure the impact of the marketing campaign. Searching Map Merchant Information Standardization and Clustering

● Cleaned and standardized the merchant information based on text data mining to reduce information variation and elevated brand identification reliability by 40%.

● Designed clustering algorithm with Python to group the merchants based on similarity calculation and fuzzy matching.

● Generated logics for nomenclature to increase accuracy of merchant searching and decrease information redundancy of merchants map.

Co-brand Card Acquisition Dashboard Design

● Designed a monthly dashboard with Tableau to track monthly acquisition performance and generate driver insights for key acquisition channels on potential growth opportunities.

● Built data pipeline to collect and consolidate application funnel data from various data sources and designed dashboard automation process.

● Analyzed and profiled on applicants firmographics information to identify well-performed customer groups for each product.

Education

Master of Science in Electrical Engineering Aug 2015 – May 2017 New York University, Tandon School of engineering, NY, USA Core curriculum: Machine learning, Probability and Stochastic Processes, System Optimization Method Bachelor of Engineering in Automation Engineering Sep 2011 – Jun 2015 Northeastern University, Shenyang, China

Core curriculum: Probability and Statistics, Modern Control Theory, Feedback Control Theory Course Project

Fully Convolutional Neural Network (FCN) Image Segmentation Mar 2017 - May 2017

● Upsampling from limited original images, extracted and integrated data with its labels.

● Designed and developed the FCN’s networks model by Python based on Caffe framework on Linux OS.

● Trained FCN-32s, FCN-16s, and FCN-8s models to make predictions at pixel level on Prince High Performance Computing system, and achieved 95% pixel level classification accuracy. Skills

Technical Skills: Python, SQL, Machine Learning, Excel, Hive, Spark, Tableau, Hadoop, Salesforce, A/B Testing

Contact this candidate