Yihui (John) Sun

Data Analyst

Goal-driven, motivated, and team-oriented data analyst passionate in

supporting business decisions using data. Strong technical skills procured as an engineer and a business mindset from MBA. Bilingual in English and Chinese (Mandarin) to support applicable functions. While I currently reside in New York State, I am thrilled about relocating. yihuisun@buffalo.edu

585-***-****

Buffalo, USA

linkedin.com/in/john-yihui-sun-627193129

SKILLS

Excel SQL Power BI Smartsheet VBA Python Statistics Teamwork Google Analytics Storyteller Data Visualizations Finance Data Cleaning Dashboards and Reports Communication KPI Ownership WORK EXPERIENCE

Supplier Quality Analyst

Thermo Fisher Scientific

07/2021 - Present,

Leading a project to harmonize supply chains across multiple Thermo Fisher Scientific sites Working with cross-functional teams and suppliers to support departmental goals and establishing great relationship Designed complex Excel sheets and wrote SQL codes to support the quality department Established KPIs to support the quality department goals Built data visualization/dashboard and reporting using PowerBI to deliver data-driven business insights Shortened a project by 6 months by working with supplier and identifying alternative solutions Automating reports by using Excel VBA to extract data from Oracle Server with a Macro button (OLEDB) Boosted supplier change notification process by 30%, reducing the weekly task by 6 hours Designed Smartsheet to track tasks, shorten the completion time from average of 28 Days to 4 Days Actively searching for data inconsistency between ERP and LIMS systems, updated more than 300 entries Teaching Assistant and Private Tutor

University at Buffalo

02/2020 - 05/2021,

Courses: Data Modeling, Statistical Analysis, Finance for Managers, Communication Comprehensive understanding on all subjects and made impacts to student's career development Planned and tailored each session according to course outlines and the attendees level of knowledge Actively monitor student progress, reached out and offer assistance when needed. Increased performance by more than 20% Built out a process to support the grading of final project, shorten the completion time from 40 hours to 8 hours EDUCATION

Master of Business Administration (MBA)

University at Buffalo

08/2019 - 05/2021,

Civil Engineering (MS and BS)

University at Buffalo

08/2014 - 05/2019,

Achievements/Tasks

Achievements/Tasks