Madoff Ponzi Scheme litigation platform
A 12-year national trial required a data platform that could ingest, index, and analyze docket filings at a scale and standard of defensibility the firm had never needed before.
- Architected a Lakehouse data platform on Azure Synapse, Data Factory, and Databricks.
- Built ETL pipelines using PolyBase for bulk and parallel data movement, indexing and compressing records before load.
- Created a Databricks intelligence platform for unified data governance, reducing storage and compute costs.
- Built discovery portals letting defending counsel negotiate document costs and give opposing counsel secure self-service download access.
- Designed the firm's custom Madoff case management system, integrating with Azure Proxy so external users could reach on-premises applications.
Azure Synapse · Data Factory · Data Lake Storage · Databricks · PolyBase · Power BI · Key Vault · Azure Proxy