data analyst

Ling Xin

San Diego, CA 858-***-**** ***********@*****.***

SUMMARY

Highly analytical, motivated, and teamwork-oriented junior Analyst with in-depth knowledge of data analysis and visualization; and significant experience in using statistical analysis to evaluate problems. Highly educated, possessing a master’s in data science, and a bachelor’s in business. Bilingual in English and Chinese. PROFESSIONAL SKILLS

• Experienced in using Excel creating dynamic reports with PivotTables and managing large dataset with functions IF, SUM, MAX, MIN, INDEX, MATCH, VLOOKUP

• Ability to perform quantitative analysis, linear/multiple and logistic regression, classification model, and time series model for prediction analysis meeting business needs

• Ability to writing simple/complex queries, and optimizing statement for various projects to ensure giving the desired output by using MySQL

• Experienced in applying visualization techniques (Tableau, Excel, Power BI) to display data and results of analysis in clear straightforward presentation

• Ability to perform data mining, analysis and prediction models by using programming language R and SAS

• Knowledge of coding with Python packages (pandas, matplotlib, NumPy) WORK EXPERIENCE

Assistant Analyst – Jackson Moving & Storage Inc., Chippewa Falls WI 05/2020 – 11/2020

• Utilized data visualization with Tableau to discover patterns to help make better business decision to control cost

• Entered and updated data in database, and extracted valuable data to support decision making by using MySQL

• Forecasted margin analysis to understand the impact of volume and seasonal pricing

• Evaluated the lane, determined product requirements, payment terms, performed risks analysis for out-of-state transportation

Operation Specialist – LPL Financial, San Diego CA 09/2017 – 07/2018

• Supported Stock Records department with DST Vision Platform, Handling Branch Trade Reports (BTR), and auditing various financial brokerage accounts

• Utilized ClientWorks, Oracle, Siebel, and Beta software and applications in direct business.

• Acted as an intermediary between internal partners to ensure LPL accounts were updated correctly in systems

• Run different Omnibus reports and processes, booking dividends, requesting fund records, reconciling discrepancies and making Rand Entries

PROJECT EXPERIENCE

RFM-Based Customer Value Analysis Model

• Applied data preprocessing of airline dataset, including data cleaning and attribution selection

• Extracted LRFMC indicators according to the airline customer value analysis model and use the standard deviation method to achieve the standardization of data

• Used K-Means algorithm to perform cluster analysis on customers and analyzed the characteristics of customer groups to obtain customer value analysis model

EDUCATION BACKGROUND

Master of Science, Data Science Bachelor of Arts, Business National University San Diego State University

02/2019 – 05/2020 08/2013 – 05/2017

Contact this candidate