Li Qin
Data Analyst Internship · Joblogic-X
Canoga Park, CAWork Experience
Data Analyst Internship
Joblogic-X2021 – 2022
Data Cleaning & Processing: Developed complex SQL queries to extract data within a streaming big data environment, applied advanced data cleaning and processing techniques to ensure data quality and integrity in SQL under heavy workloads (15MM+ electricity usage data), significantly improving working efficiency • Visualization & Reporting: Used Tableau to build automated dashboards to track electricity usage data, identified utility theft activities, and reported and presented to the revenue team timely, preventing a predicted revenue loss by 3% • Prediction Modeling: Extracted weekly and monthly inventory data from SQL data warehouse, built time series forecasting model in Python to analyze the inventory seasonality trend. Predicted weekly inventory of each product from each supplier and reported the forecasting low inventory level weeks and months to ensure a high service level • Suppliers Evaluation Analysis: Evaluated and analyzed suppliers' qualifications based on key metrics (e.g., prices, promotions, distances, delivery time, and qualities) and generated optimized purchasing solutions based on different types of products and customers' requirements
Business Analyst Internship
Bank of China, Ziyang Branch2021 – 2021
Financial Analysis: Analyzed and prepared financial statements of bank and compiled bank's weekly use of funds, built automated dashboards in Tableau to track daily transaction data, and presented weekly updates and insights to the financial team, improving team working efficiency • Audience Segmentation: Collected customers' data from multiple sources, used SQL to clean and process data, and segmented audience data based on key metrics (e.g., Transaction history, credit history). Customized promotion strategies for different audience segments and improved monthly sales by 5% • Prediction Modeling: Used SQL to extract data and built a linear regression model in Python to analyze the customer's fund trend. Identified essential factors that influence clients to buy funds to improve customer satisfaction
Education
Bachelor of Science
Iowa State University2017 – 2019
Bachelor of Science
Master of Science
Pepperdine University2021 – 2021
Master of Science