ESG Normalization & Audit PipelineDEPLOYED
BreatheESG Ingestion
Enterprise ESG metrics normalizer calculating carbon emissions (Scope 1/2/3) with model-level audit locks.
METRIC 01Normalizes complex unit formats (GAL/M3/kWh/IATA codes) to emissions.
METRIC 02100% data audit compliance through raw source payload snapshots.
METRIC 03SQL queries optimized by 73% using materialized database tables.
Corporate sustainability spreadsheets suffer from manual transcription errors and lack verifiable source lineage, exposing companies to audit failures.
Attempted Strategy
Initially attempted to perform PDF scraping and optical character recognition (OCR) directly on scanned utility bills.
Observed Symptom
Frequent character reading failures (e.g. reading 8 as 0) resulted in audit-level errors that compromised the credibility of the data.
Resolution & Fix
Pivoted to parsing structured portal CSV exports, ensuring 100% mathematical accuracy and data consistency.
Django 5.2ReactTailwind CSS v3PostgreSQLSQLite