• Wrote a Python web crawler to extract data of 125K+ car dealers, achieved a 90% reduction in program runtime by applying multi-threading techniques.• Built database query APIs to perform customized DDL and DML queries to streamline efforts and resulted in saving of 2hrs/person per day.• Implemented Python code using Pandas and NumPy to perform data cleansing, standardization and calculations.• Utilized scikit-learn and Pandas to conduct correlation analysis based on Pearson and Spearman’s rank correlation coefficient, similarity matrix and Cartesian product.

• Wrote SQL queries to extract social media posts about products of Levi’s, Pizza Hut and KFC from the database, cleansed and processed posts using Python and NLTK.• Applied bootstrapping algorithms to segment data and extracted seed word dictionary for sentiment classification, utilized latent variable model using Python scikit-learn to estimate user sentiment.• Generated social media analysis reports to derive insights to improve R&I and marketing.