Software Development Engineer-1 at FITT, IIT Delhi (2025-09 – Present)
Project: PDS Supply Chain Route Optimization
- Analyzed supply chain and warehouse datasets from 2000+ procurement and distribution centers using SQL and Python, enabling data-driven operational decisions.
- Developed automated ETL pipelines using Python (Pandas) to process 50,000+ records(including Warehouse and FPS), reducing manual effort by 85% while improving data quality.
- Extracted and validated data from MySQL databases, ensuring data accuracy and consistency for reporting.
- Analyzed and validated 20,000+ FPS and Warehouse coordinate datasets using Tableau, leveraging map visualizations and multiple filters to verify data, ensuring data integrity for business reporting.
- Generated Excel-based analytical reports using openpyxl, enabling business teams to monitor operational performance.
- Collaborated with cross-functional teams to understand reporting requirements and deliver business insights.
- Improved data quality by implementing validation checks, duplicate detection, and automated error handling and optimized data extraction APIs that supplied structured datasets for dashboards and reporting applications.
