Headline

Data Engineering and BI automation | BFSI | AI ML learner

About

** Data Engineering Leader with extensive experience in FinTech and Insurance. I build and scale reliable data platforms, modernize legacy database and BI ecosystems, and turn trusted data into faster, better decisions.** I thrive in complex, regulated data environments where performance, availability, and data integrity are non-negotiable. My work spans database engineering, ETL/ELT pipeline design, cloud migration, and BI engineering, and increasingly the ML-ready data layer that sits on top of them. ** Experience** I have managed and modernized large-scale SQL Server, PostgreSQL, and Redshift environments, from schema design and performance tuning to migrations onto AWS and Azure. Highlights: - Led migration of BI workloads and SSIS packages to AWS, including HA/DR design and IAM role-based access, and upgraded SQL Server estates to keep pace with modern BI tools. - Owned business-resiliency for critical reporting databases: reduced RTO, authored Cutover runbooks with recovery and business-continuity teams, and set up automated DB and Autosys failover/failback to BCP. - Introduced SQL Server temporal tables for point-in-time history and audit readiness, enabling daily reporting. - Re-engineered ETL/ELT: moved SSIS to Python-based orchestration, consolidated stored-procedure logic, and cut refresh time. - Modernized DB deployment pipelines (Azure DevOps → DacPac → Liquibase) with DevSecOps controls and automated secret management. ** Collaboration and Problem-Solving** I work closely with product, analytics, engineering, and infrastructure teams, and I've served as the bridge between US and India teams. I translate ambiguous business needs into measurable data and BI outcomes, and I explain trade-offs clearly to technical and non-technical stakeholders alike. I lead QA and bug triage, mentor junior engineers, and take a systematic, root-cause approach to incidents, staying calm under pressure and minimizing business impact. ** Continued Learning** I'm completing the PG Certificate in AI & ML at BITS Pilani, and I apply it where data engineering and data science meet: feature-ready datasets, data-quality and anomaly detection on pipeline metrics, forecasting on BI outputs, and model evaluation. If you're looking for a data engineer who can modernize your data platform, protect data integrity and availability, and make analytics ML-ready, let's connect. ** Core skills:** Python · PySpark · SQL Server · PostgreSQL · AWS · Azure · ETL/ELT · Data Migration · HA/DR · Power BI · CI/CD · Data Governance · Machine Learning

Location

Greater Bengaluru Area

AI stack

claude

hugging face

notebooklm

Work experience

Lead Analytics Consultant at Wells Fargo, Dec 2024 - Present · 1 yr 10 mos, Modernization & Optimization: Migrated monolithic ETL processes to modular Python orchestration, reducing latency by 80% and improving dashboard refresh by 90%. Automation & Reliability: Built self-healing ingestion pipelines, boosting data availability for executives and BI teams. Risk Management: Designed enterprise-grade DR framework, cutting RTO to near-zero and ensuring zero data loss in simulations. Governance: Implemented CI/CD validation protocols ensuring 100% audit compliance. Leadership: Partnered with stakeholders to define multi-year data roadmaps, reducing time-to-insight across departments.

Lead Information Security Engineer at Wells Fargo, Aug 2021 - Dec 2024 · 3 yrs 5 mos, Bengaluru, karnataka India

Associate Tech Lead at First American (India), Feb 2016 - Aug 2021 · 5 yrs 7 mos, Bengaluru Area, India

Associate Technical Lead at First American (India), 2016 - 2021 · 5 yrs, Led cloud migration of products from on-prem to AWS, including databases, jobs, and SSIS packages. Designed HA/DR strategies and IAM role-based access for secure cloud adoption. Revamped legacy systems (DiscImage → AgentPortal), improving stability and user experience. Migrated SQL Servers (2008 → 2016), resolving compatibility issues and eliminating technical debt. Established database maintenance plans for performance optimization and reliability.

Principal Software Engineer at First American (India), Feb 2012 - Aug 2013 · 1 yr 7 mos, Bangalore, Working on MSBI (SQL Server / SSRS / SSIS 2008) to develop and support the CLAIMS related application

Database Developer at First American (India), 2012 - 2013 · 1 yr, Designed ETL packages integrating multiple data sources into SQL Server. Automated deployments using PowerShell, reducing manual overhead. Developed parameterized reports in SSRS, enabling flexible business insights.

Senior Developer at Nomura Services India Private Limited (Ex Lehman Brothers), Oct 2008 - Sep 2010 · 2 yrs

Senior Software Engineer at Nomura Services India Private Limited (Ex Lehman Brothers), 2006 - 2010 · 4 yrs, Delivered Sales Revenue Reporting Solutions for Fixed Income, Equities, and Prime Services. Designed ETL workflows (Informatica) for data warehousing in dimensional models. Performance-tuned stored procedures and indexes for high-volume financial data. Acted as SPOC between US and India teams, ensuring seamless collaboration.

Senior Software Engineer at Lehman Brothers (Nomura), 2006 - 2010 · 4 yrs, Delivered Sales Revenue Reporting Solutions for Fixed Income, Equities, and Prime Services. Designed ETL workflows (Informatica) for data warehousing in dimensional models. Performance-tuned stored procedures and indexes for high-volume financial data. Acted as SPOC between US and India teams, ensuring seamless collaboration.

Education

Postgraduate Degree, AI & ML, BITS-PILANI

Bachelor of Engineering, Computer Software Engineering, Maulana Azad National Institute of Technology

Public links

github: https://github.com/anjugupta7