German24C Provisioning System

Project Scope: • To report new accounts, account closures and all changes to any of the reportable data attributes to Bank of Verlag, Germany on the day after the change took place; fulfillment of regulatory and operational requirements Impact: • Reduction in modelling and development effort by 20% (around 45 attributes) by leveraging client data from Master and Reference data hub. Role: • Analyzed Source System (SOR) by frequent business interactions and implemented OGG (Oracle Golden Gate) replication for data movement from Cesium(Client Onboarding Platform) to TrADS • Validated and updated conceptual and physical data models for: - Strategy definition for rewriting file data into table post extract generation - Assisted in the gap analysis of the business requirement and ensured the incorporation of the key business attributes in the model Tools Involved: SAP Power Designer, Oracle SQL, Informatica