Swayam Desai
Data Analyst Intern @ Chicago Transit Authority | Research Assistant @ UChicago | MS in Applied Data Science @ UChicago | Ex Data Science Intern @ Harman Connected Services | B.Tech Computer Science @ MPSTME
- Role
- Data Analyst Intern at Chicago Transit Authority
- Location
- Chicago, IL, US
- LinkedIn followers
- 500 followers
Experience
Data Analyst Intern
Jun 2025 — Present · Chicago, IL, US
Designed and deployed a cloud-based ETL pipeline to migrate internal data from on-premises Oracle servers to AWS Redshift, reducing average data load time and lowering infrastructure cost by roughly 25%.• Built and optimized a new Redshift database integrated with the ETL pipeline, writing SQL for schema architecture and optimization, and using AWS Glue and Lambda for data extraction, transformation, validation—enabling automated processing of over records daily.• Automated data pipelines with Apache Airflow, creating modular DAGs for scheduling and error handling.
Education
University of Chicago
Master of Science - MS, Applied Data Science
SVKM's NMIMS Mukesh Patel School of Technology Management & Engineering
Bachelor's degree, Computer Science with Business System
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.