Cierra Koen

I support data-driven marketing initiatives by translating complex datasets into actionable insights. Using Python (pandas, openpyxl), I extract and clean sales and customer data from the STORIS database to generate segmented CRM lists and build geotargeted campaign strategies. I create interactive dashboards with Plotly Dash to visualize revenue by ZIP code, enabling more effective ad placements and regional targeting across channels.

I prepare internal and monthly analytics meetings with partners like FLX, AdTaxi, HHL, and iHeart by compiling reports from Google GA4, iHeart, OTT dashboards, and Meta Suite. I analyze web traffic, campaign performance, and conversion metrics to guide our advertising strategy. Additionally, I use Placer.ai to assess competitor activity and discover high-potential ZIP codes, refining geographic targeting for sales growth.

I manage and maintain monthly marketing budget sheets for tracking campaign spend and forecasting. As part of our social media strategy, I film and edit short-form video promotions for Instagram and Facebook, supporting local branding efforts. I also track performance using Meta Business Suite, reporting on reach, engagement, and audience trends to optimize content and posting schedules.

Beyond analytics, I serve as a brand ambassador and was featured in televised employee branding spots aired on NBC, FOX, and CBS, produced with Kairos Film and HHL. In both public-facing and behind-the-scenes roles, I combine technical fluency with strategic marketing insight to support brand visibility and performance.

I also review and proof all promotional materialsranging from direct mail and digital banners to audio scripts and video contentensuring brand accuracy and messaging alignment before launch.

As a customer-focused professional with experience in hospitality management, conflict resolution, and event coordination, I excel in providing top-notch support as a support staff member for the CA desk. I am adept at managing desk operations to ensure smooth guest arrivals, resolving conflicts and issues, and overseeing key management processes. With a strong attention to detail and excellent communication skills, I consistently deliver exceptional customer service and contribute to the success of group events and arrivals through effective coordination and preparation.

As a Software Engineer Intern at Nike, I had the opportunity to contribute to the development and enhancement of the Nike Running Club application. During my internship, I successfully launched and deployed an AI/ML model, leveraging tools such as Tensorflow, XGBoost, and Amazon AWS for accurate and efficient model predictions. Through this experience, I gained valuable insights into the practical application of machine learning in the context of a real-world, industry-leading organization.

Explore my web programming class assignments that delve into front-end development fundamentals. Throughout this course, I've delved into HTML/CSS, PHP, JavaScript, and MariaDB SQL, gaining valuable insights into web development. Each project offers unique lessons: (1) Personal Webpage: This project provides hands-on experience with HTML and CSS. It explores elements like classes, IDs, buttons, span tags, and anchor tags, enhancing my skills in structuring and styling web content. The index.html file serves as a central hub connecting all projects, allowing easy exploration. (2) TMNT Movie: Visit TMNT Movie to see my mock review page inspired by Rotten Tomatoes. I've honed my skills in manipulating element placement and alignment, understanding display properties like float and position in web development. (3) NerdLuv: At NerdLuv, I created a dating site with user sign-up and matchmaking features based on gender, age range, and more. This project involved PHP post forms, data extraction from "singles.txt," and provided insights into user authentication, form handling, and data manipulation. (4) 15 Puzzle: I designed a sliding puzzle game with various levels (3x3, 5x5, and 10x10) using JavaScript and animation. Highlighted adjacent squares for swapping enhance the user experience. (5) BrewTrade Dashboard: The BrewTrade Dashboard project integrates MariaDB to manage user information for a fictional coffee-selling company. It includes user sign-up, login, and admin dashboard pages, with a focus on PHP and MariaDB integration to streamline user flows.

The team web application project, Study Buddy (SB), aims to provide a platform for students to find study groups and partners based on their specific needs. With a focus on facilitating group discussions for academic pursuits, SB will offer a matchmaking system to pair studiers with the most suitable study buddies, ensuring a more effective study experience. Students will be able to create accounts and complete a matchmaking quiz. Additionally, SB will support group chats (Study Groups) where scholars can create and manage discussions, set privacy settings, and invite studiers. The project assumes that students benefit from studying with peers, aims to limit distractions by restricting notifications, and emphasizes the importance of interactive communication during study sessions. The app will leverage web services and Google APIs for features such as the Google signin functionality. The functional requirements of the system include account creation, a matchmaking quiz, and the ability to create, join, and manage Study Groups with various privacy settings, and studier moderation features. Check out my team's SystemRequirements.md file to know more about the project or visit our deployed app at www.studybuddy.fly.dev !

Conducted an extensive evaluation of 13 different machine learning algorithms on various training and test splits, utilizing metrics such as accuracy, precision, recall, and f1-score to determine the best-performing model, contributing to the project's overall success in predicting hotel cancellations.