Junzhe Gong

New York, NY ***** ad1kpv@r.postjobfree.com 332-***-**** https://www.linkedin.com/in/junzhe-gong/ EDUCATION

Columbia University – New York, NY Anticipated December 2023 Master of Science in Applied Analytics GPA: 4.00/4.00 Kean University – New Jersey, NJ June 2022

Bachelor of Science in Mathematical Science (Data Analytics Option) GPA: 3.68/4.00 SKILLS

• Marketing Related: Google Analytics, CRM, Conversion Lift Testing, Multi-touch Attribution, Marketing Mix Modeling

• Analysis & Visualization: Tableau, Power BI, Python, R

• Database: SQL Server, Oracle SQL, Snowflake, AWS RDS, NoSQL

• Statistics & Machine Learning: A/B Testing, Hypothesis Testing, Naive Bayes, Causal Inference, Regression, Sentiment Analysis, Time Series and Forecasting, Boosting Algorithms, Advanced Tree Models PROFESSIONAL EXPERIENCE

Allina Health - Data Analyst New York, NY. July 2023 – Present

• Collaborated with a cross-functional team of 8 in a successful initiative to slash freight costs by 30%. Strategically analyzing and reducing the company’s dependency on costly air transportation for medicine shipments

• Executed advanced ETL operations to migrate 3M+ PO and shipment records into Oracle Database using SQL. Utilized EDA in Python to dissect orders with a freight ratio above 30%, pinpointing the fundamental contributors to high shipping costs

• Developing strategies that achieved freight savings through bulk ordering and optimized inventory management. Employed data visualization to optimize supplier incentive approaches, reduced lead times and transitioned to cost-saving ground transport

• Developed an ARIMA time series model with cross validation to predict medicine demand with 92% accuracy, leveraging historical data and market trends. Led to a 25% decrease in stock out rates for the following quarter

• Developed a Flask-based recommendation engine on AWS, streamlining order placements by recommending the most economical suppliers and shipping options; integrated predictive ML model to enhance procurement efficiency and cost-savings Paragon Group USA - Market Data Analyst New Jersey, NJ. August 2022 – July 2023

• Executed strategic market intelligence gathering to pinpoint critical consumer preferences and competitive differentiators. Successfully launched 30 innovative product variations and 5 distinct product lines, effectively maximizing ROI

• Established an inventory database in MySQL through cleaning and integrating multiple warehouse stocks, built automated pipeline to calculate DOI and enhance inventory planning. Improved turnaround efficiency through advertising strategies

• Enhanced decision-making on advertising spend allocation by pioneering a marketing mix model in Python, synthesizing advertising campaign spend from different channels to accurately forecast monthly sales for the upcoming year

• Drove an 18% increase in average conversion rates and a 20% rise in quarterly sales by spearheading keyword analysis and A/B testing, which informed the enhancement of listing images, bullet points, and user manual designs

• Crafted automated Tableau dashboards for real-time tracking of sales and market trends; boosted stakeholders’ decision-making SinoSoft Co., Ltd - Business Analyst Beijing, CHN. February 2020 – August 2021

• Translated business needs into technical specifications with Agile, Excel, and JIRA, performing feasibility and risk assessments that pinpointed critical areas in the Health Management Platform process

• Developed automated data integration pipeline using RestDB for real-time analysis of user interactions and feedback in various market segments, including health and recovery. Established back-end SQL database for efficient and cost-effective data updates

• Enhanced customer retention by 22% in the Asian market by meticulously analyzing in-app behavior and feedback in Python, which informed strategic workflow optimizations in mental health group app functionalities

• Ensured seamless system adoption and enhanced user experience by spearheading User Acceptance Testing (UAT) and delivering expert end-user support with tailored best practices for the Health Management Platform

• Crafted dynamic Power BI dashboards and detailed reports that narrate business performance, delivering actionable insights to stakeholders. Managed systematic status briefings and provided specialized data analysis to drive organizational strategy RELEVANT PROJECTS

Predict the Rating of the Songs Based on Their Auditory Features October 2022 – December 2022

• Developed predictive models (Random Forest, Ranger, Adaboost, Logistic Regression) using R to forecast the ratings of 30K+ songs, utilized feature engineering, model selection, and parameter tuning techniques, resulting in an RMSE of 5.76 and a model accuracy of 92.3%, achieved a top 1% ranking among all participants US Restaurant Rating System February 2023 – May 2023

• Constructed ETL data pipelines using PostgreSQL to build a database of 100K+ restaurants in US, included ratings, locations, and sanitary inspection results, developed a Python-based front-end API using PySpark and Flask to handle user requests

Contact this candidate