Xuerong(Sharon) Zhang

469-***-**** acy0j7@r.postjobfree.com;

https://www.linkedin.com/in/xuerongzhang

SUMMARY

Function as expert for various development and analysis of data reports and dashboards to ensure accuracy in requirements analysis, data quality assessments, data profiling. Apply strong research and analytical skill on data intensive projects by utilizing advanced statistical models and sophisticated data driven analysis. Use modeling building, data mining, and other analytical techniques to drive business decision. Specific expertise in:

•SQL, SAS, R

• Google Analytics

• Microsoft Office Suite (Advanced Excel)

• SQL Server, MS Access

• Tableau, ETL

• Mandarin

EDUCATION

The University of Texas at Dallas December 2016

M.S. in Information Technology and Management (STEM)

East China University of Politics June 2014

B.S. in Finance

EXPERIENCE

Wintex Group DBA First Lending October 2016 – January 2017

Analyst Intern

• Coordinate with loan applicants, loan originators, underwriters, title companies and other 3rd parties to ensure

on-time closing of cases

• Review 15 loan files to verify documents were accurately calculated and sufficiently completed for an underwriting

decision, getting loans approved in the total amount of 500K in 3 months

• Extract data out of database and create report and dashboard in Excel for loan files performance on a weekly basis

ERecycler January 2016 – April 2016

IT Intern

• Redesign 50+ web pages using SEO best practices, gained 10% more page hits and online conversions

• Develop reports for the business needs of purchasing department, inventory and sales department

• Forecast performance of possible product combination by analyzing sales performance of 500+ products

PROJECT

Google Online Marketing Challenge in AdWords August 2016 – December 2016

• Convince the company to work with us by clearing the concerns and listing the benefits

• Increase the CTR by 50 % and created 5000+ clicks during 3-week campaign by executing A/B tests

• Self-learn R Script and wrote 80% of the R code in RStudio to analyze the campaign performance

Customer Behavior Analysis in SAS August 2015 – December 2015

• Collaborate with 5 team members to perform statistical analysis and predictive analysis like Liner Regression,

Decision Tree and Bayesian using SAS Base

• Query out and manipulate a dataset with 50,000+ rows and wrote 50% SAS coding for model building

Company Database Development in Access using SQL & Visio January 2015 – June 2015

• Hold meetings to discuss roles of team members based on their interests and capability

• Generate Entity-relationship diagram (ERD) with 50+ tables in Visio after data modeling

• Create tables in SQL Server and ensure the normal operation of querying using SQL query

CERTIFICATIONS

edX Verified Certificate for Introduction to Python for Data Science (2016), SAS Certified Advanced Programmer for SAS 9 (2016), Certified Google Analytics (2016)

Contact this candidate