Graduate Assistant, Business Analyst

Issac (Jie) Zhang

240-***-**** ***.******@*************.***.*** linkedin.com/in/issac-zhang Outdoor Lover (Hiked in Tiber) EDUCATION

University of Maryland, Robert H. Smith School of Business Aug 2021 - Dec 2022 Master of Science in Information Systems College Park, MD Graduate Assistant for Student Ambassadors Program, Terrapin Scholarship awardee Coursework: Python, SQL and Database Management, Data Mining & Visualization Using R Zhejiang University of Finance and Economics Sep 2010 - Jun 2014 Bachelor's Degree, Major in Finance Hangzhou, China TECHNICAL SKILLS

Languages: Python, R, SQL (Github: github.com/zjlqzzj2020) Analysis & Modeling: Exploratory Analysis, A/B Testing, Statistical Modeling, Machine Learning, Google Analytics Data Visualization: Tableau (public.tableau.com/app/profile/issac.zhang), Python (Matplotlib, Numpy, Pandas), R (ggplot2) ANALYTICS EXPERIENCE

University of Maryland, College Park Sep 2021 - May 2022 Graduate Assistant for Student Ambassadors Program

● Developed a python script to automate the collection of 7K+ alumni information from multiple excel files and integrated the data into SQL Database for future reference and search; Automated the whole process and saved 80% manual work and time;

● Leveraged Tableau to read alumni data including company, title, geo, and industry from SQL Database and visualized the alumni persona with geo heatmap and stacked bar charts, informing strategy for alumni events, successfully increasing the participation rate by 15%

Taro Technology Incorporated Nov 2016 - Sep 2020

Business Analyst Hangzhou, China

Optimization for the Official Website and Mobile App

● Conducted funnel analysis with Tableau to identify opportunities for company website conversion

● Designed and tracked "cost per order" metrics across digital channels to optimize budget allocation

● Optimized UI design of landing page by conducting A/B testing on different creatives, driving a 20% lift in conversion rate

● Extensively used SQL (10+ queries daily) to monitor daily performance on web traffic, calls, orders by product

● Leveraged SQL to calculate the return rate for different product lines, analyzed the root causes, and communicated with stakeholders for problem-solving; Increased the retention rate by 3% Crowdfunding Marketing Campaign on Kickstarter

● Led a campaign on Kickstarter, received 527 supporters in 45 days, and raised 126,944 USD, which was 635% of the original goal; achieved the purpose of the campaign, and the amount raised provided initial funding for the company to develop the product.

● Executed an Ads campaign mainly on Youtube by monitoring Google Analytics, resulting in 150% Return on Investment; acquired hands-on experience in market research, user interview, Ad Keywords optimization and screening, and Ad performance analysis.

● Coordinated with media and organized the Press Kit to publicize campaign; interacted with graphic designers to refine campaign page; managed customer service team to timely address users' issues. ANALYTICS PROJECTS ON CAMPUS

Python: Product Recommendation via Sentiment Analysis of Smartphone Reviews

● Built sentiment analysis model to predict whether a customer review is positive or not using VADER library.

● Collected 500K+ customer order and review data and leveraged rule-based sentiment model (VADER library) to predict the sentiment score for customer reviews

● Conducted competitive analysis on different smartphones based on their price and sentiment score year over year; Provided 10+ product recommendations based on the budget level for each customer

● Utilized Word Cloud to summarize 5+ selling points in positive reviews and revealed the risks in negative reviews for customers SQL: Database design for local restaurants

● Designed a relational database based on the data type, dimension, and size to store the operational data for 300+ local restaurants

● Developed the functionality of querying restaurants' information based on their cuisine, opening hours, locations, average price, etc.

Contact this candidate