Migrated data from the old platform to the new platform, did data cleaning, data validation and data modelling.Owned the Smart Dispenser (IOT device used in cooling towers) project, performing end to end analysis for this product- overlooked 88 devices, validated the data coming from the dispensers, worked on calibrating the dispensers via backend using MobaX/Putty, presented weekly reports and gathered data to create a dataset for an inventory predicting model.Conducted comprehensive… Show more Migrated data from the old platform to the new platform, did data cleaning, data validation and data modelling.Owned the Smart Dispenser (IOT device used in cooling towers) project, performing end to end analysis for this product- overlooked 88 devices, validated the data coming from the dispensers, worked on calibrating the dispensers via backend using MobaX/Putty, presented weekly reports and gathered data to create a dataset for an inventory predicting model.Conducted comprehensive testing procedures to ensure Buckman software’s quality and functionality on the web and mobile app.Performed deep dive on various IOT devices sending data to figure out the root cause issues. Show less

Developed and optimized complex SQL queries - Redshift SQL to ensure accurate data retrieval and reduced job run times for ETL pipelines on ETL Manager. Led a project to create an automated WBR (Weekly Business Report) dashboard, on AWS Quicksight (Amazon’s data visualization software) for an entire department by collaborating with 20 teams. Identified the necessary business metrics, created a scheduled job to get the required data from the tables of the different teams and the data was… Show more Developed and optimized complex SQL queries - Redshift SQL to ensure accurate data retrieval and reduced job run times for ETL pipelines on ETL Manager. Led a project to create an automated WBR (Weekly Business Report) dashboard, on AWS Quicksight (Amazon’s data visualization software) for an entire department by collaborating with 20 teams. Identified the necessary business metrics, created a scheduled job to get the required data from the tables of the different teams and the data was transferred it to a S3 bucket from which it was uploaded onto Quicksight , data was updated on a weekly basis. The automated dashboard shows various trends in the business metrics of the teams period over period and also mentioned the key performance metrics both , the dashboard saved 2+ hours per week for each of 20 teams that they spend on manually creating the WBR. Show less

Contributed to an automatic video inspection program which alarmed the worker when a wrong part was picked for a particular assembly type. Used Open CV to get the live video feed from the camera desk. Used snap7 to connect the program to a PLC so that it can be stared or stopped with just buttons. The dataset containing the details of the various assembled and the required parts was imported onto the code using sqlite3 and the interface was created using Tkinter. The purpose of this program was… Show more Contributed to an automatic video inspection program which alarmed the worker when a wrong part was picked for a particular assembly type. Used Open CV to get the live video feed from the camera desk. Used snap7 to connect the program to a PLC so that it can be stared or stopped with just buttons. The dataset containing the details of the various assembled and the required parts was imported onto the code using sqlite3 and the interface was created using Tkinter. The purpose of this program was to alert the worker in real time when a wrong part is picked thereby improving the assembly efficiency. When the program was deployed there was almost 70 percent less cases of incorrectly assembled parts. Show less