Jun Lee Email & Phone Number

San Diego, CA, US

• Compiled a web crawler in python to extract information from sites and eliminated price datawrangling.
• Utilized data obtained through the script to cross reference UCSD data and visualized extracteddata in Tableau.
• Provided predictive modeling/trend analyses in Tableau to UCSD’s staff leadership team, on abiweekly basis.
• Provided Tableau training, visualization best practices, and core data analysis techniques toUCSD staff employees.
• Optimized Tableau queries by merging data sources and recreating nested relationships,reducing load time and improving accuracy of query results. Blended data from query results,creating new insights into the data.
• Queried data from the data warehouse of over 5 million raw records through SQL, and convertedcomplex relational databases into presentable dashboards in Tableau.

• Mined data on existing UCSD campus-wide services, including vendor information and details,current trade contracts, competition price comparisons. Utilized data to create audience-targetedweb apps, improving web traffic.
• Debugged UCSD’s mobile app for Marketplace (campus-wide inventory store) and advised coreUI/UX changes to be implemented through contract renewals/service changes. Leveraged newfeatures for upcoming updates.
• Created the blueprint and wireframes for UCSD’s social engagement app through GIMP andAndroid Studio.