
Gagan Chaudhary
Freelance Full Stack Developer
Competenze

Portfolio
Esperienza lavorativa
ICICI Bank
Full time • 3 yrs 5 mos
Senior Data Analyst
Apr 2025 - Present • 1 yr 1 mo
Own Oracle BI Publisher reporting suite end-to-end — 10–15 production reports (AUM, NAV, Income Distribution, Portfolio Holdings) used by operations, finance, and audit. Author complex Oracle SQL (CTEs, window functions, multi-table joins) for NAV validation, reconciliation analysis, and RBI regulatory evidence. Sole decision-maker for Production-to-DR failover — full environment switchover within 40 minutes, zero data loss. Triage 50+ production issues via Oracle DB log analysis, transaction data flow inspection, and application diagnostics. Coordinate multi-level approvals across 8+ teams (Business, Vendor, DBA, Infra, Security, Network, Middleware, Compliance)
Data Analyst
Nov 2022 - Mar 2025 • 2 yrs 4 mos
Sole owner of IFAME and mPower fund accounting platforms across Mutual Fund, Insurance, and AIF clients. Authored Oracle SQL for CSAP-XIII RBI backup validation — outputs used directly as regulatory audit evidence. Led automation that cut manual data verification from 15 min to under 2 min (85%+ reduction). Analysed 200+ account lifecycle records for LAM automation — reduced per-request time from 10 min to near-zero. Led MFA & SAML SSO rollout (RBI mandate) via ICICI ADFS — delivered 2 weeks ahead of deadline, securing 5,000+ daily authentications