Guohao Su

Capstone Project Product Manager & Data Scientist at D'Addario & Company, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Pittsburgh, Pennsylvania, United States, US
Languages
  • English Full professional proficiency
  • Chinese (Cantonese) Native or bilingual proficiency
  • Chinese (Mardarin) Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Raymond Peng

I have known Guohao for 6 years, and he is a great problem solver and an active thinker. In school, Guohao voluntarily worked as a class ambassador helping instructors manage student activities. His excellent skills of management and leadership were highly recognized by his peers. At the same time, Guohao demonstrated his creative thinking skills being my stage partner of magic performance. With his help, we could always come up with some innovative ideas on magic tricks and impress the audience with humorous dialogue. We still stay in touch today and share our opinions towards different aspects of life. Overall, Guohao is a reliable person with excellent skills of problem solving, creative thinking and leadership. I believe he will add great value to your company.

Shuchang (Claire) Yang

I have worked with Guohao Su in many class projects. Guohao is gifted group leader with a rare combination of patience, creativity, and persistence. Every time we worked together, I was impressed by his dedication and his inspiring ideas. He also has the ability to work under pressure. When we encountered difficulties, he would stay calm and help the group to come up with a solution and tackle the problem. From his class performance and the group working experiences we have, I can tell he is a smart, hard-working person that I could see great potential in his future career.

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Scrum Master Certified (SMC)
    Scrum Inc.
    Mar, 2023
    - Nov, 2024
  • Adult and Pediatric First Aid/CPR/AED
    American Red Cross
    Oct, 2017
    - Nov, 2024

Experience

    • Musicians
    • 200 - 300 Employee
    • Capstone Project Product Manager & Data Scientist
      • Aug 2023 - Present

      • Develop Python-based sales prediction model using data preprocessing, feature engineering, and ML algorithms • Lead end-to-end model development and deployment through cross-functional collaboration • Develop Python-based sales prediction model using data preprocessing, feature engineering, and ML algorithms • Lead end-to-end model development and deployment through cross-functional collaboration

    • United States
    • Higher Education
    • 700 & Above Employee
    • Research Assistant: Cyber Controls Efficacy
      • Jun 2023 - Aug 2023

      • Conducted thorough research on cyber controls efficacy, distilling insights, identifying patterns, and devising an Efficacy Model aligning with NIST Cyber Security Framework (CSF) and CIS Controls for cyber control prioritization • Conducted thorough research on cyber controls efficacy, distilling insights, identifying patterns, and devising an Efficacy Model aligning with NIST Cyber Security Framework (CSF) and CIS Controls for cyber control prioritization

    • United States
    • Wholesale
    • 300 - 400 Employee
    • Business Analyst
      • Jun 2018 - Jul 2022

      • Developed comprehensive executive dashboard using Power BI and SQL, consolidating 50+ tables (10 million+ entries), streamlining report generation by 40% and ensuring data consistency across functions • Led a cross-functional team of three analysts and eight product managers to reclassify over 380,000 products into a customer-focused product hierarchy, facilitating company-wide alignment post-acquisition • Implemented the K-means clustering algorithm in R to optimize the assortment of box sizes in the warehouse, leading to a projected 30% reduction in void fill within shipping boxes • Optimized outbound freight strategically at each stage, from product development to warehouse management and billing, resulting in a 20% cost reduction and a 5% increase in overall profitability • Utilized Power BI to conduct what-if analysis, visualizing freight savings for 2.4 million packages on a map • Created a sales forecasting model using linear regression in Excel, enabling insights and support for managers Show less

    • Business Consulting and Services
    • 1 - 100 Employee
    • Student Consultant
      • Oct 2017 - May 2019

      • Collaborated with a five-member team to lead and execute data analysis tasks on diverse consulting engagements • Chick-fil-A (Fast Food): Utilized Power BI to analyze sales data, uncovering previously hidden insights, and presented data-driven recommendations for optimizing mobile orders based on identified trends • Keep It Simple Syrup (Beverage Mixer): Developed a VBA script in Excel to streamline daily inventory data extraction from 430 web pages, significantly reducing manual workload and saving the company owner 3 hours per day Show less

    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • Capstone Project Student Consultant
      • Sep 2018 - Dec 2018

      • Analyzed 500,000 patient records using Stata to identify ER throughput factors and presented recommendations to VP of Performance Improvement, projecting a 25-minute (17%) reduction in average ER visit length of stay • Analyzed 500,000 patient records using Stata to identify ER throughput factors and presented recommendations to VP of Performance Improvement, projecting a 25-minute (17%) reduction in average ER visit length of stay

    • United States
    • Non-profit Organization Management
    • 1 - 100 Employee
    • Sponsorship and Procurement Coordinator
      • Jan 2016 - Oct 2018

      • Cultivated partnerships with restaurant managers, outlining CSSA's value proposition and mutual benefits of event sponsorship • Executed meticulous budgeting for CSSA's biannual events, sourcing and procuring supplies to optimize attendee satisfaction within budget constraints • Cultivated partnerships with restaurant managers, outlining CSSA's value proposition and mutual benefits of event sponsorship • Executed meticulous budgeting for CSSA's biannual events, sourcing and procuring supplies to optimize attendee satisfaction within budget constraints

    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Nonprofit Management Intern
      • May 2017 - Aug 2017

      • Enhanced fundraising efforts by producing six promotional videos on YouTube, fostering relationships with other non-profit leaders, and volunteering as a magic performer, which resulted in tripling event attendance and raising $3,000 in donations • Managed three social media accounts effectively, increasing online visibility, and designed a compelling pitch deck for the CEO to showcase the organization's value and achievements • Enhanced fundraising efforts by producing six promotional videos on YouTube, fostering relationships with other non-profit leaders, and volunteering as a magic performer, which resulted in tripling event attendance and raising $3,000 in donations • Managed three social media accounts effectively, increasing online visibility, and designed a compelling pitch deck for the CEO to showcase the organization's value and achievements

    • Hong Kong
    • Education Management
    • 1 - 100 Employee
    • Student Teacher
      • Jun 2016 - Aug 2016

      • Created and implemented engaging, experiential lessons enriched with creative activities, catering to a diverse class of 12 ninth-grade students with varying levels of English proficiency • Cultivated an environment conducive to learning entrepreneurship and innovation concepts, fostering critical thinking, problem-solving, and creativity among students • Created and implemented engaging, experiential lessons enriched with creative activities, catering to a diverse class of 12 ninth-grade students with varying levels of English proficiency • Cultivated an environment conducive to learning entrepreneurship and innovation concepts, fostering critical thinking, problem-solving, and creativity among students

    • China
    • Non-profit Organizations
    • 1 - 100 Employee
    • Student Teacher
      • Sep 2012 - May 2014

      • Led weekly meetings, delivering career and culture lessons to 30 junior school freshmen per semester, fostering a sense of belonging for children of immigrant workers, and contributing to enhanced community cohesion • Led weekly meetings, delivering career and culture lessons to 30 junior school freshmen per semester, fostering a sense of belonging for children of immigrant workers, and contributing to enhanced community cohesion

Education

  • Carnegie Mellon University
    Master's degree, Information Systems Management
    2022 - 2023
  • University of Richmond
    Bachelor's degree, Business Administration & Computer Science
    2015 - 2019
  • The University of Edinburgh
    Study Abroad, Informatics
    2018 - 2018
  • Guangzhou Zhixin High School
    High School Diploma
    2012 - 2015

Community

You need to have a working account to view this content. Click here to join now