• 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 profound business insights for potential growth.• Ensured data accuracy and reliability by validating against multiple template views and deep diving into raw data sets.• Supported fellow buying, planning, and operation team on any ad hoc queries, template errors, and streamlining data analysis processes.

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