Work Experience
4 years building production systems in fintech and enterprise environments.
IB
Data Analyst
ICICI Bank
Nov 2022 - Present
Hyderabad, India
Current- Built and validated 10–15 production reports in Oracle BI Publisher (AUM, NAV, income, portfolio holdings, coupon): wrote the data-model SQL and designed the RTF/Excel templates; used by operations, finance and audit teams
- Wrote complex Oracle SQL (CTEs, window functions, multi-table joins, subqueries) to analyse fund accounting data for financial analysis, regulatory reporting and reconciliation
- Built Power BI dashboards and reports for the fund accounting team to track fund and portfolio trends and present them to clients
- Reconciled NAV and fund data across 15+ schemes using SQL and Python (Pandas), identifying discrepancies and tracing data lineage from source systems to reports
- Investigated 50+ production data incidents through SQL-based root-cause analysis of transaction flows and database logs; drove fixes with DBA, vendor and infrastructure teams
- Defined validation logic for automated post-deployment sanity checks, cutting manual verification from 10–15 minutes to under 2 (85%+) across UAT, Production and DR
- Authored SQL-based RBI CSAP-XIII backup and restoration validation, accepted as formal audit evidence without revision; classified 226 database columns for PII discovery
- Translated SEBI, RBI and IRDAI mandates into data requirements and validation checks; delivered UAT and data validation for 50+ change requests with zero production rollbacks
Oracle SQLPower BIOracle BI PublisherPython (Pandas)PostgreSQLMySQLSEBI/RBI/IRDAI ComplianceJIRA
AB
Associate Consultant
Abjayon
Jun 2022 - Sep 2022
Ahmedabad, India
- Built enterprise data integrations using Oracle Service Bus (OSB) and SOA-based architecture to enable reliable data exchange between systems
Oracle Service BusSOAEnterprise Integration