Junjie Wang Email and Phone Number
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.
Columbia University Applied Analytics Club
View- Website:
- columbiaappliedanalyticsclub.com
- Employees:
- 6
-
PresidentColumbia University Applied Analytics Club Sep 2024 - PresentNew York, New York, United States -
Assistant Vice President At Marketing DepartmentColumbia University Applied Analytics Club Mar 2024 - Sep 2024New York, New York, United StatesLed content creation, managing social media accounts, fostering connections within the Columbia community -
Program RepresentativeColumbia University School Of Professional Studies Feb 2024 - PresentNew York, United States -
Business AnalystShanghai Shenchi Industry Co., Ltd. May 2023 - Sep 2023Shanghai, 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. -
Data AnalystAmazon.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. -
Accounting AssistantShanghai Xinyan Mould Manufacturing Co., Ltd. May 2021 - Sep 2021Shanghai, 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
-
4.17/4.00 -
School Of Business: Accounting -
Bachelor'S Degree
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?
-
2gmail.com, ixl.com
5 +120649XXXXX
-
Junjie Wang
Princeton, Nj3firmenich.com, rutgers.edu, rockefeller.edu2 +121232XXXXX
-
Junjie Wang
Greater Seattle Area2amazon.com, amazon.com -
1hnagroup.com
2 +134733XXXXX
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial