Wanru Huang
Pittsburgh,PA
Overview
6
6
years of professional experience
1
1
Certification
Work History
Lean Six Sigma Consultant | Part-time
Mosebach
09.2024 - Current
- Collected business needs from the client across 15 manufacturing stages, developing a seasonal data collection and analysis plan.
- Conducted weekly site visits to gather and validate sample data, applying Six Sigma statistical analysis to identify 4 waste areas in sales and inventory points.
- Created detailed data-driven reports using Microsoft Visio to design Fishbone Diagrams and Value Stream Maps, effectively resolving process bottlenecks and providing actionable solutions.
- Utilized Python and Minitab for statistical analysis and visual reports, reducing forecast bias and lowering MAE by 3 units in October, improving forecast accuracy.
Business Analytics | Intern
EZSVS USA
06.2024 - 09.2024
- Optimized report visualizations for tracking sales and inventory KPIs, transitioning from PowerPoint to Power BI, reducing manual reporting errors by 25 reports per month, thereby streamlining decision-making processes.
- Migrated Excel-based data to SQL Server, automating the data cleaning and integration processes, saving the team 10.5 hours per week in manual work.
- Developed sales demand forecasting models using R, applying decision tree algorithms to improve transportation planning accuracy by 2.5 days per month, optimizing the allocation of warehouse resources.
Digital Marketing Analyst | Specialist
By-health
04.2021 - 01.2022
- Boosted predictive accuracy by applying Logistic Regression and Random Forest in SPSS, developing credit risk models with precise outcomes, leading to actionable insights for decision-making.
- Increased engagement through A/B testing, optimizing email marketing strategies, and improving CTR by 3.5% across email ad campaigns.
- Segmented demographic and geographic data using Tableau, resulting in the identification of 521 new potential leads for sales teams.
- Developed sales forecasting models in Python using random forest and regression analysis, reducing forecast errors by 2 units weekly and optimizing resource allocation.
Marketing Research Analytics | Intern
DiDi Global
12.2020 - 03.2021
- Analyzed data on competitors' products using platforms such as Alibaba and JD.com, applying machine learning models like clustering and classification through Spark for faster processing of large datasets.
- Conducted market demand analysis for 32 community leaders, building a transportation demand model using regression and decision trees, leveraging SQL to handle big data efficiently.
- Provided strategic recommendations to improve B2B promotional channels and optimize routes based on predictive models and qualitative analysis.
Commercial Director | Intern
Hunan Satellite TV
01.2019 - 04.2020
- Managed financial oversight and resource allocation for international music show promotions, boosting user engagement by 25% and ensuring efficient budget management.
- Led brand collaborations and video production, achieving over 200 million favorites on TikTok and Instagram, while maintaining an ROI of 0.8.
- Created and optimized digital marketing campaigns, generating 500 million weekly clicks and delivering financial reports and insights for senior management decisions.
Education
Master of Science - Business Analytics and Marketing Science
University of Pittsburgh
Pittsburgh, Pennsylvania05.2025
Bachelor of Arts - Radio and Television Production
Chongqing University of Posts and Telecommunications
07.2021
Skills
Python RStudio SPSS Power BI Tableau Excel PowerPoint Microsoft Visio Lean Six Sigma
Certification
- My SQL for Data Analytics and Business Intelligence | Udemy
- Decision Making for Leaders Hackathon using AHP and Python | Creative Decisions Foundation
- Google Ads Search Advertising Certification | Google
Google Analytics Certification | Google - The Facebook and Instagram Advertising Workshop | University of Pittsburgh
Languages
English
Professional Working
Chinese (Mandarin)
Native or Bilingual
Timeline
Lean Six Sigma Consultant | Part-time
Mosebach
09.2024 - Current
Business Analytics | Intern
EZSVS USA
06.2024 - 09.2024
Digital Marketing Analyst | Specialist
By-health
04.2021 - 01.2022
Marketing Research Analytics | Intern
DiDi Global
12.2020 - 03.2021
Commercial Director | Intern
Hunan Satellite TV
01.2019 - 04.2020
Bachelor of Arts - Radio and Television Production
Chongqing University of Posts and Telecommunications
Master of Science - Business Analytics and Marketing Science
University of Pittsburgh
Similar Profiles
Gary ChaseGary Chase
Electrical Assembler at Mosebach Manufacturing CoElectrical Assembler at Mosebach Manufacturing Co
Robert HamptonRobert Hampton
Warehouse Worker at Monogram FoodsWarehouse Worker at Monogram Foods
Mary Ann HammillMary Ann Hammill
Staff Accountant at Bruns Gelles & CompanyStaff Accountant at Bruns Gelles & Company
Michelle RagerMichelle Rager
EMT-Basic at Baldwin Emergency Medical ServicesEMT-Basic at Baldwin Emergency Medical Services
April DeandaApril Deanda
Paraprofessional at Delta T. Group/ Pittsburgh MorrowParaprofessional at Delta T. Group/ Pittsburgh Morrow