Yixuan Wang

**** ******** ** **● Atlanta, GA ****2

352-***-**** ● adcjtp@r.postjobfree.com

HIGHLIGHTS Added up to 5 years data/business analytics experience. Proficient in data analytics, statistical modeling, data storage and warehousing, data visualization, and project management.

Experienced in dealing with multi- tasks cross functional projects with high efficiency. SKILLS Programming language: Python, R, SQL, Java ERP Software: SAP, Salesforce Data analysis/visualization tools: Tableau, Lumira, Alteryx, SSIS, Advanced Excel (incl. Mekko Chart), Power BI EXPERIENCE CSM Bakery Solutions (Brills Inc) ATLANTA, GA Business Analyst, November 2017 – May 2019

Project:

• Database Migration Optimization Project: Worked as a project lead, migrated database from Alteryx/Tableau to SAP based Lumira, analyzed the prior database in Tableau, re-designed the new database schema, reduced unnecessary database storage aims to improve system performance. Designed 3 main report dashboards and 7 metrics in Lumira, used comparison test to track accuracy of new dashboards. Realized automatic self- updated reporting system, reduced 30% of reporting expenses, cut down errors’ root causes.

• Deduction Reporting System: Analyzed over 5 years deduction raw data using SQL and power BI, cooperated with Marketing Department to trace down directly to responsibility parties, designed and built real-time dashboards to monitor new generated deduction expenses, reduced 2.7 million deduction expenses in the following 3 month.

Main responsibilities:

• Provided cross-functional data support for multi- functional teams, captured root causing of exceptions and brought up business insights by providing YOY scorecards.

• Managed data integrity, responsible for data accuracy inspection, data cleaning using SQL or Alteryx.

• Optimized the reporting system, designed repeatable reporting procedures and templates utilized Advanced Excel skills, Macro and Power BI.

• Effectively collaborated with business stakeholders and presented on-time data solutions based on requests.

• Designed and implemented over 13 dynamic data visualization dashboards using SAP, Alteryx, Tableau for global team in six months.

• Assisted Finance team to analyze and report on monthly plant level EBITA metrics to business stakeholders. STATE MATERIAL LAB (FLORIDA DEPARTMENT OF TRANSPORTATION) GAINESVILLE, FL Database Specialist, October 2016 – June 2017

• Actively assisted the management team in data compilation and analysis to ensure data integrity.

• Implemented and designed comparison reporting deck using SSRS to help contractors calculate profit.

• Designed A/B Testing for lab’s web products new features, evaluated results and selected best product feature.

• Implemented VBA, advanced excel skills to realize automatic reporting system.

• Employed the business intelligence application Crystal Reports to pull reports from company’s prior system.

• Maintained Sharepoint site and updated site information based on clients’ requests. PERTH LEADERSHIP INSTITUTION GAINESVILLE, FL

Web Data analyst, Jan 2016 – May 2016

• Tested the stability of Perth model utilized thousands of customer data in company’s system.

• Generated report for customers utilizing MS Access and SQL. Forecasted trend, generated solutions based on potential risks and presented with metrics to customers. PROJECT LESS- ON LANGUAGE SCHOOL SYSTEM (SQL, Java) GAINESVILLE, FL

• Conducted a full-stack project for school online course registration process from SQL Server.

• Designed schema, database, ER-D/UML and implemented the user-friendly interface using Java. AIRBNB USER BEHAVIOR SEGMENTATION ANALYSIS (R) ATLANTA, GA

• Used R to pre-clean the dataset and used PCA model to select most affective attributes.

• Normalized the selected features and used machine learning function KNN to cluster the users’ behavior and predicted users’ future behaviors, created visualization report based on the analysis. EDUCATION UNIVERSITY OF FLORIDA GAINESVILLE, FL

• Master of Science in Information Systems and Operations Management (ISOM), May 2016 QINGDAO UNIVERSITY OF SCIENCE AND TECHNOLOGY QINGDAO, CHINA

• Bachelor of Science in International Trading and Economy, May 2014

Contact this candidate