Utilized AB Initio to design frameworks for onboarding various sources to Barclays' data warehouse.
Converted Informatica/bteq scripts into Ab Initio graphs for data loading into different layers in HDFS and external Hive tables.
Developed multi-layered data architecture to support effective data ingestion, integration, and consumption.
Worked on Data Warehouse related to Personal banking, collections, and recovery, focusing on controls and business-specific layers for data understanding.
Gathered business requirements and performed data discovery.
Developed A>I graphs based on business rules and performed Impact Analysis for Change Requests.
Conducted unit testing, prepared test documents, HLD, and LLD documents.
Debugged A> I graphs and validated data in target tables post-loading.
Mentored SA partners to understand data and requirements.
Improved process performance and efficiency through data analysis.
Conducted data analysis for various MI reports requested by the business.
Developed controls to facilitate bank audits.

SUSHANT SINHA