Punit B.

About Punit B.

Looking for a Data Engineer, Data Analyst, Business Analyst, Python Developer & SQL Developer role. I have 3.5+ years of experience & a B.Tech from IIT DelhiProficient Data Engineer with expertise in Python, SQL, Spark (PySpark), Azure Databricks (ADB), Azure Data Factory (ADF), and Power BI. Demonstrated success in creating and optimizing ETL pipelines, leveraging cloud-based platforms like Azure to extract, transform, and load data. Adept at designing data models, developing dashboards for insightful data visualization, and automating processes for enhanced productivity. Collaborative team player with a strong track record of delivering high-quality solutions in a fast-paced environment.Led end-to-end ETL pipeline projects, extracting, validating, and transforming retail data from Azure Blob Storage to Azure Databricks using Spark (PySpark), and subsequently loading processed data into the Data Warehouse.Designed and deployed dashboards for Healthcare data analysis and trend visualization using Power BI, facilitating informed decision-making.Extracted and transformed retail data from Azure Blob Storage, enabling real-time analytics for enhanced sales performance monitoring.Created 2 dashboards for Operations & Marketing teams to monitor store sales performance, leading to improved decision-making and targeted discounting strategies.Designed and implemented an incentive scheme dashboard for the billing team, enhancing productivity by 12% for top performers.Analyzed customer spending patterns, facilitating personalized coupon offers and increasing customer engagement by 22%.Developed a GUI using Tkinter for Automated Image Processing and Analysis, achieving 27% execution time reduction through code optimization.Successfully implemented a remote system booking web application, designing a structured data model with MySQL and integrating APIs for seamless data access.SKILLS & TECHNOLOGIES - Python, SQL, Pandas, PySpark, Azure Databricks, Azure Data Factory (ADF), Power BI, MySQL, OpenCV, PyCharm, Visual Studio, Tkinter, Pytesseract

Experience

1. Data Engineer

   Capgemini

   Nov 2020 — Present

   Led end-to-end ETL pipeline projects, extracting, validating, and transforming retail data from Azure Blob Storage to Azure Databricks using Spark (PySpark), and subsequently loading processed data into the Data Warehouse.Designed and deployed dashboards for Healthcare data analysis and trend visualization using Power BI, facilitating informed decision-making.Extracted and transformed retail data from Azure Blob Storage, enabling real-time analytics for enhanced sales performance monitoring.Created 2 dashboards for Operations & Marketing teams to monitor store sales performance, leading to improved decision-making and targeted discounting strategies.Designed and implemented an incentive scheme dashboard for the billing team, enhancing productivity by 12% for top performers.Analyzed customer spending patterns, facilitating personalized coupon offers and increasing customer engagement by 22%.Developed a GUI using Tkinter for Automated Image Processing and Analysis, achieving 27% execution time reduction through code optimization.Successfully implemented a remote system booking web application, designing a structured data model with MySQL and integrating APIs for seamless data access.

Education

• Indian Institute of Technology, Delhi

  Bachelor of Technology

  2016 — 2020