Sumedh Pawar Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, California, United States

Los Angeles, California, United States

- Designed and architected framework for ingesting data from any external REST API.- Implemented fully configurable ingestion pipeline framework capable of connecting to any REST API, parsing any format of JSON responses and loading the parsed data to Amazon S3 and Snowflake data warehouse.- Designed and Implemented real time data integration from various database sources to OpenSearch and DynamoDB using Amazon DMS, AWS Kinesis Streams and AWS Lambda.

Mumbai, Maharashtra, India

- Worked as part of NBA squad of Morgan Stanley's Wealth Management division in a fast paced Agile environment.- Worked on .Net Web API and Java Spring based microservices on the middle layer for implementing new business features.- Developed Spark and PySpark based framework for automatically creating NBA ideas for 1M+ clients.- Designed, created and maintained 100+ complex Stored Procedures and Queries in Microsoft SQL Server.- Created end to end CI/CD pipelines for various projects leveraging TeamCity to reduce deployment time by ~30 minutes.- Oversaw smooth production deployments.- Conducted knowledge sessions and training sessions for new hires.- Conducted telephonic interviews for new hire candidates.

Mumbai Area, India

- Written 25+ complex ETL pipelines using Hive/HQL to prepare data for Apache Solr Indexing and searching.- Reorganized and optimized 150+ batch processing jobs using Autosys job scheduler.- Created an automated deployment framework for SQL Server database using Liquibase and thus eliminated manual deployment errors by 100%.- Developed an Automation tool for comparing, detecting differences and automatically deploying Jil definitions of Autosys jobs which can be leveraged by any Autosys job.- Fixed bugs in existing ETL pipelines to solve data issues.- Developed a framework for automatically creating backups of Solr collections with optimized runtimes.- Recovered production job failures during outage incidences.- Developed a deployment framework for automating Solr and Autosys deployment to higher environments.

Mumbai, Maharashtra, India

- Collaborated with business teams for information and requirement gathering for implementing new features and reports in 'Analytics Hub' application of Morgan Stanley's Wealth Management platform.- Built several Query and Index pipelines in 'Liquibase Fusion' for retrieving and indexing billions of documents to Apache Solr cluster.- Created and maintained several Apache Solr collections, schemas and solr-config configurations.- Written Junit4 test cases for liquibase fusion pipelines created in java.- Fixed bugs/issues in existing codebase to enhance the user experience.

Bengaluru Area, India

- Attended the Morgan Stanley TAP program.- Collaborated with a squad of 3 to build a trading portal.- Created a monitoring tool for Kafka cluster to keep track of topics, producers, consumers and consumer group offsets, etc. in real time.

Pune Area, India

- Added value to NVIDIA’s GPU driver for windows by enhancing the telemetry performed by the driver.- Built detailed test cases for GPU performance benchmark.- Resolved bugs and issues found in GPU driver by doing system debugging.

Pune, Maharashtra, India

Pune, Maharashtra, India

Master Of Science - Ms, Computer Science, 3.9 / 4.0

Activities and Societies: USC Taekwondo Relevant Courses: CSCI 570 Analysis of Algorithms CSCI 561 Foundations of Artificial intelligence.

Bachelor Of Technology - Btech, Computer Engineering, 9.5/10

Activities and Societies: Robotics Forum, VIT Socials, Aesthetics Club Relevant Courses: CS401 Artificial Intelligence CS402 Network.