Vaibhav Patil

Experience

• 

  Cipla

  Jun 2021 - Nov 2021

  Engineering Apprentice

  Job Description:1)Improving Cycle Time and Yield of Carvidilol: Spearheaded initiatives to enhance the production efficiency and yield of Carvidilol, resulting in significant process optimizations.2)Data Collection and Analysis: Diligently gathered and analyzed comprehensive project data from the Batch Manufacturing Record (BMR) of Carvidilol to identify key areas for improvement and ensure data-driven decision-making.3)Cross-functional Coordination: Collaborated closely with the Unit Head and various departments to strategize and implement cycle time improvements, ensuring alignment with organizational goals and fostering a culture of continuous improvement.Key Achievements:1)Enhanced Production Efficiency: Successfully reduced the cycle time of Carvidilol production by 10%, leading to increased throughput and cost savings.2)Yield Improvement: Implemented process optimizations that boosted the yield of Carvidilol by 15%, enhancing overall productivity and profitability.3)Data-driven Process Improvements: Utilized detailed BMR data to pinpoint inefficiencies and implement targeted improvements, resulting in measurable performance enhancements.4)Effective Collaboration: Built strong relationships with cross-functional teams, facilitating seamless communication and coordination that drove successful project outcomes.5)Innovation and Best Practices: Introduced innovative methodologies and best practices to streamline operations, contributing to the long-term success and sustainability of the manufacturing process. Show less

• 

  Jain Irrigation Systems Ltd.

  Dec 2022 - Mar 2023

  Executive Engineer

  Job Description:1)Automated data cleaning and analysis using Python and Pandas to improve dataaccuracy and reporting efficiency.2)Queried data using SQL to track product trends and generate actionable insights.

• 

  Infinite Tech Solutions

  Apr 2023 - Apr 2024

  Data Engineer

  1)Designed and implemented a scalable batch and streaming data pipeline to ingest, process, and analyze largevolumes of structured, semi-structured, and unstructured data .2)Built end-to-end data pipelines using AWS Kinesis for real-time streaming and AWS Glue for ETL, ingesting1TB+ of data daily from diverse sources.3)Implemented batch processing with Apache Spark on Amazon EMR, enabling seamless data transformationsand aggregations for reporting.4)Created and maintained a data lake in Amazon S3, using Redshift as the analytical data warehouse forhigh-performance queries.5)Applied Spark optimization techniques including partitioning, broadcast joins, and caching to enhance performance and reduce job execution times. Show less

• 

  Smartavya Analytica Private Limited

  May 2024 - now

  Data Engineer

  Projects:1)Migrated a real-time fraud detection data pipeline for the National Stock Exchange of India Ltd(NSE) from Greenplum to Cloudera Data Platform (CDP) using Kafka and Spark Structured Streaming,enhancing scalability and efficiency in monitoring trading activities.2)Optimized real-time data analytics by leveraging Impala and Kudu as a modern data warehouse, enabling fast,efficient querying and storage for business-critical insights.3) Utilized Cloudera Hadoop Distribution for scalable data storage, distributed processing, and workfloworchestration, ensuring efficient ETL pipelines.4) Refactored an existing Linux shell script with PostgreSQL queries to be Impala-compatible, streamliningdatabase interactions for Start of Day (SOD), Intraday, and End of Day (EOD) operations in NSE. Show less