Yuanzhe Wang Email & Phone Number

Minneapolis, Minnesota, United States

• Client: Consumer Electronics Retailer
• Leveraged multiple services in GCP for data migration and data warehouse recreation
• Implemented quality checks using Github and Dataplex as part of the data pipeline Client: Agricultural Co-op
• Migrated data from Oracle to Snowflake using Qlik Replicate with change data capture implemented
• Rebuilt Informatica mapping logics using Snowflake and Qlik Compose to enable time-efficient PowerBI reporting

Minneapolis, Minnesota, United States

• Client: Crop Science Company
• Built a Python application from scratch to perform quality control on Data Engineering pipeline in GCP
• Designed and implemented CI/CD pipeline using Github Action to boost productivity Client: Agricultural Co-op
• Conducted quality checkes and remodeled data for business to quickly identify alternative products, which generated $0.5M
• Refactored and rebuilt 5000+ lines Python code to 200+ lines for easy future maintenance and better readability using Databricks

Minneapolis, Minnesota, United States

• Client: Customer Service Intelligence Company
• Analyzed rapport using call center audio and transcript data of 10K records in Python with machine learning models such as XGBoost to evaluate agents’ performance
• Presented results along with detailed documentations to help company identify target teams and improve customer service Client: Hennepin County
• Used beta-regression to estimate eligible population for government assistance food program
• Conducted clustering analysis in R and collaborated with client to discover low usage groups, and potentially increase usage by 12%

Minneapolis, Minnesota, United States

• Used SQL to process data from data lake and built dashboards in Redash to analyze merchant performance and investigate high-risk accounts
• Collaborated with other internal teams to solve clients credit assessment issues by analyzing financial statements

Greater Minneapolis-St. Paul Area

• Developed gross margin model and forecasted 5-year performance for investor sourcing and for management to make business decision on business development and hiring

Greater Minneapolis-St. Paul Area

• Processed data from MongoDB and visualized usage data of 5K+ records in Python to adjust product features and increased usage by 4.5%
• Built customer acquisition and P&L models and forecasted 24-month performance

Greater Minneapolis-St. Paul Area

• Conducted research in Healthcare Industry, identified key drivers, and built discount cash flow models of two companies in Excel to provide a quantitative foundation for investment recommendations
• Adjusted portfolio strategy periodically and updated models automatically using VBA to reduce potential loss

Greater Minneapolis-St. Paul Area

Shenyang, Liaoning, China

• Acquired business license for selling a bio-product, and made $2K net profit in three months

Master Of Science - Ms, Business Analytics

Master Of Science - Ms, Finance, General

Bachelor'S Degree, Finance, General