Shubham Shetty
About
I'm a software engineer and graduate student in Computer Science at UMass Amherst, focused on database systems and systems for deep learning. I spent close to three years at JPMorgan Chase building backend services, data pipelines, and a natural language to SQL interface used across the firm's data lake. I built KodaDB, a relational database engine written from scratch in C++17, and this site runs on it. I'm interning at C3.ai now and join AWS Redshift's query planning team this fall.
Projects
Experience
Incoming Software Engineer Intern · AWS Redshift
- Working on query and planning optimization inside the C++ and Python codebase that powers Redshift's query planner.
Forward Deployed Engineer Intern · C3.ai
- Engineering a Premise Awareness feature for a San Mateo law enforcement platform, fusing data across 16 police departments so first responders see hazards, photos, and prior incidents before arriving on scene.
Software Engineer II · JPMorgan Chase
- Developed and deployed a GPT-4 powered natural language to SQL interface that let non-technical users query complex data lake schemas, cutting analytics turnaround time by 70%.
- Spearheaded ETL pipelines on AWS using PySpark and Pandas, processing data from 85+ sources and over 20GB daily, saving $150K+ a year by decommissioning legacy workflows.
- Engineered a reusable data ingestion framework supporting multiple sources and formats on AWS Lambda, Glue, and S3, cutting onboarding time for new data sources by 80%.
- Architected the backend using Spring Boot with Aurora PostgreSQL on AWS ECS, building REST APIs for 10,000+ production users and optimizing database queries for performance.
- Engineered a blue-green deployment strategy for ECS services with Terraform and Spinnaker, enabling zero-downtime deploys and rollback for critical production workloads.
- Built a user-facing dashboard with Java Spring Boot and ReactJS on AWS ECS, using AWS ElastiCache for caching to support 1,000+ active users.
Software Engineer I · JPMorgan Chase
- Promoted to Software Engineer II in 18 months, in the top 3% of new hires globally, for high impact on critical data lake initiatives.
- Built a data lineage tracking solution for the data lake using AWS Neptune, improving data quality and observability and cutting compliance audit time by 40%.
- Authored a technical primer on using Liquibase for Redshift that drew over 700 unique visitors in 3 months and improved team knowledge.
Contact
- Currently in Redwood City, CA
- [email protected]
- GitHub