Jiaqi Guo
Newyork ,NY
Summary
With a Master’s in Statistics from Columbia University and a proven track record in data analysis and modeling, I bring a robust skill set in Python, R, and SQL, complemented by experience in both LSTM and Transformer models for stock prediction and sports analytics. My technical expertise and strong business acumen allow me to transform complex data into actionable insights, driving strategic decisions and efficiencies. I am eager to contribute to your team with a focus on delivering data-driven solutions and fostering business growth through informed decision-making.
Overview
2
2
years of professional experience
Work History
Capstone Project Team Leader
Stock Price Prediction Using Deep Learning Models
02.2024 - 05.2024
- Compared the performance of Long Short-Term Memory (LSTM) and Transformer models in stock price forecasting, focusing on their strengths and weaknesses in short-term and long-term time series predictions. Employed TensorFlow and Keras to implement these models, using GPU acceleration to handle large datasets efficiently.
- Leveraged Python’s data manipulation libraries (pandas, NumPy) for data preprocessing, including normalization, sequence generation, and feature engineering, which improved the accuracy of the models by ensuring the data was optimally structured.
- Employed Python libraries like Pandas for efficient data manipulation, and Matplotlib and Seaborn for sophisticated visual analytics, enhancing the interpretation of stock price trends and anomalies.
Project Team Leader
SMT Data Challenge
06.2023 - 08.2023
- Engaged in a data challenge aimed at analyzing the performance of shortstops in baseball using advanced statistical methodologies, spatial statistics, and player interaction data. The challenge focused on evaluating the impact of positioning on defensive performance.
- Conducted targeted filtering of datasets to identify successful defensive actions using Python's Pandas library. Executed detailed calculations of movement distances using NumPy to process numerical data efficiently. Developed custom functions to calculate lateral (X-axis) and longitudinal (Y-axis) movements from the positional data, which were tracked and analyzed to assess their impact on success rates.
- Utilized Matplotlib and Seaborn for generating scatter plots and heatmaps, visualizing the correlation between movement patterns and defensive effectiveness, which provided a clear graphical representation of spatial performance metrics.
Data Analyst
Han's Laser Technology Industry Group Co., Ltd.
07.2022 - 08.2022
- Data Querying and Management: Proficiently utilized SQL to extract, filter, and aggregate large datasets from the company’s production database. Developed complex SQL queries to monitor key performance indicators (KPIs) such as machine utilization rates, production output, and defect rates, allowing for real-time tracking of production efficiency.
- Production Data Analysis: Created a detailed pivot table for the Production Department, summarizing key statistical data from the first three quarters of 2022. The analysis identified bottlenecks in the production process, leading to a 10% improvement in workflow efficiency after the implementation of recommended changes.
Education
Master of Arts - Statistics
Columbia University in The City of New York
New York, NY01.2026
Bachelor of Arts - Statistic
University of Wisconsin Madison
United States05.2024
Skills
- Python (Pandas, NumPy, Matplotlib)
- SQL
- R
- Tableau & Power BI
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Capstone Project Team Leader
Stock Price Prediction Using Deep Learning Models
02.2024 - 05.2024
Project Team Leader
SMT Data Challenge
06.2023 - 08.2023
Data Analyst
Han's Laser Technology Industry Group Co., Ltd.
07.2022 - 08.2022
Master of Arts - Statistics
Columbia University in The City of New York
Bachelor of Arts - Statistic
University of Wisconsin Madison
Similar Profiles
Elavarsan KElavarsan K
Software Developer at College Project (Heart Disease Prediction by Machine Learning)Software Developer at College Project (Heart Disease Prediction by Machine Learning)
Alperen Cengiz OZTURKAlperen Cengiz OZTURK
AI Researcher at Ozyegin University Deep Learning, Computer Vision and Image Processing LabAI Researcher at Ozyegin University Deep Learning, Computer Vision and Image Processing Lab
K SHAKTHIK SHAKTHI
COMPUTER COURSE- 2 at DEEP LEARNING-ALCOMPUTER COURSE- 2 at DEEP LEARNING-AL