Senior Consultant

• Jan 2023 - Present

Consultant

• Aug 2017 - Dec 2022

• Involved in implementing, development and production support activities for Multiple AML projects implementing NICE Actimize and Work with product owners to identify and fix issues.• Installing product patches and new product modules.• Full stack development (Oracle/MS SQL, Java, HTML, JS, Apache VTL, Tomcat, WebSphere) on windows and Linux OS. • Creating new Work Items, views, Workflows from RCM (Risk Case Manager) designer.• Creating and managing user roles, groups and permissions in RCM.• Debugging objects in AIS (Actimize Intelligence Server) and developing new execution plans, flows and other AIS objects to automate BAU processes and schedule them in Tidal.• Worked with AVA (Actimize Visual Analytics) designer to implement tuning insights.• Developed and Implemented custom SAM (Suspicious Activity Monitoring) SQL rules in Actimize.• Developed new custom reports from XML data.• Reduced monthly batch processing time by a factor for 4 with SQL and process tuning.• Developed a log monitoring process in PowerShell.• Assisted in migrating reports and developing dashboards in Qlik Sense.• Developed Actimize plugins and Utilities in JAVA to implement custom processes and automations. Show less

Associate Software Engineer

• Aug 2013 - Jul 2015

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. Show less