Experience

• 

  MechCraft Tech

  • New York, United States

  • Business Analyst Intern

    • Jan 2024 - Mar 2024
    • New York, United States

    • Utilize technical knowledge to communicate and present between business stakeholders and IT teams• Perform quality checks on updates to industry information and data (online articles, white papers, industry reports), including proper document reviews; composed research papers to be delivered to the business team• Analyze the last 5 years of industry reports in conjunction with internal requirements using advanced EXCEL to forecast and visualize market trends for Blockchain in the financial arena over the next 3 years• Assist departments in resolving routine and complex issues with the CRM system and various sub-systems• Work bi-weekly with the VP to track the division's business continuity under various (sometimes unfavorable) conditions, strictly adhering to established guidelines and deadlines

• 

  Jiefang Daily Group

  • Shanghai, China

  • Digital Marketing Intern, Data Transformation Team

    • Dec 2021 - Feb 2022
    • Shanghai, China

    • Conducted 50K+ rows data cleaning and preparation tasks, like removing duplicates, filling in missing values• Followed and analyzed independent store inventory and sales using Excel formulas (PivotTable, VBA, Macros) and produce business summaries and analytical reports to make decisions about redeeming products• Designed SQL queries to derive actionable insights from databases to improve data analysis efficiency by 25%• Produced reports and dashboards thru Power BI, creating 1 dashboard which shared with over 600 employees