Sai Pavan Panchagnula

Led end-to-end migration of on-premise SQL databases to GCP, onboarding 400+ tables and designing a three-layer Medallion Architecture. Applied Spark optimization and BigQuery partitioning to cut processing time by up to 83% and reduce compute costs.

Architected an end-to-end serverless data lake on AWS, orchestrating hybrid ingestion of unstructured R&D research PDFs and structured clinical data. Engineered distributed PySpark ETL pipelines in AWS Glue, reducing manual metadata processing effort by 90%.

Built a barcode-based order return system for a leading Indian unicorn online retail platform, reducing inventory return-to-seller turnaround time by 50-70%. Designed backend services for Stockone, a multi-tenant SaaS warehouse management system.

Led backend development for a social fashion discovery mobile app, building Django REST APIs for real-time trending brand tracking and in-app purchases. Built a large-scale Scrapy web scraping pipeline for OTT platform data and a Django-based data comparison tool.

Developed automated test scripts for Dell India R&D's RAID storage management product (OMSS), improving test coverage and reducing manual regression testing effort.

Built a social graph aggregation service to consolidate a user's friend networks from Google, Facebook, and Twitter into a single platform. Worked as a software engineer in various data crawling projects.

Completed Bachelor of Engineering in Computer Science and Engineering.

Certified as a Google Cloud Professional Data Engineer.