f
fullstackgagan

Gagan C

@fullstackgagan

Full Stack Developer

India
About me
I am a Senior Data Analyst (Manager I) at ICICI Bank with 3.5+ years delivering analytics, reporting, and compliance governance. Alongside full-time work, I freelance as a full stack web developer.... Read more

Skills

f
fullstackgagan
Gagan C
Offline

Work experience

ICICI_Bank

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