Junjie Wang Email & Phone Number

New York, New York, United States

New York, New York, United States

Led content creation, managing social media accounts, fostering connections within the Columbia community

New York, United States

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.

• 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, 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.

Master Of Science - Applied Analytics, Computer And Information Sciences, General, 4.17/4.00

Activities and Societies: 2023~2024 SPS Excellence Awards - Academic Leadership Award Finalist Executive Member of Columbia Student.

Bachelor Of Business Administration - Bba, School Of Business: Accounting

Bachelor'S Degree