Skip to main content
Python AWS Pandas

Multi-Cloud Cost Optimiser

Automated cloud waste detection that cut infrastructure spend by 37% for a SaaS startup.

Multi-Cloud Cost Optimiser — ProjectsHub
37%
Cost Reduction
$3.4K
Monthly Savings Found
2 clouds
AWS + GCP
4.9★
Client Rating
Overview

What is this project?

A CLI and scheduled-job tool that pulls granular billing data from AWS Cost Explorer and the GCP Billing API, normalises it into a unified cost model, and runs a rule engine against it. Rules catch common waste patterns: instances idle >80% over 7 days, unattached EBS volumes older than 30 days, orphaned snapshots, reserved instance coverage gaps, and data transfer anomalies. Each finding is ranked by monthly savings potential and exported to a pandas-powered HTML report.

For findings that can be safely automated, the tool generates ready-to-apply Terraform snippets (right-sizing, snapshot cleanup, RI purchase recommendations). In production for a Series-B SaaS startup, the first run identified $3,400/month in savings; after applying the generated scripts, the client achieved a 37% infrastructure cost reduction within one billing cycle — with zero disruption to running workloads.

Process

Build Timeline

Phase 01 Aug 2024
Billing API Integration
Integrated AWS Cost Explorer and GCP Billing API via boto3 and google-cloud-billing. Built unified cost model to normalise spend data across clouds.
Phase 02 Aug 2024
Rule Engine Development
Designed 14 waste-detection rules covering idle EC2/GCE instances, unattached volumes, orphaned snapshots, and RI coverage gaps. Each rule outputs a monthly savings estimate.
Phase 03 Sep 2024
Terraform Generation & Reports
Built Terraform snippet generator for safe remediations and a pandas-powered HTML report ranked by savings potential. CLI packaged with Click and distributed via PyPI.
Phase 04 Sep 2024
Production Deployment & Results
Deployed as a weekly Lambda scheduled job for the client. First run identified $3,400/month savings; scripts applied with zero disruption achieved 37% cost reduction.
Get This Project

What's Included

₹3,499
one-time payment · lifetime access
  • Full Python source code (CLI + Lambda scheduler)
  • All 14 waste-detection rules with documentation
  • Terraform snippet generator templates
  • AWS + GCP IAM permission setup guide
  • 60-minute video walkthrough
  • 30-day email support