Yifan Tao Email & Phone Number

Los Angeles, California, United States

• 根据销售预测与仓储情况决定产品进货数量，以保障产品供应量充足且不超出仓储能力。• 设计制作并优化销售与仓储容量预测模型。模型包含公司总体预测至各仓库各产品销售与仓储预测。目前总体预测误差在10%以内。帮助采购员更细致的规划采购方案并改善库存状况。同时管理层参考模型结果决定产品线的存续。• 维护与更新产品信息，以确保数据正确性。根据各仓库与总仓存储情况定期更新产品状态，减少客户的无效订单，提高客户满意度。• 通过VBA编码实现报告的自动化生成，大幅减少制作报告的劳动力成本。

Gainesville, Florida Area

One-year teaching assistant for Java, C# and advanced Java courses held for graduate students and undergraduate students, around 200 students each semester. Assisting with professors’ teaching and helping students.• Hold office hours for 4 hours each week, and make additional appointments with students if required. Helping more than 20 students with their programming assignments and answering all sorts of questions within my capability. Managed to improve their coding ability and overall understanding of Java and C#.• Grade students’ programming assignment (around 100 pieces) every week and give them feedback afterwards, which takes up to 10 hours when the scale of the project is large. Grade all students’ midterm and final exam paper.• Keep the professor updated of students’ performance on their programming assignment and inform the professor of the part where many students had trouble understanding.

Houston, Texas Area

Two-month rotational intern program within the financial department of a transnational corporation, directly under the management of the CFO. Familiarized with most process inside the financial department.• Sorted, collated and bound thousands of pages of financial statements, voucher and tax report each month.• Used the pivot table in MS Excel to extract all transactions occurred within a month, and employed the formula given by parent company to decide the best transfer pricing strategic to make most profit.• Made dozens of travelling reimbursement and all other reimbursement to employees every day. And double check that all transactions were using the correct bank account. Otherwise, do a reverse process.• Adjusted and updated balance sheet, income statement, stockholder’s equity statement and financial statement to help generate the semi-annual financial report.• Used internal ERP system to keep record of hundreds of transactions occurred every day, and comparing the internal records with the bank records to ensure the number matches at the end of every month.

Shanghai

Assisted to update and maintain the Enterprise Resource PlanningGenerated procurement costs forms and other forms in daily work

Shanghai

Checked printed bills against information on the computerInput relevant account information into the computer and checked the veracity of the information

Information System Of Operation And Management

Bachelor Of Laws (Llb), International Economic Law

Bachelor Of Management, Electronic Business

Activities and Societies: Table tennis Club-Assisted to organize weekly activities of the club