Junjie Wang

Junjie Wang Email and Phone Number

Program Representative & Ambassador @ Columbia University | Data Analyst | President @ APAN Club | Actively Seeking for Full-time Jobs @ Columbia University Applied Analytics Club
new york, new york, united states
Junjie Wang's Location
Harrison, New Jersey, United States, United States
About Junjie Wang

Hello everyone,My name is Junjie Wang, and I hail from Shanghai, China. I completed my undergraduate degree from the University of Wisconsin-Madison, School of Business, majoring in Accounting. My academic background primarily focused on accounting, but I'm excited to embark on the data science field to expand my skill set, particularly in the areas of business analysis and programming.As a graduate student deeply passionate and sensitive to data, I perceive data analysis as a powerful tool for solving real-world problems. Not only do I possess solid skills in data analysis, but I also prioritize keen insights into data details, enabling me to extract key information from vast datasets and provide reliable support for business decision-making.Having completed multiple data-related courses on online learning platforms and obtained certificates through examinations, I have acquired proficiency in using tools such as Python, R, SQL, and Tableau. Furthermore, I have delved into database management and interactive programming, integrating them to realize the Extract, Transform, Load (ETL) process for data. I have led teams on numerous occasions to accomplish high-quality academic projects, earning praise from academic professors and being showcased as exemplary projects. These projects span various domains and technologies, including business decision-making, market analysis, and database management.Additionally, I have held positions as the Program Representative for Applied Analytics, Associate Vice President of Marketing for the Columbia University Applied Analytics Club, as well as the Social Committee member of the Student Government. In these roles, I have not only led content creation and social media management for the club but also collaborated with school faculty to negotiate key performance indicators and standards for projects and course evaluations. I have organized a variety of social activities catering to the diverse interests and needs of over 3,000 students.I'm currently seeking full-time opportunities to apply my academic knowledge to the real business world.

Junjie Wang's Current Company Details
Columbia University Applied Analytics Club

Columbia University Applied Analytics Club

View
Program Representative & Ambassador @ Columbia University | Data Analyst | President @ APAN Club | Actively Seeking for Full-time Jobs
new york, new york, united states
Employees:
6
Junjie Wang Work Experience Details
  • Columbia University Applied Analytics Club
    President
    Columbia University Applied Analytics Club Sep 2024 - Present
    New York, New York, United States
  • Columbia University Applied Analytics Club
    Assistant Vice President At Marketing Department
    Columbia University Applied Analytics Club Mar 2024 - Sep 2024
    New York, New York, United States
    Led content creation, managing social media accounts, fostering connections within the Columbia community
  • Columbia University School Of Professional Studies
    Program Representative
    Columbia University School Of Professional Studies Feb 2024 - Present
    New York, United States
  • Shanghai Shenchi Industry Co., Ltd.
    Business Analyst
    Shanghai Shenchi Industry Co., Ltd. May 2023 - Sep 2023
    Shanghai, China
    • 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.
  • Amazon.Com
    Data Analyst
    Amazon.Com Jun 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.
  • Shanghai Xinyan Mould Manufacturing Co., Ltd.
    Accounting Assistant
    Shanghai Xinyan Mould Manufacturing Co., Ltd. May 2021 - Sep 2021
    Shanghai, China
    • Applied Excel's VLOOKUP to match personal income tax rates for hundreds of employees and conducted payroll processing for 200+ employees.• Spearheaded inventory reconciliation, identifying and rectifying errors totaling $5,000 through meticulous analysis, corrective measures, and ensuring accurate financial reporting.• Assisted accountants in supplier reconciliation, ensuring timely and accurate processing of accounts receivable and accounts payable.• Produced monthly financial statements, meticulously auditing financial data to ensure 100% accuracy.• Audited transaction history on ledger accounts, resolving financial discrepancies and contributing to the development of accurate financial statements.• Organized financial records in both electronic and print formats, ensuring secure and accessible backups.

Junjie Wang Education Details

Frequently Asked Questions about Junjie Wang

What company does Junjie Wang work for?

Junjie Wang works for Columbia University Applied Analytics Club

What is Junjie Wang's role at the current company?

Junjie Wang's current role is Program Representative & Ambassador @ Columbia University | Data Analyst | President @ APAN Club | Actively Seeking for Full-time Jobs.

What schools did Junjie Wang attend?

Junjie Wang attended Columbia University, University Of Wisconsin-Madison, University Of Wisconsin-Fox Valley.

Who are Junjie Wang's colleagues?

Junjie Wang's colleagues are Yaorui Guo, Zeyi Bai, Haotian Chi, Caisen (Cason) Mo, Vivian Yin, Sachin Otsuka Arjun, Wenxuan (Alice) Wu.

Not the Junjie Wang you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.