← ALL WORK
Software / Data Systems / 2024SHIPPED
Unifi ESG — Compliance & Analytics Platform
A scalable ESG compliance platform with 50+ REST APIs, dynamic schema generation and embedded row-level-secured analytics.
PROBLEM
ESG compliance reporting needs dynamic data schemas, strict row-level security per client, and analytics dashboards that stay fast as record counts grow.
APPROACH
A Flask API layer with dynamic SQL Server schema generation (staging → final tables), Auth0-based OAuth2 and RBAC, and Power BI embedded analytics using EffectiveIdentity for row-level security.
ENGINEERING
- 50+ REST APIs (Flask) with dynamic SQL Server schema generation
- Auth0 OAuth2 authentication with role-based access control
- Power BI embedded analytics with EffectiveIdentity row-level security
- Server-side DataTables processing achieving sub-second performance across 1,000+ records
- Cell-level audit logging with full user attribution
RESULT
A production ESG compliance platform with sub-second analytics performance and full audit traceability.
TECHNOLOGY
PythonFlaskMicrosoft SQL ServerAuth0Power BI REST APIDocker