Back

Operations Efficiency Platform

Architecture Diagram

Role: Full-Stack Developer (Solo)
Duration: 7 months
Company: Techrupt Innovations
Stack:

Django Stripe PayPal Shopify WooCommerce Chart.js AWS EC2 RDS S3 GitHub Actions Matplotlib

Project Overview

Techrupt needed a centralized platform to automate revenue splits and provide real-time business insights to over 40 eCommerce clients across Shopify, WooCommerce, Instagram Shop, and TikTok Shop. I was solely responsible for designing, developing, and deploying a scalable Django-based web platform to streamline this workflow and reduce manual overhead.

Problem Statement

Before this platform, Techrupt's outreach team manually tracked revenue metrics and handled revenue-sharing calculations using Stripe and PayPal. As the client base grew, this manual process became inefficient and prevented the outreach team from onboarding new clients. The company needed a solution that could:

  • Automate commission-based revenue splits
  • Provide real-time business performance insights
  • Scale seamlessly across multiple platforms
  • Minimize manual data reconciliation

Solution Design

Architecture & Ingestion

  • Built custom integrations using the Google Analytics API, Shopify/WooCommerce plugins, and Stripe/PayPal webhooks.
  • Used Matplotlib for backend data analysis and Chart.js for frontend visualizations.
  • Stored only the last 7 days of data in RDS to minimize cost and latency; older data was fetched from the source on-demand.
  • Enabled auto-scaling on EC2 instances, and stored large report files in S3.
  • CI/CD pipelines were set up using GitHub Actions.

Revenue Split Flow

  • Captured successful payments via Stripe and PayPal webhooks and used metadata-enriched plugins (order ID, vendor ID, subtotal) to enable precise tracking.
  • Commission logic included vendor payouts, platform share, and later, affiliate revenue splits.
  • Used Stripe Connect to programmatically create transfers in connected accounts.
  • Admins had UI access to configure split percentages per client.
  • Tackled legal/financial challenges, including:
    • Reversing commissions improperly applied to taxes/discounts
    • Navigating cross-border payment regulations using Stripe's built-in controls

Reporting & Insights

  • Tracked key KPIs: total visitors, new visitors, bounce rate, and revenue.
  • Delivered data via a custom dashboard and automated weekly PDF reports sent by email.
  • Default data refresh was periodic, with an option to switch to real-time on-demand.
  • Standardized dashboard layout for all clients, with customization possible via admin requests.

Security & Compliance

  • Avoided storing PII or sensitive payment data; retained only essential metadata.
  • Enforced strict server-side access control; no direct access to stored sensitive data.
  • As a contract-based B2B platform, it operated outside GDPR/PCI scope.

Implementation Highlights

  • Used custom Stripe/WooCommerce plugins with metadata for accurate tracking.
  • Bypassed TikTok ban using Azure VM with VPN for integration testing.
  • Used sandbox/testing tools from Stripe/PayPal for integration testing.

Results & Impact

  • Reduced manual reporting time by 70-80%
  • Freed up outreach team to focus on new clients
  • Handled 5K+ daily events across 40+ clients
  • Introduced affiliate revenue split based on evolving client needs

Key Learnings

  • Hands-on experience handling multi-party payments and compliance using Stripe Connect.
  • Designing for scalability and performance by limiting data retention and decoupling storage from real-time processing.
  • The power of automation—not just in code, but in unlocking team productivity and business growth.