Badges
Certifications
sumit_nalwade13 has not earned any certificates yet.
Work Experience
Data Analyst Intern
Metropolitan Transportation Authority (MTA)•  August 2023 - Present•  New York, USA
Introduced first PowerApps application to streamline the bus data analysis workflow that increased efficiency by at least 40%. Created a PostgreSQL database to store bus maintenance data and import 10,000 plus rows of data from CSV file to tables. Developed Power BI dashboards and Retool applications for Bus maintenance and servicing data housed in a PostgreSQL database, resulting in a 30% acceleration in data query response times.
Data Engineer Intern
Metropolitan Transportation Authority (MTA)•  May 2023 - August 2023•  New York, USA
Engineered an Azure Synapse pipeline, slashing data ingestion time by 40% by optimizing data flow from diverse sources into Data Lake. Led Apache Spark data processing initiatives, enhancing work efficiency by 50% across four departments through streamlined data transformation and loading into Delta tables. Automated Synapse pipeline execution and streamlined data transfer from SharePoint to Azure Data Lake through the creation of three Airflow Directed Acyclic Graphs (DAGs), enhancing operational efficiency. Implemented Jinja templating within Airflow DAGs, enabling dynamic string formatting during runtime to enhance task customization and adaptability, further optimizing workflows.
Senior Analyst-System Engineer
Capgemini Technology Services India Ltd•  May 2019 - September 2022•  Mumbai, India
Orchestrated the migration of 100 virtual machines to Azure, saving nearly $10,000 monthly. Decommissioned 120 virtual machines and servers, saving at least $16,800 monthly. Managed backup operations for 250 Windows machines, ensuring data integrity and continuity.
Education
Pace University, Seidenberg School of Computer Science and Information Systems
Data Science, Master of Science (MS) in Data Science•  September 2022 - May 2024•  GPA: 3.97
Malwa Institute of Technology
Bachelor of Engineering (B.E.)•  May 2014 - June 2018
Links
sumit_nalwade13 has not updated links details yet.