Jensen Xu

add8io@r.postjobfree.com https://jensenxu.xyz www.linkedin.com/in/Jensenxu/

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics; GPA 3.74 May 2020 Coursework: Big Data, Predictive Analytics, Machine Learning, Web Analytics, Database Design Kean University Union, NJ

Bachelor of Science in Finance; GPA 3.86 June 2019 Coursework: Corporate Finance, Bloomberg Terminal, Quantitative Financial Analysis, Financial Modeling for Investment Awards: Top Outstanding Graduate, Leadership Scholarship (2015 - 2017), Deans List (2015 - 2019) TECHNICAL SKILLS

R • SQL • Tableau • Alteryx • Anaplan • Viso • Power BI • Google Analytics • Microsoft BI (SSRS/SSIS) • Python • SAP PROFESSIONAL EXPERIENCE

PrimeSource Building Products, Inc. Irving, TX

Business Analyst (FP&A) Jan 2020 – May 2020

• Modeling variance analysis for CFO to improve 4% margin and explain impact of periodic revenue and expense variance

• Presented Anaplan and R models for managers on predicting $360M Q2 sale and budget with operations costs and trends

• Visualized MTD sales-cost performance, inventory, budget and asset management by channel, product, customer and time

• Maintained and moved 2 asset/cost evaluation models in Excel to the cloud and visualized as Tableau financial models

• Performed ETL on Alteryx and T-SQL with teams from SAP HANA & BOBJ to create 3 auto-updating datasets

• Built Tableau Executive Dashboard to monitor daily operation KPIs and risk from millions of orders in 34 U.S. centers Pickup Truck Delivery – SMU Project Addison, TX

Data Visualization Analyst Aug 2019 – Oct 2019

• Prepared Tableau reports to pinpoint system development strategy on potential launch of offices in California and Canada

• Designed BI solutions with SSRS/SSIS and SQL for client to illustrate geospatial, customer, sales, and operation insights

• Applied external traffic, demographics and partners data to predict labor, order demand and supply balance scorecard Only Photo (Top 1 Travel Shoot Company in China) Shanghai, China Business Analyst – eCommerce Dec 2017 – Jan 2019

• Led a team of 7 to drive business insights in Tableau projects on investment evaluation, KPI and daily sales dashboards

• Predicted sales volume and labor costs in three months using Time Series models (ARMA and ARIMA) in SPSS and SAS

• Consolidated complex data in routine workload from ERP to SFMC Cloud with SQL and Excel (VBA, Pivot, Lookup)

• Utilized A/B testing to implement improvement on click-through, bounce and conversion rate of online sales

• Developed web crawler scripts using R and Python to acquire product reviews, features and Ads rank from search engine on social media, online marketplaces, and web-traffic statistics; analyzed pros and cons of products and competitors

• Cleaned pre-process (tokenize, tag, vectorize) text data from reviews and visualized comments to increase reproducibility Zhejiang Saint Angelo Garment Co., Ltd Wenzhou, China BI Analyst Intern Dec 2015 – Feb 2016

• Collaborated with team to classify customers into 4 groups with RFM model to increase churn rate of target customers

• Developed weekly reports on customers classification with K-means clustering and sales trend using Power BI and Excel SELECTED ACADEMIC AND FIELD PROJECTS

Applied Econometrics - IMDB Movies to Investors Mar 2020 – Apr 2020

• Predicted movies profit with Bayes’ Theorem on 45k movies data -17 indexes (cast, crew, competitors) in R models

• Provided top 10 movie portfolios most likely to succeed and visualized in Power BI (hero science fiction, June published) Big Data - Dallas Crime Report Jan 2020 – Mar 2020

• Developed website in R shiny for police and residents to allocate police power and check living safe by criminal records

• Designed ERD; added web functions (login, records insert & update, query visualization, density map and dispatch speed) Predictive Modeling - STEAM Game Report Oct 2019 – Dec 2019

• Performed sentiment analysis (NLP) on 71K reviews for game designer to summarize game characters in Python and R

• Provided insights of topic modeling among comments and popular trends using time series and categorizing game users LEADERSHIP AND COMMUNITY INVOLVEMENT

Campus Youth Volunteer Association – President Sep 2015 – May 2017

• Planned, designed websites, executed 25+ voluntary activities in campus, Hong Kong, Taiwan, and 8 provinces in China

• Mentored freshmen and taught in local primary school for two years, as well as in orphanage in Nepal for two months

Contact this candidate