Shivam Verma

Project - Trade Data Processing and ETL Optimization | Client: Barclays Bank. Designed and optimized Ab Initio ETL graphs using components such as Join, Rollup, Reformat, Filter by Expression, Scan, Lookup, and Partition to process large-scale financial data. Implemented transformation logic as per business requirements and improved graph runtime performance. Developed and executed SQL scripts for data extraction, validation, and analysis. Deployed Ab Initio graph changes, database scripts, and Unix shell scripts across multiple environments. Monitored and managed batch jobs using Tivoli Workload Scheduler (TWS), resolving runtime errors for migrated graphs to ensure uninterrupted processing. Participated in data warehousing activities, including data modeling and integration from multiple upstream sources. Conducted code reviews to ensure compliance with client standards and best practices. Utilized JIRA for effective task management of bugs, change requests, and user stories. Created and maintained technical documentation, release notes, unit test plans, and user guides in Confluence. Tech stack :- AbInitio, Oracle SQL, Unix, TWS, JIRA, Confluence.