• Organized 900+ potential users’ data and analyzed their usage habits statistically; performed 4-layer pyramid data mapping on the marketing database by Excel and conducted more than 10 different email marketing campaigns aiming to the different level of customer groups, increased the click-per-rate to 5%• Developed business requirement documents including technical and cost proposals in response to the Request for Proposals (RFPs); generated use cases by Microsoft Visio and timeline with milestones by Microsoft Project• Assisted in web development project, including system analysis and design and some programming parts

• Deployed research on web crawling with YELP and MTA API to generate the list of top restaurants near a specific subway station with the conditional filter • Assisted in developing and updating 5 Oracle installation documents and SQL query workshop, grading more than 110 students Database Management Course 6 assignments and projects

Applied feature selection, parameter optimization and cross validation methods on NCAA March Madness dataset to ensemble multiple classification models to predict the results

• Collaborated as a team member to test 2G-BOH project by test case• Verified fixed bugs and updated in website

• Operated in researching and analyzing industry information of marketing changes from 10000+ records of customs data by required standards monthly• Assessed and processed data using SQL server and generated 4 marketing analysis and reports using Pivot Table in Excel