Pricing Analyst

Accounting & Finance

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.

•   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%.

Revenue & Pricing Analyst

•   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.

Commercial Assistant

•   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.

Marketing Coordinator Intern

•   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.

Logistics Coordinator Intern

Find out detailed information about Yuan He, Pricing Analyst in Irvine, CA

Yuan He: Pricing Analyst in Irvine, CA

Yuan He