• Served as the technical lead for SAM and RCM upgrades, enhancing system reliability and performance.

• Engineered and implemented automated processes for CTR filing, streamlining compliance procedures.

• Developed XSL for Alert display and PDF export in Actimize, improving alert management and reporting capabilities.

• Generated data metrics for transaction monitoring systems, enabling advanced data analysis and insights.

• Designed and developed Tableau dashboards to analyze data trends in the transaction monitoring process, facilitating proactive data quality checks.

• Integrated new source data into the transaction monitoring system, enhancing data completeness and accuracy.

• Lead the implementation, development, and support of multiple AML projects utilizing NICE Actimize, collaborating closely with product owners to resolve issues efficiently.

• Spearheaded the installation of product patches and new modules, and executed full stackdevelopment across Oracle/MS SQL, Java, HTML, JS, Apache VTL, Tomcat, WebSphere on bothWindows and Linux OS.

• Designed and managed new Work Items, views, and Workflows using RCM (Risk Case Manager)designer, and orchestrated the creation and administration of user roles, groups, and permissions within RCM.

• Innovated debugging techniques for AIS (Actimize Intelligence Server) objects, developing new execution plans, flows, and other AIS objects to automate BAU processes and ensure their scheduling in Tidal.

• Developed and implemented custom SAM (Suspicious Activity Monitoring) SQL rules in Actimize, and crafted custom reports from XML data.

• Created dashboard with AVA (Actimize Visual Analytics) for SAM detection rules to derive tuning insights.

• Achieved a fourfold reduction in monthly batch processing time through strategic SQL and process tuning.

• Facilitated the migration of reports and the development of dashboards in Qlik Sense.

• Developed Actimize plugins and utilities to implement custom processes and automations.

Involved in requirement gathering, system design, development and customization of insurance software solutions in Oracle database (Procedures, Functions, Triggers & Packages) and D2K (Forms & Reports). Analysed trace files and explained plans to improve database performance for ETL scripts and product database by restructuring SQL Statements, creating new indexes, using Optimizer hints, bulk collect as necessary. Supported a ASP.net module which acts as an alternative front-end for the product. Led team of two for end-to-end Data migration (ETL). Completed data migration by modifying existing scripts and effective pipelining of processes.

Key Achievements:

▪ Implemented new technique using oracle utility package, triggers and tools in PL/SQL developer to reduce print debugging time from hours to minutes.

▪ Played a crucial role during UAT at a client (NTIC, Kuwait) location, participated in user testing and training sessions.

▪ Provided scalable solution to migrate bilingual data between the source and the target databases with NLS_LANG configuration issue, without data loss.

▪ Developed scripts to automate recurring activities related to product configuration and data migration.

▪ Recipient of Exceeding Expectation award for exhibiting exceptional performance.