Developing and implementing a Python script to automate the process of randomly selecting a team member for the chai treat, ensuring fairness and equal distribution of responsibilities among team members.

Utilized email sending functionality and integrated it with the script to send reminder emails to the selected team member, while also including the rest of the team members in CC, enhancing communication and collaboration within the team.

Analyzed US accident data from the previous year using Python and EDA techniques, identifying trends, and visualizing the impact of COVID-19 on traffic behavior and accidents.

Conducted exploratory data analysis on US accident data with Python, correlating and presenting insights on the impact of COVID-19 on traffic behavior and accidents.

Developed a Python script using ElementTree to process XML data from 3 files, adding prefixes to customer IDs and merging missing entries in the All-Heart file based on login credentials, reducing manual effort, and improving data accuracy.

Utilized ElementTree in Python to parse and manipulate XML data from CK.xml, HH.xml, and AH.xml files, successfully adding customer ID prefixes and merging missing entries in the All-Heart file based on login credentials

Designed and implemented an advanced SQL database schema for retail inventory management, incorporating tables for product inventory, sales transactions, supplier information, and customer data.

Developed complex SQL queries and Utilized SQL window functions and subqueries to perform advanced analytics on sales data, including calculating KPI’s such as sell-through rate, inventory turnover, and providing actionable insights for inventory optimization and profitability analysis.