Ansh Agarwal

About Ansh Agarwal

The best engineering decisions start before a single line of code is written. As…

Experience

1. Software Development Engineer

   ArcelorMittal Digital Consulting

   Jan 2023 — Present

   Technologies: Python | SQL | Django REST Framework | Flask | Azure Functions, Azure Batch, Azure Data Factory | Azure SQL Database, Azure Blob Storage | AWS EC2, RDS, CodePipeline, CodeCommit | Database Design Experience Highlights Cash Collections Tool – Invoice-to-Cash Cycle Automation- Developed scalable backend APIs using Django REST Framework, combining complex raw SQL and ORM queries to deliver real-time business-centric KPIs and dashboard insights- Engineered serverless workflows with Azure Functions (Python) to automate critical operational tasks at scale. Built a sophisticated task engine leveraging ReportLab (PDF generation), OpenPyXL (Excel generation), and SQLAlchemy for ORM-driven database interactions. Seamlessly integrated Azure Blob Storage and File Share for secure document handling and scalable storage solutions. Designed dynamic notification systems, auto-reminders, and customized report generation modules to drive user engagement. Cloud-Native ETL/ELT Pipelines - Architected a serverless ETL/ELT solution on Azure using Data Factory and Functions to streamline enterprise data ingestion, transformation, and warehousing. AI & R&D – Enterprise Knowledge Systems- Explored OpenAI Embeddings and Chat Completion APIs to build an in-house RAG (Retrieval- Augmented Generation) solution- Developed a smart document Q&A system backed by vector search, empowering users with instant intelligent information retrieval. Team Growth & Culture Building- Spearheaded initiatives to identify and mentor high-performing talent, contributing to a highly skilled, ever-learning engineering team focused on innovation and quality delivery.

Education

• Dayalbagh Educational Institute, Agra

  Bachelor's degree

  2017 — 2020

• Dayalbagh Educational Institute, Agra

  Diploma

  2014 — 2017