Project Scope: Regulatory requirement of reporting deposit account (TD, DDA) entities to Federal Deposit Insurance Corporation for Insurance coverage determination. Tools Involved: SAP Power Designer, Oracle SQL, Notepad ++, Informatica PowerCenter Role:  Conducted Preliminary delta analysis of deposit account entities in existing treasury system (Treasury Authorized Data Store)  Scrutinized & converted COBOL (mainframe) files into Exadata tables, defining corresponding data types, load pattern and load pattern and frequency   Created conceptual, logical and physical data models for staging, core and provisioning data layers  Analyzed FDIC requirements & updating KBE’s, and underlying physical data attributes in Treasury database  Conceptualized DDL, DML and mapped specifications for E2E database development  Designed mappings, sessions and work-flows for data load into FDIC tables for defect defection at early phase of development  Implemented Agile methodology in delivering information solutions to client, adhered to the FDIC compliance 

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. Tools Involved: SAP Power Designer, Oracle SQL, Informatica 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  Created & maintained German24C provisioning mapping documents with the focus on tracking the account or stakeholder data amendment  Validated and updated  conceptual and physical data models for: o Strategy definition for rewriting file data into table post extract generation o Delivering the DDL, DML and mapping specification artefacts for E2E Database development o Assisted in the gap analysis of the business requirement and ensured the incorporation of the key business attributes in the model