Lily Shih

**** ***** ***** ******, **** ****, Chicago, IL 60605

312-***-****

ac3wx3@r.postjobfree.com

https://www.linkedin.com/in/lily-shih-1a63b7b6/

Profile

Data-driven person and recent graduate educated in computer science. Eager to advance and gain additional knowledge in data science and data analysis industry. Seeking to apply learned knowledge to achieve a successful position as a Data Analyst or Data Science in an established organization. Education:

Illinois Institute of Technology, Chicago, IL May 2016 Masters of Science in Computer Science

National Chung Hsing University, Taichung, Taiwan June 2013 Bachelor of Science in Civil Engineering

Skills:

x Programming/scripting languages: (proficient) Python, SQL; (familiar) HTML, CSS, Java, Javascript, MATLAB, and R

x Frameworks/tools: MySQL, RStudio, MS SQL Server and Oracle SQL Developer Experience:

Gelber Group, Chicago, IL July 2016-Present

Database Administrator

x Managing database security. Design, develop, and implement automated data backup and restoration procedures x Created new databases and users: setup backup, maintenance, archive and other database management scripts x Supporting and monitoring database servers to ensure maximum uptime and implement proper safeguards for backup, replication, and recovery

Gelber Group, Chicago, IL

Database Administrator Intern March 2016-May 2016

x Created time-saving, robust database refresh script (in Python) that refreshe test database from production database, enabling developers to refresh database and apply schema changes with just one click. Projects:

Gelber Group, Chicago, IL

Web Scraping Project for Trader February 2017

x Designed unique web scraping system using Python to pull textual chemical data used in hydraulic fracturing oil and gas wells from the web and convert data to flat files x Created a raw data processing script to clean and format data then store result in MySQL database x Managed and sustained MySQL database containing several GB of oil wells data for more than hundreds of oil wells across United States

Illinois Institute of Technology, Chicago, IL

Class Project for Data Preparation and Analysis Spring 2014 x Collaborated as team to analyze relationship between climate change and happiness x Defined happiness as a measureable data and gathered qualitative data that is in the form of responses to standardized questionnaire survey from World Database of Happiness x Manipulated and quantified mass qualitative happiness data to draw conclusions x Developed histograms and scatter plots by using R to show the type of relationship between happiness and climate change

x Presented completed analysis to the class

Additional Courses:

x Cognitive Class Data Science Methodology

x edX Foundations of Data Analysis

x Coursera Data Science Specialization (in progress)

Contact this candidate