Jacob Yu Email & Phone Number

San Francisco, California, United States

San Francisco, California, United States

Davis, California, United States

• Collaborate with Operations, Sales, and C-Level executives to develop company reports, highlighting the internal team’s competitive analysis findings and analyzing areas of improvement. • Build complex SQL queries to manipulate and compile data according to report parameters. • Generate Tableau dashboards to analyze and visualize insights on internal performance numbers.• Develop and implement project status reports to provide clients insight and visibility into progress.• Automate processes to transform data for reports, reducing creation time by 60%.• Investigate issues in Engage3’s competitive intelligence dashboards, identifying areas of inaccurate data to provide potential solutions.• Train and supervise team members in successfully executing the category mapping procedure.

Davis, California

• Built SQL queries to fulfill internal data export requests, providing project updates and validating data.• Analyzed queried data through Excel techniques (vlookups, sumif, pivots) and generated routine internal reports and visualizations with the results for stakeholders.• Developed and maintained Engage3’s category database, used by internal teams to store category data in a tiered hierarchy and categorize products across all retail departments. • Analyzed internal data, online retail sites, and brick-and-mortar layouts to build the 8,500 record database from the ground up.• Spearheaded an initiative with the Data Science team to map retailer categories to Engage3’s categories, providing more accurate cross-categorization analysis and laying groundwork for future data and reporting work. • Mapped 35,000 categories across the nation’s top grocers and retailers by analyzing their online sites.• Provided competitive analyses for clients, enabling them to maximize their pricing strategies based on the findings.

Aptos, California

• Contacted businesses to coordinate meetings and attain additional information about potential clients.• Recorded and analyzed all call statistics to evaluate agency sales performance level.

Santa Cruz, California, United States

• Advised 120 students by evaluating their prior performances and facilitating development of action plans to successfully achieve their academic goals.• Collaborated with management on outreach events and participated department functions to increase presence for the advising department.• Managed the front desk and served as a resource for questions about the Economics department.