Business Analyst

JENNY RONG

Corona, California ***** 626-***-**** *********.***@*****.***

https://www.linkedin.com/in/jenny-rong-682a32116/

Skills

● Programming Languages: C++, SQL

● Programming IDE: Visual Studio, MS Visio

● Structured Data Analytic Tools: Tableau, SPSS,

Advanced Excel

● Marketing Tools: Adobe Spark, Adobe

Premiere

● Marketing Analytic Tools: Leximancer,

Adobe Analytics, IBM Watson NLP,

Microsoft Video Indexer

● Bilingual/ native Cantonese

Education

Bachelor of Arts in Business Administration: Business Analytics May 2020 California State University - Fullerton Fullerton, CA Work History

Lead Server May 2016 – May 2020

Romano's Macaroni Grill Anaheim Hills, CA

● Averaged $1,000 in sales per shift by up-selling guests through knowledgeable recommendations regarding menu items and daily restaurant specials

● Processed multiple customer requests in a timely manner

● Routinely followed up with guests throughout their visit to establish an enjoyable dining experience

● Collaborated with a team of servers, hosts, and cooks to ensure all customer needs were successfully fulfilled

Relevant Projects

SQL Database Management, Customer Invoice Database May 2020

● Managed and created a five-relation database

● Identified and created an entity relationship model through Visio to better understand and visualize attributes among the database

● Extracted specific customer, item purchased, and vendor data

● Retrieved information from multiple tables using subqueries and join syntaxes

● Eliminated duplications from retrievals to ensure reoccurring information was not recorded

● Obtained pricing information by using aggregated functions

● Modified and updated database when new information arose Excel, Monte Carlo Simulation Project March 2020

● Created pivot tables to identify items such as most popular item sold, high sales period, and total transactions of the month

● Manipulated data to discover number of sales needed to meet target profit by using goal seek

● Calculated risk analysis using best- and worst-case scenarios to show range of possible values and likelihood of various outcomes

● Forecasted profits using simulated numbers with distribution of random variables

Contact this candidate