Sign in

Data Social Media

Dallas, Texas, United States
November 07, 2018

Contact this candidate


Jiayuan (Alice) Chen

**** ****** ******, ***.**** Dallas TX 75235 214-***-**** EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics GPA: 3.54/4.0 May 2018 Coursework: Multivariate Analysis (R), Business Intelligence (SQL), Data Visualization (Tableau), Web and Social Media Analytics, Programming for Analytics (Python), Decision Model (VBA), Data Mining (Knime), Business Metrics, Revenue Management University of Nottingham Ningbo, China

Bachelor of Science in International Business Management GPA: 3.6/4.0 May 2017 Awards: 2016/2017 Head’s Scholarship

Coursework: Financial Management, Financial Accounting, Management Accounting and Decision, Logistic Supply Chain Management NEOMA Business School Reims, France

Exchange program in Marketing GPA: 3.7/4.0 June 2016 Coursework: Luxury Marketing and Branding, Market Strategy, Marketing Metrics and Analytics TECHNICAL SKILLS

Oracle SQL • MS SQL • SAP • SSIS • ERP • R • Tableau • Power BI • Alteryx • Access • Excel (VBA, Pivot Table) • Python PROFESSIONAL EXPERIENCE

Worldwide Express (Third Party Logistic), Dallas, TX May 2018 –Aug 2018 Marketing Analytics Intern

• Communicated with leaders across departments to identify business opportunities for potential AI use cases and translated the business questions to statistical challenges

• Extracted, transformed data from Oracle SQL Developer and prepared large-scale datasets through AWS Cloud

• Identified factors that impact customer’s satisfaction of company’s shipping service and continue use of the service

• Predicted customer attrition rate by implementing Machine Learning Frameworks, informing company’s strategy Flagship Credit Acceptance, Dallas, TX Jan 2018 – May 2018 Data Analyst (Practicum)

• Wrote functions in Python that automated the applicants’ profile data check process; the functions decreased over 80% time spent on validating the applicants’ reported profiles

• Leveraged third-party data to pair 64% of total 80K applicants with employment data, improved the data quality and reliability

• Extracted data on MS SQL Server and utilized Power BI to visualize data, making the analysis easier for business users

• Predicted default risk by building logistic regression models in R, achieving 25% more accuracy than historical average LIXIN Certified Public Accountants Co. Lt, Ningbo, China Apr 2016 – Sep 2016 Risk Analyst Intern

• Participated in a Liquidation & Assets check project to evaluate financial situation for the company facing liquidity problem

• Collected and examined bank statements and adjusted monetary funds of nearly $50,000; Performed account adjustments and completed application forms for adjustments for final approval

• Analyzed financial statements, monitored the financial metrics to detect potential fraud risks and walked through the business to conducted further investigations, mitigating over $800,000 in fraud ACADEMIC EXPERIENCE

Data Analytics Project with Caliber Collision (Auto body repair service company), Dallas, TX Jan 2018 – Mar 2018

• Communicated with project lead at Caliber Collision to analyze its utilization of employees and dynamics of attrition

• Conducted Cluster analysis utilizing K-Means algorithm to generate segmented profiled of employees

• Employed PCA technique and logistic regression model to predict turnover results based on employees’ performance Business Intelligence Project for a Local Bike Company, Dallas, TX Sep 2017 – Dec 2017

• Drove business insights from data warehouse by created SQL queries on MS SQL Server

• Analyzed database physical structure and functional requirements of virtual users

• Developed ETL process for production data utilizing Visual Studio, and built production data warehouse in SQL Data Visualization Project for Pick Up (Instant Furniture Delivery Startup), Dallas, TX Aug 2017 – Dec 2017

• Used Alteryx to integrate data from different sources and prepare the dataset

• Used advanced Microsoft Excel to create Pivot Tables, used VLOOKUP, and other Excel functions

• Built dashboards in Tableau to illustrate geospatial, customer and sales insights and presented to the stakeholders Forecasting Analytic Project for Toyota Financial Service Analytics Team, Plano, TX Oct 2017 – Nov 2017

• Utilized forecasting techniques in R to predict the automobile sales of luxury segments

• Performed regression models to analyze the effectiveness of incentive spending on different groups of customers

• Built decision models to achieve optimal solution on allocating $200 million incentive spending on segments

Contact this candidate