Lily Y. Email and Phone Number

contract digitalization retail business bptrade exlenses

• Generated and manually adjusted monthly& quarterly& annual landings, gross sales, volume, BS and P&L reports for sales/ executives to review business performance• Assisted in developing 2016 9+3 Market Forecast and 2017 Market Budget breakdowns for channels, product lines, and entities and tracked the actual variances so that further adjustments would be made to better predict performance• Familiar with Smartview, BO HFM and BW system

• Improved&Processed&tracked distributor commission plan and provided sales person with YOY sales analysis and performance reports• Designed two ultimate reports to trouble shoot high freight problem, Market Lead Time Analysis and Freight Fee Analysis, and developed an Air Freight Calculator for PLMs to review margin&air freight&revenue % before choosing air transportation• Developed annual budget& forecasting plan broke down by multiple dimensions, worked with IT loading data into dashboard, and tracked actual&budget variances in 2015• Price, product hierarchy and sales order maintenance in SAP

• Analyzed food additives costs in China, India and Indonesia to find the Heinz Asian supplier consolidation opportunity and earned about 0.75% annual savings• Researched two competitive suppliers' financial status by using financial ratios and comparing their cost structure reports and negotiated with them about the 2014 tomato paste price, lowering the tomato price per ton by nearly 8% • Updated international tomato and garlic monthly market reports and made Heinz monthly Assumptions of Tomato Paste Price based on reports founding and maintained accuracy of the price assumption at 95%

· Communicated directly with clients to improve the perception of VF’s new products for2012 winter, invited them to the VANS brand fair and fashion show and assisted in schedulingthese events.· Quantified the number of clothing orders, planned financial budgets for the VANS brandfair, managed inflows and outflows during the fair, verified cost allocations and mademonthly cash flow statement

• Conducted location investigation on office buildings and facilities in Jing’an central business districts in Shanghai and quantified the data of office buildings and facilities in Excel• Constructed capital budgeting model by Excel to select the optimal project combinations with different periods and cash flows that would generate highest net present value• Assisted in evaluating location value, depreciation and replacement cost to estimate fair market value of properties by reconciling results of 3 different approaches: the sales comparison, income and cost approach • Analyzed investment-benefit process to find ideal real estate location for clients as well as negotiated lease agreements, saving 5.41% of client’s total budget

• Assisted in granting credit for small and medium sized companies by evaluating their financial statements • Negotiated with clients on investment portfolios and strategies to securitize receivables of 3.29% on average• Conducted researches on competitors’ custom service and clients interviews to improve banking service

• Monitored gold and agricultural future price, simulated investment in future market, and constructed a portfolio demonstrating virtual revenue increase of 45%• Assisted in constructing Morkowitz model by Excel to analyze stock performances and constructed stock portfolios under different constrains, gaining 10.9% overall portfolio return• Participated in two-week training program composed of 20 summer interns and selected one financial derivative, the call option, to successfully reduce market risk by 9.09% in a virtual stock market