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

Method to ease client interactions using AI, cognitive automation, and big data. Modernized fulfilment & servicing platforms for Treasury.

Implemented near real-time client reporting through redesign of Treasury functions. Merged Pega with existing systems for client reporting.

Developed business reporting solutions using MicroStrategy, MS SQL Server, and AutoSys. Created datasets, metrics, and dashboards for client reporting.