Ecommerce profit analyst. I find where D2C brands are quietly losing margin — dead SKUs, bad shipping tiers, discount leaks — using SQL, Python, and Power BI.
Most D2C and Shopify brands are profitable on paper but bleeding margin in practice.
The gap usually hides in three places:
• SKUs that look profitable but lose money after fulfillment costs
• Shipping tiers quietly consuming 15–20% of order value
• Discount codes that continue reducing profits long after they should be retired
Most businesses don't catch these issues because nobody owns finding them.
WHAT I DO
I pull raw order-level data, build a clean analytics schema, and perform profitability and shipping-cost analysis to identify:
• Where margin is leaking
• Why it's happening
• How much it's costs every month
• Which fixes will have the biggest financial impact
FLAGSHIP PROJECT
Profit Leak Diagnostic
Built using:
• PostgreSQL
• Python
• Power BI
Dataset:
• 180,000+ e-commerce orders
Final Deliverable:
• Client-facing PDF report with actionable recommendations
Key findings:
• A small group of SKUs generated the majority of total profit.
• A significant portion of the catalog acted as dead weight.
• One shipping method delivered late on every single order it handled.
HOW I WORK
You work directly with me—not through account managers or multiple team layers.
You'll receive:
• Raw findings from your data
• Plain-English explanations of what's happening
• Prioritized recommendations ranked by dollar impact
• Practical insights instead of a 40-slide deck nobody reads twice
IF THIS SOUNDS FAMILIAR...
If you suspect something is wrong with your margins but can't tell whether it's:
• Ad spend
• Shipping setup
• Product mix
• SKU profitability
...that's exactly the kind of problem I solve.
Portfolio, full project breakdown, and case studies:
https://zeeshan-portfolio-swart.vercel.app/
Work Terms
• I work on a fixed-price, project basis—not hourly.
• Most projects begin with a fixed-fee diagnostic, so the scope and cost are clear before any ongoing work.
• Typical turnaround is 5–10 business days, depending on data size and access. I'll confirm the timeline before we begin.
• Communication is primarily through email or Slack, with a kickoff call and a final findings walkthrough included.
• Based in Pakistan (GMT+5) with availability overlapping UK and US business hours.
• For larger projects, payments are milestone-based (deposit, midpoint, final delivery).
• I accept payments via Payoneer. SWIFT is available for larger invoices.
• I only require read access to your data (Shopify export, database, or BI tool). Full admin access isn't necessary.
• NDA available upon request before any data is shared.
Attachments (Click to Preview)
-