Software Engineer Developer

Tejaswini Madam

**** ***** *** ** ****, Redmond, WA 980**-***-*** 1547 ****.*********@*****.***

Professional Experience

Software Engineer, HSBC Global Technology, India Aug 2012 – Oct 2016

Customer Activity Monitoring Program(CAMP):

Developed PL/SQL Package and shell scripts which scans through all the transactions and summarize the details w.r.t account and customer and then rules (predefined or user defined) are applied to find out the suspicious (possible) transactions.

Transaction Monitoring Optimization(TMO)

Due to the ever evolving stringent Anti Money laundering laws there is an urgent need to revamp the quality of alerts that are being generated by the AML systems, in order to do that an end to end statistical and analytical process involving various techniques has been designed in HSBC to counter the Money Laundering activities, This process involves 4 stages of in-depth analysis to perform data quality check, testing the scenarios, segmenting the customers based on their AML risk and tuning the final threshold that is to be applied for the scenarios based on the new segments. The necessary coding activities and the supporting oracle scripts were developed for this project.

Alert Management System (AMS):

AMS is one initiative taken to strengthen risk management in HSBC, compliance and culture and enhancing the Group standards, to achieve this CAMP would be sending alert related data in the form of feed files to and external system and would be receiving narratives which would be loaded into the CAMP system. Investigators would be going through the attached narratives to analyze the risk level of the alert and categorize it accordingly.

Correspondent Bank Monitoring

Correspondent Banking involved the transactions that happen between interbank where HSBC may be involved as an originator or a beneficiary or as a third party acting as an intermediate. The biggest challenge is to come up with a model which can help identify the suspicious activity with these types of transactions. The solution designed was to develop a sophisticated backend design to study the transactions and raise and alert wherever the case of suspicion arises.

Threshold Calibration for Violation scenarios

The HSBC’s in-house Anti Money Laundering Solution CAMP has diverse violation scenarios which are used to monitor the accounts as well as customers in as many ways possible. This project emphasis on setting up the starting threshold values for a given scenario such as Daily Cash scenario or a Daily Wire transfer scenario to begin things in more accurate statistically proven way rather than a blind guess of values.

Education

Hyderabad, India Jawaharlal Nehru Technological University 2008 – 2012

Bachelor of Technology in Computer Science and Engineering GPA: 8.5/10

Technical Skills

Programming Languages: SQL, PL/SQL, Linux shell scripting,SSIS,SSRS,SQL Server,T- SQL

Databases: Oracle 10g,11g,12c

Database Tools: PL/SQL Developer, SQL Developer 3.0,Terradata.

Certifications: Oracle PL/SQL Developer Certified Associate, Oracle SQL Expert, IIBF- AML/KYC (Indian Institute of Banking and Finance- Anti Money Laundering/Know Your Customer)

Contact this candidate