Loading Portfolio
Preparing your data engineering showcase...
System Initialization
OpenCompliance ESG
ESG data validation, prediction API, and Streamlit dashboard for automated compliance analytics.
Jan 2024
3 months
Solo project
High
Project Overview
OpenCompliance ESG is an open-source analytics suite that standardizes ESG inputs, validates data quality, and exposes a prediction API with a live Streamlit dashboard for real-time metrics and reporting.
System Architecture
Key Features
- Schema + rule-based validation for ESG data consistency
- Real-time KPIs via Streamlit dashboard
- Prediction API for integration with downstream services
- Automated validation reduces manual QA effort
Technical Implementation
architecture
Validation layer with FastAPI backend and Streamlit frontend
database
DuckDB for analytical workloads
api
RESTful API with FastAPI
Challenges & Solutions
[ Diagnostic: Roadblocks ]
- Inconsistent ESG inputs
- Manual validation causing delays
[ Execution: Resolutions ]
- Built Streamlit dashboard for non-technical stakeholders
- Used DuckDB warehouse for analytics
Impact & Results
Automated validation reduces manual QA effort by 70%.
Project Access
Tech Stack
Streamlit
FastAPI
DuckDB
Python
Tags
ESG
Analytics
Dashboard
Data Pipeline
Streamlit
Key Outcomes
- ESG data validation and prediction API
- Live dashboard for real-time ESG metrics
- Automated PDF report generation for compliance
- Open-source ESG analytics platform