Client Due Diligence Business Analyst

OneBank CDD Entity Operationalization
Project Description
This Project is aimed to standardize Client due diligence process and platforms. The bank defined group and segment procedures (CIB, CB, Retail Clients). To achieve this target state, the system needed to be more robust and data quality needed to be reassessed. Major functionality that were re-defined are Sanction Screening, PEP Assessment, Group Prohibitions, Risk Rating, Periodic reviews
Responsibilities

• Participated in the data assessment strategy planning and identified areas of gaps
• Lead the team on data quality using data profiling techniques
• Did the data analysis and was part of data remediation activities.
• Facilitated the functional BA’s with appropriate data for the proper FSD preparation
• Managing the DQMS project and reported the status

Data Quality Model - Risk Data Aggregation
Project Description
Currently working on building Data Quality Management System for the all the DQ Queries generated for Risk data queries. This project involves building request handling mechanism through which all the DQ request would arrive and all the actions
Would be performed per the request actions specified in the reference tables. The typical actions are verifying counts and dollar amounts across various staging layers in the system for Key Data elements identified. This covers data lineage across
Different systems right from source to target. This ensures the data accuracy, completeness, uniqueness and other data quality dimensions.
Responsibilities

• Leading a team of business analysts (3 Bas) at offshore and tracking their efforts
• Reviewing requirements , data flow diagram and involved in data analysis
• Explaining the QA team about the functionality involved and participating in the defect review meetings
• Reporting status to senior management about the project impediments and highlighting risks
• Coordinating with lower environment teams for pre-prod runs and ensuring all the deliverables

are part of the pre-prod run

• Coordinating with downstream systems and got involved in integration testing

Tools: Netezza, Teradata, UNIX Shell Scripting                                 
MIFID / FATCA / OFAC Reporting Project
Project Description:
                                                                                                                                          
Bank received audit point from FSA regarding over reporting of the MiFID reportable securities.  So Bank decided to on board a New feed from Unavista (approved by ESMA) for MIFID, and during 2014, another regulation FATCA required securities issued before a specific date are eligible for FATCA
Responsibilities:

• Initiate kick off meeting with Stakeholders (Tech Manager, Production support of the consuming systems) to understand the requirements
• Provided status updates to the technology partners about the progress (involving UK Ops Managers, US Product Manager,  offshore delivery managers) on weekly basis
• Did data analysis of the existing MiFID reportable securities in the golden copy for any data inconsistencies
• Back-Populating of this missing securities in the Golden copy database
• Prepared the Scope document, Functional Test scenarios, traceability matrix
• DQ Report Check in the UAT for possible mismatches
• Report weekly basis on status of program to Product Head
• Obtain signoff from the stakeholders.

Tools:  UNIX Shell Scripting, ETL Informatica, Oracle 11g, JAVA J2EE