At IT Roots, I cleaned and transformed raw datasets using Python, SQL, and Excel, and wrote SQL queries to extract and analyze data. I also performed exploratory data analysis using Pandas.
I created Power BI dashboards to monitor KPIs and business performance, and automated Excel reports. My reporting automation improved reporting efficiency by 25%.
I built an Expense Tracker using Python and MySQL, with CRUD operations and monthly and category-wise summaries. I also developed an e-commerce ETL pipeline that transforms CSV and Excel data and loads it into MySQL.
