Divyansh Agarwal

About Divyansh Agarwal

With over 2.5 years of hands-on experience at HDFC Bank driving large-scale data…

Experience

1. Data Engineer

   HDFC Bank

   Feb 2023 — Present · Mumbai, IN

   Led 10+ end-to-end projects, from business requirement gathering to automation using SQL, SSIS, and Power BI, reducing manual effort by over 80% and delivering savings of ₹5+ Cr. Built and deployed fully automated ETL pipelines using SSIS + Visual Studio, saving the bank multiple crores in recurring operational costs and enabling data-driven decisions for finance and business teams across BFSI processes. Developed SQL Server and Oracle SQL procedures, indexes, and reporting solutions (SSRS) to improve data retrieval times and maintain data quality. Extracted, cleaned, and transformed terabytes of structured and unstructured data using Advanced SQL, Oracle, and Python—turning raw banking data into meaningful insights. Designed and published interactive dashboards using Power BI and Tableau, delivering real-time visibility into business KPIs across departments. Deployed data pipelines and services on AWS (S3, Lambda, RDS) for scalable, cloud-native analytics.🤖 Integrated AI models (Python-based) to automate data validation, anomaly detection, and report generation, accelerating delivery cycles.🧩 Partnered with business stakeholders to understand requirements and deliver real-time reporting, supporting audit and compliance needs, meanwhile collaborating cross-functionally with data, IT, risk, and product teams to align technical execution to fulfill business needs.