Data Analyst

Erin Xinran Dong

**** *** ****, ******, ** 469-***-**** *******@***.***

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Business Analytics STEM-OPT certificated Does Not Require Visa Until 2021 May 2018 Coursework: Business Intelligence, Data Visualization, Applied Predictive Analytics, Data Mining, Database Design, Business Analytics Consulting, Revenue Management, Decision Models GPA: 3.82 / 4.00

China Pharmaceutical University Nanjing, Jiangsu, China Bachelor of Arts in English Language and Literature Jun. 2017 GPA: 89 / 100 Top 1 out of 110

Saint Joseph’s University, Haub School of Business Philadelphia, PA Visiting Student, Exchange Program May 2016

GPA: 3.67 / 4.0

TECHNICAL SKILLS

SQL Tableau Alteryx Python SAS R Excel (VBA, Solver, Decision Tree) Access Visio ACADEMIC PROJECT

Toyota Financial Services Case Competition – Team Lead Plano, TX

• Built a semi-log regression model by analyzing historical sales data and third party data using R and Excel

• Developed 3 scenario models using Excel Solver to achieve FY 2018 segment share goals

• Recommended the optimized incentive spending plan to Toyota Financial Services Collin County Data Analyst Volunteer - Team Lead Dallas, TX

• Lead a team of 5 to understand business needs and develop interactive analytical solutions

• Designed and built Alteryx to cleanse, combine and analyze data to extract business insight

• Built 3 interactive dashboards and story points by Tableau to illustrate adopted and actual budget from Year 2011 to 2017

Business Intelligence

• Developed relational cloud databases, such as built data warehouse, maintained ETL, wrote queries, created tables, index, and views

• Analyzed database physical structure and functional requirements of virtual users Tools used: SQL Server Management Studio 17, MS Access, Power BI Data Mining

• Built a Naïve Bayes Model to predict the subscription of a new savings product for the Portuguese Bank using KNIME and R

• Provided managerial insights after the modelling process using Tableau and PowerPoint EXPERIENCE

PickUp Instant Delivery Academic Practicum: Business Intelligence Analyst Dallas, TX

• Created a forecasting model for demand that includes demographic and retailer data using R and Excel Solver

• Build a supply model which foresees the expected demand for drivers as well as the driver attrition levels

• Used Tableau to design and implement dashboards that measure actual results against forecasts along with corporate KPIs

General Electric Shanghai, China

Sourcing Analyst Intern, GE Lighting Jul. 2016 – Dec. 2016

• Consolidated and analyzed 10M in monthly spend with 6 suppliers using VBA, advanced Excel functions and Pivot Tables to evaluate company’s costs and savings for upper management

• Negotiated NPI product price with suppliers

• Conducted supplier management and product market research, and developed analytic presentations IBM Nanjing, Jiangsu, China

Data Analyst Intern, GBS May 2016 – Jul. 2016

• Cleansed and analyzed operation and strategy data by using Alteryx and Excel to establish a library and index of custom queries

• Gathered requirement from AIS team and other foreign divisions to develop a dashboard for data analysis module of China Telecom Accounting System using Tableau

Contact this candidate