Resume Download

Education

──────────────────────────────────────────

Columbia University, New York, NY Dec. 2024

MS Computer and Information Science - Applied Analytics GPA 4.17/4.00

• Relevant Coursework: Data Modeling│Distributed Systems│Database Management│Anomaly Detection│Machine Learning

• Honor: Annual Dean’s Excellence Awards of Academic Leadership; Executive Member of Columbia Student Organization

University of Wisconsin - Madison, WI May 2023

BBA Wisconsin School of Business – Accounting GPA 3.7/4.00

Skills

──────────────────────────────────────────

Python PostgreSQL Data Visualization R Language Exploratory Data Analysis

MongoDB API Design Statistical Inference BI Reporting Interactive Programmin

Metabase Research Design Machine Learning Apache Spark Regression Modeling

Experiences

──────────────────────────────────────────

Business Analyst Intern at Shanghai Shenchi Industrial Co., Ltd., May 2023 – Sep. 2023

• Financial KPI Analysis: Create a dynamic financial KPI dashboard, identifying trends and conducting cost-benefit analyses, including ROI analysis, for strategic decision-making.

• Variance Analysis: Leveraged R for variance analysis, pinpointing cost-saving opportunities totaling $100,000 and formulating strategic recommendations for profitability optimization.

• Optimization Modeling: Applied Excel Solver to minimize costs, analyze age and mileage characteristics of trucks, make business decisions, and optimize truck salvage value when retired.

• Cost Management: Presented cost management strategies with Tableau Storyboard, driving successful implementation.

Data Analyst Intern at Amazon.com, Inc. June 2022 – Sep. 2022

• Market Analysis: Applied SWOT and Porter’s 5 Forces to assess Amazon's position within the industry, involving potential threats to inform strategic recommendations.

• Data Visualization: Utilizing Tableau storyboard that visualized subscription trends, and seasonal patterns, leading to a 20% increase in model accuracy, enhancing marketing strategies, and highlighting growth opportunities.

• Predictive Analytics: Crafting over 2000 lines of R code for cleaning, feature engineering, and data modeling, enhanced data quality by 30%, identified key sales drivers, and projected future subscription trends.

• Business Intelligence: Translated complex data into actionable insights that guided strategic expansion, including exploring viewer preferences, revealing popular content genres, and informing decisions on original content investments.

Projects

──────────────────────────────────────────

Airbnb Customer Satisfaction Analysis – Project Manager Jan. 2024 – Apr. 2024

• Clustering Analysis: Integrated PCA analysis, analyzed clusters based on rating metrics and neighborhood distribution.

• Inferential Statistics: Applied quantitative analysis indicating features influence customer satisfaction, employed inferential statistics to validate findings.

• GBM Regression: Applied predictive modeling and feature importance analysis to identify key predictors impacting satisfaction.

• Text Mining: Analyzed customer sentiments and distribution patterns, providing nuanced insights into trends and preferences.

Relational Database Design – Project Manager Jan. 2024 – Apr. 2024

• ETL: Spearheaded data collection, normalization, ER-Diagram design, and loading into the PostgreSQL database.

• API Development: Led the creation of an API interface integrated PostgreSQL backend, enhancing information management and implementing stringent security protocols, resulting in a 50% reduction in data manipulation time.

• Metabase: Developed an interactive dashboard, featuring pre-defined queries for streamlined data analysis and decision-making, resulting in a 40% improvement in executive reporting efficiency.

Machine Learning Neural Networks Project – Individual Contributor May. 2024 – Aug. 2024

• Algorithm Development: Designed and trained neural networks with advanced techniques, including BatchNorm, to enhance performance and robustness. Developed a model capable of effective sequence learning and superior accuracy.

• Optimization: Employed PyTorch LSTM to further refine the algorithms. Achieved over 98% accuracy with a 30% improvement.

• N-gram and MLP: Implemented N-gram models and Multi-Layer Perceptron for complex data patterns. Developed a company name generation model with nearly a million parameters, significantly boosting the accuracy and reliability of predictions.

Leadership

──────────────────────────────────────────

Program Representative at Columbia University Feb. 2024 – Present

• Exemplary student leader; Faculty collaboration; Program improvement; Student feedback integration

JUNJIE WANG

New York, NY │ 551-229-2307 │ jason011207@gmail.com │ LinkedIn │ Personal Website