Aishwarya

ETL Developer with 5+ years in banking and financial services, building and supporting high-volume batch pipelines on IBM DataStage, Oracle PL/SQL, DB2 z/OS, Autosys and Unix shell, processing 90MM+ daily transactions. Currently converting legacy ETL workloads to IBM Cloud Pak for Data (CP4D). Strong in CDC-based incremental loading, PL/SQL performance tuning and production support, with a consistent record of shortening batch windows and improving SLA adherence.

ETL Developer / Software Developer - Bank of America - Mumbai

(2021-05)

• Design, develop and support ETL pipelines and batch workflows using IBM DataStage, Oracle PL/SQL (19c/12.2c DBaaS) and Unix shell across Cards (Oracle and DB2 z/OS), Small Business and AAAR platforms, handling 80MM+ daily inquiries and 90MM+ daily transactions.
• Converting legacy ETL workloads to the IBM CP4D platform: executed the CP4D proof of concept and modernized 45+ batch jobs, improving the batch window 15% (6.0 to 5.1 hrs) and SLA adherence from 96.8% to 98.2%.
• Develop and tune Oracle PL/SQL stored procedures, functions and packages, achieving an 18% runtime improvement and 20 minutes less reporting time through indexing, query refactoring and execution plan analysis.
• Manage Autosys scheduling (JIL), job dependencies and error handling for reliable daily batch windows.
• Own production support (incident resolution, data quality validation, SLA monitoring); built an automated log parser and alerting system that cut recurring high-priority incidents 10-15% and improved MTTR 12-18%.

Bachelor of Engineering (BE) - Computer Engineering - Pravara Rural Engineering College, Loni (2015-06 - 2019-06)