Sebastian Van Hemert
✉ svanhemert00@gmail.com 🗂 LinkedIn Profile 📄 Download my Resume
EDUCATION
Loyola Marymount University (LMU) - Los Angeles, CA
B.S. Information Systems & Business Analytics - Fall 2018-Spring 2022
- Relevant Coursework: Database Management Systems, Applied Information Management Systems, Data Visualization & GIS, Networking & Cloud Computing, Systems Analysis & Design, Operations & Supply Chain Management Analytics, Introduction to Python, Business Statistics, Business Calculus, Fundamentals of Finance, Financial/Managerial Accounting
- Spring 2022: Data Science, Data Structures & Applications, Machine Learning, Mobile Application Development, Capstone Project
PROFESSIONAL EXPERIENCE
HP Tech Ventures through Paragon One - Remote
Intern, Corporate Venture Capital & Business Analytics - July 2021-Present
- Research startup metrics, industry data, team, and business models
- Determine product differentiation and strategy across startups
- Calculate and analyze data using MS Excel and SQL to find summary values and trends
- Present and correlate the data using visualization techniques
- Recommend attractive startups for further investment due diligence
Intern, Team JLL - February 2021–April 2021
- Participated in the evaluation of live real estate deal involving value-add acquisition of multifamily asset in Los Angeles, CA
- Prepared/presented investment memo to real estate professionals from JLL, CBRE Global Investors, Marcus & Millichap
- Received 60+ hrs. of training on real estate fundamentals, property valuation, deal financing, market research
- Built 10-year cash flow projections, sensitivity analysis based various growth rates, hold periods, and exit cap rates with JLL
Intern, Data Analytics - October 2020–February 2021
- Conducted Q3 2013 South Bay Data Collection/Visualization & Market Study using CRMLS Matrix and MS Excel
- Created pivot tables and dashboards for Q3 2013 South Bay Market Study
- Compiled relevant data into Excel spreadsheet to generate leads for Buckingham Seminar in February 2021
- Attended Zoom meetings to help plan, organize, & offer suggestions for February 2021 seminar
ACTIVITIES
Research Learning Community (RLC) - Remote
Rains Undergraduate Research Scholar (3 hrs./week) - Fall 2020
- Selective paid opportunity that introduces students to effective research strategies & writing techniques
AWARDS
2021 International Business Ethics and Sustainability Case Competition (IBESCC) - Spring 2021
- Competed against student teams from multiple continents, engaging in a wide array of business ethics issues
- 1st place: 25-minute competition, 90-second competition; 2nd place: 10-minute competition
- Selected among an applicant pool of 124,000 students with an acceptance rate of 8%
SKILLS
- Microsoft Office Excel® 2016 Expert
- Microsoft Office Excel® 2016 Specialist
- SQL: Data Definition Language (DDL) Statements, Data Manipulation Language (DML) Statements, MySQL, MS Access, Entity Relationship Diagram (ERD) Design
- Python: Input; Processing, & Output; Decision Structures & Boolean Logic; Repetition Structures; Functions; Classes & Object Oriented Programming; learning Pandas, Matplotlib, & NumPy
- Tableau Software Essential Training
- Excel: Data Cleaning, Forecasting, Multilinear Regression Models, Linear Programming, Simulation Modeling, Pivot Tables
- AWS: Security identity and access management (IAM), MFA, EC2, SSH, AWS CLI, Elastic Load Balancer (ELB), Auto Scaling Group (ASG), S3, Relational/NoSQL cloud databases, DNS, AWS Route 53, Content Delivery Networks (CDN), AWS CloudFront, AWS Lambda, AWS API Gateway, CI/CD, Infrastructure as Code (IaC), Terraform
- ArcGIS Pro: Geoprocessing, Spatial Analysis, Managing Map Layers, Querying Data, Symbolizing Map Layers
- Web Design: Introductory HTML & CSS
- Microsoft Office 365, Google Workspace
- PM: Jira, Agile, Scrum, Epic, Product Requirement Document (PRD), BPMN, Use Case Diagram (UCD), Entity Relationship Diagram (ERD), Data Flow Diagram (DFD), Data Dictionary
- Network Engineering, Cisco Packet Tracer, OSI Model, TCP/IP, IPv4, Subnetting, DNS, DHCP, NAT, PAT, Wireshark
- Bilingual: Advanced Heritage Spanish; Grew up in Lima, Peru (2008-2015)
- Teleconferencing Software: Zoom, Google Meet, Microsoft Teams
- SEO: Keyword Research, Google Analytics
- Survey Tools: Qualtrics, Google Forms, SurveyMonkey
PROJECTS
Cloud Resume Challenge - Fall 2021-Present
Building a website from the ground up with a database, API Gateway, custom domain, HTTPS Security, Serverless Functions triggered through APIGW written in Python, all packaged into a SAM template only utilizing Amazon's wide variety of Cloud services.
🐱 GitHub Repository 📌 Blog Post
Capstone Project - Spring 2022
You are visitor number
✉ svanhemert00@gmail.com 🗂 LinkedIn Profile 📄 Download my Resume
