Chenxiao Wang
469-***-****; acw602@r.postjobfree.com
www.linkedin.com/in/chenxiao-wang
SUMMARY
A highly motivated and reliable data analyst with experience in IT company and financial industry
Strong experience managing databases, data mining and improving performance operations
Excellent verbal and written communication skills SKILLS
Programming: JAVA, Visual Basic, SAS
Business Intelligence Tools: SAS Enterprise Miner, Rapid Miner
Database: SQL (Access, Oracle, SQL Server, MySQL), Visio, SSRS, Tableau
Others: Fluent in English and Mandarin (Chinese), Microsoft Office Suite (Microsoft Excel skills including pivot tables, macros), Photoshop, Google Analytics, Google Sheets, Crystal Reports, SAP, SharePoint INTERNSHIP EXPERIENCE
Data Analyst: CETETEK Technology Inc., IT Department, Richardson, TX, Feb.2016-Aug.2016
Extracted and analyzed business data from data warehouse and built predictive models within Tableau to analyze datasets
Applied statistical methods to analyze the business data pattern, input and check data utilizing available resources
Worked with multi-disciplinary team to convert business needs into technical specifications
Applied ETL (Extracted, transformed, loaded) process to maintain database by writing SQL queries such as INSERT, GROUP BY, JOIN within MySQL
Analyzed big data set for updating database and expedited 35% of data processing time by using Excel VBA formulas Financial Analyst: Bank of China Ltd., China, Jan. 2013-Jun.2013
Analyzed customer needs and business processes in order to map them properly, and handled calls from internal and external customers
Addressed and help resolve investment inquiries, credit adjustments, billing questions
Analyzed variation tendency of foreign exchange based on big data, wrote daily report ACADEMIC PROJECTS
Business Intelligence (Data Mining, SAS, Modeling, Customer Analytics), June 2015-Nov. 2015
Used Sample, Explore, Modify, Model and Assess to analyze real data set of online-book-sale
Applied SEMMA process including importing, cleaning, transforming, validating and modeling data on real data set
Created five models, such as decision tree, gradient boosting, logistic regression to analyze what types of customers purchase books online
Applied SAS codes for dataset analysis, such as PROC LOGISTIC, Chi-Square to run regression for comparing behavior of customer
Database Management (Microsoft Access, SQL), June 2015-Aug. 2015
Wrote SQL queries to get valuable data, which can be used for business analysis. Designed Entity-Relationship diagram for database of Testing-Center
Developed a menu-driven environment user interface for a database system using Switchboard in Microsoft Access and created the database with 13 tables
EDUCATION
MS, Information Technology and Management, University of Texas, Dallas, earned May 2016 MS, Finance, University of Texas, Dallas, earned May 2015 BS, Accounting, Wuhan University, China, earned June 2013