Riyanka Pal

I'm building analytics-ready data products for Otsuka Pharmaceuticals at ZS Associates, turning 50+ enterprise sources into trusted Snowflake datasets for global business teams.

I design three-layer warehouses and Analytics Ready Datasets across 50B+ sales and payer records, powering 20+ executive dashboards and KPI reports. My SQL transformations reduced manual data preparation by about 80% and optimized critical reporting pipeline runtime and warehouse compute by 60%.

I've led the migration of 40+ enterprise ELT pipelines from Matillion ETL to Matillion Data Productivity Cloud, achieving about 50% lower platform costs with zero data loss at cutover. I also established Git-based CI/CD practices and onboarded two team members on migration standards and troubleshooting.

Previously at Celebal Technologies, I built Azure Data Factory pipelines ingesting 10M+ records into ADLS Gen2 and developed Databricks PySpark and SQL workflows for enrichment, reprocessing, de-duplication, and data-quality validation.