Yuan He: Pricing Analyst in Irvine, CA

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

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

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

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