Hsuan-Ting (Tommy) Wu Email & Phone Number

Los Angeles, California, United States

Taipei City, Taiwan

• Led the creation, testing, and support of 36 Python, VBA, and Power Query scripts with Excel interfaces automating 20 supply planners’ reporting processes, saving over 31 hours weekly and 11 hours monthly of working time
• Ensured continuous shipping of 2 product lines by collaborating with Quanta regional factories, supply planning, and demand forecast teams through adjusting inventory levels based on demand changes and market trends
• Maintained and improved legacy code of 8 VBA scripts ensuring continuous operations during ERP system updates

Bloomington, Indiana Area

• Developed Power BI dashboard showing team weekly ticket handling status and 10 employees’ performance, presented to department head and management
• Created 50+ web forms with over 6000 submissions by collaborating with 8 different departments’ leadership and developers while improving current business processes
• Created year-end report for tech support team by cleaning, analyzing and visualizing ticket data for 2019 using Python, leading to improved data collection methods and resource management decisions
• Provided technical support for over 400 non-technical staff by troubleshooting issues covering 60 applications including Salesforce, SharePoint, and hospitality software
• Provided testing, implementation, training, and support of Salesforce CRM for over 400 staff members in 4 departments
• Documented over 40 pages of user guides on application software from both administrative and end-user perspectives

Bloomington, Indiana Area

• Griffin Realty's Off Campus Housing Agency provides customized search results of off-campus residence as well as experienced real estate agents to assist clients while living there. This is a consulting project focused.
• Troubleshot website applications to enhance end-user experience, resulting in more effective marketing strategies
• Created 2 HTML email prototypes and website wireframe, aiming to increase website traffic by 30%
• Produced target audience analysis report and introduced new pricing strategies that helped increase brand awareness
• Facilitated meetings between client and 5 Indiana University departments, leading to additional marketing opportunities

Bloomington, Indiana Area

• Analyzed sales data for better forecasting accuracy and provided sales advice to management, which led to lower waste
• Recorded inventory data and produced monthly reports, which resulted in improved data management process
• Designed inventory storage maps for three Indiana University campus cafés, increasing inventory auditing efficiency

Bloomington, Indiana Area

• Opportunity House is a volunteer-run, non-profit resale store that sells merchandise donated by community members. (https://ophousethrift.org)
• Identified sales trends using advanced Excel, resulting in new promotional strategies that increased in-store traffic
• Improved supply chain processes through the use of DMAIC framework and Value Stream Maps

Bloomington, Indiana Area

• Consulting project working on improving the package delivery process through Lean Six Sigma for Eigenmann Resident Hall at Indiana University Bloomington.
• Designed process flow charts and determined the bottleneck through the use of Lean tools, reducing waste by 30%
• Achieved over $4000 annual saving costs through advanced data analysis and sophisticated operation simulations
• Worked closely with client and stakeholders to enhance cross functional communication and employee training procedures
• Performed informational interviews with Eigenmann Hall employees to better define and understand the operational process

Taipei City, Taiwan

• Worked closely with stakeholders and development team to create a global website wireframe for North America expansion
• Constructed A/B testing through publishing Facebook Ads, increasing user awareness and advertisement effectiveness
• Conducted market research on North American key opinion leaders for potential sponsorship opportunities
• Successfully managed international shipment process through FedEx for over 300 customers in a short amount of time

Bloomington, Indiana Area

• Created database utilizing Microsoft Access to manage client information and performance data
• Designed and refined organization website through Wix

Bloomington, Indiana Area

• Facilitated the transition from traditional recording methods to electronic inventory management system
• Developed time-tracking database utilizing Microsoft Access for staff and interns to record work hours
• Coordinate with Bridal Online Store Team using library tracking system and Access database to manage movement of bridal/formal stock

Bloomington, Indiana Area

• Created and refined a strategical standardized process for staff and volunteers to easily sort and handle inventory
• Optimized the flow of merchandise by streamlining organizational supply chain processes resulting in smoother operations and increased work efficiency
• Trained new interns to understand the strategy and coordinate supply chain needs to ensure the continuous movement of inventory
• Supervised, managed, and appointed tasks for volunteer groups of 15-20 people on a weekly basis

Indiana University Bloomington

• Coordinate with the Vice President of Finance with managing the budget account of the organization and seeking corporate sponsorship
• Collaborate with different departments in allocating funds for multiple events

Bloomington, Indiana Area

• Guided hundreds of visitors during football games by providing instructions, guaranteeing their safety and solving problems
• Created positive experiences for thousands of fans through addressing and greeting them at sports events

Bloomington, Indiana Area

• Provided in-class tutoring weekly to students with questions, while enhancing experience on Microsoft Access and Excel
• Collaborated with 5 other tutors to assist the professor and TA in explaining concepts to a class of 30 students
• Selected by faculty due high performance and proficient skills in class

Auburn, Washington

• Design and lead activities with a small team for more than 30 international students each week to help them establish a foundation for success in college
• Form mentor relationships with a group of 4-7 students and help them solve personal problems regarding academic and social issues
• Encouraging students to be more active in school, resulting with a lot of them getting involved in clubs, volunteers or student government

Auburn, Washington

• Collaborated with 10 other mentors and staff to design a training program for new peer mentors
• Implemented the training program to over 100 students in 2 days, helping them establish a strong foundation to the job

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Information Systems, Operations Management, 3.619

Activities and Societies: Kappa Eta Phi, Net Impact, Ascend, Tau Sigma Honor Society

Associate'S Degree, Business/Commerce, General, 3.64

Activities and Societies: Taiwanese Cultural Association, Resident Housing Association, Peer Volunteer, Peer Mentor