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