Resume

Sign in

SQL/SAS/Python/Tableau/Bash/SPSS

Location:
Richardson, Texas, United States
Posted:
January 18, 2018

Contact this candidate

Yang (Carrie) Chen

972-***-****; ac33bf@r.postjobfree.com

www.linkedin.com/in/yang-carrie-chen

EDUCATION

The University of Texas at Dallas Dec. 2017

M.S. Information Technology Management, M.S. Marketing GPA: 3.9/4.0 China Women’s University, Beijing June. 2015

B.S. Business English GPA: 3.3/4.0

CERTIFICATIONS & TECHNICAL SKILLS

Certifications: SAS Advanced Programmer Certificate, SAS Base Programmer Certificate, Google Analytics Certificate Analysis Tools: Microsoft SQL Server, Tableau, SAS (Macro, Proc SQL), SPSS, MS Excel, MS Access, Google Analytics, Google AdWords, Facebook Ads Manager

Languages: SQL, Python, SAS, Java and Bash

WORK EXPERIENCE

The University of Texas at Dallas Department of Biological Sciences – Texas, Dallas Sept. 2017 – Dec. 2017 Database Developer Intern

• Utilized indexes, macros and proc SQL procedure in SAS to improve program efficiency; automated data import process with dynamic file name control list

• Applied Binary Sort algorism in Python to create matrix table through millions of records to count the number of intersections of DNA regions

• Designed and constructed MySQL relational database to enable users to retrieve overlapped DNA regions as well as their corresponding transcription factors

• Built process between MySQL and Python, enabling users to retrieve data remotely from database

• Conducted Fisher’s Exact Test using Python to analyze similarity level of transcription factors’ bindings on DNA Linfen Daily Newspaper Office – Linfen, China May. 2015 – Oct. 2015 Assistant Advertising Manager Intern

• Consulted and Interviewed 9 prospect clients to gather requirements on commercial advertising needs

• Monitored company’s Wechat Official Newsfeed (online subscription page) by tracking clicks and traffic, creating dashboards to summarize findings

• Created visualizations of sales patterns on Tableau using data extract, data blending and parameter setting ACADEMIC PROJECT

Barnes & Noble Data Analytics with SAS Mar. 2017 – May. 2017

• Built 3 predictive models (NBD, Poisson Regression, NBD Regression) for ‘barnesandnoble.com’ to analyze 40,945 consumers’ book purchase behavior

• Created 10 models to improve champion model performance and achieved highest Log-likelihood value (-5780)

• Utilized Logistic Regression to get insights into customers’ preference about Amazon over Barnes & Noble DNA Sequencing Data with Python July. 2017 – July. 2017

• Designed a user-defined function to read FASTQ file and extracted row 4 in each block (4 rows as a block)

• Converted extracted characters to ASCII values and calculated corresponding error probabilities

• Opened FASTQ file by invoking defined function and summarized quality value with Numpy package RestaurantGrades A/B Testing Analytics with SPSS Feb 2017 – Apr 2017

• Assisted RestaurantGrades to conduct A/B testing to evaluate the efficiency of their ads especially current adverting strategy and alternative advertising strategy

• Coded treatment variable into dummy variables such as control group, first treatment group and second treatment group to prepare data

• Conducted linear regression and evaluated the significance levels of coefficients; current ads were not as effective as alternative ads in terms of page views and reservations LEADERSHIP EXPERIENCE

INFORMS Student Chapter, UT Dallas Sept. 2016 – Dec. 2016 University Relations Leader

• Coordinated to plan events and promoted events on social media to raise students' awareness

• Designed surveys using Qualtrics to investigate satisfaction of attendees



Contact this candidate