Summary
Work History
Education
Skills
Publications
Projects
Languages
Timeline
Generic

Zhoulin Pan

Jersey City,NJ

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Work History

Human resource Intern

Hewitt Associates Inc.
  • Remote: True
  • Assisted with designing the corporate training programs and training schedules planning; Delivered employee questionaries and collected quantitative and qualitative data for further analysis
  • Investigated consumer needs, conducted human resources project research and analysis and scheme design, included data gathering and analysis, and compiled management regulations
  • Forecast the demand and supply of talent for each role, identify potential talent gaps, and compile an inventory of talent
  • Conducted enterprise-wide research based on client requirements, refined interview transcripts, and composed research findings
  • Collected and analyzed the recruitment statistics and generated visualized reports for the person-in-charge independently

Analyst Assistant

Accenture, Strategy Consulting
  • Remote: True
  • Sorted and translated five expert interview transcripts into Chinese; assist team members with the translation of over twenty English research reports
  • Investigated the market structure of the universe via research reports, expert interview records, etc., including investigating the comparison of products and services of AR/VR leading enterprises
  • Constructed Sony's business model, financial report data, company revenue business composition, and AR/VR game market distribution
  • Conduct business analysis using SWOT and Boston matrix models and assist team members with the production of business analysis reports

Graduate Assistant

Fordham University
10.2023 - Current
  • Developed and managed organized, orderly student databases and tracking systems.
  • Built a Transfer credit repository, a comprehensive list of the credit that Gabelli undergraduate awards for courses from external institutions.


Education

Master of Science - Marketing Intelligence

Fordham University Gabelli School of Business
New York, NY
08.2024

Bachelor of Science in Psychology - Psychology, Minor in Criminology

Rutgers University
05.2022

Skills

  • Proficient in Microsoft Suite
  • SQL
  • Tableau
  • SPSS

Publications

From Educational Field to Work Place: The Impact of Effective Feedback on Leadership Development, Zhoulin Pan, Jingyi Zhou, Sicheng Zhu, Advances in Social Science, Education and Humanities Research (ISSN: 2352-5398), 2022

Projects

Digital China Marketing Analysis Report, 02/2022, Conducted risk analysis, investigated market insights, analyzed supply chain networks and global autonomous car users, etc., Created a dashboard for a vehicle brand's sales revenue trend including metrics such as retail price, discount, number of cars sold, the volume of sales, sales cost, gross profit, and gross profit rate., Developed a strategy plan for constructing a vehicle brand's retail system and e-commerce platform, as well as e-commerce market analysis and hybrid retail model insights., Produced a report for the top management team of Digital China summarizing the program management system of Digital China, including a discussion of the software's advantages and fundamental characteristics. World Happiness Report |Individual Analysis Report, 06/2021, Utilized SQL and Excel to aggregate and cleanse data from various sources., Implemented SQL, Python, and Tableau, analyzed characteristics such as GDP per capita, social support, life expectancy, freedom to make life choices, charity, and belief in national well-being influence the happiness score., Discovered the identified GDP per capita and life expectancy are the two most influential determinants on happiness.

Languages

Chinese (Mandarin)
Native or Bilingual
English
Professional Working

Timeline

Graduate Assistant

Fordham University
10.2023 - Current

Human resource Intern

Hewitt Associates Inc.

Analyst Assistant

Accenture, Strategy Consulting

Master of Science - Marketing Intelligence

Fordham University Gabelli School of Business

Bachelor of Science in Psychology - Psychology, Minor in Criminology

Rutgers University
Zhoulin Pan