Global Sourcing & Procurement Co-op

Vivian (Jiawen) Li

+1-781-***-**** • **.*******@************.*** • linkedin.com/in/vivianlineu/ • Boston, MA EDUCATION

Northeastern University, D’Amore-McKim School of Business Boston, MA Candidate for Bachelor of Science Degree in Business Administration September 2018 - May 2023 Concentration: Management Information Systems, Supply Chain Management GPA: 3.7 Relevant Coursework: Business Systems Integration(relational databases), Sourcing and Procurement, Data Management in the Enterprise, Global Supply Chain Strategy, Information Visualization for Business, Financial Accounting and Reporting Activities: ambassador of NU Entrepreneurs Club, case competition chair of Supply Chain Club, Data Club, NU Consulting Club Meiji University (Tokyo)-Fall Exchange Shanghai, China Relevant Coursework: Internet Business, Japanese Manufacturing Management September 2021- January 2022 Cefam University- Summer Exchange Lyon, France

Relevant Coursework: Management Information Systems, Managerial Accounting May 2019 - July 2019 Chapel Hill-Chauncy Hall School Waltham, MA

Achievements and Activities: Valedictorian, Relay for Life Co- President, Volleyball (Coach’s Award), Harvard Prize GPA 4.16/4.3 EXPERIENCE

Illuminera Shanghai, China

Marketing Consulting Intern June 2022 - August 2022

• Conducted 3 market research and quantitative analysis for healthcare and retail clients to determine estimation of regional population sizing, pricing, local legal requirements related to shipping, suppliers, etc…

• Learned Alibaba’s analytical tools on-site, extracted, and consolidated relevant consumer behavior data for brand strategy presentation and proposed strategies

• Prepared framework questions before a total of six interviews with industry leaders to provide ideas and perspective, assisted managers with asking live questions, compiled key solutions for clients through PowerPoint presentation Philips Shanghai, China

Procurement Coop & Summer Intern November 2021 - June 2022

• Saved 5% ($70,000) more through negotiating and evaluating prices for special-pricing dealer projects; processed 1-3 cases simultaneously each day; initiated streaming process for procurement managers

• Improved data accuracy and accessibility for order management team through updating product information on estimated 4000 Philips healthcare shared catalog file

• Created or consolidated suppliers on Oscar system; updated contract terms with legal team and procurement manager

• Assisted procurement managers and vendors with RFI, RFQ, RFP, PO, BOL by required deadlines Kohler Shanghai, China

Master Data Intern September 2021 - November 2021

• Produced weekly & monthly sales reports of key terms within Kohler Shanghai stores from ERP

• Created 3 dashboards using Tableau visualization tools to highlight performances of stores and seasonal products

• Performed SQL commands searching products or store information The TJX Companies, Inc. Framingham, MA

Global Sourcing & Procurement Coop January 2021 - June 2021

• Supported IT, finance, logistics, operations, and product development through analysis using Excel, PowerPoint, and Sievo:

• Led weekly IT hardware meetings between the legal and GS&P team to make sure company initiatives and goals are met or exceeded: supported leaders with Master Services, Statements of Work (SOWs), Facility Management, etc…

• Cleaned and sorted all 30+ excel data files using VLOOKUP, then uploaded information of international suppliers and factory details into Microsoft Access

• Managed domestic and global hardware and software vendor relationships and acted as a liaison with internal teams

• Coordinated purchase requests following vendor management and procurement processes

• Organized and managed real-time tracking for ocean freights; analyzed trends using Excel Northeastern Supply Chain Club Boston, MA

Case Competition Chair (E-board) July 2020 - January 2021

• Initiated outreach to companies (Raytheon, Bose) and raised approximately $1000 for an annual event

• Reviewed and made recommendations with team regarding supply chain cases in the annual competition

• Managed event logistics (for 60 people) and executed timely decisions in fast-paced and unpredictable environment

• Participated in weekly meetings with a network of business undergraduates, fraternities, and supply chain professors Northeastern Library Boston, MA

Circulation Desk Assistant December 2019 - June 2021

• Effectively communicated policies and answer questions of all patrons in person, online, and over the phone

• Managed circulation of library materials and course content in an effective and organized manner SKILLS/INTERESTS

Skills: Microsoft Excel (Proficient), Microsoft Word (Proficient), Microsoft PowerPoint (Proficient), Microsoft Access, Tableau, SQL(relational databases), ERP, SAP, Python (Introductory), R, R Studio, Jira, Confluence, Sievo Languages: Mandarin (Native), English (Fluent), Japanese (Basic), French (Basic) Interests: Travel, Piano, Volleyball

Contact this candidate