Jiayi Pan (Kirsten)

Jiayi (Kirsten) Pan has a diverse work experience in data analysis and engineering. In their most recent position at SDG Group, starting in 2023, they worked as a Data Engineer. Prior to this, they were a Data Analyst at InetSoft from January 2023 to May 2023, where they developed interactive dashboards, optimized SQL views, and built a Logistic Regression model to detect fake user accounts.

In 2022, Jiayi held multiple roles. Jiayi (Kirsten) worked as a Data Analyst at Civilience from May 2022 to September 2022, where they led a team and developed Cloud Services Pipeline on AWS for efficient data storage. Jiayi (Kirsten) also automated NLP Topic Modeling and Sentiment Analysis for infectious diseases and created infectious disease monitoring maps using ESRI ArcGIS.

Jiayi was also a Data Analyst at an unknown company from February 2022 to April 2022, where they accelerated data analysis and ETL processes for millions of apps on Google Play Store. Jiayi (Kirsten) also conducted Ad-hoc analysis and utilized Linear Regression to investigate the correlation between customer purchasing behavior and app pricing strategy.

In 2022, they briefly worked as a Data Analyst specializing in analyzing Alibaba's shopper behavior. Jiayi (Kirsten) investigated shopper behavior metrics, presented findings on a Tableau dashboard, and published business insights reports.

In 2022, Jiayi worked as a Database Designer at New York University, where they built a course enrollment system and produced relational data models for multiple departments.

Prior to their data-related roles, Jiayi worked as a Financial Advisor at Aflac from June 2019 to October 2020, focusing on customer conversion and sales analysis. Jiayi (Kirsten) also interned as a Product Development Intern at Toyota Motor Corporation in 2018, where they created analytical reports and collaborated with stakeholders for efficient product manufacturing.

Overall, Jiayi (Kirsten) Pan has a strong background in data analysis, engineering, and database design, with experience in a range of industries including insurance, automotive, and education.

Jiayi (Kirsten) Pan completed their Bachelor of Science (BS) degree in Applied Mathematics and Bachelor of Arts (BA) degree in Economics from Stony Brook University from 2017 to 2021. Jiayi (Kirsten) then pursued their Master of Science (MS) degree in Management Information Systems, General at New York University from 2021 to 2023. Additionally, they obtained a certification in Social and Behavioral Research - Basic/Refresher from the CITI Program in October 2022.