SUMMARY:

• Certified Anti Money Laundering Specialist with 12+ Years of IT experience worked in Financial and Banking Industry with extensive Functional and Technical skills (Skills highlighted below).
• Certified Microsoft professional , having balanced experience and credentials in Technical and Business knowledge.
• Proficiency in Change Management, Project Management, Business Analysis, Risk Assessment, Financial Crime, Compliance, AML, KYC, Risk Framework, Data Quality, Data visualization tool experiences with Tableau & Qlikview to code and design backend and frontend, experience in Data & Statistical Analysis, Regulatory reporting, Automation of reports, ETL, VB skills, PowerShell Scripting, SQL, handling structure, semi - structure & unstructured data(NoSQL), knowledge on Database - DB2, Oracle, Microsoft SQL Server, MySQL, Ample experience in writing Joins and Stored Procedures, AWS Cloud - S3, EC2, RDS & VPC. Process Design and Documentation, Project Management activities to handle global teams.
• Worked on various BAU projects, self-motivated and highly organized with an exceptional work ethic.
• I have a good fundamental knowledge in Robotic Process Automation - UiPath.
• Most recent assignments within the Financial Crime Compliance, supported AML Operations and Investigation teams as a data specialist in defining risk framework, data analysis, change management and produce various Risk metrics, Management Information and regulatory reporting.
• Primarily involved in designing Risk framework of the Global SAR reporting and spotlight country SARs from Transaction Monitoring, Production Orders, UARs, Other referral systems, Correspondent Banking SARs & CDD and extended role on the investigation side to analyze Alerts and Cases generated from Transaction Monitoring systems which enhanced acquaintance in Reputational risk and Customer selection.

SKILL:

• Risk Analysis
• Reporting and Analysis
• Process Design
• Analytical Problem Solver
• Change Management
• Datastage, Informatica & IBM WTX
• S3, EC2, RDS, VPC
• Tableau & Qlikview
• Db2, Oracle & MS SQL Server
• MS Office Proficient
• Database Management
• Visual Basics & PowerShell Scripting
• Python
• Business Relationship skills
• Hadoop
• Stakeholder Management Skills
• Gap Analysis
• Project Management

WORK EXPERIENCE:

Confidential

Senior Consultant /Manager

Responsibilities:

• Define Financial Crime risk models and develop mechanism to capture the risk metrics data
• Sharing experiences and monitoring within the team to support data analysis and to propose dimensional data methodologies to solve complex business problems
• Performed duties as Financial crime consultant for both money laundering and fraud cases
• Technical challenges to handle large volumes of data from various data sources Oracle, DB2 & CSV files to ensure the data quality before injecting into the systems for evaluation process and to maintain the data consistencies
• Designed data modelling framework to understand the nature of data and how data flow can be extracted through DB2 and Microsoft SQL server.
• Data has been extracted through database by writing store procedures and complex SQL statements which meets the business requirements to capture the daily and historical data
• Performed updates to the SQL system as per business requirements
• WinSCP was used to transfer the secure data to remote servers
• Perform detailed analyses to detect patterns, trends, anomalies and schemes in transactions and relationships across multiple business/products
• Perform detailed analysis and maintain required documentation to report Suspicious activity reports-SAR
• Responsible for and mentoring new employees as well as fellow team members
• Draft corrective action plans and assist in managing to build financial crime strategies
• Supervise the team on daily activity work and share progressive thought process
• Collaborate with other parties to make them understand the framework and how the end-to-end risk data evaluation program works

Confidential

Business Analyst

Responsibilities:

• Developed automation process using VBScript to integrate AML Risk metrics data
• Interaction with regional and country AML teams to enhance data metrics
• Create SAR reporting at a country level - spotlight
• Data check of SAR reports from various data sources and Line of Business
• Data validation and reconciliation process designed to ensure the quality of risk data
• Data comparison of various metrics and to demonstrate data in a graphical representation with different types of charts to understand the trend analysis
• AML data capture from various data sources and combining the data by writing complex JOINS and SQL procedures
• Transaction monitoring data extraction through CAMP application by defining complex SQL statements
• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports
• Review SAR cases in the case management tools - ACTIMIZE & SCION
• Good understanding on CSEM - Client Selection and Exit Management
• Produce Management Information monthly packs - Power Point presentation
• Analyze the Investigation data and perform data quality checks
• Liaise with Transaction Monitoring and EWRA teams to understand the level of risk

Confidential

Business Analyst

Responsibilities:

• Identifying areas for business improvement
• Developing maps and flowcharts of current and future business processes
• Reporting on the likely impact of process modifications
• Flagging up potential problems at an early stage
• Developing a clear understanding of existing business functions and processes
• Preparing PowerPoint presentations and develop reports using Qlikview
• Define business functionality at the transform layer by writing the script and generate QVS file
• Create Dashboard by using charts, text objects, table boxes and populate Google maps based on geographical data
• Schedule and Monitor the PROD task and involve if any concerns on the Dashboard when data and UI defects
• Using any information gathered to write up detailed reports and draw conclusions

Confidential

Consultant

Responsibilities:

• Mapping the flow of information around a business
• Providing process definition, analysis and documentation
• Identifying new opportunities to increase efficiency and performance
• Monitor and Enhancement on the Legacy Data warehouse system
• Putting together procedures manuals and system documentation
• ETL - enhancement jobs on Datastage, Pentaho Kettle to replicate data from multiple data sources
• Monitor the Datastage production jobs and re-run the failed jobs to make sure the end-to-end flow of the data process loads into DB2 database

Confidential, Des Moines, IOWA

Consultant

Responsibilities:

• Interact with Business Users to gather source information and requirements
• Provide estimation, development plan and specifications for various development work
• Preparing and analyzing financial performance information
• Proficient in Microsoft Office programs
• Identifying and managing any anticipated risks
• Working with business owners to develop solutions using IBM Websphere TX and Informatica for data extraction process
• Assisting in the preparation of business proposals
• Involved in designing Low-Level Design (LLD) documents which provide detail description about each transformation developed in Datastage
• Development of ETL maps, Unit Testing and documentation
• Used DataStage and WTX as an ETL tool to extract data from source systems, aggregate the data and load into the DB2/Oracle database
• Execute, monitor sequence and parallel jobs using Data Stage Director and verify log file if any warnings or failure
• Upload ETL jobs into Version control and Deployed the maps and its objects into PRODUCTION server
• Create manual escalation process documentation for the post production activities