Penghua Wu

Penghua Wu

Commercial Analytics at WESCO · Boston University

New York, New York, MA

In My Own Words

I love solving problems with data—finding patterns, automating tedious tasks, and turning raw numbers into insights that actually drive business decisions.

I started my journey in marketing analytics, digging into consumer behavior and campaign performance. Over time, I realized I wanted to do more than just analyze results—I wanted to build the tools that helped businesses predict what’s coming next. That’s what led me to commercial analytics, where I now focus on predictive modeling, sales optimization, and automation.

At Wesco International, I’ve built models that help sales teams decide which products to promote, automated SQL workflows that cut 80% of manual reporting, and created interactive Power BI dashboards that make insights accessible to everyone.

I’m always looking for new ways to make data work smarter, whether it’s through machine learning, automation, or better storytelling. If you love data, automation, or just geeking out over SQL queries, let’s connect! 🚀

Work Experience

Teaching Assistant

Boston University

2021 – 2021

• Evaluated 45 students' homework in Foundation of Analytics with R • Held weekly office hours and helped students via email

Marketing Specialist

JD.com

2018 – 2019

Focused on continuous improvement throughout campaign budget management, analysis, and reporting. • Created and managed campaign budgets (up to $15 millions) and event costs document via Excel (Sumif, Vlookup, Pivot table), ensuring efficient and reliable financial oversight despite emerging challenges. • Selected as the principal liaison with business analysis team to update market research results due to relevant expertise. Provided training to incoming marketing professionals on research topics. • Negotiated campaign detail based on customer segmentation and characteristics with clients. Outpaced deadlines and targets with 17% more new users annually. • Accomplished 3 important campaign reports involving event consumption data, competitor's comparison, buyer persona and results on A/B test.

Administrative Assistant

Sense Time Group Limited

2017 – 2018

Provided support to administration director. • Updated and completed monthly expense reports of 7 departments on traveling cost, office supply and business gifts via Excel (Vlookup, Pivot table). • Initiated and realized self-buy business travel system cooperated with Ctrip. Reduced labor expense on ticket-buyer position ($15,000 per year) and lessen nearly 300 approving emails in leaders' inbox monthly. • Trained 5 interns to execute marketing day-to-day tasks including meeting scheduling, brochures and client gifts distribution and quantity checking. Implemented an effective intern training mechanism. PROJECT Campaign Effect Analysis with Python & Tableau • Applied python (Random Forest, Logistic Regression) to analyze Starbucks campaign with 300,000 records and build the predictive model to recommend higher conversion rate discount category based on customer's demography. Used MySQL and Tableau to present campaign analysis of different customer groups with different discount categories. Factors Influencing Product Usage Analysis via Survey Design & Data Analysis • Designed the questionnaire survey for "Keep, " employed SPSS to conduct analysis of data more than 100 surveys (via Qualtrics) and optimized the original survey measurement. Applied Python(sklearn) to rank the importance of each influencing factor and produced valuable insights in formal report.

Education

M.S. in Marketing Communication Research

Boston University

2019 – 2021

M.S. in Marketing Communication Research

Bachelor of Art in History

Sen University

2012 – 2016

Bachelor of Art in History