The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Currently working on a metadata scraper to find B2B potential sales clients for multiple companies. Hit me up if you need a developer!
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Working hard for a client, even making the merch, even shopify, google shopping, merchant center. It is way too much work for me
Title:
30-Day Social Media Content Strategy — Skincare Brand
Description:
A self-initiated concept project demonstrating a complete social media content strategy for a modern skincare brand. I developed content pillars, a 30-day content calendar, post concepts, captions, and Reels ideas designed to build brand awareness and audience engagement.
Role:
Social Media Manager & Content Creator
Project type:
Self-initiated / Concept Project
Project Title: Hotel Revenue & Margin Optimization Engine
Role: Data Analyst / BI Developer Tools: Tableau, SQL (SQLite)
The Overview Most hospitality businesses celebrate top-line gross revenue but lack visibility into the millions bleeding out through third-party OTA commissions. I built an end-to-end data pipeline and interactive executive dashboard to transition a hotel’s focus from Gross ADR to true Net Profitability.
The Problem The client had a pipeline of 119,000+ bookings generating $26M in gross revenue. However, they had no automated way to track the $3.8M lost to commission leakage, nor could they pinpoint which customer booking behaviors were driving these losses.
My Solution I engineered a Dynamic Pricing & Revenue Engine designed for senior leadership:
Data Modeling (SQL): Wrote complex queries utilizing Common Table Expressions (CTEs) and Window Functions to dynamically calculate Net ADR and aggregate commission costs across multiple distribution channels.
Executive Dashboard Design (Tableau): Developed a low-cognitive-load, Dark SaaS-themed UI. I applied strict semantic color coding (Teal for retained profit, Muted Coral for commission loss) to instantly guide executive attention to critical margins.
The Impact & Insights
Isolated exactly where the $3.8M in revenue leakage was occurring.
Revealed a major vulnerability in "Long Lead" bookings (90+ days in advance), empowering the management team to adjust dynamic pricing and minimum length-of-stay restrictions.
Provided an interactive, filterable tool for regional managers to assess profitability between City and Resort properties in real time.
Need clarity on your business data? I combine hands-on operational hospitality experience with advanced data analytics to build tools that drive strategic decisions. If you need to uncover hidden revenue or upgrade your reporting infrastructure, let’s collaborate.
