James Petravich
Chicago,IL
Summary
Experienced professional with a strong background in designing and implementing dashboards using Tableau and SQL Workbench. Proficient in SQL, Excel, and Microsoft programs. Skilled in accurately and efficiently cleaning and analyzing data using RStudio.
Overview
1
1
year of professional experience
Work History
Suites Coordinator
Delaware North Hospitality Group
Minneapolis
11.2023 - Current
- Coordinated with other departments to ensure projects were completed on time and within budget.
- Created and maintained accurate records of departmental activities, including budgets, personnel documents and project timelines.
- Analyzed financial activities of department to share budgetary input with managers.
- Computed balances, totals or commissions to support accounting team.
- Created Excel sheets with various running formulas to guarantee precise financial figures for budgeting needs of clients and companies.
Business Admin
Delaware North Hospitality Group
Minneapolis
08.2023 - 11.2023
- Managed and analyzed budget data and spending from 100+ local and international companies for suite at Target Field.
- Contributed to the accurate and efficient collection of credit card invoices and sorting of receipts, recognizing the sensitivity of the data
- Entered data for weekly orders for each suite into their database using Excel and the company's online software.
- Demonstrated a strong commitment to precision by diligently focusing on every task, safeguarding against potential financial implications.
Office Intern
Delaware North Hospitality Group
Minneapolis
03.2023 - 08.2023
- Utilized analytical skills to effectively manage and maintain databases containing various types of confidential company information, including product inventory, payroll, and employee records.
- Organized physical files, tracking spreadsheets and reports.
- Analyzed inventory reports, tracked payroll and wage data using strong Excel and Microsoft Word skills.
- Provided administrative support to the office staff by answering phones, filing documents, and data entry.
Education
Bachelor of Business Administration With A Concentration in Analytics -
Hamline University
St. Paul, MN05.2023
Skills
- Fluent in SQL
- Fluent in RStudio
- Fluent in Tableau
- Fluent in Python
- Fluent in Microsoft applications
- Fluent in Google applications
- 2 years of experience with SQL
- 2 years of experience with Tableau
- 2 years of experience with RStudio
- 2 years of experience with Python
- 2 years of experience with Data Entry
- Advanced abilities with Excel
- Advanced abilities with Excel formulas
Relevant Projects
- Created an entire database on local libraries from scratch using SQL and visualizing with Tableau
- Competed in 2023 BAC@MC, business analytics competition on Sub-Saharan food safety data using RStudio for causal inference, Python, dashboards and Powerpoint
- Competed in BSG, a semester long, business simulator that focused on each fiscal & managerial aspect of the business in the simulator.
Timeline
Suites Coordinator
Delaware North Hospitality Group
11.2023 - Current
Business Admin
Delaware North Hospitality Group
08.2023 - 11.2023
Office Intern
Delaware North Hospitality Group
03.2023 - 08.2023
Bachelor of Business Administration With A Concentration in Analytics -
Hamline University
Similar Profiles
Wei LuWei Lu
Casual Chef at Delaware North HospitalityCasual Chef at Delaware North Hospitality
Sashank GhimireSashank Ghimire
Food & Beverage Attendant at Delaware North MCG Hospitality ServicesFood & Beverage Attendant at Delaware North MCG Hospitality Services
John EvansJohn Evans
Chief Operating Officer at Old North State Hospitality GroupChief Operating Officer at Old North State Hospitality Group