Amazon Redshift

Responsible for end to end migration of on-prem apps to GCP for leading European bank's terminating deposits and mortgage loans department

- Integration of on-prem Access Management (IAM) system with Azure AD and GCP Cloud Identity via on-Prem AD for Cloud User Account, Group and Group Membership Management- API development for GCP Group Creation along with membership management for Terraform- Implemented Segregation of Duties (SoD) for GCP Groups Membership - Integration of on-prem Access Management (IAM) system with GCP IAM for Service Account Management - Implemented group managed Service Account (gSMA)… Show more - Integration of on-prem Access Management (IAM) system with Azure AD and GCP Cloud Identity via on-Prem AD for Cloud User Account, Group and Group Membership Management- API development for GCP Group Creation along with membership management for Terraform- Implemented Segregation of Duties (SoD) for GCP Groups Membership - Integration of on-prem Access Management (IAM) system with GCP IAM for Service Account Management - Implemented group managed Service Account (gSMA) management functionality within centralised on-prem IAM solution Show less

- Integrated centralised Entitlements management (ABAC based) systems with Centralised IAM application to streamline organisation’s vision to have only one centralised Access Management system for ALL types of accesses- Integrated Access Management application with Database of Database Accounts to automate database accounts management (Request and approval workflows, provisioning/de-provisioning) for relational databases within Organisation- Developed Application onboarding Framework to… Show more - Integrated centralised Entitlements management (ABAC based) systems with Centralised IAM application to streamline organisation’s vision to have only one centralised Access Management system for ALL types of accesses- Integrated Access Management application with Database of Database Accounts to automate database accounts management (Request and approval workflows, provisioning/de-provisioning) for relational databases within Organisation- Developed Application onboarding Framework to support onboarding of various provisioning target types of applications to Access Management tool for centralised access management - Developed required processes in organisation’s centralised Access Management tool to support migration of PeopleSoft as authoritative source of identities/HR Solution to Workday Show less

- Integrated One Identity Manager product with CyberArk for Infrastructure Account, Group and Membership management and with Role Management portal to established role based access- Developed data distribution framework to create and distribute Identity/Access data to downstream interfaces

- Conducted PoC to migrate transaction reporting portal for AFC applications from on-Prem to Elastic MapReduce (EMR)- Designed and developed data pipelines using Python and Spark scripts for Data Analysis fulfilling various AML monitoring business requirements - Designed/developed effective visualisations in Tableau representing business requirements related to compliance reporting SLAs breaches- Setup CI/CD pipeline for automated deployment

- Identified service improvement areas for the compliance and AFC applications and implemented proper solutions to cut down support cost/effort and to improve application stability - Worked towards Zero Intervention Production approach. Implemented various improvement Ideas/Strategic changes to reduce support issues by 50% resulting cost reduction by 30% and downtime reduction by 20%.- Implemented automated system/application health checks using Geneos.

- Designed/developed integrated portal for Compliance domain applications like Interface Contact detail management, Interface Holiday Management, automated MIS reporting, email broadcast etc.- Developed dashboards for various compliance subdomains to review overall alert generation process performance and compare that with cut-off times set-up by various regulations along with recommendations- Actively participated in external audits and designed/developed various reports for regulatory… Show more - Designed/developed integrated portal for Compliance domain applications like Interface Contact detail management, Interface Holiday Management, automated MIS reporting, email broadcast etc.- Developed dashboards for various compliance subdomains to review overall alert generation process performance and compare that with cut-off times set-up by various regulations along with recommendations- Actively participated in external audits and designed/developed various reports for regulatory bodies based on their requirement Show less

- Developed Collateral Exposure Management application for Bank to reduce counter party credit exposures- Improved daily processing batch runtime by 50% with performance tuning of backend PL/SQL code - Transitioned codebase from Oracle 9i to Oracle 11g- Enhanced application health monitoring suit to reduce monitoring effort by 70% improving Operations team efficiency - Migrated ETL processing scheduling from custom UNIX based scripts to Control-M