Yuqi Su Email & Phone Number

• Developed SQL queries using subqueries, joins, and aggregated procedures in MySQL to create data sets for analysis.
• Presented monthly/quarterly sales performance by creating Dashboards & 10-page deck to help management team with performance tracking
• Created a monthly segment recap that is a combination of 3 unique templates to streamline process.
• Crafted pivots tables with 3million rows of data into comprehensive views, such as category, price range and YTD performances.
• Designed and automated excel reports creating VBA to refresh all tabs and optimize template efficiency.
• Conducted in-depth review of current reporting, pinpointing areas with insufficient data insights such as new brand performances and TikTok shop driven sales, further developed new tables and templates to generate.

Los Angeles Metropolitan Area

• Developed SQL queries to assess property performance relative to comparable properties, presented data-driven insights for management.
• Worked closely with sales and marketing to design promotion events using SQL to analyze historical promotion performances and returns.
• Analyzing market trends and consumer behavior to identify patterns on buying behavior in relations to economy indicators such as interest rates, employment rates and economic forecasts.
• Create pivot tables to show historical rent performances and forecast future growth, inserted pivot table line chart to for visualization.
• Forecast and analyzed future income through rent projection model on excel, provide supervisors with different options for savings.
• Monitored the local and regional industry markets and reported on any pertinent news or market trends for opportunities.

Greater New York City Area

Greater Los Angeles Area

Los Angeles Metropolitan Area

Masters Of Science

Bachelor'S Degree, Communication And Media Studies