Resume

Sign in

Data Microsoft Office

Location:
Texas, United States
Posted:
October 23, 2016

Contact this candidate

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



Contact this candidate