PROFILE:

• Working Assistant Manager a with 14+years of experience in successful design, development and implementation and support of web, client - server. worked on client location (UK) as a onsite coordinator.
• Good understanding on the functional domain(Banking and Financial) of the application.
• Interacting with client to gather the requirement and making the team member to understand the functionality for the application and requirement.
• Analyze and fix any data related issue causing by other system.
• Oracle FCCM (Mantas) implementation and data migration.
• DIS data mapping, encryption and data Quality.
• Thresholds analysis and tuning.
• Watch list and threshold implementation
• Mantas batch scheduling and Batch run with Control-M.
• Mantas batch scheduling and Batch run with Control-M.
• Customize or develop new Oracle FCCM (Mantas) scenarios if out of box scenario doesn't satisfy red flag requirements Mantas scenario development with scenario developer
• Involving in fixing the Critical production issue.
• Preparing weekly, monthly report for call with the client.
• Giving helping hand to make understand the requirement, issue to team member.
• Involving on Quality audit.
• Involving on DR issue during the DR activity.
• Involving in implementing the code in UAT, QAT (Pre prod) and Prod.
• Involving on guiding to team to write Unit test case, preparing business logic document etc.
• Writing the script to clearing the old files from the server as per the retention policy.
• Writing the script for getting data in the form of file, dblink from source system and loading those files into our system as per the locations.
• Involving on writing the script for automating the various manual activity. Like generating the reports as per the business requirement and sending the report to the business with the attachment.
• Managing of 15 member team.
• Scheduling the jobs in Control-M and Geneos.
• Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
• Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
• Implement alerts assignment rules.
• User set up and management
• Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects

TECHNICAL SKILLS:

Databases: Oracle 8i,9i,10g,11g

Languages: PL/SQL, SQL, Unix Shell Script,AML -Mantas(OFSAA, FCCM )

Hp: UX 12,UNIX, Windows 2000 Server, Windows NT 4.0

Tools: 10gAs, SQL* Loader, SQL Plus, Toad,clarify,dbsymphony,Control-M,Geneos,Matas,Jira,Servicenow

Version Control: SVN

PROFESSIONAL EXPERIENCE:

Confidential

Project Environment: Oracle 9i/10g, PL/SQL, Shell Script,Mantas

Responsibilities:

• Good understanding on the functional domain of the application.
• Monitor, track and ensure all AML relevant legislative and regulatory changes are duly considered and that local AML policies and procedures reflect required regulatory and CS internal standards.
• Conduct periodic review of Mantas Scenarios and Thresholds review as required
• Manage BAU Change Management process (Change Requests, BoW changes etc.).
• Alert routing and Watchlist maintenance
• Worked on Business, Geography, Entity and Activity risk projects
• Provide management with enough, frequent and objective information to get an accurate picture of the ML risks the bank is exposed through its activities and individual business
• Analyze and fix any data related issue causing by other system.
• Involved in IM call for P3C or above incident to fix the production P3c or above incident.
• Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
• Involve on the RCA for the application functional issue.
• Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
• Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
• Involved on DR activity that has been scheduled as per the datacenter.

Confidential

Project Environment: Oracle 9i/10g, PL/SQL, Shell Script

Responsibilities:

• Good understanding on the functional domain of the application.
• Analyze and fix any data related issue causing by other system.
• Involved in IM call for P3C or above incident to fix the production P3c or above incident.
• Good understanding ITIL process.
• Implemented Geneos across the DB to avoid the SOD and health checks.
• Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
• Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
• Involve on the RCA for the application functional issue.
• Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
• Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
• Implement alerts assignment rules.
• User set up and management
• Run the batch using control-M and generate the alerts.
• Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects
• Track all the SL to avoid any breaches.
• Implement production changes as per the steps mentioned in the GCM.
• Involved on the new application or any release activity transition from Dev team.
• Involved on DR activity that has been scheduled as per the datacenter.
• Created incident and SR matrix which help the team to track the process of the incident and SR .

Confidential

Project Environment: Oracle 9i/10g, PL/SQL, Shell Script,Mantas

Responsibilities:

• Good understanding on the functional domain of the application.
• Analyze and fix any data related issue causing by other system.
• Involved in IM call for P3C or above incident to fix the production P3c or above incident.
• Good understanding ITIL process.
• Implemented Geneos across the DB to avoid the SOD and health checks.
• Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
• Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
• Involve on the RCA for the application functional issue.
• Explain the data field requirements of different source files require to run the identified trade surveillance scenarios and work with source system for data mapping and data assessment to ensure that data is sourced in good quality.
• Work with the business to understand the requirement to prioritize the alerts and apply scoring rules.
• Implement alerts assignment rules.
• User set up and management
• Run the batch using control-M and generate the alerts.
• Investigate the issues like alerts not generated, data not populated correctly etc in all phases of the projects
• Track all the SL to avoid any breaches.
• Implement production changes as per the steps mentioned in the GCM.
• Involved on the new application or any release activity transition from Dev team.
• Involved on DR activity that has been scheduled as per the datacenter.
• Created incident and SR matrix which help the team to track the process of the incident and SR .

Confidential

Project Environment: Oracle 9i, PL/SQL, Shell script

Responsibilities:

• Good understanding on the functional domain of the application.
• Analyze and fix any data related issue causing by other system.
• Involved in IM call for P3C or above incident to fix the production P3c or above incident.
• Good understanding ITIL process.
• Implemented Geneos across the DB to avoid the SOD and health checks.
• Identify the repeated incident and Create knowledge based article (KEDB). This enhance the response and resolution time of the incident.
• Weekly setting up the call with the SL3/Dev team to track the PM status or any long pending issue.
• Involve on the RCA for the application functional issue.
• Have good understanding on the ASM.
• Track all the SL to avoid any breaches.
• Implement production changes as per the steps mentioned in the GCM.
• Involved on the new application or any release activity transition from Dev team.
• Involved on DR activity that has been scheduled as per the datacenter.
• Created incident and SR matrix which help the team to track the process of the incident and SR .

Confidential

Responsibilities:

• Gathering requirement and preparing System design specification.
• Analysing the effort time to deliver and resource planning.
• Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
• Design the screens and the logics to reduce the complexity of the code.
• Developing the module and also allocating resources for development.
• Closely co-ordinate and work with developer in the developing and system testing.
• Attending and fixing production defects that comes through clarify case from L3 team.
• Preparing complete weekly status report for clients and keeping them updated.

Confidential

Project Environment: Oracle 9i, PL/SQL, Java Script

Responsibilities:

• Gathering requirement and preparing System design specification.
• Analysing the effort time to deliver and resource planning.
• Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
• Design the screens and the logics to reduce the complexity of the code.
• Developing the module and also allocating resources for development.
• Closely co-ordinate and work with developer in the developing and system testing.
• Attending and fixing production defects that comes through clarify case from L3 team.
• Preparing complete weekly status report for clients and keeping them updated.

Confidential

Project Environment: Oracle 9i, PL/SQL, Unix shell script, SQL* Loader

Responsibilities:

• Designed algorithm for implementing numerous client’s business rules. Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
• Design the screens and the logics to reduce the complexity of the code.
• Prepared the test cases for the users testing and the project documentation. Bug fixing and trouble shooting major cases, which were encountered while integrating testing and UAT.
• Optimization of queries by creating Indexes, Hints and testing all queries using Explain Plan.

Confidential

Project Environment: Oracle 9i, PL/SQL, Unix shell script, SQL* Loader, PL/SQL Developer, Discoverer

Responsibilities:

• Designed algorithm for implementing numerous client’s business rules. Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.
• Design the screens and the logics to reduce the complexity of the code.
• Numerous front-end applications like forms and reports where created using Forms 6i and Reports 6i.
• Critical reports and Labels were development-using Reports6i.
• Design the screens and the logics to reduce the complexity of the code.
• Prepared the test cases for the users testing and the project documentation. Bug fixing and trouble shooting major cases, which were encountered while integrating testing and UAT.
• Optimization of queries by creating Indexes, Hints and testing all queries using Explain Plan.