Experience

The Salvation Army, International Headquarters

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Data Analyst Intern

  • Sep 2023 - Present

  Alexandria, Virginia, United States • Spearheaded data collection and analysis efforts for SAWSO's overseas community development projects, ensuring data accuracy and consistency for over 2000 rows of project indicators using Python and MySQL. • Generated comprehensive reports and data visualizations in Power BI, effectively communicating project outcomes and impact to diverse stakeholders. • Played a pivotal role in assessing donor preferences and evaluating the potential success of overseas projects, aiding in fundraising… Show more • Spearheaded data collection and analysis efforts for SAWSO's overseas community development projects, ensuring data accuracy and consistency for over 2000 rows of project indicators using Python and MySQL. • Generated comprehensive reports and data visualizations in Power BI, effectively communicating project outcomes and impact to diverse stakeholders. • Played a pivotal role in assessing donor preferences and evaluating the potential success of overseas projects, aiding in fundraising initiatives and maximizing SAWSO's community development impact. Show less



ICDR International

• United States
• Non-profit Organizations
• 1 - 100 Employee

• Project Coordinator Fellowship intern

  • May 2023 - Oct 2023

  Washington, District of Columbia, United States • Assisted in building dashboard reports in Power BI, such as the Global Caste Freedom Index, by using Python to collect and clean relevant data, and calculate different ratios to analyze the results • Used Client relationship management (CRM) tool to manage client relationships, including organizing different meetings and managing donation funds, etc.



Bosch (China) Investment Ltd.

• China
• Retail
• 100 - 200 Employee

• Business Analyst Intern

  • May 2022 - Sep 2022

  Shanghai, China • Designed and built production e-commerce market database, extracted data, and consolidate from multiple channels, improved data processing efficiency by 30% • Built Tableau dashboard to visualize analytical results, outlined the specific improvements for e-commerce products and provided business recommendations and data-driven solutions to team leaders • Conducted in-depth global market research through collecting latest E-commerce news and industrial data, established country… Show more • Designed and built production e-commerce market database, extracted data, and consolidate from multiple channels, improved data processing efficiency by 30% • Built Tableau dashboard to visualize analytical results, outlined the specific improvements for e-commerce products and provided business recommendations and data-driven solutions to team leaders • Conducted in-depth global market research through collecting latest E-commerce news and industrial data, established country evaluation model, supported D2U Strategy and roadmap decisions with a focus on innovation and maximum profits Show less



Guotai Junan Futures

• China
• Financial Services
• 1 - 100 Employee

• Asset Management Intern

  • Jul 2021 - Sep 2021

  Shanghai, China • Collected and processed historical financial data and relevant news of fallout stocks, analyzed daily fluctuation of stock price, optimized price predication model with seasonality factors, and improved model accuracy by 20% • Utilized iFinD and Wind to gather information, implemented the fundamental analysis for companies of interest to capture the buy/sell signal and comparative analysis by calculating financial key ratios such as P/E ratios



Jifeng Ventures 济峰资本

• China
• Venture Capital and Private Equity Principals
• 1 - 100 Employee

• Investment Analysis Intern

  • Oct 2020 - Mar 2021

  Shanghai, China • Cleaned, transformed, and normalized 10K+ pharmaceutical industry data and analyzed the status trends, performed descriptive analysis to summarize the distribution of demographic data • Analyzed the financing frequencies and operation status of targeted companies to propose investment suggestions for the stakeholders with product managers based on data-driven results



CPIGTJA-Allianz Funds Management Co. Ltd.

• Marketing Intelligent Intern

  • Mar 2020 - Apr 2020

  Shanghai, China • Created and built a company database system by applying Wind and Galaxy Securities to find up-to-date data of related funds and indices, proofread contents of promotional copy and updated report charts automatically, and used the wind plug-in in Excel to collect the yield of return for each managed funds by the company • Collected and organized information of funds being issued to help guide teachers in the production of marketing copywrite