Sharon Xinran L. Email and Phone Number

• Cash flow forecasting: Established and optimized a 6-month rolling forecasting model, keeping the accuracy within 5%, and assisting the financing and liquidity team to rationally arrange long-term and short-term financing plans and the short-term capital allocation ensure the reasonable cash balance at the end of the month.• Treasury analysis: Combined historical treasury data to build financial models and create dashboards and reporting tools to display capital level, interest analysis, financing details, and other internal financial results. The model significantly improves the efficiency of the monthly treasury report.• FX management and analysis: as a member of the FX team of Ali group, participated in multiple FX projects of Ali economy, mainly responsible for the bi-weekly FX market report of Ali Group; responsible for Intime FX inquiry and FX cost analysis.• Liquidity management: On Ali’s treasury management system, completed inter-company fund transactions through the Intime’s cash pooling. • Account management: Responsible for the open/close and maintain all overseas bank accounts.

• Budget Plan:Compiled data and generated weekly budget reports needed to conduct weekly purchasing. Developed data analysis and Solver Tools to build predictive models to purchasing department weekly and analyzed variances in actual sales and forecasts for all types of products to ensure accuracy and appropriate purchasing budget.• Cost Controls: Provided and analyzed the cost of marketing and labor, resulting in an annual saving 23%. Identified and recovered approximately 45% of the annual cost through cost analysis and audit.• Financial analysis: Prepared and recorded account information such as revenue and expense entries, and regularly analyze historical costs, expense reports, budget reports, and audit statement quarterly with management • Tax Return: prepared financial reports and statements to facilitate the filing of the company's tax returns and foreign clients' tax returns• Daily Duty: Arranged completion of daily tasks including posting, processing, and verification of receipts, credit claims, refunds, interest charges, or other similar records. Provided support to the internal and external auditors as needed.

• Participated in cash budgeting for the long-term educational program. The budget plan includes direct and indirect cost such as labor, service fee etc• Tracked spending against budget and analyzed the profit margin of camp products. The ratios are higher than the industry average• Slashed summer camp product costs 15% by negotiating pricing and fees while ensuring the continuation and enhancements of services.• Built more than 5 key vendor relationships by performing market research, analyzing current camp market conditions and negotiating with vendors• Supported team with summer product design and development and camp products logistic arrangement• Supported IT Team in the design, development, and testing of the new website; Maintain & Update website photos and strain descriptions; Keep Blog up-to-date• Managed Social Media content & accounts; Developed and managed media database

Data Analyst Intern June – September 2014 • Developed a detailed business plan implementing customer segmentations, cost and profit projection, and product development analyses resulted in Applied data Project Management Training Certificate Program in Master Data Management, Data Governance, and Data Quality• Real Estate Data Project by using SQL Basic, filter in Excel, and KPI