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
Batch ETL Data Warehouse Modernization
Led modernization of a legacy batch ETL pipeline into a scalable AWS-based data warehouse. Replaced manual SQL jobs with an automated system loading diverse sources into Amazon Redshift.
Ingestion: Daily CSVs and API data land in S3; S3 events trigger Lambda to launch Glue Crawlers and update the Data Catalog.
Transformation: Glue PySpark jobs join and cleanse sales, inventory, and customer data, apply quality checks, and move errors to a quarantine path.
Output: Partitioned Parquet files stored in S3 for loading into Redshift.
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
Organized, cleaned, and accurately formatted raw client database into Google Sheets with 100% accuracy. Applied color-coded status tracking (Verified/Pending) and standardized contact details for seamless workflow management.
Automated Web Scraping & Data Extraction Pipeline
Overview: Built an automated, scalable data extraction workflow to harvest, parse, and structure nested e-commerce catalog data from dynamic web pages.
Key Deliverables:
HTML DOM inspection and robust tag traversal for complex, paginated product structures.
Resilient headless scraping pipeline using custom parsing logic to prevent data loss.
Direct ingestion into clean tabular schemas exported as analysis-ready CSV files with detailed execution logs.
Tech Stack: Python, BeautifulSoup, Selenium, Pandas, Requests.
Project 3 — Excel Workflow Automation & Performance Tracking
Developed an Excel and Google Sheets-based workflow to monitor daily and weekly production, track individual performance, and evaluate compliance with predefined targets.
The system uses automated formulas to calculate production results, compare performance against daily and weekly goals, and identify whether targets are met.
This workflow reduces manual tracking, improves data consistency, and provides a clear view of team productivity and progress.
