Shivansh Singh

At Ayekart, I reconcile merchant, product, inventory, order, sales, and payment data across transactional and financial workflows using PostgreSQL.

I validate GSTIN, PAN, banking, warehouse, and master data to support e-Invoice, E-Way Bill, and IRN processing. I also investigate collection mismatches across cash, cheque, UPI, and bank transfer records.

I build Metabase dashboards that centralize warehouse and business KPIs across inventory, merchants, orders, collections, GRNs, and sales. My work turns data-quality findings into clearer operational reporting and stronger controls.

I automated IRN updates from finance data through payload generation and backend order updates with Python and Pandas, reducing batch processing from 30 minutes to under 5 minutes. I also built a merchant data validation engine that cut manual review time from 30 minutes to 5 minutes per batch.