Andrea Kwong Email & Phone Number

Portland, OR, US

Charlotte, North Carolina, US

Charlotte, North Carolina, US

Write SQL queries for data requests and dashboard creation as well as documentation of processes. Meet with internal stakeholders to create and enhance dashboards to improve functionality and provide meaningful metrics to aid in company operations and decision making. Understand objectives, KPIs, other metrics of different areas and groups and convert data.

• Brought over 300 categories and brands to quality standards by writing SQL queries and generated $2M in sales.
• Coordinated with the Machine Learning team to build three node qualification process automation tools.
• Make data analytics support decisions, conduct statistical analysis, data mining, business intelligence gathering, trending and benchmarking.
• Drive business analytics reports to dashboards, build and manage Tableau dashboards, and create new taxonomies.
• Research e-commerce market to define the feasibility, and present the prospects of potential business expansion into China.

Global, Global, CN

• Coordinated with China experts to bring them on as speakers for YCW events.
• Organized the logistics for events/talks.
• Sent out invites, published on social media to publicize events

• Explored company and industry data feedback for further use in proceedings before government agencies.
• Created metrics and ensured that the prioritization was data-driven.
• Collected, cleaned the data, and provided modeling analysis of structured and unstructured data used for major business initiatives.
• Performed surrogate country analysis using financial statements and calculated import duty margins.
• Identified misclassifications of imports of customs that saved clients over $1M.
• Participated in stakeholders meetings and conferences related to research areas.

Arlington, Virginia, US

• Searched/reviewed literature and performed due diligence investigations on potential private sector partners with USAID.
• Created usable and actionable tables and graphs through related data and statistics interpretation, synthesizing and summarizing.
• Coordinated with the White House Council of Environmental Quality to organize focus group sessions on climate change.
• Conducted case studies and created presentations on partnerships.

Washington, District Of Columbia, US

• Developed and presented business intelligence reports on the market situation, political and economic risks faced by foreign businesses in China.
• Produced the China Monthly Market Monitor, a report describing business environments and growth in 10 provinces.

Washington, DC, US

• Analyzed assets, including stocks, bonds, currencies, and commodities, collected information and performed research.
• Assessed the impact of potential investments in India, Mexico, and other emerging markets.
• Conducted industry/sector analyses and explained potential additional risks associated with proposed projects.

Washington, DC, US

• Supported senior researchers in data collection, including assisting in a survey, questionnaire.
• Provided support for conducting and organizing structured and semi-structured interviews and focus groups with research participants.
• Contributed to drafts and edits project reports, policy briefs, and case studies.

San Francisco, California, US

Washington, District Of Columbia, US

• Built a computer center in collaboration with the local community, with the intention of incorporating it into the school system.
• Interacted with entrepreneurs and business owners to develop and market their products.
• Helped women food vendors learn more about food preparation hygiene.

Ma, International Relations

Bs, Finance, Mis