Yiqi Fu
Long Island City,NY
Summary
Pragmatic professional with solid experience in leadership roles. Adept at implementing strategic business plans, driving growth and improving operations. Skilled in financial management and stakeholder relations. Collaborative and dedicated to building and leading talented and motivated individuals.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Operation Data Analyst
Admarketplace
02.2022 - Current
- Take initiative to increase team efficiency by 60% for current advertiser–publisher integration setup and QA process by performing code optimization on complex stored procedures using Python and SQL
- Developed 20+ SQL scripts for extracting the desired data for compliance & data quality check and reporting, which reduced the ticket response time of ad-hoc request by 30%
- Built a python package wrapped with bash and task scheduler that automatically sends report daily to publisher through Google Cloud, AWS, Email and SFTP folder
- Wrote complex SQL queries and created Compliance dashboard in tableau to monitor overall traffic health for internal team to capture unmonetized traffic, traffic spike, overspent & underspent accounts.
Research Assistant
Fashion Deepblue Crop
12.2020 - 10.2021
- Architected web crawlers to extract over 200,000 processed fashion trend records from over 20 fashion brands with BeautifulSoup, and formatted the text data with NLTK, Pandas in Python
- Constructed ETL pipelines and built two interactive dashboard templates for analyzing latest fashion industry insights with Python plotly and tableau
- Extracted, filtered, and cleaned 100,000+ data from social media channels (Weibo, Twitter, etc), and built brand customer profiles by analyzing tweets, retweets, comments, and hashtags with NLTK in Python.
Data Science Intern
NurseDash
02.2021 - 06.2021
- Reduced 60% data processing time by building a ETL pipeline and enhanced 30% data quality through data engineering techniques including data cleaning, imputing missing values, and feature engineering
- Forecasted clinician urgent shift withdraws with logistic regression, random forest, and SVM using Python and conveyed key model insights to internal stakeholders in Excel.
Education
MS - Business Analytics
Fordham University
New York, NY12.2021
MS - Applied Statistics and Decision Making
Fordham University
New York, NY02.2021
BS - Mathematics (Actuarial Science Concentration)
Colorado State University
Fort Collins, CO03.2019
Skills
- Python (3 yrs - Matplotlib, NumPy, Pandas, Scikit-Learn, NLTK, BeautifulSoup)
- R (1 yrs - ggplot, dplyr)
- SQL (3 yrs)
- Tableau (2 yrs)
- Linux
- Git
- Google Cloud
- Analytical Problem Solving
- SQL Databases
- Statistical Analysis
- Database Programming and SQL
- Machine Learning
- Data Modeling
- Feature Engineering
- Transfer Learning
- Big Data Analytics
- Predictive modeling
- Python Programming
- Genetic Algorithms
- Business Forecasting
Websites
Accomplishments
- Modified and improved existing databases to reduce processing time by [number] and improve accuracy by [number]%.
- Made recommendations on business intelligence tools to cut processing time by [number].
Data Science Skills
- Machine Learning
- Statistics
- Feature Engineering
- A/B Testing
- Data Analysis
- Hadoop
- Spark
Hobbies and Interests
- Weightlifting (5 yrs)
- Tennis
- Golf
- Texas-holdem
- Movie
Projects
Data Science - Spotify Song Hit prediction, 10/2022, 12/2022, Built a classification model using logistic regression, KNN, random forest and AdaBoost based on features of tracks data fetched using Spotify’s Web API, performed data wrangling and feature selection with exploratory data analysis and PCA., Applied hyper parameter tuning and selected the AdaBoost model with an F1-score of 0.80.
Certification
- CBAP - Certified Business Analysis Professional
Languages
Chinese (Mandarin)
Native or Bilingual
Timeline
Senior Operation Data Analyst
Admarketplace
02.2022 - Current
Data Science Intern
NurseDash
02.2021 - 06.2021
Research Assistant
Fashion Deepblue Crop
12.2020 - 10.2021
MS - Business Analytics
Fordham University
MS - Applied Statistics and Decision Making
Fordham University
BS - Mathematics (Actuarial Science Concentration)
Colorado State University