Japanese Intern

***** ****** ***. **** ** 732-***-****

Irvine, CA 92606 adl1tf@r.postjobfree.com

EDUCATION

Rutgers Business School, New Brunswick, NJ May 2018 B.S: Supply Chain Management Cumulative GPA: 3.5

SKILLS

Technical Skills: Excel Expert, Tableau (Certified Tableau Desktop Specialist), SQL, Access Language Skills: Mandarin, Japanese

WORK EXPERIENCE

Tireco Inc, Gardena, CA

Pricing Analyst 12/2020 - Present

• 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, New York, NY

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, New York, NY

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, Frederick, MD

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, Shanghai, China

Logistics Coordinator Intern Summer 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.

Contact this candidate