Talk to sales Try for Free
Yifan Chen

Yifan Chen

Data Analyst

Followers of Yifan Chen2000 followers
location of Yifan ChenDallas, Texas, United States

Connect with Yifan Chen to Send Message

Connect

Connect with Yifan Chen to Send Message

Connect

  • Timeline

  • About me

    Master of Science in Business Analytics | B.S. Statistical Science, M.N. Data Science & Educational Studies

  • Education

    • The Barstow School of Ningbo

      2016 - 2017
      High School General Studies

      Activities and Societies: Summer Camp(3 Weeks), Leadership Club, Business Club, Commissary in charge of general affairs, Nanking Model United Nations It is a satellite campus of the Barstow campus, situated in Kansas City, Missouri, and it is positioned in Ningbo, Zhejiang, China, commonly referred to as Ningbo Hanvos School. Prior to my arrival in the United States, I spent a year studying at this institution, which significantly enriched my understanding of Western culture. Among the memorable experiences, the Nanking Model United Nations stands out as a source of great pride and inspiration.

    • Southern Methodist University

      2020 - 2024
      Bachelor of Science - BS Statistical Science; Minor in Data Science & Educational Studies

      Activities and Societies: Chinese Student Union, Mid-autumn Festival Gala Emcee, K Pop Club, ASA DataFest, Epic Movement, International Student Fellowship

    • SMU Cox School of Business

      2024 - 2024
      Master's degree Business Analytics

    • The Oakridge School

      2017 - 2020
      High School Diploma General Studies

      Activities and Societies: Chinese Club, Field Hockey Manager, Junior Varsity Golf, Junior Varsity Basketball(2 years), Close Up Washington D.C. Trip, Model United Nations San Antonio I spent the formative years of my life in China until the age of 17. Despite attending an international school for a year, I encountered a significant cultural shift and experienced a noticeable cultural dichotomy upon arriving in a new country. However, as time went on, I adapted to my new environment, finding joy in academics, sports, and traveling with my friends.Growing up with exposure to two distinct cultures has been invaluable in fostering my appreciation for diversity and… Show more I spent the formative years of my life in China until the age of 17. Despite attending an international school for a year, I encountered a significant cultural shift and experienced a noticeable cultural dichotomy upon arriving in a new country. However, as time went on, I adapted to my new environment, finding joy in academics, sports, and traveling with my friends.Growing up with exposure to two distinct cultures has been invaluable in fostering my appreciation for diversity and enhancing my understanding of cultural nuances. It has allowed me to develop a keen awareness of both the commonalities and differences across cultures from a relatively early age, which I consider a valuable aspect of my personal and academic development. Show less

  • Experience

    • Yankon Lighting Inc.

      Jun 2022 - Aug 2022
      Data Analyst

      - Utilized SQL to extract a dataset of 7,000 entries containing sales data for LED luminaries spanning the past four years and conducted data filtering and aggregation to meet the specific requirements of key business stakeholders- Partnered with the engineering team to develop an R-based model for identifying sales seasonality trends and forecasting sales six months ahead, which garnered strong adoption from the finance planning team- Collated use cases from leadership and the business team, resulting in the design of a report that aligns FOB prices and monitors LPN records. This report empowers users to monitor monthly lighting sales and conduct MoM and YoY price comparisons for each lighting model- Collaborated with the engineering team to create a comprehensive analytical report tailored for client presentations, providing clients with the insights necessary to make informed business decisions Show less

    • Sunlitlux (H.K.) Company Limited

      May 2023 - Jul 2023
      Business Analyst

      - Conducted independent extraction of over 10,000 rows of unshelled pistachio import data sourced from the General Administration ofCustoms, People's Republic of China, and export data from the United States Department of Agriculture (USDA) website- Performed a data cleansing using a combination of R and Excel to eliminate outliers. Categorized produce prices by year and month, as well as marketplace segmentation, leveraging statistical libraries in R for precision- Executed a data analysis, with a primary focus on comparing pistachio export volumes and pricing trends among key players, namely Iran and the United States. Visualization techniques such as frequency tables and bar charts were employed to present and interpret these comparative insights- Created a detailed report particularly highlighting the substantial import data from The United State to Chinese main markets Zhejiang, Guangdong. Used Excel Macro to automate report so that it can be triggered to refresh whenever new data are imported. The report was used as a key input in the monthly business review (WBR) deck to help leadership with decision making Show less

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Yifan Chen
      SMU Merit Scholarship Southern Methodist University Nov 2023 I have been awarded a merit scholarship totaling $6,000 with half applied to the fall semester and half applied to the spring semester of the MSBA Program
    • Awarded to Yifan Chen
      Talent Candidate J.P. Morgan Chase Sep 2023 An honor to be identified as a talent candidate by J.P. Morgan Chase
    • Awarded to Yifan Chen
      The National Society of Leadership and Success Southern Methodist University Mar 2022 An honor to be nominated for a member of the National Society of Leadership and Success
    • Awarded to Yifan Chen
      TCU Frog Family Scholarship Texas Christian University May 2020 Texas Christian University (TCU) offered to me a Frog Family Scholarship, valued at $40,000, which spanned a duration of four years.
    • Awarded to Yifan Chen
      Most Outstanding Student in Pre-Calculus The Oakridge School May 2019
    • Awarded to Yifan Chen
      National Honors Society The Oakridge School Oct 2018 An honor to be selected as a member of the National Honors Society

  • Volunteer Experience

    • North American Blockchain Summit 2023 Volunteer

      Issued by Texas Blockchain Council on Nov 2023
      Texas Blockchain CouncilAssociated with Yifan Chen

    • Child Care Specialist

      Issued by Little Shepherd Foundation on Aug 2023
      Little Shepherd FoundationAssociated with Yifan Chen

    • Student Volunteer

      Issued by Mission Arlington / Mission Metroplex on Nov 2018
      Mission Arlington / Mission MetroplexAssociated with Yifan Chen

    • Volunteer

      Issued by Arlington Charities on Mar 2018
      Arlington CharitiesAssociated with Yifan Chen