Education
Loyola Marymount University
May 2023
Dual Degree: Bachelor of Business Administration in Information Systems and Business Analytics; Bachelor of Arts in Recording Arts
GPA: 3.95; member of International Business Honors Society (Beta Gamma Sigma)
Awards: Program Scholar for Information Systems and Business Analytics (Highest GPA/academic rigor of my graduating class), Summa Cum Laude, Dean’s List (achieved all semesters)
Portfolio Projects
“What Makes a Hit Song” Project
GitHub Repository: https://github.com/zonnid76/sql-portfolio-project
Utilized Python and Spotify API to collect data on 5,300 hit songs (100 from each year since 1970) in a MySQL database hosted with AWS RDS.
Queried with SQL for 12 characteristics of hit songs, such as average tempo and length, and to uncover trends over time.
Utilized Tableau for dashboarding, to create data visualizations presenting my insights.
Cloud Resume Challenge
GitHub Repository (Backend): https://github.com/zonnid76/cloud-resume-backend
GitHub Repository (Frontend): https://github.com/zonnid76/cloud-resume-frontend
Blog Post: https://dev.to/zonnid76/this-is-how-i-created-my-cloud-resume-475l
Developed a cloud-hosted resume with AWS (S3, Lambda, DynamoDB, API Gateway, CloudFront, Route 53), using full-stack (HTML, CSS, JS, Python) and DevOps skills, with custom domain and HTTPS SSL certificate.
Implemented CI/CD pipelines with GitHub Actions and deployed infrastructure as code using Terraform.
Work Experience
Freelance Sound Professional
April 2021 - Present
Sound Designer / Sound Mixer / Dialogue Editor / Composer / Music Producer
Worked on a wide variety of productions, short films, podcasts, events, and music, fulfilling various sound roles.
CBS Survivor
(Seasonal ~ April-July) 2022, 2024
Audio Technician - Seasons 47 & 48; Fiji
Meticulously tested, programmed, and packed each piece of gear for transport to Fiji at gear rental facility in LA.
Created spreadsheets to manage logistics (i.e. manifests, metadata, task management, how to documents, etc.).
Set up and manned RF Antennas in the jungles of Fiji for the filming of challenges.
Recorded 2nd unit production sound effects for over 80% of the challenges.
Edited and organized a sound effects library consisting of over 1500 audio files.
Filled in as necessary for reality sound mixers at contestant tribe camps.
Built an acoustically-treated recording studio into a shipping container.
Cleaned, repaired, maintained, and replaced equipment used throughout the audio department.
Set up and oversaw recording sessions for On Fire With Jeff Probst, the world’s #1 TV/Aftershow podcast.
Live-mixed production events.
Challenge Production Assistant (Dream Team) - Seasons 43 & 44; Fiji
Painted, set up, and tested Survivor challenges, as well as assisting the Audio Department during filming.
L'ANZA Haircare
October 2022 - May 2023
Supply Chain Consultant - Senior Capstone Project; Remote / Los Angeles, CA
Conducted a predictive cost-benefit analysis for L’ANZA to decide between a 3PL or in-house operations.
My recommendation to go with a 3PL discovered estimated potential savings of over $1.1 million annually.
Loyola Marymount University
September 2021 - December 2022
Teacher's Assistant; Los Angeles, CA
Taught 5 classes of graduate and undergraduate students, as well as consulting/assisting them with projects.
Los Angeles Loyolan
October 2019 - October 2022
Business Manager; Los Angeles, CA
Managed a 5-person business team, overseeing ad sales, ad placement, digital analytics, marketing, hiring, and training, as well as special projects and business development. Under my leadership, revenue increased 400%.
Created new spreadsheets to efficiently keep track of important data, such as ad campaigns and commissions.
- Previous positions: Assistant to Student Media Coordinator (October 2019-March 2020), Business Intern (March 2020-February 2021), and Assistant Business Manager (February 2021-December 2021)
RedCola Music
March 2021 - December 2021
Intern; Remote / Los Angeles, CA
Organized databases of assets (songs, sound design elements, and composers); Wrote metadata for new releases.
Parker House Furniture
June 2016 - July 2021 (Summers)
Office Clerk; Eastvale, CA
As an office clerk, I fulfilled parts orders for customers who received damaged products, as well as filing paperwork and scanning it into their database.
- Previous position: Warehouse Worker (2016-2018)
Skills & Interests
- Skills: Analytics, supply chain management, web scraping, IT, customer service, business development
- Programs: SQL, Python, Tableau, Jira, Confluence, AWS Cloud Services (S3, CloudFront, Route 53, DynamoDB, Lambda, API Gateway, EC2, Certificate Manager, CloudShell), Excel, VBA, HTML, APIs, Microsoft Office Suite, Google Suite, Google Colab, BLOX CMS, Hootsuite, Mailchimp, ChatGPT, Packet Tracer, Pro Tools, Logic Pro X, Final Cut Pro
- Hobbies: Playing the tuba, music production, AI, VR, slacklining, video editing, film scoring, reality shows