Ayush Raj Arya
IT ANALYST → DATA ENGINEER → MANAGER
SUMMARY
Data Engineer with 3+ years designing ETL pipelines, data validation frameworks, and large-scale regulatory reporting systems in banking. Track record: 75% processing-time reduction, 83% faster issue detection, 100+ person-hours saved daily.
SKILLS
Languages
SQLPythonPL/SQLShell ScriptingLinux
Databases
Oracle DBSQL Developer
Data Engineering
ETL / ELTData
WarehousingData ModelingData Quality
Platforms
OFSAAControl-MOBIEE
Visualisation
Power BIOBIEE Reports
AI & Productivity
Gen AIPrompt
EngineeringChatGPT
EDUCATION
IIT Bhubaneswar
B.Tech & M.Tech (Dual Degree)
2016 - 2021 · CGPA 7.22
PROJECTS
NFT Art Generator
Generates 100,000+ unique layered assets using hash-based uniqueness algorithms.
Python · Algorithms
Portfolio Website
Built from scratch with vanilla HTML/CSS/JS. Includes schema markup, analytics, dark mode.
HTML · CSS · JavaScript
DOMAINS
Regulatory Reporting
LCR
ALM
BLR
Financial Data
Banking Systems
EXPERIENCE
Manager - Data Engineer / Developer / Analyst
ICICI Bank Ltd
Sep 2022 - Present
STARTED AS IT ANALYST · ICICI BANK
- Joined as IT Analyst in Sep 2022; progressed to Data Engineer (2023) and promoted to Manager (2024).
ETL & DATA ENGINEERING (OFSAA)
- Architected end-to-end ETL workflows within OFSAA for LCR and ALM regulatory systems, enabling accurate T+1 reporting.
- Engineered data quality and reconciliation framework across 9 enterprise sources — reduced inconsistencies by 20%.
- Implemented real-time monitoring at 4 pipeline checkpoints — cut failure detection time by 83%.
- Orchestrated large-scale data population, reducing processing time by 75% and saving 100+ person-hours daily.
- Streamlined inbound global data validation using Linux and Control-M, improving process uptime by 50%.
- Applied Generative AI tools to debug and optimise SQL queries, reducing debugging time by 50%.
- Delivered 5+ regulatory and business requirements monthly with a team of 45+ engineers and 85+ stakeholders.
REPORTING & ANALYTICS (OBIEE)
- Led development and maintenance of 150+ OBIEE reports for BLR, ALM, and internal analytics — saving 12 person-hours daily.
- Automated secure delivery of sensitive regulatory reports via email workflows, saving 4 additional person-hours daily.
TECHNICAL LEADERSHIP (RISK DASHBOARD)
- Led executive-sponsored data extraction initiative enabling analytics for 20+ stakeholders — cut delivery from 2 weeks to 3 days.
- Redesigned scalable OFSAA extraction architecture, improving data availability by 78%.
- Acted as single point of contact — driving design decisions, resolving cross-team dependencies, and ensuring delivery alignment.
KEY IMPACT
75%Processing
time reduction
83%Faster failure
detection
100+Person-hours
saved daily
150+Reports
maintained
78%Data
availability improvement
2wk→3dDelivery
timeline reduction