Yuan He: Pricing Analyst in Irvine, CA
Yuan He
Pricing Analyst
Irvine | United States
Skills
No information
Interests
No information
Industries
No information
Summary
No information
Activity
Projects
No information
Work experience
Tireco Inc
Pricing Analyst | 12/2020 - Current
Extracting, manipulating and cleaning data from different data vendors and internal database by writing
complex SQL queries; being the only data specialist within the team to communicate with data engineer team
in order to better understand the database. Improve team efficiency by 15%.
• Building dashboards of pricing trends and cost-revenue analysis in Tableau for internal teams and providing high
level insights to managers.
• Updating the pricing tool in Excel using complex formulas on a monthly basis for each subsidiary, and collaborating with Sales team to adjust the pricing strategy accordingly. Revenue is up by 6% in Q1 2021.
• Pulling data and deriving insights by using SQL & Excel and interpreting findings to stakeholders which potentially
help to improve the business process.
Ion Media Networks
Revenue & Pricing Analyst | 11/2019 - 12/2020
• Determined pricing for each buy (general ads) by digging into the historical record, market trend (using iSpot - a web analytics service for media industry), inventory capacity and liability.
• Built Excel reports using VLOOKUP, INDEX MATCH and PIVOT TABLE to keep track on revenue and pricing for
general ads on a daily basis.
• Built finance models to forecast quarterly revenue and set sales target for account executives and report uses.
• Pulled both internal and external data and deriving insights by using SQL queries and interpreted findings to
management level which helps to find potential opportunity of business growth - successfully reduced the revenue loss during the pandemic period by 8%.
Ion Media Networks
Commercial Assistant | 02/2019 - 11/2019
• Communicated with client and maintain over 70 deals using Dealmaker (allocations, moves, delivery, etc).
• Collaborated with different teams and helped to solve inventory discrepancies.
• Kept tracking on delivery and try to secure ADUs in order to lower the entire liabilities.
Music & Arts
Marketing Coordinator Intern | 08/2018 - 12/2018
• Collaborated with different teams to check and approve marketing work order on a daily basis.
• Created weekly and monthly reports using Pivot Table based on sales and promotion data.
• Made preparation for new store opening including new store website design, advertisement preparation and grand opening event design.
• Measured the success of New Store Traction Program by designing A/B testing for direct mail campaigns,
social media efforts and analyzing results.
L'Oréal China
Logistics Coordinator Intern | 06/2017 - 08/2017
• Managed inventory levels, delivery schedules and availability of selected items.
• Visualized selling trend using Tableau, helped the company save 0.8% of inventory carrying cost.
• Formulated long-term strategy and communication plan with two more new 3PLs.
Education history
Rutgers Business School
B.S
Connections
Companies (0)
No information