Yifan Sun Email & Phone Number

Seattle, Wa, Us

Global Mile Import Visibility - Short Range Forecasting

Seattle, Wa, Us

Seattle, Wa, Us

Boston, Ma, Us

Advanced Analytics and Insights (formerly Web Analytics) - Search• Designed, implemented and analyzed several A/B tests, and proposed the best strategy to roll out• Analyzed customer data related to sorting algorithm of search results and product rankings, and proposed opportunity areas to improve the algorithm• Simulated offline validation methods with Python and provide business impact for decision making to reduce financial risk of running tests.• Created potential customer segments and shed light on potential investment strategies to improve the customer experience• Partnered with cross-functional teams to generate automated reports to quantify business problems and keep track of key performance metrics• Comprehend, extract, and massage information from multi-terabyte data sources including sales,clickstream, logistics, product, and customer databases to deliver business insights and recommendations

• Constructed ETL process to synthesized 50M+ data via APIs for retailing performance monitor• Developed and optimized time series regression on demand forecasting by building Autoregressive (AR), Moving Average (MA), and ARIMA models, improving weekly accuracy from 61% to 83%• Automated Power BI dashboard by deploying Python scripts on AWS to track key metrics and generate the ongoing business report, and reduced the workflow cycle by 90% cross-functionally• Integrated predictive model with in-transit replenish inventory using SQL to deliver demand and supply balance recommendations, and slashed storage cost by 47%• Performed ad-hoc analysis to fill in financial gaps and support advertising campaign budgets allocation

New York, New York, Us

Spirituality Mind Body Institute Research Lab: Research Assistance & Data Analysis• Designed a digital version of 6 psychological evaluation surveys on Qualtrics• Solved survey programming by analyzing the simulated output in SPSS to ensure the data consistency • Researched on spiritual compassion for the longitudinal study, quantifying survey variables and scoring

Los Angeles, California, Us

• Coordinated with Marketing and PR teams on people research by updating database for contacts• Managed data organization to track fee engagement and verify details of the clients’ report• Conducted hiring process by posting on various platforms to help manager recruit talent

Beijing, Cn

• Operated in issuing, advising L/C by examinations of documents• Executed letter of guarantee, exporting and importing documents to facilitate international trade settlement

Dublin 2, Ie

(Track: Client Delivery & Operations)• Performed data transaction with the global management data team for clients’ required tests in SAP modules• Managed monthly import history data of SAP and reported to the global team on the project progress• Coordinated the communications between clients, project team and global data team• Led a team of four interns and scheduled their work assignments with mentor input

Master Of Science - Ms, Applied Statistics

Teaching English To Speakers Of Other Languages (Tesol)

Bachelor’S Degree, Applied Psychology