Data Analysis/Data Modeling• Collaborated with internal and external teams, collected data from data warehouse, Redshift, Sandbox, SharePoint, Adobe, Concentrix, and other vendors, queried, reconciled, and piped raw data into server or project files, aggerated, analyzed data, and created report to executives.• Used Python Programming language/ R programming language to develop machine learning models and business models, combined them together to find solutions to increase business performance.• Visualized data to highlight the trends and outliers, communicated insights from data through charts and graphs. • Responded to data requests from other departments and troubleshot data issues.• Worked closely with Marketing/Sales Dept. to build Customer Engagement Evaluation System.• Tools: SQL, Python, R, Machine Learning Modeling, Business Modeling, AB TestingDashboard Creating /Updating/Monitoring• Updated MyMazda Enrollment/Connected Vehicle Dashboard weekly, reconciled data disagreement, solved data issue, responded requests from other departments.• Built Volume Performance/Transaction Price Performance/SSR Performance matrix to tract MOM, YOY brand performance.• Created new dashboard based on business needs.• Tools: Power BI, SharePointProjects in JobCustomer Engagement Value Project• Worked closely with Marketing/Sales Dept., developed Machine learning models and business models to build the Customer Engagement Evaluation System, which includes1. Predict Repeat Customers, 2. Customer Behavior Analysis & Marketing Strategy Recommendation, 3. Customer Segmentation & Specific Traits Analysis, 4. STP Targeting & Personalized Marketing, 5. Channel Credit Model 6. Last-Touch Attribution Model 7. Channel Link & Extend Model. • Tools: Python, R, SQL, Machine Learning Modeling, Business Modeling.Sales Goal Prediction Project• Built machine learning model to predict sales performance goal, increased accuracy rate from 68% to 81%.• Tools: R.

• Successfully created interactive managerial dashboards, combined with critical financial data, and updated weekly to help executives monitoring the metrics of business units and drove business decisions.• Collected data from multiple departments, visualized data to reveal business insights, and reported results to executives.• Responded to data requests from other departments and troubleshot data issues. • Collaborated with Customer Service Dept., classified customers based on their features, created reports to highlight outliers and predicted possible churned customers. Collaborated with marketing team to test the effectiveness of a marketing strategy and forecasted the future performance. • Tools: Tableau, Alteryx, SQL, Python, R, Machine Learning, AB Testing.Projects in JobBusiness Gap Detection System • Collaborated with sales and technical team to develop a detection system, helped salespersons detecting new business opportunities and monitoring abnormal data to avoid hacker invasion.• Utilized Tkinter to create an interactive GUI as frontend which allowed non-professional users to query, display and save data as they needed. • Solved a KPI conflict between Sales Dept. and Technical Dept., and saved revenue loss about $20,000 per month.• Tools: Python, MySQL, Tkinter.NOC Generation Center Customer Optimization • Optimized the Customer Segmentation system via Customer Journey Analysis and used CAC/LTV ratio as KPI to optimize marketing expense allocation.• Increased the customer retention rate from 46% to 65% and increased the profit about 15%.• Tools: Tableau, R, Machine Learning.

• Designed questionnaires, collected, and analyzed data to probe the core needs of a customer.• Developed customized solutions to fit a client's requirements.• Generated professional PPTs to convey the business strategies to clients.• Persuaded business audiences to accept and implement managerial improvement solutions.• Tools: Excel, PowerPoint.