Learn Data Skills
Beta
Yixin Yao

Yixin Yao

Data Analyst

Thermo fisher

Technologies

My Portfolio Highlights

My New Track

SQL Fundamentals

My New Course

Introduction to Python

My New Track

SQL Fundamentals

Data enthusiast, embracing the beauty of numbers and algorithms.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to Python

course

Intermediate Python

course

Introduction to Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Intermediate Python
Introduction to Power BI
Data Manipulation in SQL

My Work Experience

Where I've interned and worked during my career.

Thermo Fisher Scientific | Feb 2024 - Present

Pricing Analyst III

• Conduct pricing analysis and support Pricing Operations group in meeting complex customer pricing requirements. • Import, consolidate, analyze, and summarize data from large datasets using SQL Server. • Validate data integrity, join data from multiple tables, and provide insights to optimize customer pricing. • Provide pricing guidance and tool support to the Commercial team. • Perform ad hoc data analysis for business units, customers, products, and vendors. • Develop tools in SQL and Excel to set strategic prices, implement pricing improvement programs, and track financial impact. • Prepare executive-level reports and support the development of tools, policies, and procedures to enhance performance. • Collaborate with cross-functional teams to identify opportunities for profitability improvements.
Show More

GLS Canada | Feb 2021 - Feb 2024

Pricing Analyst

• Created customized rate proposals for customers by analyzing volume, regions, weights, and other factors. Developed comprehensive proposals using Excel and TCG that met the client's specific transportation requirements. • Participated in Yield & GRI increases and the annual rate increase process, conducting cost-benefit analysis, checking client's Key Performance Indicators (KPIs), and using Business Intelligence (BI) tools to gather insights. • Collaborated with different departments to solve rate-related problems, supported by database management. data analytics and modeling.

Promark Electronics Inc. | Nov 2019 - May 2020

Proposal Specialist

• Collected and analyzed vast amounts of price data by using Excel (vlookup, sumif and pivot table etc.). Completed bid analysis, resulting in a 17% decrease in quote. • Assisted in the establishment and organization of the database. Created Preferred and secondary source supplier, including pricing, lead time and min/ mult information. • Collaborated with Sales, Engineering, Purchasing & Production to coordinate the execution of customer quotes by respecting deadlines. Supported outside sales reps and agents in winning bid opportunities. • Developed relationships with vendors and distributors. • Identified and helped implement innovative ways for improving efficiency of quotation process. • Read Drawings and BOM’s, updated proposals as per feedback and design changes.

Heritage Gallery | Apr 2019 - Nov 2019

Sales Professional and Operation coordinator

N/A

My Education

Take a look at my formal education

Diploma of Education, Data scienceConcordia University | 2023
Master of Engineering - MEng, Electrical and Computer EngineeringConcordia University | 2017
Bachelor of Engineering - BE, communication and information engineeringUniversity of Electronic Science and Technology | 2014

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free