Software Engineer · Remote
- Developed a Metro reconciliation application using React, FastAPI, and OpenPyXL, consolidating repeated Excel-based tasks into a workflow for uploads, validation, calculations, and result downloads.
- Automated buyer payment-reminder emails for pending and short payments flagged by negative closing balances, validated receipts against bank statements, and calculated cumulative amounts settled to each corresponding Metro.
- Automated GSTR-2A invoice reconciliation by normalizing invoice numbers and combining tax values to match records, then generated Excel reports separating matched invoices from unmatched entries.
- Built bank-statement validation and balance calculation to check dates, narration, debit and credit values, duplicate entries, and running balances before calculating the closing balance.
- Implemented REST APIs and reconciliation safeguards for multi-file uploads, DRAFT/CALCULATED/REJECTED status tracking, and read-only storage of source files.
- Created responsive React interfaces for run creation, file uploads, validation results, and file-level calculations, with actionable error messages to help users correct invalid data.
- Developed a refund-management portal for DMRC and the SequelString Finance team to track buyer payments, cancellation status, refund initiation, and settlement progress through one centralized workflow.
- Automated buyer refund notifications based on cancellation status and tracked pending, processed, and received refunds, improving follow-up and financial visibility.
